Name: QueryTable1_Final_ish

Display Field: Name

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:

XMin: -165.396604673443
YMin: 19.4268030373835
XMax: -68.6509736285763
YMax: 64.8463270048123
Spatial Reference: 4269 (4269)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[34,132,88,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID_1

Unique ID Field:

Name : OBJECTID_1

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID_1 (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• Band_ID (type: esriFieldTypeBigInteger, alias: Band ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Name (type: esriFieldTypeString, alias: Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• URL (type: esriFieldTypeString, alias: URL, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Photo_URL (type: esriFieldTypeString, alias: Photo URL, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Location_forJoin (type: esriFieldTypeString, alias: Location_forJoin, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Location_FullHistory (type: esriFieldTypeString, alias: Location_FullHistory, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Formed_In (type: esriFieldTypeInteger, alias: Formed In, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Years_Active (type: esriFieldTypeString, alias: Years Active, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• City_Raw (type: esriFieldTypeString, alias: City_Raw, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• City_CleanedUp (type: esriFieldTypeString, alias: City_CleanedUp, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• State_Raw (type: esriFieldTypeString, alias: State_Raw, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• State_CleanedUp (type: esriFieldTypeString, alias: State_CleanedUp, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Genre (type: esriFieldTypeString, alias: Genre, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Genre_1 (type: esriFieldTypeString, alias: Genre 1, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Genre_2 (type: esriFieldTypeString, alias: Genre 2, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Genre_3 (type: esriFieldTypeString, alias: Genre 3, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Genre_4 (type: esriFieldTypeString, alias: Genre 4, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Genre_5 (type: esriFieldTypeString, alias: Genre 5, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Field20 (type: esriFieldTypeString, alias: Field20, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• OBJECTID (type: esriFieldTypeInteger, alias: OBJECTID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NAME_1 (type: esriFieldTypeString, alias: NAME, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• State (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Location (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CLASS (type: esriFieldTypeString, alias: CLASS, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• POPULATION (type: esriFieldTypeInteger, alias: POPULATION_2022, SQL Type: sqlTypeOther, nullable: true, editable: true)
• POP_CLASS (type: esriFieldTypeSmallInteger, alias: POP_CLASS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STATE_ABBR (type: esriFieldTypeString, alias: STATE_ABBR, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• STATE_FIPS (type: esriFieldTypeString, alias: STATE_FIPS, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• PLACE_FIPS (type: esriFieldTypeString, alias: PLACE_FIPS, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
• POP_SQMI (type: esriFieldTypeDouble, alias: POP22_SQMI, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SQMI (type: esriFieldTypeDouble, alias: SQMI, SQL Type: sqlTypeOther, nullable: true, editable: true)
• POPULATION_2020 (type: esriFieldTypeInteger, alias: POPULATION_2020, SQL Type: sqlTypeOther, nullable: true, editable: true)
• POP20_SQMI (type: esriFieldTypeDouble, alias: POP20_SQMI, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Band_ID_1 (type: esriFieldTypeBigInteger, alias: Band ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Name_12 (type: esriFieldTypeString, alias: Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• URL_1 (type: esriFieldTypeString, alias: URL, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Status_1 (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Photo_URL_1 (type: esriFieldTypeString, alias: Photo URL, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Location_1 (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Formed_In_1 (type: esriFieldTypeString, alias: Formed In, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Years_Active_1 (type: esriFieldTypeString, alias: Years Active, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• State_1 (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Genre_12 (type: esriFieldTypeString, alias: Genre, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Genre_12_13 (type: esriFieldTypeString, alias: Genre 1, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Genre_23 (type: esriFieldTypeString, alias: Genre 2, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Genre_34 (type: esriFieldTypeString, alias: Genre 3, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Genre_45 (type: esriFieldTypeString, alias: Genre 4, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Genre_56 (type: esriFieldTypeString, alias: Genre 5, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)

Templates:

Name: QueryTable1_Final_ish
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Relationships:

• USAStatesGeneralized_ForRelationship (0) -- Related To: USAStatesGeneralized_ForRelationship (1)
• USAStatesGeneralized_ForRelationship (1) -- Related To: USAStatesGeneralized_ForRelationship (1)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/13/2025 5:55:52 AM

Schema Last Edit Date: 3/13/2025 5:55:52 AM

Data Last Edit Date: 3/13/2025 5:55:52 AM

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