Name: Apartments/suites table - Data Share

Display Field: St_Name

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 4e8e2fa6c3cd477eb420d23616a0885a

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
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: false
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:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• UniqueStructureNumber ( type: esriFieldTypeDouble, alias: Unique Structure Number, editable: true, nullable: true, defaultValue: null, modelName: UniqueStructureNumber )
• DiscrpAgID ( type: esriFieldTypeString, alias: Discrepancy Agency ID, editable: true, nullable: true, length: 75, defaultValue: crawford.state.pa.us, modelName: DiscrpAgID )
• DateUpdate ( type: esriFieldTypeDate, alias: Date record last updated, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateUpdate )
• Effective ( type: esriFieldTypeDate, alias: Date record added, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Effective )
• Expire ( type: esriFieldTypeDate, alias: Temporary address expiration date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Expire )
• Site_NGUID ( type: esriFieldTypeString, alias: Site NENA Globally Unique ID, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Site_NGUID )
• Country ( type: esriFieldTypeString, alias: Country, editable: true, nullable: true, length: 2, defaultValue: US, modelName: Country )
• Inc_Muni ( type: esriFieldTypeString, alias: Incorporated Municipality, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Inc_Muni , 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, editable: true, nullable: true, defaultValue: null, modelName: Inc_Muni_FIPS , Coded Values: [4203903408: ATHENS TWP (4203903408)] , [4203904720: BEAVER TWP (4203904720)] , [4203907032: BLOOMFIELD TWP (4203907032)] , ...75 more... )
• Add_Number ( type: esriFieldTypeDouble, alias: Address Number, editable: true, nullable: true, defaultValue: null, modelName: Add_Number )
• AddNum_Suf ( type: esriFieldTypeString, alias: Address Number Suffix, editable: true, nullable: true, length: 15, defaultValue: null, modelName: AddNum_Suf )
• St_PreDir ( type: esriFieldTypeString, alias: Street Name Pre Directional, editable: true, nullable: true, length: 9, defaultValue: null, modelName: St_PreDir )
• St_Name ( type: esriFieldTypeString, alias: Street Name, editable: true, nullable: true, length: 60, defaultValue: null, modelName: St_Name )
• St_PosTyp ( type: esriFieldTypeString, alias: Street Name Post Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: St_PosTyp )
• St_PosDir ( type: esriFieldTypeString, alias: Street Name Post Directional, editable: true, nullable: true, length: 9, defaultValue: null, modelName: St_PosDir )
• St_FullName ( type: esriFieldTypeString, alias: Street Full Name, editable: true, nullable: true, length: 160, defaultValue: null, modelName: St_FullName )
• FullAddress ( type: esriFieldTypeString, alias: House # & Street, editable: true, nullable: true, length: 200, defaultValue: null, modelName: FullAddress )
• ESN ( type: esriFieldTypeSmallInteger, alias: Emergency Service Number, editable: true, nullable: true, defaultValue: null, modelName: ESN )
• Post_Box ( type: esriFieldTypeString, alias: Current PO Box # (if applicable), editable: true, nullable: true, length: 7, defaultValue: null, modelName: Post_Box )
• Post_Comm ( type: esriFieldTypeString, alias: Postal Community Name, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Post_Comm , Coded Values: [ADAMSVILLE: ADAMSVILLE] , [ALBION: ALBION] , [ATLANTIC: ATLANTIC] , ...28 more... )
• Post_Code ( type: esriFieldTypeString, alias: Postal Code, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Post_Code , Coded Values: [16110: ADAMSVILLE (16110)] , [16401: ALBION (16401)] , [16111: ATLANTIC (16111)] , ...26 more... )
• Building ( type: esriFieldTypeString, alias: Building, editable: true, nullable: true, length: 75, defaultValue: null, modelName: Building )
• Floor ( type: esriFieldTypeString, alias: Floor, editable: true, nullable: true, length: 75, defaultValue: null, modelName: Floor )
• Unit ( type: esriFieldTypeString, alias: Unit, editable: true, nullable: true, length: 75, defaultValue: null, modelName: Unit )
• Room ( type: esriFieldTypeString, alias: Room, editable: true, nullable: true, length: 75, defaultValue: null, modelName: Room )
• Elevation ( type: esriFieldTypeInteger, alias: Elevation, editable: true, nullable: true, defaultValue: null, modelName: Elevation )
• LastName ( type: esriFieldTypeString, alias: Business Name, editable: true, nullable: true, length: 150, defaultValue: null, modelName: LastName )
• State ( type: esriFieldTypeString, alias: State, editable: true, nullable: true, length: 2, defaultValue: PA, modelName: State , Coded Values: [PA: PENNSYLVANIA (PA)] , [OH: OHIO (OH)] )
• AddrType ( type: esriFieldTypeDouble, alias: Address Type, editable: true, nullable: true, defaultValue: null, modelName: AddrType , Coded Values: [1: AGRICULTURE (1)] , [2: CEMETERY (2)] , [3: COMMERCIAL USE - SEASONAL (3)] , ...42 more... )
• CountyFIPS ( type: esriFieldTypeDouble, alias: County FIPS Code, editable: true, nullable: true, defaultValue: 42039, modelName: CountyFIPS , Coded Values: [42039: CRAWFORD (42039)] , [39007: ASHTABULA (39007)] , [42049: ERIE (42049)] , ...4 more... )
• CountyName ( type: esriFieldTypeString, alias: County Name, editable: true, nullable: true, length: 50, defaultValue: CRAWFORD, modelName: CountyName , Coded Values: [CRAWFORD: CRAWFORD] , [ASHTABULA: ASHTABULA] , [ERIE: ERIE] , ...4 more... )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Templates:

• Name: Apartments/suites table - Data Share
  Description:
  Prototype:
  CountyName: CRAWFORD
  UniqueStructureNumber: null
  DiscrpAgID: crawford.state.pa.us
  DateUpdate: null
  Effective: null
  Expire: null
  Site_NGUID: null
  Country: US
  Inc_Muni: null
  Inc_Muni_FIPS: null
  Add_Number: null
  AddNum_Suf: null
  St_PreDir: null
  St_Name: null
  St_PosTyp: null
  St_PosDir: null
  St_FullName: null
  FullAddress: null
  ESN: null
  Post_Box: null
  Post_Comm: null
  Post_Code: null
  Building: null
  Floor: null
  Unit: null
  Room: null
  Elevation: null
  LastName: null
  State: PA
  AddrType: null
  CountyFIPS: 42039
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

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

Capabilities: Query,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Query Related Records   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata