Name: MAPSPUB.GIS.MasterStreetName

Display Field: ROADNAME

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

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

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 )
• STCODE ( type: esriFieldTypeString, alias: Street Code, editable: true, nullable: true, length: 10, defaultValue: null, modelName: STCODE )
• ROADPREDIR ( type: esriFieldTypeString, alias: Road Prefix, editable: true, nullable: true, length: 2, defaultValue: null, modelName: ROADPREDIR , Coded Values: [N: N] , [S: S] , [E: E] , ...9 more... )
• ROADNAME ( type: esriFieldTypeString, alias: Road Name, editable: true, nullable: true, length: 75, defaultValue: null, modelName: ROADNAME )
• ROADTYPE ( type: esriFieldTypeString, alias: Road Type, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ROADTYPE , Coded Values: [AcRd: Access Road] , [Aly: Alley] , [Anx: Annex] , ...221 more... )
• ROADPOSTDIR ( type: esriFieldTypeString, alias: Post Direction, editable: true, nullable: true, length: 2, defaultValue: null, modelName: ROADPOSTDIR , Coded Values: [N: N] , [S: S] , [E: E] , ...5 more... )
• FULLNAME ( type: esriFieldTypeString, alias: Full Road Name, editable: true, nullable: true, length: 125, defaultValue: null, modelName: FULLNAME )
• MSAGPREDIR ( type: esriFieldTypeString, alias: MSAG Road Prefix, editable: true, nullable: true, length: 2, defaultValue: null, modelName: MSAGPREDIR )
• MSAGNAME ( type: esriFieldTypeString, alias: MSAG Road Name, editable: true, nullable: true, length: 75, defaultValue: null, modelName: MSAGNAME )
• MSAGTYPE ( type: esriFieldTypeString, alias: MSAG Road Type, editable: true, nullable: true, length: 5, defaultValue: null, modelName: MSAGTYPE , Coded Values: [Al: Alley] , [Av: Avenue] , [Bu: Bayou] , ...58 more... )
• MSAGPOSTDIR ( type: esriFieldTypeString, alias: MSAG Post Direction, editable: true, nullable: true, length: 5, defaultValue: null, modelName: MSAGPOSTDIR , Coded Values: [E: E] , [E E: E E] , [E N: E N] , ...37 more... )
• MSAGFULLNAME ( type: esriFieldTypeString, alias: MSAG Full Road Name, editable: true, nullable: true, length: 125, defaultValue: null, modelName: MSAGFULLNAME )
• ALTROADNAME ( type: esriFieldTypeString, alias: Alternate Road Name, editable: true, nullable: true, length: 125, defaultValue: null, modelName: ALTROADNAME )
• MUNICIPALITY ( type: esriFieldTypeString, alias: Municipality Name, editable: true, nullable: true, length: 1, defaultValue: null, modelName: MUNICIPALITY , Coded Values: [C: Clearwater] , [D: Hardee County] , [H: Hillsborough County] , ...10 more... )
• STATUS ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 30, defaultValue: null, modelName: STATUS , Coded Values: [Current: Current] , [Pending: Pending] , [Retired: Retired] , ...6 more... )
• CREATOR ( type: esriFieldTypeString, alias: Created User, editable: false, nullable: true, length: 255, defaultValue: null, modelName: CREATOR )
• CREATEDDATE ( type: esriFieldTypeDate, alias: Date Created, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CREATEDDATE )
• LASTEDITOR ( type: esriFieldTypeString, alias: Last Editor, editable: false, nullable: true, length: 255, defaultValue: null, modelName: LASTEDITOR )
• LASTUPDATE ( type: esriFieldTypeDate, alias: Last Update Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: LASTUPDATE )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• St_PreMod ( type: esriFieldTypeString, alias: Street Name Pre Modifier, editable: true, nullable: true, length: 15, defaultValue: null, modelName: St_PreMod )
• St_PreDir ( type: esriFieldTypeString, alias: Street Name Pre Directional, editable: true, nullable: true, length: 9, defaultValue: null, modelName: St_PreDir , Coded Values: [East: East] , [North: North] , [Northeast: Northeast] , ...5 more... )
• St_PreTyp ( type: esriFieldTypeString, alias: Street Name Pre Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: St_PreTyp , Coded Values: [Abbey: Abbey] , [Access Road: Access Road] , [Acres: Acres] , ...318 more... )
• St_PreSep ( type: esriFieldTypeString, alias: Street Name Pre Type Separator, editable: true, nullable: true, length: 20, defaultValue: null, modelName: St_PreSep , Coded Values: [at: at] , [de las: de las] , [del: del] , ...7 more... )
• St_Name ( type: esriFieldTypeString, alias: Street Name, editable: true, nullable: true, length: 100, 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 , Coded Values: [Abbey: Abbey] , [Access Road: Access Road] , [Acres: Acres] , ...318 more... )
• St_PosDir ( type: esriFieldTypeString, alias: Street Name Post Directional, editable: true, nullable: true, length: 9, defaultValue: null, modelName: St_PosDir , Coded Values: [East: East] , [North: North] , [Northeast: Northeast] , ...5 more... )
• St_PosMod ( type: esriFieldTypeString, alias: Street Name Post Modifier, editable: true, nullable: true, length: 25, defaultValue: null, modelName: St_PosMod )
• LSt_PreDir ( type: esriFieldTypeString, alias: Legacy Street Name Pre Directional, editable: true, nullable: true, length: 2, defaultValue: null, modelName: LSt_PreDir , Coded Values: [E: East] , [N: North] , [NE: Northeast] , ...5 more... )
• LSt_Name ( type: esriFieldTypeString, alias: Legacy Street Name, editable: true, nullable: true, length: 75, defaultValue: null, modelName: LSt_Name )
• LSt_Type ( type: esriFieldTypeString, alias: Legacy Street Name Type, editable: true, nullable: true, length: 4, defaultValue: null, modelName: LSt_Type , Coded Values: [Aly: Alley] , [Anx: Annex] , [Arc: Arcade] , ...206 more... )
• LSt_PosDir ( type: esriFieldTypeString, alias: Legacy Street Name Post Directional, editable: true, nullable: true, length: 2, defaultValue: null, modelName: LSt_PosDir , Coded Values: [E: East] , [N: North] , [NE: Northeast] , ...5 more... )

Templates:

• Name: MAPSPUB.GIS.MasterStreetName
  Description:
  Prototype:
  LSt_Type: null
  LSt_Name: null
  STCODE: null
  ROADPREDIR: null
  ROADNAME: null
  ROADTYPE: null
  ROADPOSTDIR: null
  FULLNAME: null
  MSAGPREDIR: null
  MSAGNAME: null
  MSAGTYPE: null
  MSAGPOSTDIR: null
  MSAGFULLNAME: null
  ALTROADNAME: null
  MUNICIPALITY: null
  STATUS: null
  LSt_PreDir: null
  St_PosMod: null
  St_PosDir: null
  St_PosTyp: null
  LSt_PosDir: null
  St_PreMod: null
  St_PreDir: null
  St_PreTyp: null
  St_PreSep: null
  St_Name: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• RoadCenterline (0) -- Related To: MAPSPUB.GIS.RoadCenterline (1)

Capabilities: Query,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: CREATEDDATE
• Creator Field: CREATOR
• Edit Date Field: LASTUPDATE
• Editor Field: LASTEDITOR

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Query Related Records   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata