Name: RP_Address_SDE

Display Field: ADR_ADDRESS

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• ADR_ADNO (type: esriFieldTypeInteger, alias: ADR_ADNO, SQL Type: sqlTypeOther, nullable: false, editable: true)
• ADR_ADDRESS (type: esriFieldTypeString, alias: ADR_ADDRESS, SQL Type: sqlTypeOther, length: 49, nullable: false, editable: true)
• ADR_CITY_POSTAL (type: esriFieldTypeString, alias: ADR_CITY_POSTAL, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• ADR_ZIP (type: esriFieldTypeString, alias: ADR_ZIP, SQL Type: sqlTypeOther, length: 5, nullable: false, editable: true)
• ADR_TYPE (type: esriFieldTypeString, alias: ADR_TYPE, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true)
• ADR_CITY_MUNICIPAL (type: esriFieldTypeString, alias: ADR_CITY_MUNICIPAL, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• ADR_CITY_WARD (type: esriFieldTypeString, alias: ADR_CITY_WARD, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• ADR_CITY_PRECINCT (type: esriFieldTypeString, alias: ADR_CITY_PRECINCT, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• ADR_COUNTY_PRECINCT (type: esriFieldTypeString, alias: ADR_COUNTY_PRECINCT, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• ADR_RTD_DIST (type: esriFieldTypeString, alias: ADR_RTD_DIST, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• ADR_SJLID (type: esriFieldTypeString, alias: ADR_SJLID, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• ADR_TIFA (type: esriFieldTypeString, alias: ADR_TIFA, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• ADR_COMMISSIONER_DIST (type: esriFieldTypeString, alias: ADR_COMMISSIONER_DIST, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• ADR_US_HOUSE_DIST (type: esriFieldTypeString, alias: ADR_US_HOUSE_DIST, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• ADR_US_HOUSE_REP (type: esriFieldTypeString, alias: ADR_US_HOUSE_REP, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true)
• ADR_ST_HOUSE_DIST (type: esriFieldTypeString, alias: ADR_ST_HOUSE_DIST, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• ADR_ST_HOUSE_REP (type: esriFieldTypeString, alias: ADR_ST_HOUSE_REP, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true)
• ADR_ST_SENATE_DIST (type: esriFieldTypeString, alias: ADR_ST_SENATE_DIST, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• ADR_ST_SENATOR (type: esriFieldTypeString, alias: ADR_ST_SENATOR, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true)
• ADR_LONGITUDE (type: esriFieldTypeDouble, alias: ADR_LONGITUDE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ADR_LATITUDE (type: esriFieldTypeDouble, alias: ADR_LATITUDE, SQL Type: sqlTypeOther, nullable: false, editable: true)
• ADR_ELEVATION (type: esriFieldTypeInteger, alias: ADR_ELEVATION, SQL Type: sqlTypeOther, nullable: false, editable: true)
• PAR_AIN (type: esriFieldTypeString, alias: PAR_AIN, SQL Type: sqlTypeOther, length: 13, nullable: true, editable: true)
• AMA_ZONING_COUNT (type: esriFieldTypeSmallInteger, alias: AMA_ZONING_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AMA_ZONING1 (type: esriFieldTypeString, alias: AMA_ZONING1, SQL Type: sqlTypeOther, length: 48, nullable: true, editable: true)
• AMA_ZONING2 (type: esriFieldTypeString, alias: AMA_ZONING2, SQL Type: sqlTypeOther, length: 48, nullable: true, editable: true)
• AMA_ZONING3 (type: esriFieldTypeString, alias: AMA_ZONING3, SQL Type: sqlTypeOther, length: 48, nullable: true, editable: true)
• AMA_ZONING4 (type: esriFieldTypeString, alias: AMA_ZONING4, SQL Type: sqlTypeOther, length: 48, nullable: true, editable: true)
• AMA_ZONECASE (type: esriFieldTypeString, alias: AMA_ZONECASE, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
• AMA_HAZ_DIPPING_BEDROCK (type: esriFieldTypeString, alias: AMA_HAZ_DIPPING_BEDROCK, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• AMA_HAZ_FLOOD (type: esriFieldTypeString, alias: AMA_HAZ_FLOOD, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
• AMA_HAZ_GEOLOGIC (type: esriFieldTypeString, alias: AMA_HAZ_GEOLOGIC, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
• AMA_WATERSHED_AUTHORITY (type: esriFieldTypeString, alias: AMA_WATERSHED_AUTHORITY, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
• AMA_PRP_RECEPTION_ODP (type: esriFieldTypeString, alias: AMA_PRP_RECEPTION_ODP, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• AMA_PRP_RECEPTION_PLAT (type: esriFieldTypeString, alias: AMA_PRP_RECEPTION_PLAT, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• AMA_PRP_RECEPTION_OTHER (type: esriFieldTypeString, alias: AMA_PRP_RECEPTION_OTHER, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• AMA_COMMUNITY_PLAN (type: esriFieldTypeString, alias: AMA_COMMUNITY_PLAN, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)

Templates:

Name: RP_Address_SDE
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Relationships:

• AdrTbl2Par (2) -- Related To: RP_Parcel_FC (0)
• Adr2ParFC (0) -- Related To: RP_Parcel_FC (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/9/2023 8:11:28 AM

Schema Last Edit Date: 5/9/2023 8:11:28 AM

Data Last Edit Date: 5/9/2023 8:11:28 AM

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