units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where AGNCY_LEV = 2, DES_TP = 3 and MNG_AGENCY = 610
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16221 | 16221 | 16220 | {"type": "Polygon", "coordinates": [[[-121.9305, 37.9469], [-121.92784, 37.9479], [-121.92463, 37.94919], [-121.92428, 37.94883], [-121.92252, 37.94895], [-121.92223, 37.94883], [-121.9219, 37.94872], [-121.92131, 37.94859], [-121.92078, 37.94851], [-121.92023, 37.94847], [-121.91938, 37.94838], [-121.91908, 37.94839], [-121.91797, 37.94851], [-121.91718, 37.94867], [-121.91666, 37.94852], [-121.91642, 37.94838], [-121.91616, 37.94832], [-121.91613, 37.94837], [-121.91608, 37.94823], [-121.9159, 37.94827], [-121.91598, 37.94853], [-121.9159, 37.94853], [-121.91583, 37.94828], [-121.9156, 37.94826], [-121.91549, 37.94855], [-121.9154, 37.9487], [-121.91517, 37.94892], [-121.91511, 37.94892], [-121.91504, 37.94893], [-121.91499, 37.94897], [-121.91496, 37.94901], [-121.91457, 37.94901], [-121.91445, 37.93618], [-121.91437, 37.92671], [-121.91905, 37.9267], [-121.92053, 37.9274], [-121.92054, 37.92744], [-121.92044, 37.92758], [-121.9201, 37.92829], [-121.91994, 37.92846], [-121.91971, 37.9286], [-121.91943, 37.92868], [-121.91867, 37.92876], [-121.91841, 37.92875], [-121.91815, 37.92859], [-121.91794, 37.92861], [-121.91742, 37.92859], [-121.9171, 37.92882], [-121.9169, 37.9289], [-121.91693, 37.92927], [-121.91714, 37.92944], [-121.91729, 37.92953], [-121.91715, 37.92967], [-121.91718, 37.92988], [-121.91698, 37.93003], [-121.91681, 37.93033], [-121.91612, 37.93063], [-121.91601, 37.93105], [-121.91631, 37.93118], [-121.91666, 37.93088], [-121.91683, 37.93086], [-121.9174, 37.93102], [-121.91734, 37.93066], [-121.9175, 37.93052], [-121.91788, 37.93052], [-121.91795, 37.93036], [-121.91862, 37.9301], [-121.91881, 37.92987], [-121.91926, 37.92992], [-121.91954, 37.92998], [-121.91983, 37.9301], [-121.92035, 37.93054], [-121.92072, 37.9308], [-121.9225, 37.93346], [-121.92125, 37.93347], [-121.92059, 37.93359], [-121.92059, 37.93384], [-121.92271, 37.93389], [-121.9228, 37.93419], [-121.9229, 37.9344], [-121.92321, 37.93494], [-121.92359, 37.93545], [-121.92479, 37.93674], [-121.92608, 37.93823], [-121.92572, 37.93842], [-121.92587, 37.9396], [-121.92587, 37.9398], [-121.92626, 37.93991], [-121.92616, 37.94011], [-121.92597, 37.9403], [-121.92581, 37.94039], [-121.92551, 37.94049], [-121.92529, 37.94059], [-121.9251, 37.94073], [-121.92502, 37.94081], [-121.92495, 37.94089], [-121.92485, 37.94107], [-121.92471, 37.94171], [-121.92463, 37.94186], [-121.92452, 37.94199], [-121.92436, 37.94212], [-121.92419, 37.9422], [-121.924, 37.94225], [-121.92386, 37.94227], [-121.92383, 37.942], [-121.92366, 37.94192], [-121.92351, 37.94192], [-121.92336, 37.9418], [-121.92326, 37.94178], [-121.92319, 37.94157], [-121.92314, 37.94155], [-121.92309, 37.94133], [-121.92303, 37.9413], [-121.92272, 37.94076], [-121.92249, 37.94049], [-121.92219, 37.94027], [-121.92182, 37.94008], [-121.92143, 37.93996], [-121.91974, 37.93974], [-121.91946, 37.93965], [-121.91916, 37.93951], [-121.91846, 37.93928], [-121.91788, 37.93905], [-121.91758, 37.93892], [-121.91649, 37.93839], [-121.9164, 37.93831], [-121.91627, 37.93816], [-121.91635, 37.93808], [-121.91638, 37.93776], [-121.91634, 37.93768], [-121.91627, 37.93761], [-121.91621, 37.93759], [-121.91594, 37.93758], [-121.91596, 37.93737], [-121.91624, 37.93753], [-121.91696, 37.93746], [-121.91694, 37.93726], [-121.91684, 37.93709], [-121.91611, 37.93663], [-121.91598, 37.93675], [-121.91592, 37.93673], [-121.91566, 37.93648], [-121.91541, 37.93631], [-121.91518, 37.93629], [-121.91512, 37.93636], [-121.91512, 37.93646], [-121.91533, 37.9368], [-121.9154, 37.93702], [-121.9154, 37.93705], [-121.91545, 37.9373], [-121.91542, 37.93733], [-121.91542, 37.93757], [-121.91536, 37.93763], [-121.91529, 37.93782], [-121.91525, 37.93785], [-121.91519, 37.93802], [-121.91512, 37.93807], [-121.91508, 37.93827], [-121.91512, 37.93838], [-121.91517, 37.93842], [-121.91513, 37.93849], [-121.91514, 37.93856], [-121.91508, 37.93859], [-121.91501, 37.93905], [-121.91478, 37.93922], [-121.91476, 37.93937], [-121.91459, 37.93959], [-121.91454, 37.93983], [-121.91468, 37.94024], [-121.91493, 37.94033], [-121.91496, 37.94037], [-121.91523, 37.94046], [-121.91526, 37.94051], [-121.91556, 37.94059], [-121.91559, 37.94064], [-121.91587, 37.94072], [-121.91591, 37.94076], [-121.91611, 37.94083], [-121.91632, 37.94079], [-121.91641, 37.94067], [-121.91669, 37.94078], [-121.91716, 37.94092], [-121.91735, 37.94099], [-121.91752, 37.94109], [-121.91737, 37.94124], [-121.91748, 37.94138], [-121.91766, 37.94152], [-121.91768, 37.94156], [-121.91793, 37.9417], [-121.91797, 37.94173], [-121.91818, 37.94182], [-121.91821, 37.94186], [-121.91844, 37.94193], [-121.91847, 37.94198], [-121.91869, 37.94204], [-121.91873, 37.94209], [-121.91896, 37.94216], [-121.919, 37.9422], [-121.91923, 37.94224], [-121.91937, 37.94218], [-121.91948, 37.94202], [-121.91988, 37.94205], [-121.92017, 37.94213], [-121.92057, 37.94233], [-121.92049, 37.94239], [-121.9205, 37.9425], [-121.92057, 37.94264], [-121.92072, 37.94271], [-121.92076, 37.94274], [-121.92105, 37.94284], [-121.92109, 37.94287], [-121.92115, 37.94288], [-121.92142, 37.94284], [-121.92145, 37.94285], [-121.9216, 37.9428], [-121.92172, 37.94271], [-121.92176, 37.94273], [-121.92197, 37.94269], [-121.92202, 37.94262], [-121.92196, 37.9424], [-121.92267, 37.94227], [-121.92296, 37.94216], [-121.92302, 37.94217], [-121.92313, 37.94224], [-121.92334, 37.94233], [-121.92367, 37.9424], [-121.92402, 37.94238], [-121.92425, 37.94232], [-121.92435, 37.94228], [-121.92453, 37.94217], [-121.92462, 37.94211], [-121.92476, 37.94196], [-121.92481, 37.94187], [-121.92489, 37.94165], [-121.925, 37.94115], [-121.92503, 37.94106], [-121.92513, 37.94091], [-121.92527, 37.94078], [-121.92544, 37.94067], [-121.92574, 37.94056], [-121.92582, 37.94101], [-121.92587, 37.94175], [-121.92555, 37.94245], [-121.92662, 37.94297], [-121.92639, 37.94295], [-121.92617, 37.94296], [-121.92595, 37.94301], [-121.92576, 37.9431], [-121.92559, 37.94321], [-121.92551, 37.94328], [-121.92545, 37.94335], [-121.92528, 37.94361], [-121.92523, 37.94366], [-121.92514, 37.94372], [-121.92494, 37.94375], [-121.92452, 37.94368], [-121.92421, 37.94371], [-121.92393, 37.94381], [-121.92376, 37.94392], [-121.92348, 37.94415], [-121.92336, 37.94421], [-121.9228, 37.94432], [-121.92258, 37.94538], [-121.92348, 37.94574], [-121.92504, 37.94618], [-121.92651, 37.94566], [-121.92758, 37.94516], [-121.9305, 37.9469]], [[-121.91577, 37.94768], [-121.9157, 37.94776], [-121.91566, 37.94785], [-121.91567, 37.94795], [-121.91571, 37.94805], [-121.91603, 37.94798], [-121.91616, 37.94776], [-121.91583, 37.94763], [-121.91577, 37.94768]], [[-121.91723, 37.94739], [-121.91723, 37.94737], [-121.91682, 37.94723], [-121.91663, 37.94761], [-121.91705, 37.94774], [-121.91723, 37.94739]]]} | Open Access 1 | 44716 | City of Clayton Open Space | 2402 | 1058 | Clayton, City of 621 | City 2 | City Agency 2 | http://ci.clayton.ca.us/?page_id=65 | City 2 | 1058 | Clayton, City of 610 | City 2 | City Agency 2 | Contra Costa 12 | 434.323 | City of Clayton OS | 0 | Local Recreation Area 3 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);