Layer: FC_master_state

View In: Map Viewer

Name: FC_master_state_map

Display Field: name

Type: Feature Layer

Geometry Type: esriGeometryPolygon

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":"esriSFS","style":"esriSFSSolid","color":[79,129,189,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[54,93,141,255],"width":1.5}}},"scaleSymbols":true,"transparency":25,"labelingInfo":null}
HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
target_fid (type: esriFieldTypeInteger, alias: TARGET_FID, SQL Type: sqlTypeOther, nullable: true, editable: true)
state (type: esriFieldTypeString, alias: STATE, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
name (type: esriFieldTypeString, alias: NAME, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
fips (type: esriFieldTypeString, alias: FIPS, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
lon (type: esriFieldTypeDouble, alias: LON, SQL Type: sqlTypeOther, nullable: true, editable: true)
lat (type: esriFieldTypeDouble, alias: LAT, SQL Type: sqlTypeOther, nullable: true, editable: true)
re_st_code (type: esriFieldTypeString, alias: RE_ST_CODE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
count_retailers (type: esriFieldTypeInteger, alias: Total retailers, SQL Type: sqlTypeOther, nullable: true, editable: true)
count_retailers_inspany (type: esriFieldTypeInteger, alias: Total retailers with an inspection, SQL Type: sqlTypeOther, nullable: true, editable: true)
perc_retailers_inspany (type: esriFieldTypeDouble, alias: Percent of retailers with an inspection, SQL Type: sqlTypeOther, nullable: true, editable: true)
count_retailers_insp3yr (type: esriFieldTypeInteger, alias: Total retailers with an inspection 2017-2019, SQL Type: sqlTypeOther, nullable: true, editable: true)
perc_retailers_insp3yr (type: esriFieldTypeDouble, alias: Percent of retailers with an inspection 2017-2019, SQL Type: sqlTypeOther, nullable: true, editable: true)
count_retailers_vio (type: esriFieldTypeInteger, alias: Total retailers with a violative inspection, SQL Type: sqlTypeOther, nullable: true, editable: true)
perc_retailers_vio (type: esriFieldTypeDouble, alias: Percent of retailers with a violative inspection, SQL Type: sqlTypeOther, nullable: true, editable: true)
count_retailers_warnlet (type: esriFieldTypeInteger, alias: Total retailers with a warning letter, SQL Type: sqlTypeOther, nullable: true, editable: true)
perc_retailers_warnlet (type: esriFieldTypeDouble, alias: Percent of retailers with a warning letter, SQL Type: sqlTypeOther, nullable: true, editable: true)
count_retailers_cmp (type: esriFieldTypeInteger, alias: Total retailers with a CMP, SQL Type: sqlTypeOther, nullable: true, editable: true)
perc_retailers_cmp (type: esriFieldTypeDouble, alias: Percent of retailers with a CMP, SQL Type: sqlTypeOther, nullable: true, editable: true)
count_retailers_ntso (type: esriFieldTypeInteger, alias: Total retailers with an NTSO, SQL Type: sqlTypeOther, nullable: true, editable: true)
perc_retailers_ntso (type: esriFieldTypeDouble, alias: Percent of retailers with an NTSO, SQL Type: sqlTypeOther, nullable: true, editable: true)
avg_costinsp (type: esriFieldTypeInteger, alias: Average inspection cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
total_cost (type: esriFieldTypeInteger, alias: Total inspection cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
count_cost (type: esriFieldTypeInteger, alias: Total inspections, SQL Type: sqlTypeOther, nullable: true, editable: true)
count_vio_fu (type: esriFieldTypeInteger, alias: Count of Follow Up Inspections within 12 months of Violative Inspection, SQL Type: sqlTypeOther, nullable: true, editable: true)
percent_vio_fu (type: esriFieldTypeDouble, alias: Percent of Violative Inspections with a Follow Up Inspection, SQL Type: sqlTypeOther, nullable: true, editable: true)
count_multi (type: esriFieldTypeInteger, alias: Total retailers with multiple inspections, SQL Type: sqlTypeOther, nullable: true, editable: true)
percent_multi (type: esriFieldTypeDouble, alias: Percent of retailers with mulitple inspections, SQL Type: sqlTypeOther, nullable: true, editable: true)
correlation_cmpprop (type: esriFieldTypeDouble, alias: Correlation between ADI and the proportion of retailers with a CMP, SQL Type: sqlTypeOther, nullable: true, editable: true)
pvalue_cmpprop (type: esriFieldTypeDouble, alias: pvalue_cmpprop, SQL Type: sqlTypeOther, nullable: true, editable: true)
correlation_cmpratio (type: esriFieldTypeDouble, alias: Correlation between ADI and CMPs per retailer, SQL Type: sqlTypeOther, nullable: true, editable: true)
pvalue_cmpratio (type: esriFieldTypeDouble, alias: pvalue_cmpratio, SQL Type: sqlTypeOther, nullable: true, editable: true)
correlation_inspprop (type: esriFieldTypeDouble, alias: Correlation between ADI and the proportion of retailers with an inspection, SQL Type: sqlTypeOther, nullable: true, editable: true)
pvalue_inspprop (type: esriFieldTypeDouble, alias: pvalue_inspprop, SQL Type: sqlTypeOther, nullable: true, editable: true)
correlation_inspratio (type: esriFieldTypeDouble, alias: Correlation between ADI and inspections per retailer, SQL Type: sqlTypeOther, nullable: true, editable: true)
pvalue_inspratio (type: esriFieldTypeDouble, alias: pvalue_inspratio, SQL Type: sqlTypeOther, nullable: true, editable: true)
correlation_violative_inspprop (type: esriFieldTypeDouble, alias: Correlation between ADI and the proportion of retailers with a violative inspection, SQL Type: sqlTypeOther, nullable: true, editable: true)
pvalue_violative_inspprop (type: esriFieldTypeDouble, alias: pvalue_violative_inspprop, SQL Type: sqlTypeOther, nullable: true, editable: true)
correlation_violative_inspratio (type: esriFieldTypeDouble, alias: Correlation between ADI and violative inspections per retailer, SQL Type: sqlTypeOther, nullable: true, editable: true)
pvalue_violative_inspratio (type: esriFieldTypeDouble, alias: pvalue_violative_inspratio, SQL Type: sqlTypeOther, nullable: true, editable: true)
correlation_warnletprop (type: esriFieldTypeDouble, alias: Correlation between ADI and the proportion of retailers with a warning letter, SQL Type: sqlTypeOther, nullable: true, editable: true)
pvalue_warnletprop (type: esriFieldTypeDouble, alias: pvalue_warnletprop, SQL Type: sqlTypeOther, nullable: true, editable: true)
correlation_warnletratio (type: esriFieldTypeDouble, alias: Correlation between ADI and warning letters per retailer, SQL Type: sqlTypeOther, nullable: true, editable: true)
pvalue_warnletratio (type: esriFieldTypeDouble, alias: pvalue_warnletratio, SQL Type: sqlTypeOther, nullable: true, editable: true)
Shape__Area (type: esriFieldTypeDouble, alias: Shape__Area, SQL Type: sqlTypeDouble, nullable: true, editable: false)
Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)
avg_days (type: esriFieldTypeInteger, alias: Average Days Between a Violative Inspection and a Follow Up Inspection, SQL Type: sqlTypeOther, nullable: true, editable: true)
Year_Joined (type: esriFieldTypeString, alias: Year Joined, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
pct_fu_12_2 (type: esriFieldTypeDouble, alias: Percent of Violative Inspections with a Follow Up Inspection within 12 months, SQL Type: sqlTypeOther, nullable: true, editable: true)
months_btw (type: esriFieldTypeDouble, alias: Average months between a violative inspection and a followup inspection, SQL Type: sqlTypeOther, nullable: true, editable: true)
Year_Left (type: esriFieldTypeString, alias: Year Left, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/15/2023 6:31:24 PM

Schema Last Edit Date: 9/12/2023 4:07:28 PM

Data Last Edit Date: 9/15/2023 6:31:24 PM

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

Layer: FC_master_state_map (ID:0)