20241127 14370700 FALSE CV_STREETS_102 Address US Dual Range Addresses 85 80 -1 -1 false true false true false 0 false false 200 200 1 Shape Status Score X Y 75 true 511705088 true true true 40 Feet 3 Percent L R / & ; 128 true State ZIP City {DA70B7E3-10B2-42E3-BFF7-6C81355862BC} ProgID = esriDataSourcesFile.ShapefileWorkspaceFactory.1; Path = Address  Locators 10.2\ True sde.DEFAULT 133769503702560000 7:32:50 PM CV_STREETS_102 {AE5A3A0E-F756-11D2-9F4F-00C04F8ED1C4} True 1 0 :: :: CVADDRESS :: :: 50000 20211026 09383300 20211026 09383300 NW_CASES 002 397390.050000 782319.966250 835672.922000 1090168.396750 1 Projected GCS_North_American_1983_HARN Linear Unit: Foot (0.304800) NAD_1983_HARN_StatePlane_Arizona_Central_FIPS_0202_Feet_Intl <ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/10.4'><WKT>PROJCS[&quot;NAD_1983_HARN_StatePlane_Arizona_Central_FIPS_0202_Feet_Intl&quot;,GEOGCS[&quot;GCS_North_American_1983_HARN&quot;,DATUM[&quot;D_North_American_1983_HARN&quot;,SPHEROID[&quot;GRS_1980&quot;,6378137.0,298.257222101]],PRIMEM[&quot;Greenwich&quot;,0.0],UNIT[&quot;Degree&quot;,0.0174532925199433]],PROJECTION[&quot;Transverse_Mercator&quot;],PARAMETER[&quot;False_Easting&quot;,700000.0],PARAMETER[&quot;False_Northing&quot;,0.0],PARAMETER[&quot;Central_Meridian&quot;,-111.9166666666667],PARAMETER[&quot;Scale_Factor&quot;,0.9999],PARAMETER[&quot;Latitude_Of_Origin&quot;,31.0],UNIT[&quot;Foot&quot;,0.3048],AUTHORITY[&quot;EPSG&quot;,2868]]</WKT><XOrigin>-17746700</XOrigin><YOrigin>-44067300</YOrigin><XYScale>4000</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.0032808398950131233</XYTolerance><ZTolerance>2</ZTolerance><MTolerance>2</MTolerance><HighPrecision>true</HighPrecision><WKID>2868</WKID><LatestWKID>2868</LatestWKID></ProjectedCoordinateSystem> 1.0 Dataset updated by the Omega Import Wizard. Required en REQUIRED: Reference to a formally registered thesaurus or a similar authoritative source of theme keywords. ESRI ArcCatalog 9.3.1.3500 REQUIRED: The name of an organization or individual that developed the data set. REQUIRED: The date when the data set is published or otherwise made available for release. NW_CASES vector digital data withheld REQUIRED: The basis on which the time period of content information is determined. REQUIRED: The year (and optionally month, or month and day) for which the data set corresponds to the ground. REQUIRED: The state of the data set. REQUIRED: The frequency with which changes and additions are made to the data set after the initial data set is completed. -112.507744 -112.057520 33.996578 33.423308 520851.313000 657025.988750 882051.477250 1090168.396750 REQUIRED: Restrictions and legal prerequisites for accessing the data set. REQUIRED: Restrictions and legal prerequisites for using the data set after access is granted. Feature Class PEORIA_PD_AZ_CASES IW-203912-28834 1 0 2024-11-27 13:31 831 RTRIM(lecase.casenumber) + '-' + ISNULL(RTRIM(CAST(lecaseoffense.ibrseqnumber AS CHAR(3))), '1') AS PRIMARYKEY, LECase.CaseID AS CASE_ID, LTRIM(RTRIM(LECase.CaseNumber)) AS CASE_NUM, CASE WHEN (SELECT TOP 1(lecaseoffense.ibrseqnumber) FROM LECASEOFFENSE WHERE LECASE.CASEID = LECASEOFFENSE.CASEID ORDER BY lecaseoffense.ibrseqnumber ASC) = Lecaseoffense.ibrseqnumber THEN 'Y' ELSE 'N' END AS TOP_OFFENSE, lecaseoffense.ibrseqnumber AS OFF_SEQ, LTRIM(RTRIM(LECase.ORI)) AS AGENCY, CAST( (SELECT LTRIM(RTRIM(dbo.LECaseAssistingORI.ORI)) + '; ' FROM LECaseAssistingORI WHERE dbo.LECaseAssistingORI.CaseID = LECase.CaseID FOR XML PATH ('')) AS VARCHAR (255)) AS ASSISTING_AGENCY, /*LTRIM(RTRIM( dbo.LECaseAssistingORI.ORI)) AS ASSISTING_AGENCY,*/ LECase.OccurredFromDate AS FROM_DATETIME, LECase.OccurredThroughDate AS TO_DATETIME, DATEADD(minute, DATEDIFF(minute, LECase.OccurredFromDate, ISNULL(LECase.OccurredThroughDate, LECase.OccurredFromDate)) / 2 , LECase.OccurredFromDate) AS SPLIT_DATETIME, LECase.ReportedDate AS RPT_DATETIME, LECase.DispositionDate AS DISP_DATETIME, dbo.LECase.StatusDate AS STATUS_DATETIME, LECase.ClearanceDate AS CLEAR_DATETIME, LECase.DateChanged AS MODIFIED_DATETIME, LTRIM(RTRIM(LECaseOffense.OffenseID)) AS OFNS_ID, CASE WHEN REPLACE(CONVERT(CHAR(6), CAST(RIGHT(LECase.ReportedDate, 8) AS DATETIME), 108), ':', '') BETWEEN '0530' AND '1259' THEN 'DAYS (0530-1259)' WHEN REPLACE(CONVERT(CHAR(6), CAST(RIGHT(LECase.ReportedDate, 8) AS DATETIME), 108), ':', '') BETWEEN '1300' AND '2029' THEN 'SWINGS (1300-2029)' WHEN REPLACE(CONVERT(CHAR(6), CAST(RIGHT(LECase.ReportedDate, 8) AS DATETIME), 108), ':', '') >= '2030' OR REPLACE(CONVERT(CHAR(6), CAST(RIGHT(LECase.ReportedDate, 8) AS DATETIME), 108), ':', '') BETWEEN '0000' AND '0529' THEN 'GRAVES (2030-0529)' ELSE 'NA' END AS SHIFT, UPPER(LTRIM(RTRIM(CrimeCode.CrimeCode))) AS CRIME_CODE, UPPER(LTRIM(RTRIM(CrimeCode.Description))) AS CRIME_DESC, LECase.vsOccurredIncidentType AS OCC_INC_CODE, UPPER(LTRIM(RTRIM(VS_1.ENTRYVALUE))) AS OCC_INC_TYPE, dbo.Statute.ReportingHierarchy AS REPORTING_HIERARCHY, CASE WHEN dbo.Statute.UCRReportableFlag = 1 THEN 'Y' ELSE 'N' END AS UCR_RPT_FLAG, CASE WHEN lecaseoffense.SubmitOffenseFlag = 1 THEN 'Y' ELSE 'N' END AS SUBMIT_OFFENSE_FLAG, dbo.Statute.vsUCRMinorClass, VS_14.ENTRYVALUE AS UCR_SCODE, VS_15.ENTRYVALUE AS UCR_RCODE, VS_50.ENTRYVALUE AS UCR_MINOR_CODE, VS_50.DESCRIPTION AS UCR_MINOR_DESC, CASE WHEN VS_50.ENTRYVALUE IS NOT NULL THEN CASE WHEN VS_50.ENTRYVALUE = '01A' THEN 'Part I Violent' WHEN VS_50.ENTRYVALUE = '01B' THEN 'Part I Violent' WHEN VS_50.ENTRYVALUE = '02' THEN 'Part I Violent' WHEN VS_50.ENTRYVALUE = '03' THEN 'Part I Violent' WHEN VS_50.ENTRYVALUE = '04' THEN 'Part I Violent' WHEN VS_50.ENTRYVALUE = '05' THEN 'Part I Property' WHEN VS_50.ENTRYVALUE = '06' THEN 'Part I Property' WHEN VS_50.ENTRYVALUE = '07' THEN 'Part I Property' WHEN VS_50.ENTRYVALUE = '08' THEN 'Part II' WHEN VS_50.ENTRYVALUE = '09' THEN 'Part I Property' WHEN VS_50.ENTRYVALUE = '10' THEN 'Part II' WHEN VS_50.ENTRYVALUE = '11' THEN 'Part II' WHEN VS_50.ENTRYVALUE = '12' THEN 'Part II' WHEN VS_50.ENTRYVALUE = '13' THEN 'Part II' WHEN VS_50.ENTRYVALUE = '14' THEN 'Part II' WHEN VS_50.ENTRYVALUE = '15' THEN 'Part II' WHEN VS_50.ENTRYVALUE = '16' THEN 'Part II' WHEN VS_50.ENTRYVALUE = '16A' THEN 'Part II' WHEN VS_50.ENTRYVALUE = '16B' THEN 'Part II' WHEN VS_50.ENTRYVALUE = '16C' THEN 'Part II' WHEN VS_50.ENTRYVALUE = '17' THEN 'Part II' WHEN VS_50.ENTRYVALUE = '18A' THEN 'Part II' WHEN VS_50.ENTRYVALUE = '18B' THEN 'Part II' WHEN VS_50.ENTRYVALUE = '18C' THEN 'Part II' WHEN VS_50.ENTRYVALUE = '18D' THEN 'Part II' WHEN VS_50.ENTRYVALUE = '18E' THEN 'Part II' WHEN VS_50.ENTRYVALUE = '18F' THEN 'Part II' WHEN VS_50.ENTRYVALUE = '18G' THEN 'Part II' WHEN VS_50.ENTRYVALUE = '18H' THEN 'Part II' WHEN VS_50.ENTRYVALUE = '19A' THEN 'Part II' WHEN VS_50.ENTRYVALUE = '19B' THEN 'Part II' WHEN VS_50.ENTRYVALUE = '19C' THEN 'Part II' WHEN VS_50.ENTRYVALUE = '20' THEN 'Part II' WHEN VS_50.ENTRYVALUE = '21' THEN 'Part II' WHEN VS_50.ENTRYVALUE = '22' THEN 'Part II' WHEN VS_50.ENTRYVALUE = '23' THEN 'Part II' WHEN VS_50.ENTRYVALUE = '24' THEN 'Part II' WHEN VS_50.ENTRYVALUE = '25' THEN 'Part II' WHEN VS_50.ENTRYVALUE = '26' THEN 'Part II' WHEN VS_50.ENTRYVALUE = '27' THEN 'Part II' WHEN VS_50.ENTRYVALUE = '28' THEN 'Part II' WHEN VS_50.ENTRYVALUE = '29' THEN 'Part II' WHEN VS_50.ENTRYVALUE = '30' THEN 'Part I Violent' WHEN VS_50.ENTRYVALUE = '31' THEN 'Part I Violent' ELSE 'Other' END WHEN VS_15.ENTRYVALUE IS NOT NULL OR VS_15.ENTRYVALUE NOT LIKE '%SELECT TYPE%' THEN (CASE WHEN VS_15.ENTRYVALUE = 'Assault - Firearm' THEN 'Part I Violent' WHEN VS_15.ENTRYVALUE = 'Assault - Hands Fists Feet Etc' THEN 'Part I Violent' WHEN VS_15.ENTRYVALUE = 'Assault - Knife' THEN 'Part I Violent' WHEN VS_15.ENTRYVALUE = 'Assault - Other Dangerous Weapon' THEN 'Part I Violent' WHEN VS_15.ENTRYVALUE = 'Assault - Simple' THEN 'Part II' WHEN VS_15.ENTRYVALUE = 'Burglary - Attempted Force' THEN 'Part I Property' WHEN VS_15.ENTRYVALUE = 'Burglary - Forcible Entry' THEN 'Part I Property' WHEN VS_15.ENTRYVALUE = 'Burglary - Unlawful Entry' THEN 'Part I Property' WHEN VS_15.ENTRYVALUE = 'Larceny Theft' THEN 'Part I Property' WHEN VS_15.ENTRYVALUE = 'Manslaughter by negligence' THEN 'Part I Violent' WHEN VS_15.ENTRYVALUE = 'Murder/Nonnegligent manslaughter' THEN 'Part I Violent' WHEN VS_15.ENTRYVALUE = 'MVT - Auto' THEN 'Part I Property' WHEN VS_15.ENTRYVALUE = 'MVT - Motorcycles' THEN 'Part I Property' WHEN VS_15.ENTRYVALUE = 'MVT - Other' THEN 'Part I Property' WHEN VS_15.ENTRYVALUE = 'MVT - Trucks and Buses' THEN 'Part I Property' WHEN VS_15.ENTRYVALUE = 'Rape - Attempted Forcible' THEN 'Part I Violent' WHEN VS_15.ENTRYVALUE = 'Rape - Commited by Force' THEN 'Part I Violent' WHEN VS_15.ENTRYVALUE = 'Robbery - Firearm' THEN 'Part I Violent' WHEN VS_15.ENTRYVALUE = 'Robbery - Knife' THEN 'Part I Violent' WHEN VS_15.ENTRYVALUE = 'Robbery - Other weapon' THEN 'Part I Violent' WHEN VS_15.ENTRYVALUE = 'Robbery - Strong arm' THEN 'Part I Violent' END) ELSE 'Other' END as UCR_TYPE, VS_45.ENTRYVALUE AS LARC_TYPE, LECaseOffense.StatuteID AS STAT_ID, LTRIM(RTRIM(Statute.Statute)) AS STAT_CODE, UPPER(LTRIM(RTRIM(Substring(Statute.Description, 1, 80)))) AS STAT_DESC, UPPER(LTRIM(RTRIM(VS_40.ENTRYVALUE))) AS CASE_STAT, LECase.vsDisposition AS DISPO_CODE, UPPER(LTRIM(RTRIM(VS_2.ENTRYVALUE))) AS DISPO_DESC, VS_46.ENTRYVALUE AS EXCEPT_CLEAR, VS_49.ENTRYVALUE AS ATTEMPT_DESC, LTRIM(RTRIM(Address.XStreetName)) AS CROSS_STREET, CAST( CASE WHEN LTRIM(RTRIM(Address.HouseNumber)) IS NOT NULL THEN CAST(LTRIM(RTRIM(Address.HouseNumber)) AS VARCHAR(10)) + ' ' + ISNULL(LTRIM(RTRIM(Address.StreetPrefix)) + ' ','') + ISNULL(LTRIM(RTRIM(Address.StreetName)) + ' ','') + ISNULL(LTRIM(RTRIM(Address.StreetType)) + ' ','') + ISNULL(LTRIM(RTRIM(Address.StreetSuffix)) + ' ','') WHEN LTRIM(RTRIM(Address.HouseNumber)) IS NULL AND LTRIM(RTRIM(Address.XStreetName)) IS NOT NULL THEN UPPER(ISNULL(LTRIM(RTRIM(Address.StreetPrefix)) + ' ','') + ISNULL(LTRIM(RTRIM(Address.StreetName)) + ' ','') + ISNULL(LTRIM(RTRIM(Address.StreetType))+ ' ','') + ISNULL(LTRIM(RTRIM(Address.StreetSuffix)) + ' ','') + '/ ' + ISNULL(LTRIM(RTRIM(Address.XStreetPrefix)) + ' ','') + ISNULL(LTRIM(RTRIM(Address.XStreetName)) + ' ','') + ISNULL(LTRIM(RTRIM(Address.XStreetType)) + ' ','') + ISNULL(LTRIM(RTRIM(Address.XStreetSuffix)),'')) ELSE ISNULL(LTRIM(RTRIM(Address.StreetPrefix)) + ' ','') + ISNULL(LTRIM(RTRIM(Address.StreetName)) + ' ','') + ISNULL(LTRIM(RTRIM(Address.StreetType)) + ' ','') + ISNULL(LTRIM(RTRIM(Address.StreetSuffix)) + ' ','') END AS VARCHAR(129)) AS CVADDRESS, CASE WHEN LTRIM(RTRIM(Address.HouseNumber)) IS NOT NULL THEN CAST(LTRIM(RTRIM(Address.HouseNumber)) AS VARCHAR(10)) + ' ' + ISNULL(LTRIM(RTRIM(Address.StreetPrefix)) + ' ','') + ISNULL(LTRIM(RTRIM(Address.StreetName)) + ' ','') + ISNULL(LTRIM(RTRIM(Address.StreetType)) + ' ','') + ISNULL(LTRIM(RTRIM(Address.StreetSuffix)) + ' ','') + ISNULL(LTRIM(RTRIM(Address.Zip)) + ' ','') WHEN LTRIM(RTRIM(Address.HouseNumber)) IS NULL AND LTRIM(RTRIM(Address.XStreetName)) IS NOT NULL THEN UPPER(ISNULL(LTRIM(RTRIM(Address.StreetPrefix)) + ' ','') + ISNULL(LTRIM(RTRIM(Address.StreetName)) + ' ','') + ISNULL(LTRIM(RTRIM(Address.StreetType))+ ' ','') + ISNULL(LTRIM(RTRIM(Address.StreetSuffix)) + ' ','') + '/ ' + ISNULL(LTRIM(RTRIM(Address.XStreetPrefix)) + ' ','') + ISNULL(LTRIM(RTRIM(Address.XStreetName)) + ' ','') + ISNULL(LTRIM(RTRIM(Address.XStreetType)) + ' ','') + ISNULL(LTRIM(RTRIM(Address.XStreetSuffix)),'')) + ISNULL(LTRIM(RTRIM(Address.Zip)) + ' ','') ELSE ISNULL(LTRIM(RTRIM(Address.StreetPrefix)) + ' ','') + ISNULL(LTRIM(RTRIM(Address.StreetName)) + ' ','') + ISNULL(LTRIM(RTRIM(Address.StreetType)) + ' ','') + ISNULL(LTRIM(RTRIM(Address.StreetSuffix)) + ' ','') + ISNULL(LTRIM(RTRIM(Address.Zip)) + ' ','') END AS CVADDRESS_ZIP, LTRIM(RTRIM(dbo.Address.Apt)) AS APT, CAST(CASE WHEN LTRIM(RTRIM(Address.HouseNumber)) IS NULL AND LTRIM(RTRIM(Address.XStreetName)) IS NULL THEN REPLACE(LTRIM(RTRIM(Address.StreetName)), '~', '') WHEN LTRIM(RTRIM(Address.HouseNumber)) IS NULL AND LTRIM(RTRIM(Address.XStreetName)) IS NOT NULL THEN UPPER(ISNULL(LTRIM(RTRIM(Address.StreetPrefix)) + ' ','') + ISNULL(LTRIM(RTRIM(Address.StreetName)) + ' ','') + ISNULL(LTRIM(RTRIM(Address.StreetType))+ ' ','') + ISNULL(LTRIM(RTRIM(Address.StreetSuffix)) + ' ','') + '/ ' + ISNULL(LTRIM(RTRIM(Address.XStreetPrefix)) + ' ','') + ISNULL(LTRIM(RTRIM(Address.XStreetName)) + ' ','') + ISNULL(LTRIM(RTRIM(Address.XStreetType)) + ' ','') + ISNULL(LTRIM(RTRIM(Address.XStreetSuffix)),'')) ELSE CAST(LTRIM(RTRIM(Address.HouseNumber)) AS VARCHAR(10)) + ' ' + ISNULL(LTRIM(RTRIM(Address.StreetPrefix)) + ' ','') + ISNULL(LTRIM(RTRIM(Address.StreetName)) + ' ','') + ISNULL(LTRIM(RTRIM(Address.StreetType)) + ' ','') + ISNULL(LTRIM(RTRIM(Address.StreetSuffix)) + ' ','') + ISNULL(LTRIM(RTRIM(Address.City)) + ' ','') + ', ' + ISNULL(LTRIM(RTRIM(VS_6.ENTRYVALUE)) + ' ','') + ISNULL(LTRIM(RTRIM(Address.Zip)) + ' ','') END AS VARCHAR (255)) AS CVADDRESS_ALL, LTRIM(RTRIM(Address.Zip)) AS ZIPCODE, LTRIM(RTRIM(Address.Zip4)) AS ZIPCODE2, Address.Lat AS LATITUDE, Address.Lon AS LONGITUDE, LTRIM(RTRIM(Address.City)) AS CITY, LTRIM(RTRIM(VS_6.ENTRYVALUE)) AS STATE, CAST((SELECT LTRIM(RTRIM(CommonNameAddress.CommonName)) + '; ' FROM CommonNameAddress WHERE CommonNameAddress.AddressID = LECASE.ADDRESSID FOR XML PATH('')) AS VARCHAR (255)) AS COMMON_NAME, LTRIM(RTRIM(VS_21.ENTRYVALUE)) AS DOM_CODE, LTRIM(RTRIM(VS_22.ENTRYVALUE)) AS GANG_REL, LTRIM(RTRIM(VS_23.ENTRYVALUE)) AS BIAS, LTRIM(RTRIM(VS_24.ENTRYVALUE)) AS SCENE1, LTRIM(RTRIM(VS_25.ENTRYVALUE)) AS SCENE2, LTRIM(RTRIM(LECaseOffense.PremisesEntered)) AS PREM_CODE, CAST((SELECT (SELECT ValidationSetEntry.EntryValue FROM ValidationSetEntry WHERE (ValidationSetEntry.EntryID = LECaseModusOperandi.vsModusOperandi AND ValidationSetEntry.SetID = '35')) + '; ' FROM LECaseModusOperandi WHERE LECASE.CaseID = LECaseModusOperandi.CaseID FOR XML PATH('')) AS VARCHAR (255)) MO_DESC, CAST((SELECT LECaseModusOperandi.vsModusOperandi + ' ' FROM LECaseModusOperandi WHERE LECASE.CaseID = LECaseModusOperandi.CaseID FOR XML PATH('')) AS VARCHAR (255)) AS MO_CODE, LTRIM(RTRIM(VS_26.ENTRYVALUE)) AS MOEN_CODE, LTRIM(RTRIM(VS_27.ENTRYVALUE)) AS MOEN_TYPE, LTRIM(RTRIM(VS_28.ENTRYVALUE)) AS MOEX_CODE, LTRIM(RTRIM(VS_29.ENTRYVALUE)) AS MOEX_TYPE, LTRIM(RTRIM(VS_30.ENTRYVALUE)) AS POEN_CODE, LTRIM(RTRIM(VS_31.ENTRYVALUE)) AS POEX_CODE, LTRIM(RTRIM(VS_32.ENTRYVALUE)) AS OFF_ALCOH, LTRIM(RTRIM(VS_33.ENTRYVALUE)) AS OFF_COMPTR, LTRIM(RTRIM(VS_34.ENTRYVALUE)) AS OFF_DRUGS, LTRIM(RTRIM(VS_35.ENTRYVALUE)) AS VIC_ALCOH, LTRIM(RTRIM(VS_36.ENTRYVALUE)) AS VIC_COMPTR, LTRIM(RTRIM(VS_37.ENTRYVALUE)) AS VIC_DRUGS, CAST( STUFF( (SELECT ' || ' + ValidatiONsetentry.ENTRYVALUE FROM LeCaseOffenseWeapon, validatiONsetentry WHERE LECaseOffense.OffenseID = LeCaseOffenseWeapon.OffenseID AND LECaseOffenseWeapon.vsWeapon = validatiONsetentry.ENTRYID FOR XML PATH('')), 1, 4, '') AS VARCHAR(255)) AS WEAPON, CAST( LEFT( (SELECT DISTINCT UPPER(VOR.ENTRYVALUE) + ' || ' FROM dbo.LECaseSubject, validatiONsetentry SubjectType, LeCaseSubjectVOR, validatiONsetentry VOR WHERE dbo.LECaseSubject.CaseID = LECASE.CASEID AND dbo.LECaseSubject.vsSubjectType = SubjectType.ENTRYID AND SubjectType.ENTRYVALUE LIKE 'V%' AND dbo.LECaseSubjectVOR.VictimID = dbo.LECaseSubject.SubjectID AND dbo.LECaseSubjectVOR.vsRelationshipType = VOR.ENTRYID FOR XML PATH('')) , LEN( (SELECT DISTINCT UPPER(VOR.ENTRYVALUE) + ' || ' FROM dbo.LECaseSubject, validatiONsetentry SubjectType, LeCaseSubjectVOR, validatiONsetentry VOR WHERE dbo.LECaseSubject.CaseID = LECASE.CASEID AND dbo.LECaseSubject.vsSubjectType = SubjectType.ENTRYID AND SubjectType.ENTRYVALUE LIKE 'V%' AND dbo.LECaseSubjectVOR.VictimID = dbo.LECaseSubject.SubjectID AND dbo.LECaseSubjectVOR.vsRelationshipType = VOR.ENTRYID FOR XML PATH('')) )-3) AS VARCHAR(255)) AS VIC_OFNDR_REL, CAST( UPPER( ISNULL(VS_AGGASLT1.ENTRYVALUE, '') + ISNULL(' || ' + VS_AGGASLT2.ENTRYVALUE, '')) AS VARCHAR(50)) AS AGG_ASLT, CAST( UPPER(VS_OCCUP.ENTRYVALUE) AS VARCHAR(30)) AS OCCUPANCY, CAST( STUFF( (SELECT ' || ' + LTRIM(RTRIM(LECaseActivity.Comment)) FROM LECaseActivity WHERE LECaseActivity.CaseID = LECase.CaseID FOR XML PATH('')) , 1, 4, '') AS VARCHAR (255)) AS COMMENT, LTRIM(RTRIM(LECaseOffense.Remarks1)) AS REMARKS1, LTRIM(RTRIM(LECaseOffense.Remarks2)) AS REMARKS2, LTRIM(RTRIM(LECase.ReportedOfficerID)) AS OFFCR_ID, CASE WHEN Personnel.LastName IS NULL AND Personnel.FirstName IS NULL THEN '' ELSE UPPER(LTRIM(RTRIM(Personnel.LastName))) + ', ' + UPPER(LTRIM(RTRIM(Personnel.FirstName))) END AS OFFICER_NAME, VS_47.ENTRYVALUE AS ASSIGNED_BUREAU, LECaseAssignment.AssignmentDate AS ASSIGN_DATE, LECase.TotalSolvFactor AS SOLVFACTOR, CASE WHEN AssignedPersonnel.LastName IS NULL AND AssignedPersonnel.FirstName IS NULL THEN '' ELSE UPPER(LTRIM(RTRIM(AssignedPersonnel.LastName))) + ', ' + UPPER(LTRIM(RTRIM(AssignedPersonnel.FirstName))) END AS INVESTIGATOR_NAME, CAST( STUFF( (SELECT ' || ' + CAST(ValidationSetEntry.ENTRYVALUE AS VARCHAR(20)) FROM LECaseOffenseTool, ValidationSetEntry WHERE LECaseOffense.OffenseID = LECaseOffenseTool.OffenseID AND LECaseOffenseTool.vsTool = ValidationSetEntry.ENTRYID FOR XML PATH('')), 1, 4, '') AS VARCHAR(255)) AS TOOL, CAST( STUFF( (SELECT DISTINCT ' || ' + ValidationSetEntry.ENTRYVALUE FROM Property, PropertyCodeHistory, ValidationSetEntry VS_PropStatus, ValidationSetEntry WHERE Property.CaseID = LECaseOffense.CaseID AND Property.PropertyID = PropertyCodeHistory.PropertyID AND PropertyCodeHistory.vsPropertyCode = VS_PropStatus.ENTRYID AND Property.vsPropertyType = ValidationSetEntry.ENTRYID AND VS_PropStatus.ENTRYVALUE IN ('Burned', 'Destroyed/Damaged/Vandalized', 'Stolen') FOR XML PATH('')), 1, 4, '') AS VARCHAR(255)) AS PROPERTY_TYPE, CAST( STUFF( (SELECT DISTINCT ' || ' + VS_PropClass.ENTRYVALUE FROM Property LEFT OUTER JOIN PropertyCodeHistory ON (Property.PropertyID = PropertyCodeHistory.PropertyID) LEFT OUTER JOIN ValidationSetEntry VS_PropStatus ON (PropertyCodeHistory.vsPropertyCode = VS_PropStatus.ENTRYID) LEFT OUTER JOIN ValidationSetEntry VS_PropClass ON (Property.vsPropertyClass = VS_PropClass.ENTRYID) WHERE Property.CaseID = LECaseOffense.CaseID AND VS_PropStatus.ENTRYVALUE IN ('Burned', 'Destroyed/Damaged/Vandalized', 'Stolen') FOR XML PATH('')), 1, 4, '') AS VARCHAR(255)) AS PROPERTY_CLASS, CAST( STUFF( (SELECT DISTINCT ' || ' + CAST(VS_PropStatus.ENTRYVALUE AS VARCHAR(30)) FROM Property, PropertyCodeHistory, ValidationSetEntry VS_PropStatus WHERE Property.CaseID = LECaseOffense.CaseID AND Property.PropertyID = PropertyCodeHistory.PropertyID AND PropertyCodeHistory.vsPropertyCode = VS_PropStatus.ENTRYID AND VS_PropStatus.ENTRYVALUE IN ('Burned', 'Destroyed/Damaged/Vandalized', 'Stolen') FOR XML PATH('')), 1, 4, '') AS VARCHAR(255)) AS PROPERTY_CODE, CAST( ISNULL( STUFF( (SELECT ' || ' + 'VEH: ' + GlobalVehicle.Description FROM Property, PropertyCodeHistory, ValidationSetEntry VS_PropStatus, GlobalVehicle WHERE LECASE.CaseID = Property.CaseID AND Property.PropertyID = PropertyCodeHistory.PropertyID AND PropertyCodeHistory.vsPropertyCode = VS_PropStatus.ENTRYID AND VS_PropStatus.ENTRYVALUE IN ('Burned', 'Destroyed/Damaged/Vandalized', 'Stolen') AND Property.VehicleID = GlobalVehicle.VehicleID FOR XML PATH('')), 1, 4, '') , '') + ISNULL( STUFF( (SELECT ' || ' + 'PROP: ' + GlobalItem.ItemDescription FROM Property, PropertyCodeHistory, ValidationSetEntry VS_PropStatus, GlobalItem WHERE LECASE.CaseID = Property.CaseID AND Property.PropertyID = PropertyCodeHistory.PropertyID AND PropertyCodeHistory.vsPropertyCode = VS_PropStatus.ENTRYID AND VS_PropStatus.ENTRYVALUE IN ('Burned', 'Destroyed/Damaged/Vandalized', 'Stolen') AND Property.ItemID = GlobalItem.ItemID FOR XML PATH('')), 1, 4, '') , '') AS VARCHAR(4000)) AS PROPERTY_DETAILS, CAST( (SELECT SUM(Property.PropertyValue) FROM Property, PropertyCodeHistory, ValidationSetEntry VS_PropStatus WHERE Property.CaseID = LECaseOffense.CaseID AND Property.PropertyID = PropertyCodeHistory.PropertyID AND PropertyCodeHistory.vsPropertyCode = VS_PropStatus.ENTRYID AND VS_PropStatus.ENTRYVALUE IN ('Burned', 'Destroyed/Damaged/Vandalized', 'Stolen')) AS INT) AS PROPERTY_VALUE, CAST( STUFF( (SELECT ' || ' + ISNULL('YEAR: ' + CAST(GlobalVehicle.VehicleYear AS VARCHAR(10)), '') + ISNULL(' - MAKE: ' + vs_VehMake.EntryValue, '') + ISNULL(' - MODEL: ' + GlobalVehicle.Model, '') + ISNULL(' - TYPE: ' + vs_VehType.EntryValue, '') + ISNULL(' - STYLE: ' + vs_VehStyle.Description, '') + ISNULL(' - BOT COLOR: ' + vs_BotColor.EntryValue, '') + ISNULL(' - TOP COLOR: ' + vs_TopColor.EntryValue, '') + ISNULL(' - PLATE: ' + GlobalVehicle.RegistrationNumber, '') FROM LECaseSuspectVehicle LEFT OUTER JOIN GlobalVehicle ON (GlobalVehicle.VehicleID = LECaseSuspectVehicle.VehicleID ) LEFT OUTER JOIN ValidationSetEntry vs_VehRole ON (vs_VehRole.EntryID = LECaseSuspectVehicle.vsRole) LEFT OUTER JOIN ValidationSetEntry vs_VehMake ON (vs_VehMake.EntryID = GlobalVehicle.vsMake) LEFT OUTER JOIN ValidationSetEntry vs_VehType ON (vs_VehType.EntryID = GlobalVehicle.vsVehicleType) LEFT OUTER JOIN ValidationSetEntry vs_VehStyle ON (vs_VehStyle.EntryID = GlobalVehicle.vsStyle) LEFT OUTER JOIN ValidationSetEntry vs_TopColor ON (vs_TopColor.EntryID = GlobalVehicle.vsColorTop) LEFT OUTER JOIN ValidationSetEntry vs_BotColor ON (vs_BotColor.EntryID = GlobalVehicle.vsColorBottom ) WHERE LECaseSuspectVehicle.CaseID = LECASE.CaseID AND vs_VehRole.EntryValue IN ('Suspect Vehicle') FOR XML PATH('')), 1, 4, '') AS VARCHAR(4000)) AS SUSPECT_VEHICLE, CAST( STUFF( (SELECT ' || ' + ISNULL('YEAR: ' + CAST(GlobalVehicle.VehicleYear AS VARCHAR(10)), '') + ISNULL(' - MAKE: ' + vs_VehMake.EntryValue, '') + ISNULL(' - MODEL: ' + GlobalVehicle.Model, '') + ISNULL(' - TYPE: ' + vs_VehType.EntryValue, '') + ISNULL(' - STYLE: ' + vs_VehStyle.Description, '') + ISNULL(' - BOT COLOR: ' + vs_BotColor.EntryValue, '') + ISNULL(' - TOP COLOR: ' + vs_TopColor.EntryValue, '') + ISNULL(' - PLATE: ' + GlobalVehicle.RegistrationNumber, '') FROM Property, PropertyCodeHistory, ValidationSetEntry VS_PropStatus, GlobalVehicle LEFT OUTER JOIN ValidationSetEntry vs_VehMake ON (vs_VehMake.EntryID = GlobalVehicle.vsMake) LEFT OUTER JOIN ValidationSetEntry vs_VehType ON (vs_VehType.EntryID = GlobalVehicle.vsVehicleType) LEFT OUTER JOIN ValidationSetEntry vs_VehStyle ON (vs_VehStyle.EntryID = GlobalVehicle.vsStyle) LEFT OUTER JOIN ValidationSetEntry vs_TopColor ON (vs_TopColor.EntryID = GlobalVehicle.vsColorTop) LEFT OUTER JOIN ValidationSetEntry vs_BotColor ON (vs_BotColor.EntryID = GlobalVehicle.vsColorBottom ) WHERE LECASE.CaseID = Property.CaseID AND Property.PropertyID = PropertyCodeHistory.PropertyID AND PropertyCodeHistory.vsPropertyCode = VS_PropStatus.ENTRYID AND VS_PropStatus.ENTRYVALUE IN ('Burned', 'Destroyed/Damaged/Vandalized', 'Stolen') AND Property.VehicleID = GlobalVehicle.VehicleID FOR XML PATH('')), 1, 4, '') AS VARCHAR(4000)) AS VICTIM_VEHICLE, (SELECT COUNT(DISTINCT LECaseSubject.SubjectID) FROM LECaseSubjectRelatedOffense, LECaseSubject WHERE LECASEOFFENSE.OffenseID = LECaseSubjectRelatedOffense.OffenseID AND LECaseSubjectRelatedOffense.SubjectID = LECaseSubject.SubjectID AND LECaseOffense.CaseID = LECaseSubject.CaseID AND LECaseSubject.vsSubjectType = 805) AS VICT_CNT LECASE LEFT OUTER JOIN ADDRESS ON (LECASE.ADDRESSID = ADDRESS.ADDRESSID) LEFT OUTER JOIN LECASEOFFENSE ON (LECASE.CASEID = LECASEOFFENSE.CASEID) LEFT OUTER JOIN validatiONsetentry VS_1 ON (LECase.vsOccurredIncidentType = VS_1.ENTRYID) LEFT OUTER JOIN validatiONsetentry VS_2 ON (LECase.vsDisposition = VS_2.ENTRYID) LEFT OUTER JOIN validatiONsetentry VS_3 ON (LECase.vsExceptionalClearance = VS_3.ENTRYID) LEFT OUTER JOIN validatiONsetentry VS_4 ON (LECaseOffense.vsAttemptCode = VS_4.ENTRYID) LEFT OUTER JOIN validatiONsetentry VS_5 ON (LECaseOffense.vsOffenseStatus = VS_5.ENTRYID) LEFT OUTER JOIN validatiONsetentry VS_6 ON (Address.vsState = VS_6.ENTRYID) LEFT OUTER JOIN validatiONsetentry VS_7 ON (LECaseOffense.vsNCICCode = VS_7.ENTRYID) LEFT OUTER JOIN validatiONsetentry VS_8 ON (LECaseOffense.vsOccupancyCode = VS_8.ENTRYID) LEFT OUTER JOIN validatiONsetentry VS_9 ON (LECaseOffense.vsSubcode = VS_9.ENTRYID) LEFT OUTER JOIN validatiONsetentry VS_10 ON (LECaseOffense.vsAggravatedAssault1 = VS_10.ENTRYID) LEFT OUTER JOIN validatiONsetentry VS_11 ON (LECaseOffense.vsAggravatedAssault2 = VS_11.ENTRYID) LEFT OUTER JOIN validatiONsetentry VS_12 ON (LECaseOffense.vsArsonCode = VS_12.ENTRYID) LEFT OUTER JOIN validatiONsetentry VS_13 ON (LECaseOffense.vsLarcenyType = VS_13.ENTRYID) LEFT OUTER JOIN validatiONsetentry VS_14 ON (LECaseOffense.vsUCRStolenPropertyCode = VS_14.ENTRYID) LEFT OUTER JOIN validatiONsetentry VS_15 ON (LECaseOffense.vsUCRReturnACode = VS_15.ENTRYID) LEFT OUTER JOIN validatiONsetentry VS_16 ON (LECaseOffense.vsCounterfeitStatus = VS_16.ENTRYID) LEFT OUTER JOIN validatiONsetentry VS_17 ON (LECaseOffense.vsCounterfeitType = VS_17.ENTRYID) LEFT OUTER JOIN validatiONsetentry VS_18 ON (LECaseOffense.vsAccostingSituation = VS_18.ENTRYID) LEFT OUTER JOIN validatiONsetentry VS_19 ON (LECaseOffense.vsAidingAbetting = VS_19.ENTRYID) LEFT OUTER JOIN validatiONsetentry VS_20 ON (LECaseOffense.vsChildAbuse = VS_20.ENTRYID) LEFT OUTER JOIN validatiONsetentry VS_21 ON (LECaseOffense.vsDomesticCode = VS_21.ENTRYID) LEFT OUTER JOIN validatiONsetentry VS_22 ON (LECaseOffense.vsGangRelated = VS_22.ENTRYID) LEFT OUTER JOIN validatiONsetentry VS_23 ON (LECaseOffense.vsBiasMotivation = VS_23.ENTRYID) LEFT OUTER JOIN validatiONsetentry VS_24 ON (LECaseOffense.vsLocationScene = VS_24.ENTRYID) LEFT OUTER JOIN validatiONsetentry VS_25 ON (LECaseOffense.vsLocationScene2 = VS_25.ENTRYID) LEFT OUTER JOIN validatiONsetentry VS_26 ON (LECaseOffense.vsMethodOfEntry = VS_26.ENTRYID) LEFT OUTER JOIN validatiONsetentry VS_27 ON (LECaseOffense.vsMethodOfEntryType = VS_27.ENTRYID) LEFT OUTER JOIN validatiONsetentry VS_28 ON (LECaseOffense.vsMethodOfExit = VS_28.ENTRYID) LEFT OUTER JOIN validatiONsetentry VS_29 ON (LECaseOffense.vsMethodOfExitType = VS_29.ENTRYID) LEFT OUTER JOIN validatiONsetentry VS_30 ON (LECaseOffense.vsPointOfEntry = VS_30.ENTRYID) LEFT OUTER JOIN validatiONsetentry VS_31 ON (LECaseOffense.vsPointOfExit = VS_31.ENTRYID) LEFT OUTER JOIN validatiONsetentry VS_32 ON (LECaseOffense.vsOffenderAlcoholUse = VS_32.ENTRYID) LEFT OUTER JOIN validatiONsetentry VS_33 ON (LECaseOffense.vsOffenderComputerUse = VS_33.ENTRYID) LEFT OUTER JOIN validatiONsetentry VS_34 ON (LECaseOffense.vsOffenderDrugUse = VS_34.ENTRYID) LEFT OUTER JOIN validatiONsetentry VS_35 ON (LECaseOffense.vsVictimAlcoholUse = VS_35.ENTRYID) LEFT OUTER JOIN validatiONsetentry VS_36 ON (LECaseOffense.vsVictimComputerUse = VS_36.ENTRYID) LEFT OUTER JOIN validatiONsetentry VS_37 ON (LECaseOffense.vsVictimDrugUse = VS_37.ENTRYID) LEFT OUTER JOIN validatiONsetentry VS_39 ON (LECase.vsSignificantEvent = VS_39.ENTRYID) LEFT OUTER JOIN validatiONsetentry VS_40 ON (LECase.vsStatus = VS_40.ENTRYID) LEFT OUTER JOIN validatiONsetentry VS_AGGASLT1 ON (dbo.LECaseOffense.vsAggravatedAssault1 = VS_AGGASLT1.ENTRYID) LEFT OUTER JOIN validatiONsetentry VS_AGGASLT2 ON (dbo.LECaseOffense.vsAggravatedAssault2 = VS_AGGASLT2.ENTRYID) LEFT OUTER JOIN validatiONsetentry VS_OCCUP ON (dbo.LECaseOffense.vsOccupancyCode = VS_OCCUP.ENTRYID) LEFT OUTER JOIN statute ON (LECaseOffense.StatuteID = Statute.StatuteID) LEFT OUTER JOIN CrimeCode ON (Statute.CrimeCode = CrimeCode.CrimeCode) LEFT OUTER JOIN Personnel ON (Personnel.PersonnelID = LECase.ReportedOfficerID) LEFT OUTER JOIN validatiONsetentry VS_45 ON (LECaseOffense.vsLarcenyType = VS_45.ENTRYID) /*LEFT OUTER JOIN dbo.LECaseAssistingORI ON (dbo.LECaseAssistingORI.CaseID = LECase.CaseID)*/ LEFT OUTER JOIN validatiONsetentry VS_46 ON (LECase.vsExceptionalClearance = VS_46.ENTRYID) LEFT OUTER JOIN LECaseAssignment ON (LECaseAssignment.CaseID = LECase.CaseID AND LECaseAssignment.AssignmentID = (SELECT TOP 1 (LECaseAssignment.AssignmentID) FROM LECaseAssignment where LECaseAssignment.CaseID = LECase.CaseID order by dbo.LECaseAssignment.AssignmentDate ASC)) LEFT OUTER JOIN Personnel AssignedPersonnel ON (AssignedPersonnel.PersonnelID = LECaseAssignment.AssignedOfficerID) LEFT OUTER JOIN validatiONsetentry VS_47 ON (LECase.vsAssignedBureau = VS_47.ENTRYID) LEFT OUTER JOIN validatiONsetentry VS_49 ON (LECaseOffense.vsAttemptCode = VS_49.ENTRYID) LEFT OUTER JOIN validatiONsetentry VS_50 ON (dbo.Statute.vsUCRMinorClass = VS_50.ENTRYID) ( LECase.OccurredFromDate BETWEEN '2024-11-20 00:00:00' AND '2024-11-27 23:59:59' OR LECase.ReportedDate BETWEEN '2024-11-20 00:00:00' AND '2024-11-27 23:59:59' OR ( LECase.DateChanged BETWEEN '2024-11-20 00:00:00' AND '2024-11-27 23:59:59' AND LECase.DateChanged NOT BETWEEN '2023-03-09 00:00:00' AND '2023-03-09 23:59:59' ) OR ( LECaseOffense.DateChanged BETWEEN '2024-11-20 00:00:00' AND '2024-11-27 23:59:59' AND LECaseOffense.DateChanged NOT BETWEEN '2023-03-09 00:00:00' AND '2023-03-09 23:59:59' ) ) Update Duplicated Records [7] Updates the values and geometry of the duplicated records in the feature class that is being appended to using the primary key. Once the duplicated records are updated, any additional records are appended. If the existing feature class is not found then a new one is created. PRIMARYKEY FALSE No attribute query used. FALSE No spatial query used. None Date range not used NONE CVFROMDATE Date FROM_DATETIME REQUIRED 11 19300613 20241127 0 CVFROMDOW Day of Week FROM_DATETIME REQUIRED 11 0 CVFROMTIME Time FROM_DATETIME REQUIRED 9 0 CVDATETO Date TO_DATETIME REQUIRED 11 19300613 20241127 0 CVDOWTO Day of Week TO_DATETIME REQUIRED 11 0 CVTIMETO Time TO_DATETIME REQUIRED 9 0 CVDATESPLIT Date SPLIT_DATETIME REQUIRED 11 19300613 20241127 0 CVDOWSPLIT Day of Week SPLIT_DATETIME REQUIRED 11 0 CVTIMESPLIT Time SPLIT_DATETIME REQUIRED 9 0 CVDATERPT Date RPT_DATETIME REQUIRED 11 19500101 20241127 1 CVDOWRPT Day of Week RPT_DATETIME REQUIRED 11 1 CVTIMERPT Time RPT_DATETIME REQUIRED 9 1 CVDATESTATUS Date STATUS_DATETIME REQUIRED 11 19500101 20241219 0 CVDATEDISPO Date DISP_DATETIME REQUIRED 11 19500101 20241219 0 CV_ADDRESS_POINTS_102 CV_ADDRESS_POINTS_UNIT_102 CV_ADDRESS_POINTS_ZIP_102 CV_ESRI_STREETS_102 CV_ESRI_STREETS_ZIP_102 CV_PARCELS_102 CV_PARCELS_ZIP_102 CV_STREETS_102 CV_STREETS_NO_RULES_102 CV_STREETS_ZIP_102 X-Y Coordinates / & ; TRUE 13480 3378 303175 320033 98.94 TRUE 19300613 20241127 CVFROMDATE INCIDENT CVADDRESS NW_Cases_Details_Alpha.rpt NW_Cases_Details_Frequency.rpt NW_Cases_Temporal_Heat_Index.rpt NW_Cases_Threshold.rpt NW_Cases_RepeatCalls.rpt CVLEGEND NW 1ST OFFENSE (Cases) NW CRIME TYPE (Cases) NW NIBRS TYPE (Cases) NW CRIME AGAINST (Cases) NW OCCURRED INCIDENT TYPE (Cases & Involvement) NW DISPOSITION (Cases) NW ENTRY LOCATION (Cases) NW ENTRY METHOD (Cases) NW EXIT LOCATION (Cases) NW LOCATION TYPE (Cases) NW WEAPON (Cases) NW TOOLS (Cases) NW STATUS (Cases) NW UCR TYPE (Cases) NW UCR REPORTABLE (Cases) NW NIBRS REPORTABLE (Arrests & Cases) NW AGG ASSLT / HOM CIRC (Cases) NW VIC/OFNDR REL (Cases & Involvement) NW OCCUPANCY (Cases) NW PROPERTY CODE (Cases) NW PROPERTY TYPE (Cases) NW SUSPECT VEHICLE COLOR (Cases) NW SUSPECT VEHICLE STYLE (Cases) NW SUSPECT VEHICLE TYPE (Cases) NW VICTIM VEHICLE COLOR (Cases) NW VICTIM VEHICLE STYLE (Cases) NW VICTIM VEHICLE TYPE (Cases) NW SHIFT (Cases) NW DV RELATED (Cases) Version 6.2 (Build 9200) ; Esri ArcGIS 10.4.1.5686 NW_CASES 520851.313 657025.98875 1090168.39675 882051.47725 1 -112.507744 -112.05752 33.996578 33.423308 1 1 -112.915045 -111.645058 33.996659 33.293284 en FGDC Content Standards for Digital Geospatial Metadata FGDC-STD-001-1998 local time REQUIRED: The person responsible for the metadata information. REQUIRED: The organization responsible for the metadata information. REQUIRED: The mailing and/or physical address for the organization or individual. REQUIRED: The city of the address. REQUIRED: The state or province of the address. REQUIRED: The ZIP or other postal code of the address. REQUIRED: The telephone number by which individuals can speak to the organization or individual. 20131002 ISO 19115 Geographic Information - Metadata DIS_ESRI1.0 dataset Downloadable Data 002 withheld Feature Class Feature Class Vector Simple FALSE 262633 TRUE FALSE GCS_North_American_1983_HARN NAD_1983_HARN_StatePlane_Arizona_Central_FIPS_0202_Feet_Intl coordinate pair international feet 0.000250 0.000250 D_North_American_1983_HARN Geodetic Reference System 80 6378137.000000 298.257222 Explicit elevation coordinate included with horizontal coordinates 1.000000 NAD_1983_HARN_StatePlane_Arizona_Central_FIPS_0202_Feet_Intl EPSG 6.13(9.0.0) 262633 NW_CASES Feature Class 262633 ObjectID OBJECTID OID 4 10 0 Internal feature number. ESRI Sequential unique whole numbers that are automatically generated. PRIMARYKEY PRIMARYKEY String 17 0 0 CASE_ID CASE_ID Integer 4 10 0 CASE_NUM CASE_NUM String 13 0 0 TOP_OFFENSE TOP_OFFENSE String 1 0 0 OFF_SEQ OFF_SEQ SmallInteger 2 5 0 AGENCY AGENCY String 9 0 0 ASSISTING_AGENCY ASSISTING_AGENCY String 255 0 0 FROM_DATETIME FROM_DATETIME String 23 0 0 TO_DATETIME TO_DATETIME String 23 0 0 SPLIT_DATETIME SPLIT_DATETIME String 23 0 0 RPT_DATETIME RPT_DATETIME String 23 0 0 DISP_DATETIME DISP_DATETIME String 23 0 0 STATUS_DATETIME STATUS_DATETIME String 23 0 0 CLEAR_DATETIME CLEAR_DATETIME String 23 0 0 MODIFIED_DATETIME MODIFIED_DATETIME String 23 0 0 OFNS_ID OFNS_ID String 12 0 0 SHIFT SHIFT String 19 0 0 CRIME_CODE CRIME_CODE String 5 0 0 CRIME_DESC CRIME_DESC String 50 0 0 OCC_INC_CODE OCC_INC_CODE Integer 4 10 0 OCC_INC_TYPE OCC_INC_TYPE String 32 0 0 REPORTING_HIERARCHY REPORTING_HIERARCHY SmallInteger 2 5 0 UCR_RPT_FLAG UCR_RPT_FLAG String 1 0 0 vsUCRMinorClass vsUCRMinorClass Integer 4 10 0 UCR_SCODE UCR_SCODE String 32 0 0 UCR_RCODE UCR_RCODE String 32 0 0 UCR_MINOR_CODE UCR_MINOR_CODE String 32 0 0 UCR_MINOR_DESC UCR_MINOR_DESC String 128 0 0 UCR_TYPE UCR_TYPE String 15 0 0 LARC_TYPE LARC_TYPE String 32 0 0 STAT_ID STAT_ID Integer 4 10 0 STAT_CODE STAT_CODE String 32 0 0 STAT_DESC STAT_DESC String 80 0 0 CASE_STAT CASE_STAT String 32 0 0 DISPO_CODE DISPO_CODE Integer 4 10 0 DISPO_DESC DISPO_DESC String 32 0 0 EXCEPT_CLEAR EXCEPT_CLEAR String 32 0 0 ATTEMPT_DESC ATTEMPT_DESC String 32 0 0 CROSS_STREET CROSS_STREET String 50 0 0 CVADDRESS CVADDRESS String 129 0 0 APT APT String 32 0 0 CVADDRESS_ALL CVADDRESS_ALL String 255 0 0 ZIPCODE ZIPCODE String 20 0 0 ZIPCODE2 ZIPCODE2 String 20 0 0 LATITUDE LATITUDE Double 8 38 8 LONGITUDE LONGITUDE Double 8 38 8 CITY CITY String 32 0 0 STATE STATE String 32 0 0 COMMON_NAME COMMON_NAME String 255 0 0 DOM_CODE DOM_CODE String 32 0 0 GANG_REL GANG_REL String 32 0 0 BIAS BIAS String 32 0 0 SCENE1 SCENE1 String 32 0 0 SCENE2 SCENE2 String 32 0 0 PREM_CODE PREM_CODE String 12 0 0 MO_DESC MO_DESC String 255 0 0 MO_CODE MO_CODE String 255 0 0 MOEN_CODE MOEN_CODE String 32 0 0 MOEN_TYPE MOEN_TYPE String 32 0 0 MOEX_CODE MOEX_CODE String 32 0 0 MOEX_TYPE MOEX_TYPE String 32 0 0 POEN_CODE POEN_CODE String 32 0 0 POEX_CODE POEX_CODE String 32 0 0 OFF_ALCOH OFF_ALCOH String 32 0 0 OFF_COMPTR OFF_COMPTR String 32 0 0 OFF_DRUGS OFF_DRUGS String 32 0 0 VIC_ALCOH VIC_ALCOH String 32 0 0 VIC_COMPTR VIC_COMPTR String 32 0 0 VIC_DRUGS VIC_DRUGS String 32 0 0 WEAPON WEAPON String 255 0 0 COMMENT COMMENT String 255 0 0 REMARKS1 REMARKS1 String 128 0 0 REMARKS2 REMARKS2 String 128 0 0 OFFCR_ID OFFCR_ID String 12 0 0 OFFICER_NAME OFFICER_NAME String 42 0 0 ASSIGNED_BUREAU ASSIGNED_BUREAU String 32 0 0 ASSIGN_DATE ASSIGN_DATE String 23 0 0 SOLVFACTOR SOLVFACTOR Double 8 38 8 INVESTIGATOR_NAME INVESTIGATOR_NAME String 42 0 0 NARRATIVE NARRATIVE String 1200 0 0 CVLEGEND CVLEGEND String 255 0 0 NIBRS_TYPE NIBRS_TYPE String 255 0 0 CVFROMDATE CVFROMDATE Integer 4 10 0 CVFROMDOW CVFROMDOW SmallInteger 2 5 0 CVFROMTIME CVFROMTIME String 4 0 0 CVDATETO CVDATETO Integer 4 10 0 CVDOWTO CVDOWTO SmallInteger 2 5 0 CVTIMETO CVTIMETO String 4 0 0 CVDATESPLIT CVDATESPLIT Integer 4 10 0 CVDOWSPLIT CVDOWSPLIT SmallInteger 2 5 0 CVTIMESPLIT CVTIMESPLIT String 4 0 0 CVDATERPT CVDATERPT Integer 4 10 0 CVDOWRPT CVDOWRPT SmallInteger 2 5 0 CVTIMERPT CVTIMERPT String 4 0 0 CVDATESTATUS CVDATESTATUS Integer 4 10 0 CVDATEDISPO CVDATEDISPO Integer 4 10 0 iwTrans_7 iwTrans_7 String 40 0 0 iwTrans_1 iwTrans_1 String 40 0 0 iwStandard iwStandard String 255 0 0 iwGeoName iwGeoName String 40 0 0 iwStep iwStep SmallInteger 2 5 0 Status Status String 1 0 0 Score Score SmallInteger 2 5 0 Side Side String 1 0 0 X X Double 8 38 8 Y Y Double 8 38 8 Stan_Addr Stan_Addr String 80 0 0 CVZONE CVZONE String 50 0 0 CVGRID CVGRID String 5 0 0 CVBEATUPD CVBEATUPD String 10 0 0 CVDISTRICT CVDISTRICT Integer 4 10 0 CVPRECINCT CVPRECINCT String 50 0 0 CVZIPCODE CVZIPCODE String 255 0 0 Shape Shape Geometry 4 0 0 Feature geometry. ESRI Coordinates defining the features. SUBMIT_OFFENSE_FLAG SUBMIT_OFFENSE_FLAG String 3 0 0 VIC_OFNDR_REL VIC_OFNDR_REL String 255 0 0 AGG_ASLT AGG_ASLT String 50 0 0 OCCUPANCY OCCUPANCY String 30 0 0 TOOL TOOL String 255 0 0 PROPERTY_TYPE PROPERTY_TYPE String 255 0 0 PROPERTY_CLASS PROPERTY_CLASS String 255 0 0 PROPERTY_CODE PROPERTY_CODE String 255 0 0 PROPERTY_VALUE PROPERTY_VALUE Integer 4 10 0 VICTIM_VEHICLE VICTIM_VEHICLE String 4000 0 0 SUSPECT_VEHICLE SUSPECT_VEHICLE String 4000 0 0 PROPERTY_DETAILS PROPERTY_DETAILS String 4000 0 0 CRIMEAGAINST CRIMEAGAINST String 20 0 0 VICT_CNT VICT_CNT Integer 4 10 0 20211026 Dataset copied. withheld 20131002 09003300