{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 2, "name": "GISEDIT.DBO.Signs", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "Sign_Poles", "relatedTableId": 4, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "parentglobalid", "composite": true } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "globalid", "displayField": "Primary_", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "globalid", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "globalid" }, { "name": "Primary_", "type": "esriFieldTypeString", "alias": "Primary Sign", "domain": { "type": "codedValue", "name": "cvd_Primary", "description": "DESC", "codedValues": [ { "name": "Yes", "code": "YES" }, { "name": "No", "code": "NO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Primary_" }, { "name": "PoleID", "type": "esriFieldTypeString", "alias": "Pole ID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PoleID" }, { "name": "SignID", "type": "esriFieldTypeString", "alias": "Sign ID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SignID" }, { "name": "SignDistrict", "type": "esriFieldTypeString", "alias": "Sign District", "domain": { "type": "codedValue", "name": "SignDistrict", "description": "", "codedValues": [ { "name": "1", "code": "1" }, { "name": "2", "code": "2" }, { "name": "3", "code": "3" }, { "name": "4", "code": "4" }, { "name": "5", "code": "5" }, { "name": "6", "code": "6" }, { "name": "7", "code": "7" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SignDistrict" }, { "name": "SignType", "type": "esriFieldTypeString", "alias": "Sign Type", "domain": { "type": "codedValue", "name": "cvd_SignType", "description": "DESC", "codedValues": [ { "name": "Guide", "code": "Guide" }, { "name": "Other", "code": "Other" }, { "name": "Regulatory", "code": "Regulatory" }, { "name": "School", "code": "School" }, { "name": "Warning", "code": "Warning" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "SignType" }, { "name": "SchoolType", "type": "esriFieldTypeString", "alias": "School Type", "domain": { "type": "codedValue", "name": "cvd_SchoolType", "description": "DESC", "codedValues": [ { "name": "Elementary", "code": "ELEMENTARY" }, { "name": "Middle", "code": "MIDDLE" }, { "name": "Combo", "code": "COMBO" }, { "name": "High", "code": "HIGH" }, { "name": "Argyle", "code": "ARGYLE" }, { "name": "Other", "code": "OTHER" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "SchoolType" }, { "name": "SignCode", "type": "esriFieldTypeString", "alias": "MUTCD Code", "domain": { "type": "codedValue", "name": "SignMUTCD", "description": "MUTCD Codes for Flower Mound Signs", "codedValues": [ { "name": "Private SNB", "code": "SNB-Private" }, { "name": "Public SNB", "code": "SNB1-1" }, { "name": "Adopt A Spot w/ Sponsor Plaque", "code": "ADS-1" }, { "name": "We Heart Our Children", "code": "WH-1" }, { "name": "Universal Other", "code": "OTH-1" }, { "name": "Neighborhood Watch", "code": "NW-1" }, { "name": "National Night Out", "code": "NNO-1" }, { "name": "Town Population", "code": "PopLogo" }, { "name": "Town Entrance Signs", "code": "TE-1" }, { "name": "Town Facility Direction", "code": "WFR-3" }, { "name": "ClickIt or Ticket Texas", "code": "ClickIt" }, { "name": "Cross Traffic Does Not Stop", "code": "CrossTrafficDoesNotStop" }, { "name": "Universal Regulatory", "code": "Reg-1" }, { "name": "End Of Road Marker", "code": "OM4-3" }, { "name": "Stop", "code": "R1-1" }, { "name": "Yield", "code": "R1-2" }, { "name": "All Way Plaque", "code": "R1-3P" }, { "name": "Yield to Pedestrians", "code": "R1-8L" }, { "name": "20 MPH", "code": "R2-1_20MPH" }, { "name": "25 MPH", "code": "R2-1_25MPH" }, { "name": "30 MPH", "code": "R2-1_30MPH" }, { "name": "35 MPH", "code": "R2-1_35MPH" }, { "name": "40 MPH", "code": "R2-1_40MPH" }, { "name": "45 MPH", "code": "R2-1_45MPH" }, { "name": "Neighborhood", "code": "R2-5bP" }, { "name": "No U-Turn", "code": "R3-4" }, { "name": "Left Lane Plaque", "code": "R3-5bP_LeftLane" }, { "name": "Right Lane Plaque", "code": "R3-5bP_RightLane" }, { "name": "Left Only Arrow", "code": "R3-5L" }, { "name": "Right Only Arrow", "code": "R3-5R" }, { "name": "Lane Designation Multi Directional", "code": "R3-8" }, { "name": "Lane Designation Left Turn", "code": "R3-8L" }, { "name": "Lane Designation Right Turn", "code": "R3-8R" }, { "name": "Bike Lane", "code": "R3-17" }, { "name": "Keep Right Of Median", "code": "R4-7" }, { "name": "Do Not Enter", "code": "R5-1" }, { "name": "Wrong Way", "code": "R5-1a" }, { "name": "No Trucks", "code": "R5-2" }, { "name": "One way", "code": "R6-2R" }, { "name": "Chevrons", "code": "R5-5" }, { "name": "Roundabout", "code": "R6-5P" }, { "name": "No Parking", "code": "R8-3" }, { "name": "No Pedestrian Crossing", "code": "R9-3" }, { "name": "Pedestrian Crossing Push Button Timed", "code": "R10-3i" }, { "name": "No Turn On Red", "code": "R10-11" }, { "name": "Left Turn Yield On Green", "code": "R10-12" }, { "name": "Left Turn Yield On Flashing Yellow", "code": "R10-17T" }, { "name": "Bus Stop Advance Warning", "code": "S3-1" }, { "name": "End School Zone", "code": "S5-2" }, { "name": "School Crosswalk", "code": "S1-1" }, { "name": "School Zone Time Plaque", "code": "S4-1" }, { "name": "School Plaque", "code": "S4-3" }, { "name": "School Speed Limit with Times", "code": "S5-1" }, { "name": "Cell Phone Use Prohibited", "code": "S7-1" }, { "name": "End School Zone Plaque", "code": "S5-2Plaque" }, { "name": "Here Plaque (School)", "code": "W16-7Lp(S)" }, { "name": "Ahead Plaque (School)", "code": "W16-9p(S)" }, { "name": "Universal Warning", "code": "WGEN-1" }, { "name": "High Water Road Closed", "code": "WHW1-1" }, { "name": "Object Marker", "code": "OM3-L" }, { "name": "Left Curve", "code": "W1-1L" }, { "name": "Right Curve", "code": "W1-1R" }, { "name": "Left S-Curve", "code": "W1-4L" }, { "name": "Right S-Curve", "code": "W1-4R" }, { "name": "Left Arrow", "code": "W1-6L" }, { "name": "Right Arrow", "code": "W1-6R" }, { "name": "Chevron Left", "code": "W1-8L" }, { "name": "4 Way Intersection Advance", "code": "W2-1" }, { "name": "Side Road Advance", "code": "W2-2" }, { "name": "T Intersection Advance", "code": "W2-4" }, { "name": "Roundabout", "code": "W2-6" }, { "name": "Stop Advance warning", "code": "W3-1" }, { "name": "Signal Advance Warning", "code": "W3-3" }, { "name": "Speed Change Ahead", "code": "W3-5" }, { "name": "Left Lane Ends", "code": "W4-2" }, { "name": "Two way Traffic", "code": "W6-3" }, { "name": "Dip Ahead", "code": "W8-2" }, { "name": "Duck Crossing", "code": "W11-25T" }, { "name": "Pedestrian Crossing", "code": "W11-2" }, { "name": "Deer Crossing", "code": "W11-3" }, { "name": "Equestrian Crossing", "code": "W11-7" }, { "name": "Fire Truck", "code": "W11-8R" }, { "name": "Bike and Ped Crossing", "code": "W11-15" }, { "name": "Advisory Speed Plaque", "code": "W13-1" }, { "name": "No Outlet", "code": "W14-2" }, { "name": "Playground", "code": "W15-1" }, { "name": "Here", "code": "W16-7Lp" }, { "name": "Ahead", "code": "W16-9p" }, { "name": "Roundabout Plaque", "code": "W16-17p" }, { "name": "Bridges May Ice", "code": "CW8-13Modified" }, { "name": "Push Button for Crosswalk", "code": "R10-4b" }, { "name": "Primary Median Location", "code": "M1" }, { "name": "Secondary Median Location", "code": "M2" }, { "name": "Watershed Sign", "code": "BakersBranch" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SignCode" }, { "name": "SheetingType", "type": "esriFieldTypeString", "alias": "Sheeting Type", "domain": { "type": "codedValue", "name": "cvd_SheetingType", "description": "DESC", "codedValues": [ { "name": "Diamond", "code": "D" }, { "name": "Engineering", "code": "E" }, { "name": "High Intensity Prismatic", "code": "HIP" }, { "name": "Unknown", "code": "U" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "SheetingType" }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Material", "domain": { "type": "codedValue", "name": "cvd_Material", "description": "DESC", "codedValues": [ { "name": "Aluminum", "code": "A" }, { "name": "Plastic", "code": "P" }, { "name": "Steel", "code": "S" }, { "name": "Wood", "code": "W" }, { "name": "Unknown", "code": "U" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "Material" }, { "name": "SignSize", "type": "esriFieldTypeString", "alias": "Sign Size", "domain": { "type": "codedValue", "name": "cvd_SignSize", "description": "DESC", "codedValues": [ { "name": "30 x 30 Octagon", "code": "30x30o" }, { "name": "30 x 30 x 30 Yield", "code": "30x30x30y" }, { "name": "36 x 36 x 36 Yield", "code": "36x36x36y" }, { "name": "9 x 24 SNB", "code": "9x24snb" }, { "name": "9 x 30 SNB", "code": "9x30snb" }, { "name": "9 x 36 SNB", "code": "9x36snb" }, { "name": "9 x 42 SNB", "code": "9x42snb" }, { "name": "9 x 48 SNB", "code": "9x48snb" }, { "name": "9 x 54 SNB", "code": "9x54snb" }, { "name": "9 x 60 SNB", "code": "9x60snb" }, { "name": "6 x 12", "code": "6x12" }, { "name": "6 x 18", "code": "6x18" }, { "name": "6 x 24", "code": "6x24" }, { "name": "8 x 18", "code": "8x18" }, { "name": "8 x 24", "code": "8x24" }, { "name": "9 x 12", "code": "9x12" }, { "name": "9 x 15", "code": "9x15" }, { "name": "9 x 18", "code": "9x18" }, { "name": "10 x 24", "code": "10x24" }, { "name": "12 x 18", "code": "12x18" }, { "name": "12 x 24", "code": "12x24" }, { "name": "12 x 30", "code": "12x30" }, { "name": "15 x 30", "code": "15x30" }, { "name": "18 x 24", "code": "18x24" }, { "name": "18 x 30", "code": "18x30" }, { "name": "18 x 36", "code": "18x36" }, { "name": "20 x 36", "code": "20x36" }, { "name": "24 x 30", "code": "24x30" }, { "name": "24 x 36", "code": "24x36" }, { "name": "24 x 48", "code": "24x48" }, { "name": "18 x 18", "code": "18x18" }, { "name": "30 x 36", "code": "30x36" }, { "name": "36 x 42", "code": "36x42" }, { "name": "24 x 24 Diamond / Square", "code": "24x24ds" }, { "name": "30 x 30 Diamond / Square", "code": "30x30ds" }, { "name": "36 x 36 Diamond / Square", "code": "36x36ds" }, { "name": "30 x 30 Pentagon", "code": "30x30p" }, { "name": "36 x 36 Pentagon", "code": "36x36p" }, { "name": "Unknown", "code": "Unk" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 9, "defaultValue": null, "modelName": "SignSize" }, { "name": "Orientation", "type": "esriFieldTypeString", "alias": "Sign Direction", "domain": { "type": "codedValue", "name": "cvd_Orientation", "description": "DESC", "codedValues": [ { "name": "North", "code": "N" }, { "name": "South", "code": "S" }, { "name": "East", "code": "E" }, { "name": "West", "code": "W" }, { "name": "Northeast", "code": "NE" }, { "name": "Northwest", "code": "NW" }, { "name": "Southeast", "code": "SE" }, { "name": "Southwest", "code": "SW" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "Orientation" }, { "name": "SignColor", "type": "esriFieldTypeString", "alias": "Sign Color", "domain": { "type": "codedValue", "name": "SignColor", "description": "", "codedValues": [ { "name": "Green", "code": "GREEN" }, { "name": "Brown", "code": "BROWN" }, { "name": "Red", "code": "RED" }, { "name": "Blue", "code": "BLUE" }, { "name": "Yellow", "code": "YELLOW" }, { "name": "Other", "code": "OTH" }, { "name": "White", "code": "WHITE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SignColor" }, { "name": "Reflectivity", "type": "esriFieldTypeInteger", "alias": "Reflectivity", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Reflectivity" }, { "name": "Condition", "type": "esriFieldTypeString", "alias": "Sign Condition", "domain": { "type": "codedValue", "name": "cvd_PoleCondition", "description": "DESC", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Condition" }, { "name": "SignInstallDate", "type": "esriFieldTypeDate", "alias": "Date Sign Installed", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "SignInstallDate" }, { "name": "SignComment", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SignComment" }, { "name": "parentglobalid", "type": "esriFieldTypeGUID", "alias": "ParentGlobalID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "parentglobalid" } ], "indexes": [ { "name": "R288_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_288", "fields": "globalid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_2901_parentg", "fields": "parentglobalid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_288", "fields": "globalid,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "GISEDIT.DBO.Signs", "description": "", "prototype": { "attributes": { "SignComment": null, "SignInstallDate": null, "parentglobalid": null, "Primary_": null, "PoleID": null, "SignID": null, "SignDistrict": null, "SignType": null, "SchoolType": null, "SignCode": null, "SheetingType": null, "Material": null, "SignSize": null, "Orientation": null, "SignColor": null, "Reflectivity": null, "Condition": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 5000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalId", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null, "editable": true, "nullable": false, "defaultValue": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "domain": null, "editable": true, "nullable": false, "length": 150, "defaultValue": null } ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 5000, "maxRecordCountFactor": 1, "serviceItemId": "bf3c70823d5043868579ce9ebd00f7d9" }