Name: Apartments/Suite Table

Display Field: St_Name

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: bff4b3b483d54ba5bcc402832ab8388c

Copyright Text: null

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• UniqueStructureNumber ( type: esriFieldTypeDouble, alias: Unique Structure Number )
• DiscrpAgID ( type: esriFieldTypeString, alias: Discrepancy Agency ID, length: 75 )
• DateUpdate ( type: esriFieldTypeDate, alias: Date record last updated, length: 8 )
• Effective ( type: esriFieldTypeDate, alias: Date record added, length: 8 )
• Expire ( type: esriFieldTypeDate, alias: Temporary address expiration date, length: 8 )
• Site_NGUID ( type: esriFieldTypeString, alias: Site NENA Globally Unique ID, length: 254 )
• Country ( type: esriFieldTypeString, alias: Country, length: 2 )
• Inc_Muni ( type: esriFieldTypeString, alias: Incorporated Municipality, length: 100 , Coded Values: [ATHENS TWP: ATHENS TWP] , [BEAVER TWP: BEAVER TWP] , [BLOOMFIELD TWP: BLOOMFIELD TWP] , ...76 more... )
• Inc_Muni_FIPS ( type: esriFieldTypeDouble, alias: Incorporated Municipality FIPS Code , Coded Values: [4203903408: ATHENS TWP (4203903408)] , [4203904720: BEAVER TWP (4203904720)] , [4203907032: BLOOMFIELD TWP (4203907032)] , ...75 more... )
• Add_Number ( type: esriFieldTypeDouble, alias: Address Number )
• AddNum_Suf ( type: esriFieldTypeString, alias: Address Number Suffix, length: 15 )
• St_PreDir ( type: esriFieldTypeString, alias: Street Name Pre Directional, length: 9 )
• St_Name ( type: esriFieldTypeString, alias: Street Name, length: 60 )
• St_PosTyp ( type: esriFieldTypeString, alias: Street Name Post Type, length: 50 )
• St_PosDir ( type: esriFieldTypeString, alias: Street Name Post Directional, length: 9 )
• St_FullName ( type: esriFieldTypeString, alias: Street Full Name, length: 160 )
• FullAddress ( type: esriFieldTypeString, alias: House # & Street, length: 200 )
• ESN ( type: esriFieldTypeSmallInteger, alias: Emergency Service Number )
• Post_Box ( type: esriFieldTypeString, alias: Current PO Box # (if applicable), length: 7 )
• Post_Comm ( type: esriFieldTypeString, alias: Postal Community Name, length: 40 , Coded Values: [ADAMSVILLE: ADAMSVILLE] , [ALBION: ALBION] , [ATLANTIC: ATLANTIC] , ...28 more... )
• Post_Code ( type: esriFieldTypeString, alias: Postal Code, length: 255 , Coded Values: [16110: ADAMSVILLE (16110)] , [16401: ALBION (16401)] , [16111: ATLANTIC (16111)] , ...26 more... )
• Building ( type: esriFieldTypeString, alias: Building, length: 75 )
• Floor ( type: esriFieldTypeString, alias: Floor, length: 75 )
• Unit ( type: esriFieldTypeString, alias: Unit, length: 75 )
• Room ( type: esriFieldTypeString, alias: Room, length: 75 )
• Elevation ( type: esriFieldTypeInteger, alias: Elevation )
• LastName ( type: esriFieldTypeString, alias: Business Name, length: 150 )
• State ( type: esriFieldTypeString, alias: State, length: 2 , Coded Values: [PA: PENNSYLVANIA (PA)] , [OH: OHIO (OH)] )
• AddrType ( type: esriFieldTypeDouble, alias: Address Type , Coded Values: [1: AGRICULTURE (1)] , [2: CEMETERY (2)] , [3: COMMERCIAL USE - SEASONAL (3)] , ...42 more... )
• CountyFIPS ( type: esriFieldTypeDouble, alias: County FIPS Code , Coded Values: [42039: CRAWFORD (42039)] , [39007: ASHTABULA (39007)] , [42049: ERIE (42049)] , ...4 more... )
• CountyName ( type: esriFieldTypeString, alias: County Name, length: 50 , Coded Values: [CRAWFORD: CRAWFORD] , [ASHTABULA: ASHTABULA] , [ERIE: ERIE] , ...4 more... )
• UpdateCode ( type: esriFieldTypeDouble, alias: Update Code , Coded Values: [101: ROAD ADDITION (101)] , [102: LENGTH/LOCATION CHANGE (102)] , [103: SEGMENTATION CHANGE (103)] , ...4 more... )
• Editor ( type: esriFieldTypeString, alias: Last record editor, length: 150 )
• Internal_Comments ( type: esriFieldTypeString, alias: Comments/Notes (internal use only), length: 255 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )

Relationships:

• Site Structure Address Points (0) -- Related To: Address Points (4)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata