Name: Street Name Table

Display Field: full_name

Type: Table

Geometry Type: N/A

Description:

Service Item Id: ad22544c4054477081f0d78418f6d980

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: false
Supports Returning Query Extent: false
Supports Query With Distance: false
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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• objectid ( modelName: OBJECTID, nullable: false, defaultValue: null, editable: false, alias: OBJECTID, type: esriFieldTypeOID )
• st_name_key ( modelName: ST_NAME_KEY, nullable: false, editable: true, defaultValue: 0, alias: Name Key, type: esriFieldTypeInteger )
• full_name ( modelName: FULL_NAME, nullable: true, editable: true, defaultValue: null, length: 53, alias: Full Name, type: esriFieldTypeString )
• st_premod ( modelName: ST_PREMOD, nullable: true, editable: true, defaultValue: null, length: 15, alias: Pfx Mod, type: esriFieldTypeString , Coded Values: [OLD: OLD] , [NEW: NEW] , [THE: THE] )
• st_predir ( modelName: ST_PREDIR, nullable: true, editable: true, defaultValue: null, length: 9, alias: Pfx Dir, type: esriFieldTypeString , Coded Values: [NORTH: NORTH] , [SOUTH: SOUTH] , [EAST: EAST] , ...1 more... )
• st_pretyp ( modelName: ST_PRETYP, nullable: true, editable: true, defaultValue: null, length: 50, alias: Pfx Type, type: esriFieldTypeString , Coded Values: [AVENUE: AVENUE] , [HIGHWAY: HIGHWAY] , [STATE ROAD: STATE ROAD] , ...5 more... )
• st_presep ( modelName: ST_PRESEP, nullable: true, editable: true, defaultValue: null, length: 20, alias: Pfx Sep, type: esriFieldTypeString , Coded Values: [OF: OF] , [OF THE: OF THE] )
• st_name ( modelName: ST_NAME, nullable: true, editable: true, defaultValue: null, length: 60, alias: Street Name, type: esriFieldTypeString )
• st_postyp ( modelName: ST_POSTYP, nullable: true, editable: true, defaultValue: null, length: 50, alias: Sfx Type, type: esriFieldTypeString , Coded Values: [PEDESTRIAN: PEDESTRIAN] , [ALLEY: ALLEY] , [AVENUE: AVENUE] , ...211 more... )
• st_posdir ( modelName: ST_POSDIR, nullable: true, editable: true, defaultValue: null, length: 9, alias: Sfx Dir, type: esriFieldTypeString , Coded Values: [NORTH: NORTH] , [SOUTH: SOUTH] , [EAST: EAST] , ...1 more... )
• st_posmod ( modelName: ST_POSMOD, nullable: true, editable: true, defaultValue: null, length: 25, alias: Sfx Mod, type: esriFieldTypeString , Coded Values: [EXTENSION: EXTENSION] , [BYPASS: BYPASS] , [ANNEX: ANNEX] , ...1 more... )
• community ( modelName: COMMUNITY, nullable: true, editable: true, defaultValue: null, length: 75, alias: Community, type: esriFieldTypeString , Coded Values: [CHARLESTON PENINSULA: CHARLESTON PENINSULA] , [FOLLY BEACH: FOLLY BEACH] , [NORTH AREA: NORTH AREA] , ...18 more... )
• reserved ( modelName: RESERVED, nullable: true, editable: true, defaultValue: null, length: 1, alias: Reserve/Status, type: esriFieldTypeString , Coded Values: [R: RESERVED (R)] , [F: ACTIVE (F)] , [I: INACTIVE/RETIRED (I)] )
• contact ( modelName: CONTACT, nullable: true, editable: true, defaultValue: null, length: 50, alias: Contact, type: esriFieldTypeString )
• business ( modelName: BUSINESS, nullable: true, editable: true, defaultValue: null, length: 50, alias: Business, type: esriFieldTypeString )
• phone ( modelName: PHONE, nullable: true, editable: true, defaultValue: null, length: 13, alias: Phone, type: esriFieldTypeString )
• email ( modelName: EMAIL, nullable: true, editable: true, defaultValue: null, length: 100, alias: Email, type: esriFieldTypeString )
• rsrv_date ( modelName: RSRV_DATE, nullable: true, editable: true, defaultValue: null, length: 29, alias: Reserve Date, type: esriFieldTypeDate )
• create_date ( modelName: CREATE_DATE, nullable: true, editable: true, defaultValue: null, length: 29, alias: Create Date, type: esriFieldTypeDate )
• create_who ( modelName: CREATE_WHO, nullable: true, editable: true, defaultValue: null, length: 50, alias: Create Who, type: esriFieldTypeString )
• edit_date ( modelName: EDIT_DATE, nullable: true, editable: true, defaultValue: null, length: 29, alias: Edit Date, type: esriFieldTypeDate )
• edit_who ( modelName: EDIT_WHO, nullable: true, editable: true, defaultValue: null, length: 50, alias: Edit Who, type: esriFieldTypeString )
• lst_predir ( modelName: LST_PREDIR, nullable: true, editable: true, defaultValue: null, length: 2, alias: Pfx Dir (Leg), type: esriFieldTypeString , Coded Values: [N: N] , [S: S] , [E: E] , ...1 more... )
• lst_name ( modelName: LST_NAME, nullable: false, editable: true, defaultValue: null, length: 40, alias: Street Name (Leg), type: esriFieldTypeString )
• lst_type ( modelName: LST_TYPE, nullable: true, editable: true, defaultValue: null, length: 6, alias: Sfx Type (Leg), type: esriFieldTypeString , Coded Values: [PED: PED] , [ALY: ALY] , [AV: AV] , ...213 more... )
• lst_posdir ( modelName: LST_POSDIR, nullable: true, editable: true, defaultValue: null, length: 3, alias: Sfx Dir (Leg), type: esriFieldTypeString , Coded Values: [N: N] , [S: S] , [E: E] , ...1 more... )
• full_name_leg ( modelName: FULL_NAME_LEG, nullable: true, editable: true, defaultValue: null, length: 53, alias: Full Name (Legacy), type: esriFieldTypeString )
• type_of ( modelName: TYPE_OF, nullable: true, editable: true, defaultValue: null, length: 5, alias: Type Of, type: esriFieldTypeString )
• comments ( modelName: COMMENTS, nullable: true, editable: true, defaultValue: null, length: 255, alias: Comments, type: esriFieldTypeString )

Templates:

• Name: Street Name Table
  Description:
  Prototype:
  rsrv_date: null
  lst_posdir: null
  edit_who: null
  st_premod: null
  contact: null
  type_of: null
  create_who: null
  create_date: null
  email: null
  st_predir: null
  lst_type: null
  comments: null
  business: null
  st_name: null
  st_name_key: 0
  st_posmod: null
  community: null
  st_pretyp: null
  st_posdir: null
  full_name_leg: null
  st_presep: null
  st_postyp: null
  full_name: null
  reserved: null
  phone: null
  lst_name:
  lst_predir: null
  edit_date: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Calculate   Validate SQL   Generate Renderer   Return Updates   Metadata