{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 9, "name": "BaseGIS_SDE.MAINT.PlaygroundEquipment", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "PlaygroundEquipmentName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "PlaygroundEquipmentType", "type": "esriFieldTypeString", "alias": "PlaygroundEquipmentType", "length": 300, "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" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PlaygroundEquipmentName", "type": "esriFieldTypeString", "alias": "Equipment Name", "length": 50, "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" } }, { "name": "PlaygroundName", "type": "esriFieldTypeString", "alias": "Playground Name", "length": 50, "domain": { "type": "codedValue", "name": "PlaygroundName", "description": "Playground Name", "codedValues": [ { "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": "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": "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" }, { "name": "Blackhawk", "code": "Blackhawk" }, { "name": "O'Leary", "code": "O'Leary" }, { "name": "Trapp Farm", "code": "Trapp Farm" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PlaygroundID", "type": "esriFieldTypeString", "alias": "Playground ID", "length": 15, "domain": null }, { "name": "PlaygroundEquipmentManufacturer", "type": "esriFieldTypeString", "alias": "Equipment Manufacturer", "length": 50, "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" } }, { "name": "PlaygroundEquipmentModelNumber", "type": "esriFieldTypeString", "alias": "Equipment Model Number", "length": 20, "domain": null }, { "name": "LastInspectionDate", "type": "esriFieldTypeDate", "alias": "LastI nspection Date", "length": 8, "domain": null }, { "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": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Distributor", "type": "esriFieldTypeString", "alias": "Distributor", "length": 50, "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" } }, { "name": "ReplacedOnDate", "type": "esriFieldTypeDate", "alias": "Replaced On Date", "length": 8, "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PlaygroundEquipmentID", "type": "esriFieldTypeString", "alias": "PlaygroundEquipmentID", "length": 50, "domain": null }, { "name": "PlygrdEquipConsolid", "type": "esriFieldTypeString", "alias": "PlygrdEquipConsolid", "length": 300, "domain": null } ], "indexes": [ { "name": "R2066_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_2066", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "PlaygroundInspection_Equipment", "relatedTableId": 10, "role": "esriRelRoleOrigin", "keyField": "PlaygroundEquipmentID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{09F73194-CF73-4328-99B4-9D4284C070DD}" }, { "id": 1, "name": "Playgrounds", "relatedTableId": 8, "role": "esriRelRoleDestination", "keyField": "PlaygroundName", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{729E6714-4BDC-4617-A64B-57AF6F841B5D}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }