Name: Flag on Sign Support
Display Field: AssetID
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description: gisdata.CUPERTINO.traf_SignSupport is a Point FeatureClass representing sign supports in the City of Cupertino. Sign supports are entities that signs are affixed to. Light poles and traffic poles are in the "Poles" database and are not considered sign supports even if a sign is attached.It is primarily used as an inventory layer in Cityworks The layer is updated as needed by Public Works and quarterly QA/QC'd by GIS. This layer was part of a city-wide sign inventory in 2017The oldest geoprocessing history record has a date of 2011-09-16gisdata.CUPERTINO.traf_SignSupport has the following fields: OBJECTID:Unique identifier automatically generated by Esritype: OID, length: 4, domain: noneAssetID:Cupertino maintained GIS primary keytype: String, length: 20, domain: noneLegacyID:Old identifiers used to track asset migrationtype: String, length: 20, domain: noneLocation:Description or address of locationtype: String, length: 50, domain: noneStatus:The active or construction status of the asset in the fieldtype: String, length: 20, domain: pwStatusdomain values:['Abandoned', 'Proposed', 'Auction', 'Denied', 'Active', 'Removed', 'Not Connected']OwnedBy:Organization which owns the assettype: String, length: 50, domain: shdOwnedBydomain values:['Cupertino', 'San Jose Water', 'CalTrans', 'PGE', 'Los Altos', 'Santa Clara', 'Private HOA', 'Saratoga', 'Other Public', 'Santa Clara County', 'San Jose', 'Santa Clara Valley Water District', 'Private', 'California Water Service', 'State Parks', 'Sunnyvale', 'Cupertino Sanitary District', 'CWA']MaintainedBy:Organization who is responsible for maintenance of assettype: String, length: 50, domain: shdOwnedBydomain values:['Cupertino', 'San Jose Water', 'CalTrans', 'PGE', 'Los Altos', 'Santa Clara', 'Private HOA', 'Saratoga', 'Other Public', 'Santa Clara County', 'San Jose', 'Santa Clara Valley Water District', 'Private', 'California Water Service', 'State Parks', 'Sunnyvale', 'Cupertino Sanitary District', 'CWA']PlanNumber:Origniating plan number if knowntype: String, length: 100, domain: noneAsbuiltDate:Asbuilt datetype: Date, length: 36, domain: noneInstallDate:type: Date, length: 36, domain: nonePrimaryImage:Hyperlink to photo or DMStype: String, length: 100, domain: noneCreateBy:the name of the staff person who created the database rowtype: String, length: 50, domain: OPERATORdomain values:['MIKE', 'CURTIS', 'JAMES', 'KANE', 'JERRY', 'RICARDO', 'JOANNE', 'TERI', 'ANDY', 'JOE', 'ARCHANA', 'JONATHAN', 'ADAM', 'JAKE', 'MICHAEL', 'MAKIKO', 'PAUL', 'JEN', 'JASON', 'SHAWN', 'FRANK', 'JULIE', 'NICK', 'KEVIN', 'CLIFF']CreateDate:the date the database row was initially createdtype: Date, length: 36, domain: noneUpdateBy:The user who last updated the database rowtype: String, length: 50, domain: OPERATORdomain values:['MIKE', 'CURTIS', 'JAMES', 'KANE', 'JERRY', 'RICARDO', 'JOANNE', 'TERI', 'ANDY', 'JOE', 'ARCHANA', 'JONATHAN', 'ADAM', 'JAKE', 'MICHAEL', 'MAKIKO', 'PAUL', 'JEN', 'JASON', 'SHAWN', 'FRANK', 'JULIE', 'NICK', 'KEVIN', 'CLIFF']UpdateDate:the date the database row was last updatedtype: Date, length: 36, domain: noneDataSource:Description of what methods were used for data capture/migrationtype: String, length: 100, domain: shdDataSourcedomain values:['Digitized Plan as Reference', 'GPS SubFoot', 'Unknown Source', 'iStreetView', 'Field Verified', 'GPS SubMeter', 'Digitized Landbase as Reference', 'Legacy WO System', 'Digitized Ortho as Reference', 'Approximated Historical Source', 'Need Verification', 'Cogo from Plans']Rotation:Numerical value indicating degrees of rotation for proper map symbolizationtype: Double, length: 8, domain: noneSupportType:Classifies the sign support by its entity typetype: String, length: 20, domain: trafSignSupportTypedomain values:['Building', 'Bridge', 'Sound Wall', 'Sign Pole', 'Pedestrian Barricade', 'Bollard', 'Barricade', 'Fence', 'Traffic Signal', 'Light Pole']PoleType:Classification on the type of pole, if support is poletype: String, length: 20, domain: trafSignPoleTypedomain values:['Unistrut', 'None', 'Steel Round Pole', 'Steel Square Pole', 'Wood', '1A', 'UChannel', '1B']PoleHeight:type: SmallInteger, length: 2, domain: trafPoleHeightdomain values:["4'", '5', "8'", "10'", "12'", "14'"]Foundation:type: String, length: 10, domain: trafSnPlFoundationdomain values:['Concrete', 'Asphalt', 'Dirt']AnchorType:type: String, length: 20, domain: trafSnPlAnchorTypedomain values:['Embedded', 'Surface Mount']HasBeacon:type: String, length: 4, domain: shdBooleanYesNodomain values:['Yes', 'No']LocationType:type: String, length: 20, domain: trafSignSupLocationTypedomain values:['Park', 'Street', 'Median', 'Parking Lot', 'ROW']Shape:Field that stores geographic coordinates associated with featuretype: Geometry, length: 4, domain: noneGlobalID:Unique identifier automatically generated for features in enterprise databasetype: GlobalID, length: 38, domain: nonePOINT_X:type: Double, length: 8, domain: nonePOINT_Y:type: Double, length: 8, domain: none
Copyright Text: City of Cupertino Public Works Department
City of Cupertino GIS Division
Min. Scale: 0
Max. Scale: 0
Default Visibility: true
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: 6099365.6616523
YMin: 294722.991812795
XMax: 7596973.96074562
YMax: 1949481.00079241
Spatial Reference: 102643 (2227)
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[166,149,0,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field: GlobalID
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- AssetID (type: esriFieldTypeString, alias: AssetID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- LegacyID (type: esriFieldTypeString, alias: LegacyID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- Location (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- Status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Active: Active], [Abandoned: Abandoned], [Proposed: Proposed], ... 4 more ...)
- OwnedBy (type: esriFieldTypeString, alias: OwnedBy, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [CalTrans: CalTrans], [California Water Service: California Water Service], [Cupertino Sanitary District: Cupertino Sanitary District], ... 16 more ...)
- MaintainedBy (type: esriFieldTypeString, alias: MaintainedBy, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [CalTrans: CalTrans], [California Water Service: California Water Service], [Cupertino Sanitary District: Cupertino Sanitary District], ... 16 more ...)
- PlanNumber (type: esriFieldTypeString, alias: PlanNumber, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- AsbuiltDate (type: esriFieldTypeDate, alias: AsbuiltDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- InstallDate (type: esriFieldTypeDate, alias: InstallDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- PrimaryImage (type: esriFieldTypeString, alias: PrimaryImage, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- CreateBy (type: esriFieldTypeString, alias: CreateBy, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [ADAM: ADAM], [ADAMP: ADAMP], [ADRIAN: ADRIAN], ... 36 more ...)
- CreateDate (type: esriFieldTypeDate, alias: CreateDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- UpdateBy (type: esriFieldTypeString, alias: UpdateBy, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [ADAM: ADAM], [ADAMP: ADAMP], [ADRIAN: ADRIAN], ... 36 more ...)
- UpdateDate (type: esriFieldTypeDate, alias: UpdateDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- DataSource (type: esriFieldTypeString, alias: DataSource, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Approximated Historical Source: Approximated Historical Source], [Cogo from Plans: Cogo from Plans], [Digitized Landbase as Reference: Digitized Landbase as Reference], ... 9 more ...)
- Rotation (type: esriFieldTypeDouble, alias: Rotation, SQL Type: sqlTypeOther, nullable: true, editable: true)
- SupportType (type: esriFieldTypeString, alias: SupportType, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Traffic Signal: Traffic Signal], [Barricade: Barricade], [Fence: Fence], ... 7 more ...)
- PoleType (type: esriFieldTypeString, alias: PoleType, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [1A: 1A], [1B: 1B], [Steel Square Pole: Steel Square Pole], ... 5 more ...)
- PoleHeight (type: esriFieldTypeSmallInteger, alias: PoleHeight, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [4: 4'], [5: 5], [8: 8'], ... 3 more ...)
- Foundation (type: esriFieldTypeString, alias: Foundation, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Asphalt: Asphalt], [Concrete: Concrete], [Dirt: Dirt])
- AnchorType (type: esriFieldTypeString, alias: AnchorType, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Surface Mount: Surface Mount], [Embedded: Embedded])
- HasBeacon (type: esriFieldTypeString, alias: HasBeacon, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
- LocationType (type: esriFieldTypeString, alias: LocationType, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Median: Median], [ROW: ROW], [Street: Street], ... 2 more ...)
- GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
- POINT_X (type: esriFieldTypeDouble, alias: POINT_X, SQL Type: sqlTypeOther, nullable: true, editable: true)
- POINT_Y (type: esriFieldTypeDouble, alias: POINT_Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
- hasFlagHolder (type: esriFieldTypeString, alias: hasFlagHolder, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
- FlagHolderInstallDate (type: esriFieldTypeDate, alias: FlagHolderInstallDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Templates:
Name: Flag on Sign Support
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- Status: Active
- OwnedBy: Cupertino
- MaintainedBy: Cupertino
- DataSource: iStreetView
- AnchorType: Embedded
- HasBeacon: N
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 8/31/2020 10:57:32 PM
Schema Last Edit Date: 8/31/2020 10:57:32 PM
Data Last Edit Date: 8/31/2020 10:57:32 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Add Features
Update Features
Delete Features
Apply Edits
Calculate
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat