Layer: Join_Features_to_2017_2020

View In: Map Viewer

Name: Join_Features_to_2017_2020_requests

Display Field:

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[79,129,189,255],"size":10,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[54,93,141,255],"width":1}}}}
HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)
Join_Count (type: esriFieldTypeInteger, alias: Join_Count, SQL Type: sqlTypeInteger, nullable: true, editable: true)
service_request_num (type: esriFieldTypeString, alias: service_request_num, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
sr_status (type: esriFieldTypeString, alias: sr_status, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
status_date (type: esriFieldTypeDate, alias: status_date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
last_activity (type: esriFieldTypeString, alias: last_activity, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
outcome (type: esriFieldTypeString, alias: outcome, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
address (type: esriFieldTypeString, alias: address, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
neighborhood (type: esriFieldTypeString, alias: neighborhood, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
year_created (type: esriFieldTypeInteger, alias: year_created, SQL Type: sqlTypeInteger, nullable: true, editable: true)
month_created (type: esriFieldTypeInteger, alias: month_created, SQL Type: sqlTypeInteger, nullable: true, editable: true)
year_qrt_created (type: esriFieldTypeDouble, alias: year_qrt_created, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
wday_created (type: esriFieldTypeInteger, alias: wday_created, SQL Type: sqlTypeInteger, nullable: true, editable: true)
days_to_closed (type: esriFieldTypeDouble, alias: days_to_closed, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
requests_at_address (type: esriFieldTypeString, alias: requests_at_address, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
statefp (type: esriFieldTypeString, alias: statefp, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
countyfp (type: esriFieldTypeString, alias: countyfp, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
tractce (type: esriFieldTypeString, alias: tractce, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
geoid (type: esriFieldTypeDouble, alias: geoid, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
name (type: esriFieldTypeDouble, alias: name, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
namelsad (type: esriFieldTypeString, alias: namelsad, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
mtfcc (type: esriFieldTypeString, alias: mtfcc, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
funcstat (type: esriFieldTypeString, alias: funcstat, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
aland (type: esriFieldTypeString, alias: aland, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
awater (type: esriFieldTypeString, alias: awater, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
intptlat (type: esriFieldTypeDouble, alias: intptlat, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
intptlon (type: esriFieldTypeDouble, alias: intptlon, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
geo_address (type: esriFieldTypeString, alias: geo_address, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
city (type: esriFieldTypeString, alias: city, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
Zip (type: esriFieldTypeString, alias: Zip, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
FIPS (type: esriFieldTypeString, alias: FIPS, SQL Type: sqlTypeNVarchar, length: 11, nullable: true, editable: true)
COUNTY (type: esriFieldTypeString, alias: COUNTY, SQL Type: sqlTypeNVarchar, length: 50, nullable: true, editable: true)
STATE (type: esriFieldTypeString, alias: STATE, SQL Type: sqlTypeNVarchar, length: 2, nullable: true, editable: true)
POPULATION (type: esriFieldTypeInteger, alias: POP2018, SQL Type: sqlTypeInteger, nullable: true, editable: true)
SQMI (type: esriFieldTypeDouble, alias: SQMI, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
Shape__Area (type: esriFieldTypeDouble, alias: Shape__Area, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
ID (type: esriFieldTypeString, alias: Id, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
sourceCountry (type: esriFieldTypeString, alias: Country code, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
ENRICH_FID (type: esriFieldTypeInteger, alias: ENRICH_FID, SQL Type: sqlTypeInteger, nullable: true, editable: true)
aggregationMethod (type: esriFieldTypeString, alias: Aggregation method, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
populationToPolygonSizeRating (type: esriFieldTypeDouble, alias: Population to polygon size rating for the country, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
apportionmentConfidence (type: esriFieldTypeDouble, alias: Apportionment confidence for the country, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
HasData (type: esriFieldTypeInteger, alias: Has data, SQL Type: sqlTypeInteger, nullable: true, editable: true)
MEDHINC_CY (type: esriFieldTypeDouble, alias: 2019 Median Household Income, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
ACSHHBPOV (type: esriFieldTypeDouble, alias: 2014-2018 ACS HHs: Inc Below Poverty Level, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
ACSPOVINDX (type: esriFieldTypeDouble, alias: 2014-2018 ACS Poverty Index, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
TOTPOP_CY (type: esriFieldTypeDouble, alias: 2019 Total Population, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
DIVINDX_CY (type: esriFieldTypeDouble, alias: 2019 Diversity Index, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
CRMCYTOTC (type: esriFieldTypeDouble, alias: 2019 Total Crime Index, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
EvTrnsMean (type: esriFieldTypeDouble, alias: Mean Evapotranspiration, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
MeanSoilRa (type: esriFieldTypeDouble, alias: Mean Range Forage Annual Potential Production, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
ACSHHAPOV (type: esriFieldTypeDouble, alias: 2014-2018 ACS HHs:Inc at/Above Poverty Level, SQL Type: sqlTypeDecimal, nullable: true, editable: true)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/12/2020 1:30:43 PM

Schema Last Edit Date: 6/12/2020 1:30:43 PM

Data Last Edit Date: 6/12/2020 1:30:43 PM

Supported Operations: Query Query Pivot Query Top Features Query Analytic Query Bins Generate Renderer Validate SQL Get Estimates ConvertFormat

Layer: Join_Features_to_2017_2020_requests (ID:0)