{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 9, "name": "BaseGIS_SDE.MAINT.PlaygroundEquipment", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 3, "name": "PlaygroundInspection_Equipment", "relatedTableId": 10, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "PlaygroundEquipmentID", "composite": false, "catalogID": "{09F73194-CF73-4328-99B4-9D4284C070DD}" }, { "id": 1, "name": "Playgrounds", "relatedTableId": 8, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "PlaygroundName", "composite": false, "catalogID": "{729E6714-4BDC-4617-A64B-57AF6F841B5D}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "PlaygroundEquipmentName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "PlaygroundEquipmentType", "type": "esriFieldTypeString", "alias": "PlaygroundEquipmentType", "domain": { "type": "codedValue", "name": "PlaygroundEquipment", "description": "Playground Equipment", "codedValues": [ { "name": "Surface Material/Border", "code": "Surface Material" }, { "name": "Swings", "code": "Swings" }, { "name": "Climber/Ladder", "code": "Climber" }, { "name": "Slide", "code": "Slide" }, { "name": "Free Standing Toy", "code": "Free Standing Toy" }, { "name": "Main Structure", "code": "Main Structure" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 300, "defaultValue": null, "modelName": "PlaygroundEquipmentType" }, { "name": "PlaygroundEquipmentName", "type": "esriFieldTypeString", "alias": "Equipment Name", "domain": { "type": "codedValue", "name": "PlaygroundEquip", "description": "Description", "codedValues": [ { "name": "Activity Panels", "code": "ActivityPanels" }, { "name": "Activity Table", "code": "ActivityTable" }, { "name": "Balance Beam", "code": "BalanceBeam" }, { "name": "Border", "code": "Border" }, { "name": "Bridge - Canyon", "code": "BridgeCanyon" }, { "name": "Bridge - Clatter", "code": "BridgeClatter" }, { "name": "Bridge - Hoopla", "code": "BridgeHoopla" }, { "name": "Bridge - Ribbon", "code": "BridgeRibbon" }, { "name": "Bridge - Rings", "code": "BridgeRings" }, { "name": "Cargo Net", "code": "CargoNet" }, { "name": "Chest Press", "code": "ChestPress" }, { "name": "Climber - ABC", "code": "ClimberABC" }, { "name": "Climber - Accordian", "code": "ClimberAccordian" }, { "name": "Climber - Arch", "code": "ClimberArch" }, { "name": "Climber - Atom", "code": "ClimberAtom" }, { "name": "Climber - Canyon", "code": "ClimberCanyon" }, { "name": "Climber - Centipede", "code": "ClimberCentipede" }, { "name": "Climber - Chain Link", "code": "ClimberChainLink" }, { "name": "Climber - Chain Net", "code": "ClimberChainNet" }, { "name": "Climber - Cliff", "code": "ClimberCliff" }, { "name": "Climber - Clover", "code": "ClimberClover" }, { "name": "Climber - Corkscrew", "code": "ClimberCorkscrew" }, { "name": "Climber - Cosmix", "code": "ClimberCosmix" }, { "name": "Climber - Curly", "code": "ClimberCurly" }, { "name": "Climber - Cylinder", "code": "ClimberCylinder" }, { "name": "Climber - Diagonal", "code": "ClimberDiagonal" }, { "name": "Climber - Disc", "code": "ClimberDisc" }, { "name": "Climber - Disc Pole", "code": "ClimberDiscPole" }, { "name": "Climber - Double", "code": "ClimberDouble" }, { "name": "Climber - Fan", "code": "ClimberFan" }, { "name": "Climber - Grid", "code": "ClimberGrid" }, { "name": "Climber - Helix", "code": "ClimberHelix" }, { "name": "Climber - Hexagon", "code": "ClimberHexagon" }, { "name": "Climber - Honeycomb", "code": "ClimberHoneycomb" }, { "name": "Climber - Hopscotch", "code": "ClimberHopscotch" }, { "name": "Climber - Infinity", "code": "ClimberInfinity" }, { "name": "Climber - Leaf", "code": "ClimberLeaf" }, { "name": "Climber - Log Slice", "code": "ClimberLogSlice" }, { "name": "Climber - Lumberjack", "code": "ClimberLumberjack" }, { "name": "Climber - Overhead", "code": "ClimberOverhead" }, { "name": "Climber - Peak", "code": "ClimberPeak" }, { "name": "Climber - Plank", "code": "ClimberPlank" }, { "name": "Climber - Pods", "code": "ClimberPods" }, { "name": "Climber - Ridge", "code": "ClimberRidge" }, { "name": "Climber - Ring", "code": "ClimberRing" }, { "name": "Climber - Rock", "code": "ClimberRock" }, { "name": "Climber - Rope", "code": "ClimberRope" }, { "name": "Climber - Satellite", "code": "ClimberSatellite" }, { "name": "Climber - Solar", "code": "ClimberSolar" }, { "name": "Climber - Spiny Arch", "code": "ClimberSpinyArch" }, { "name": "Climber - Spiral Step", "code": "ClimberSpiralStep" }, { "name": "Climber - Stone Slope", "code": "ClimberStoneSlope" }, { "name": "Climber - Switchback", "code": "ClimberSwitchback" }, { "name": "Climber - Track", "code": "ClimberTrack" }, { "name": "Climber - Twister", "code": "ClimberTwister" }, { "name": "Climber - Vital Vortex", "code": "ClimberVitalVortex" }, { "name": "Climber - Wave", "code": "ClimberWave" }, { "name": "Comet", "code": "Comet" }, { "name": "Core Valley Course", "code": "CoreValleyCourse" }, { "name": "Digger", "code": "Digger" }, { "name": "Dip Station", "code": "DipStation" }, { "name": "Dynamic Pad", "code": "DynamicPad" }, { "name": "Elliptical", "code": "Elliptical" }, { "name": "Fire Pole", "code": "FirePole" }, { "name": "FossilDig", "code": "FossilDig" }, { "name": "Ladder", "code": "Ladder" }, { "name": "Ladder - Bubble", "code": "LadderBubble" }, { "name": "Ladder - Loop", "code": "LadderLoop" }, { "name": "Ladder - Triangle Traverse", "code": "LadderTriangleTraverse" }, { "name": "Ladder - Wiggle", "code": "LadderWiggle" }, { "name": "Ladder- Wave", "code": "LadderWave" }, { "name": "Lat Pull Down", "code": "LatPullDown" }, { "name": "Launch Pad", "code": "LaunchPad" }, { "name": "Leg Press", "code": "LegPress" }, { "name": "Link - Fat Pipe", "code": "LinkFatPipe" }, { "name": "Link - Pod", "code": "LinkPod" }, { "name": "Link - Rope", "code": "LinkRope" }, { "name": "Link - Stepping", "code": "LinkStepping" }, { "name": "Link- Odyssey Post", "code": "LinkOdysseyPost" }, { "name": "Main Structure", "code": "MainStructure" }, { "name": "Merry Go Round", "code": "MerryGoRound" }, { "name": "Overhead Rings", "code": "OverheadRings" }, { "name": "Pep Step", "code": "PepStep" }, { "name": "Pods", "code": "Pods" }, { "name": "Pull Up Bar", "code": "PullUpBar" }, { "name": "Recumbent Cycle", "code": "RecumbentCycle" }, { "name": "Rings", "code": "Rings" }, { "name": "Rock", "code": "Rock" }, { "name": "Rock Arch", "code": "RockArch" }, { "name": "Seat", "code": "Seat" }, { "name": "See Saw", "code": "SeeSaw" }, { "name": "Side Stepper", "code": "SideStepper" }, { "name": "Sky Runner", "code": "SkyRunner" }, { "name": "Sky Wheels", "code": "SkyWheels" }, { "name": "Slide - Curved Sectional", "code": "SlideCurvedSectional" }, { "name": "Slide - Double", "code": "SlideDouble" }, { "name": "Slide - Double Spiral", "code": "SlideDoubleSpiral" }, { "name": "Slide - Glider", "code": "SlideGlider" }, { "name": "Slide - Long Sectional", "code": "SlideLongSectional" }, { "name": "Slide - Sectional", "code": "SlideSectional" }, { "name": "Slide - Short Sectional", "code": "SlideShortSectional" }, { "name": "Slide - Single", "code": "SlideSingle" }, { "name": "Slide - Small", "code": "SlideSmall" }, { "name": "Slide - Spiral", "code": "SlideSpiral" }, { "name": "Slide - Straight", "code": "SlideStraight" }, { "name": "Slide - Triple", "code": "SlideTriple" }, { "name": "Slide - Tube", "code": "SlideTube" }, { "name": "Spin R.G.", "code": "SpinR.G." }, { "name": "Spin Seat", "code": "SpinSeat" }, { "name": "Spinner - Cyclone", "code": "SpinnerCyclone" }, { "name": "Spinner - Extreme Cyclone", "code": "SpinnerExtremeCyclone" }, { "name": "Spinner - Revolution Inclusive", "code": "SpinnerRevolutionInclusive" }, { "name": "Spinner - Saddle", "code": "SpinnerSaddle" }, { "name": "Spring Toy", "code": "SpringToy" }, { "name": "Stand N Spin", "code": "StandNSpin" }, { "name": "Stargazer", "code": "Stargazer" }, { "name": "Surface Material", "code": "SurfaceMaterial" }, { "name": "Swing - Adaptive", "code": "SwingAdaptive" }, { "name": "Swing - Belt", "code": "SwingBelt" }, { "name": "Swing - Bucket", "code": "SwingBucket" }, { "name": "Swing - Oodle", "code": "SwingOodle" }, { "name": "Swing - Tire", "code": "SwingTire" }, { "name": "Swivel Meister", "code": "SwivelMeister" }, { "name": "Teeter Totter", "code": "TeeterTotter" }, { "name": "Trigon Tower", "code": "TrigonTower" }, { "name": "Trolley Ride", "code": "TrolleyRide" }, { "name": "Tube - Crawl", "code": "TubeCrawl" }, { "name": "Tube - Talk", "code": "TubeTalk" }, { "name": "Tunnel - Rock", "code": "TunnelRock" }, { "name": "Tunnel - Wire Crawl", "code": "TunnelWireCrawl" }, { "name": "Wall - Climbing", "code": "WallClimbing" }, { "name": "Wall - Rock", "code": "WallRock" }, { "name": "Wobble Sphere", "code": "WobbleSphere" }, { "name": "Bridge", "code": "Bridge" }, { "name": "Climber", "code": "Climber" }, { "name": "Link", "code": "Link" }, { "name": "Slide", "code": "Slide" }, { "name": "Spinner", "code": "Spinner" }, { "name": "Swing", "code": "Swing" }, { "name": "Tube", "code": "Tube" }, { "name": "Tunnel", "code": "Tunnel" }, { "name": "Wall", "code": "Wall" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PlaygroundEquipmentName" }, { "name": "PlaygroundName", "type": "esriFieldTypeString", "alias": "Playground Name", "domain": { "type": "codedValue", "name": "PlaygroundName", "description": "Playground Name", "codedValues": [ { "name": "Blackhawk East", "code": "Blackhawk East" }, { "name": "Blackhawk West", "code": "Blackhawk West" }, { "name": "Bridgeview", "code": "Bridgeview" }, { "name": "Bridle Ridge", "code": "Bridle Ridge" }, { "name": "Bur Oaks North", "code": "Bur Oaks North" }, { "name": "Bur Oaks South", "code": "Bur Oaks South" }, { "name": "Captain Dodd", "code": "Captain Dodd" }, { "name": "Carlson Lake", "code": "Carlson Lake" }, { "name": "Carnelian", "code": "Carnelian" }, { "name": "Cascade Bay", "code": "Cascade Bay" }, { "name": "Cedar Pond", "code": "Cedar Pond" }, { "name": "Cinnamon Ridge", "code": "Cinnamon Ridge" }, { "name": "Community Center", "code": "Community Center" }, { "name": "Country Home", "code": "Country Home" }, { "name": "Evergreen", "code": "Evergreen" }, { "name": "Fish Lake", "code": "Fish Lake" }, { "name": "George Ohmann", "code": "George Ohmann" }, { "name": "Goat Hill", "code": "Goat Hill" }, { "name": "Highview", "code": "Highview" }, { "name": "Holz Farm", "code": "Holz Farm" }, { "name": "Kettle", "code": "Kettle" }, { "name": "Lakeside", "code": "Lakeside" }, { "name": "Lexington", "code": "Lexington" }, { "name": "Meadowland", "code": "Meadowland" }, { "name": "Northview", "code": "Northview" }, { "name": "Oak Chase", "code": "Oak Chase" }, { "name": "O'Leary South", "code": "O'Leary South" }, { "name": "Peridot Path", "code": "Peridot Path" }, { "name": "Quarry", "code": "Quarry" }, { "name": "Rahn Phase 2", "code": "Rahn Phase 2" }, { "name": "Rahn Tiny Tot", "code": "Rahn Tiny Tot" }, { "name": "Ridgecliff", "code": "Ridgecliff" }, { "name": "River Hills", "code": "River Hills" }, { "name": "Sky Hill", "code": "Sky Hill" }, { "name": "Slater Acres", "code": "Slater Acres" }, { "name": "South Oaks", "code": "South Oaks" }, { "name": "Trapp Farm East", "code": "Trapp Farm East" }, { "name": "Trapp Farm West", "code": "Trapp Farm West" }, { "name": "Walden Heights", "code": "Walden Heights" }, { "name": "Walnut Hill", "code": "Walnut Hill" }, { "name": "Wescott Commons", "code": "Wescott Commons" }, { "name": "Wescott Station", "code": "Wescott Station" }, { "name": "Woodhaven", "code": "Woodhaven" }, { "name": "Moonshine", "code": "Moonshine" }, { "name": "Community Center Exercise", "code": "Community Center Exercise" }, { "name": "Thomas Lake", "code": "Thomas Lake" }, { "name": "Thresher", "code": "Thresher" }, { "name": "Patrick Eagan Nature", "code": "Patrick Eagan Nature" }, { "name": "Woodhaven All Play", "code": "Woodhaven All Play" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PlaygroundName" }, { "name": "PlaygroundID", "type": "esriFieldTypeString", "alias": "Playground ID", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "PlaygroundID" }, { "name": "PlaygroundEquipmentManufacturer", "type": "esriFieldTypeString", "alias": "Equipment Manufacturer", "domain": { "type": "codedValue", "name": "PlaygroundManufacturer", "description": "Playground Equipment Manufacturer", "codedValues": [ { "name": "Burke", "code": "Burke" }, { "name": "City of Eagan", "code": "City of Eagan" }, { "name": "Game Time", "code": "Game Time" }, { "name": "Landscape Structures", "code": "Landscape Structures" }, { "name": "Little Tikes", "code": "Little Tikes" }, { "name": "Miracle", "code": "Miracle" }, { "name": "Playcraft", "code": "Playcraft" }, { "name": "Playworld", "code": "Playworld" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PlaygroundEquipmentManufacturer" }, { "name": "PlaygroundEquipmentModelNumber", "type": "esriFieldTypeString", "alias": "Equipment Model Number", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "PlaygroundEquipmentModelNumber" }, { "name": "LastInspectionDate", "type": "esriFieldTypeDate", "alias": "LastI nspection Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LastInspectionDate" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "Distributor", "type": "esriFieldTypeString", "alias": "Distributor", "domain": { "type": "codedValue", "name": "PlaygroundDistributor", "description": "Playground Equipment Distributor", "codedValues": [ { "name": "City of Eagan", "code": "City of Eagan" }, { "name": "Earl F Anderson Inc", "code": "Earl F Anderson Inc" }, { "name": "Flanagan Sales Inc", "code": "Flanagan Sales Inc" }, { "name": "Midwest Playscapes Inc", "code": "Midwest Playscapes Inc" }, { "name": "MN/WI Playground", "code": "MNWI Playground" }, { "name": "St. Croix Recreation", "code": "St Croix Recreation" }, { "name": "Webber Recreational Design Inc", "code": "Webber Recreational Design Inc" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Distributor" }, { "name": "ReplacedOnDate", "type": "esriFieldTypeDate", "alias": "Replaced On Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ReplacedOnDate" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "PlaygroundEquipmentID", "type": "esriFieldTypeString", "alias": "PlaygroundEquipmentID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PlaygroundEquipmentID" }, { "name": "PlygrdEquipConsolid", "type": "esriFieldTypeString", "alias": "PlygrdEquipConsolid", "domain": null, "editable": true, "nullable": true, "length": 300, "defaultValue": null, "modelName": "PlygrdEquipConsolid" } ], "indexes": [ { "name": "R2066_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_2066", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "BaseGIS_SDE.MAINT.PlaygroundEquipment", "description": "", "prototype": { "attributes": { "PlaygroundEquipmentID": null, "PlaygroundEquipmentType": null, "PlaygroundEquipmentName": null, "PlaygroundName": null, "PlaygroundID": null, "PlaygroundEquipmentManufacturer": null, "PlaygroundEquipmentModelNumber": null, "LastInspectionDate": null, "ReplacedOnDate": null, "Distributor": null, "PlygrdEquipConsolid": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": 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": 1000, "maxRecordCountFactor": 1 }