{ "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 97, "name": "Flag on Sign Support", "type": "Feature Layer", "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", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102643, "latestWkid": 2227, "xyTolerance": 5.9479021736623864E-5, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -1.1586059999998702E8, "falseY": -9.326949999998E7, "xyUnits": 134501.2033893968, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "City of Cupertino Public Works Department\nCity of Cupertino GIS Division", "parentLayer": { "id": 96, "name": "Crosing Flags" }, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "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 }, "defaultVisibility": true, "extent": { "xmin": 6099365.661652297, "ymin": 294722.9918127954, "xmax": 7596973.960745618, "ymax": 1949481.000792414, "spatialReference": { "wkid": 102643, "latestWkid": 2227, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -115860600, "falseY": -93269500, "xyUnits": 3.678742734568671E7, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "AssetID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 20, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "LegacyID", "length": 20, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 20, "domain": { "type": "codedValue", "name": "pwStatus", "description": "", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Proposed", "code": "Proposed" }, { "name": "Removed", "code": "Removed" }, { "name": "Not Connected", "code": "Not Connected" }, { "name": "Denied", "code": "Denied" }, { "name": "Auction", "code": "Auction" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "OwnedBy", "type": "esriFieldTypeString", "alias": "OwnedBy", "length": 50, "domain": { "type": "codedValue", "name": "shdOwnedBy", "description": "", "codedValues": [ { "name": "CalTrans", "code": "CalTrans" }, { "name": "California Water Service", "code": "California Water Service" }, { "name": "Cupertino Sanitary District", "code": "Cupertino Sanitary District" }, { "name": "Cupertino", "code": "Cupertino" }, { "name": "Other Public", "code": "Other Public" }, { "name": "PGE", "code": "PGE" }, { "name": "Private", "code": "Private" }, { "name": "Private HOA", "code": "Private HOA" }, { "name": "San Jose Water", "code": "San Jose Water" }, { "name": "State Parks", "code": "State Parks" }, { "name": "CWA", "code": "CWA" }, { "name": "Sunnyvale", "code": "Sunnyvale" }, { "name": "San Jose", "code": "San Jose" }, { "name": "Saratoga", "code": "Saratoga" }, { "name": "Santa Clara", "code": "Santa Clara" }, { "name": "Santa Clara County", "code": "Santa Clara County" }, { "name": "Santa Clara Valley Water District", "code": "Santa Clara Valley Water District" }, { "name": "Los Altos", "code": "Los Altos" }, { "name": "REM", "code": "REM" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "MaintainedBy", "type": "esriFieldTypeString", "alias": "MaintainedBy", "length": 50, "domain": { "type": "codedValue", "name": "shdOwnedBy", "description": "", "codedValues": [ { "name": "CalTrans", "code": "CalTrans" }, { "name": "California Water Service", "code": "California Water Service" }, { "name": "Cupertino Sanitary District", "code": "Cupertino Sanitary District" }, { "name": "Cupertino", "code": "Cupertino" }, { "name": "Other Public", "code": "Other Public" }, { "name": "PGE", "code": "PGE" }, { "name": "Private", "code": "Private" }, { "name": "Private HOA", "code": "Private HOA" }, { "name": "San Jose Water", "code": "San Jose Water" }, { "name": "State Parks", "code": "State Parks" }, { "name": "CWA", "code": "CWA" }, { "name": "Sunnyvale", "code": "Sunnyvale" }, { "name": "San Jose", "code": "San Jose" }, { "name": "Saratoga", "code": "Saratoga" }, { "name": "Santa Clara", "code": "Santa Clara" }, { "name": "Santa Clara County", "code": "Santa Clara County" }, { "name": "Santa Clara Valley Water District", "code": "Santa Clara Valley Water District" }, { "name": "Los Altos", "code": "Los Altos" }, { "name": "REM", "code": "REM" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "PlanNumber", "type": "esriFieldTypeString", "alias": "PlanNumber", "length": 100, "domain": null }, { "name": "AsbuiltDate", "type": "esriFieldTypeDate", "alias": "AsbuiltDate", "length": 8, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "PrimaryImage", "type": "esriFieldTypeString", "alias": "PrimaryImage", "length": 100, "domain": null }, { "name": "DataSource", "type": "esriFieldTypeString", "alias": "DataSource", "length": 100, "domain": { "type": "codedValue", "name": "shdDataSource", "description": "", "codedValues": [ { "name": "Approximated Historical Source", "code": "Approximated Historical Source" }, { "name": "Cogo from Plans", "code": "Cogo from Plans" }, { "name": "Digitized Landbase as Reference", "code": "Digitized Landbase as Reference" }, { "name": "Digitized Ortho as Reference", "code": "Digitized Ortho as Reference" }, { "name": "Digitized Plan as Reference", "code": "Digitized Plan as Reference" }, { "name": "GPS SubMeter", "code": "GPS SubMeter" }, { "name": "GPS SubFoot", "code": "GPS SubFoot" }, { "name": "iStreetView", "code": "iStreetView" }, { "name": "Need Verification", "code": "Need Verification" }, { "name": "Unknown Source", "code": "Unknown Source" }, { "name": "Legacy WO System", "code": "Legacy WO System" }, { "name": "Field Verified", "code": "Field Verified" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Rotation", "type": "esriFieldTypeDouble", "alias": "Rotation", "domain": null }, { "name": "SupportType", "type": "esriFieldTypeString", "alias": "SupportType", "length": 20, "domain": { "type": "codedValue", "name": "trafSignSupportType", "description": "", "codedValues": [ { "name": "Traffic Signal", "code": "Traffic Signal" }, { "name": "Barricade", "code": "Barricade" }, { "name": "Fence", "code": "Fence" }, { "name": "Sound Wall", "code": "Sound Wall" }, { "name": "Sign Pole", "code": "Sign Pole" }, { "name": "Light Pole", "code": "Light Pole" }, { "name": "Bridge", "code": "Bridge" }, { "name": "Building", "code": "Building" }, { "name": "Pedestrian Barricade", "code": "Pedestrian Barricade" }, { "name": "Bollard", "code": "Bollard" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "PoleType", "type": "esriFieldTypeString", "alias": "PoleType", "length": 20, "domain": { "type": "codedValue", "name": "trafSignPoleType", "description": "", "codedValues": [ { "name": "1A", "code": "1A" }, { "name": "1B", "code": "1B" }, { "name": "Steel Square Pole", "code": "Steel Square Pole" }, { "name": "Steel Round Pole", "code": "Steel Round Pole" }, { "name": "UChannel", "code": "UChannel" }, { "name": "Unistrut", "code": "Unistrut" }, { "name": "Wood", "code": "Wood" }, { "name": "None", "code": "None" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PoleHeight", "type": "esriFieldTypeSmallInteger", "alias": "PoleHeight", "domain": { "type": "codedValue", "name": "trafPoleHeight", "description": "", "codedValues": [ { "name": "4'", "code": 4 }, { "name": "5", "code": 5 }, { "name": "8'", "code": 8 }, { "name": "10'", "code": 10 }, { "name": "12'", "code": 12 }, { "name": "14'", "code": 14 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Foundation", "type": "esriFieldTypeString", "alias": "Foundation", "length": 10, "domain": { "type": "codedValue", "name": "trafSnPlFoundation", "description": "", "codedValues": [ { "name": "Asphalt", "code": "Asphalt" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Dirt", "code": "Dirt" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "AnchorType", "type": "esriFieldTypeString", "alias": "AnchorType", "length": 20, "domain": { "type": "codedValue", "name": "trafSnPlAnchorType", "description": "", "codedValues": [ { "name": "Surface Mount", "code": "Surface Mount" }, { "name": "Embedded", "code": "Embedded" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "HasBeacon", "type": "esriFieldTypeString", "alias": "HasBeacon", "length": 4, "domain": { "type": "codedValue", "name": "shdBooleanYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "LocationType", "type": "esriFieldTypeString", "alias": "LocationType", "length": 20, "domain": { "type": "codedValue", "name": "trafSignSupLocationType", "description": "", "codedValues": [ { "name": "Median", "code": "Median" }, { "name": "ROW", "code": "ROW" }, { "name": "Street", "code": "Street" }, { "name": "Park", "code": "Park" }, { "name": "Parking Lot", "code": "Parking Lot" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "POINT_X", "type": "esriFieldTypeDouble", "alias": "POINT_X", "domain": null }, { "name": "POINT_Y", "type": "esriFieldTypeDouble", "alias": "POINT_Y", "domain": null }, { "name": "hasFlagHolder", "type": "esriFieldTypeString", "alias": "hasFlagHolder", "length": 3, "domain": { "type": "codedValue", "name": "shdBooleanYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "FlagHolderInstallDate", "type": "esriFieldTypeDate", "alias": "FlagHolderInstallDate", "length": 8, "domain": null }, { "name": "Operator", "type": "esriFieldTypeString", "alias": "Operator", "length": 255, "domain": { "type": "codedValue", "name": "OPERATOR_14", "description": "Editors of the data", "codedValues": [ { "name": "AARON", "code": "AARON" }, { "name": "ADAM", "code": "ADAM" }, { "name": "ADAMP", "code": "ADAMP" }, { "name": "ADRIAN", "code": "ADRIAN" }, { "name": "ALEX", "code": "ALEX" }, { "name": "ANDY", "code": "ANDY" }, { "name": "BRANDON", "code": "BRANDON" }, { "name": "BRETT", "code": "BRETT" }, { "name": "BUCK", "code": "BUCK" }, { "name": "CHRIS", "code": "CHRIS" }, { "name": "DAN", "code": "DAN" }, { "name": "DIEGO", "code": "DIEGO" }, { "name": "FERNANDO", "code": "FERNANDO" }, { "name": "FRANK", "code": "FRANK" }, { "name": "FRANKIE", "code": "FRANKIE" }, { "name": "GILEE", "code": "GILEE" }, { "name": "JAMES", "code": "JAMES" }, { "name": "JARED", "code": "JARED" }, { "name": "JASON", "code": "JASON" }, { "name": "JEN", "code": "JEN" }, { "name": "JERRY", "code": "JERRY" }, { "name": "JOANNE", "code": "JOANNE" }, { "name": "JOHN", "code": "JOHN" }, { "name": "JONATHAN", "code": "JONATHAN" }, { "name": "JOSEPH", "code": "JOSEPH" }, { "name": "JOSH", "code": "JOSH" }, { "name": "JUSTICE", "code": "JUSTICE" }, { "name": "KANE", "code": "KANE" }, { "name": "KEVIN", "code": "KEVIN" }, { "name": "LORI", "code": "LORI" }, { "name": "MAKIKO", "code": "MAKIKO" }, { "name": "MICHAEL", "code": "MICHAEL" }, { "name": "PAUL", "code": "PAUL" }, { "name": "PETE", "code": "PETE" }, { "name": "PRASHANTH", "code": "PRASHANTH" }, { "name": "RABEYA", "code": "RABEYA" }, { "name": "RALPH", "code": "RALPH" }, { "name": "RICARDO", "code": "RICARDO" }, { "name": "RICHARD", "code": "RICHARD" }, { "name": "SEAN", "code": "SEAN" }, { "name": "SHAWN", "code": "SHAWN" }, { "name": "TERI", "code": "TERI" }, { "name": "TIFFANIE", "code": "TIFFANIE" }, { "name": "TRAVIS", "code": "TRAVIS" }, { "name": "URSULA", "code": "URSULA" }, { "name": "PETER", "code": "PETER" }, { "name": "TY", "code": "TY" }, { "name": "ROB", "code": "ROB" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R9045_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_9045", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S4395_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Query,Map,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "7110d99d307546c8a53e155386ccbdb6" }