units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where MNG_AGENCY = 465 and YR_EST = 1924
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- Santa Clara County Parks and Recreation Dept., County of · 2 ✖
DES_TP 1
ACCESS_TYP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10098 | 10098 | 10097 | {"type": "MultiPolygon", "coordinates": [[[[-122.1041, 37.27935], [-122.10011, 37.27926], [-122.10003, 37.27563], [-122.09539, 37.27567], [-122.09546, 37.27928], [-122.07757, 37.27969], [-122.07758, 37.2818], [-122.08435, 37.28458], [-122.08332, 37.28635], [-122.08099, 37.28634], [-122.08115, 37.28627], [-122.08144, 37.2862], [-122.08181, 37.28604], [-122.08169, 37.28596], [-122.08125, 37.28577], [-122.07969, 37.28434], [-122.07922, 37.28463], [-122.07917, 37.28497], [-122.07849, 37.28448], [-122.07828, 37.28463], [-122.07799, 37.2842], [-122.07759, 37.28421], [-122.07758, 37.2845], [-122.07726, 37.28431], [-122.0771, 37.28425], [-122.07693, 37.2842], [-122.07666, 37.28418], [-122.07644, 37.28421], [-122.07622, 37.28421], [-122.076, 37.28419], [-122.07588, 37.28415], [-122.07578, 37.28409], [-122.07571, 37.28401], [-122.07565, 37.28392], [-122.07563, 37.28378], [-122.07564, 37.28352], [-122.07568, 37.28335], [-122.07578, 37.28309], [-122.07577, 37.28295], [-122.07572, 37.28286], [-122.07555, 37.2828], [-122.07553, 37.28285], [-122.07563, 37.28295], [-122.07565, 37.28306], [-122.07552, 37.28341], [-122.07549, 37.2837], [-122.07552, 37.28394], [-122.07561, 37.2841], [-122.07577, 37.28422], [-122.07596, 37.2843], [-122.07632, 37.28432], [-122.07676, 37.28429], [-122.07702, 37.28434], [-122.07725, 37.28444], [-122.07758, 37.28465], [-122.07759, 37.28539], [-122.07797, 37.28556], [-122.07813, 37.28571], [-122.07821, 37.28591], [-122.07817, 37.28594], [-122.07827, 37.28605], [-122.0783, 37.28616], [-122.07825, 37.28623], [-122.07799, 37.28619], [-122.07788, 37.28622], [-122.07761, 37.28615], [-122.07762, 37.28633], [-122.06852, 37.28626], [-122.06859, 37.27193], [-122.07001, 37.27202], [-122.07521, 37.27193], [-122.07532, 37.27066], [-122.07573, 37.2704], [-122.07599, 37.27055], [-122.07754, 37.27054], [-122.07756, 37.27201], [-122.10398, 37.27196], [-122.10405, 37.27559], [-122.10404, 37.27598], [-122.1041, 37.27935]]], [[[-122.07889, 37.29493], [-122.07828, 37.29488], [-122.07805, 37.29494], [-122.07767, 37.29513], [-122.07743, 37.29519], [-122.07726, 37.29511], [-122.07719, 37.29489], [-122.07682, 37.29478], [-122.07628, 37.29448], [-122.07601, 37.29371], [-122.07562, 37.29431], [-122.07541, 37.29433], [-122.07519, 37.29425], [-122.0749, 37.2943], [-122.07469, 37.29455], [-122.07458, 37.29488], [-122.07472, 37.29507], [-122.07471, 37.29557], [-122.0748, 37.29598], [-122.07514, 37.29622], [-122.075, 37.29638], [-122.07511, 37.29648], [-122.07547, 37.29648], [-122.07565, 37.29687], [-122.07472, 37.29759], [-122.07472, 37.29831], [-122.07507, 37.30042], [-122.07747, 37.30044], [-122.07683, 37.30072], [-122.07684, 37.30074], [-122.07776, 37.30039], [-122.07782, 37.30049], [-122.07649, 37.301], [-122.07634, 37.30109], [-122.07594, 37.30141], [-122.0759, 37.30164], [-122.07593, 37.30187], [-122.07599, 37.30202], [-122.07618, 37.30235], [-122.07622, 37.30248], [-122.07643, 37.30283], [-122.07643, 37.30306], [-122.07631, 37.30326], [-122.07606, 37.30346], [-122.07586, 37.30371], [-122.07578, 37.30415], [-122.07563, 37.30433], [-122.07544, 37.30465], [-122.07569, 37.3048], [-122.07548, 37.30545], [-122.07531, 37.30581], [-122.07499, 37.30612], [-122.07489, 37.30614], [-122.07487, 37.30623], [-122.07454, 37.30654], [-122.07427, 37.30691], [-122.07422, 37.30703], [-122.07399, 37.30716], [-122.07264, 37.30751], [-122.07247, 37.30753], [-122.07222, 37.30751], [-122.07122, 37.3069], [-122.07069, 37.30692], [-122.06995, 37.30652], [-122.0698, 37.30558], [-122.07055, 37.30476], [-122.07046, 37.30033], [-122.07307, 37.30033], [-122.0731, 37.29373], [-122.07315, 37.29372], [-122.07315, 37.29354], [-122.07833, 37.29355], [-122.0782, 37.29356], [-122.07818, 37.29418], [-122.07833, 37.29439], [-122.07852, 37.29452], [-122.07868, 37.2948], [-122.07889, 37.29493]]], [[[-122.07739, 37.287], [-122.07739, 37.28701], [-122.07739, 37.28701], [-122.07739, 37.28701], [-122.07739, 37.287]]], [[[-122.08197, 37.29463], [-122.08195, 37.29498], [-122.08121, 37.29497], [-122.08084, 37.29453], [-122.08113, 37.29428], [-122.08171, 37.29372], [-122.08172, 37.29358], [-122.08171, 37.29357], [-122.08142, 37.29357], [-122.08151, 37.29345], [-122.08154, 37.29227], [-122.08131, 37.29169], [-122.08122, 37.29094], [-122.08088, 37.2903], [-122.08082, 37.28952], [-122.08036, 37.28842], [-122.07985, 37.28799], [-122.07953, 37.28792], [-122.0783, 37.28789], [-122.0781, 37.28773], [-122.07813, 37.2876], [-122.0787, 37.28677], [-122.07839, 37.28561], [-122.07784, 37.2851], [-122.0778, 37.2848], [-122.07842, 37.28521], [-122.07865, 37.28542], [-122.0788, 37.28565], [-122.07898, 37.28624], [-122.07936, 37.28709], [-122.07947, 37.28726], [-122.0796, 37.28743], [-122.07977, 37.28758], [-122.08027, 37.28796], [-122.08057, 37.28821], [-122.08066, 37.28834], [-122.08073, 37.28848], [-122.08095, 37.28925], [-122.08119, 37.28986], [-122.08162, 37.29076], [-122.0817, 37.29112], [-122.08219, 37.29279], [-122.08219, 37.29291], [-122.08216, 37.29302], [-122.08192, 37.29339], [-122.08187, 37.29349], [-122.08177, 37.29408], [-122.08177, 37.29422], [-122.0818, 37.29435], [-122.08186, 37.29447], [-122.08197, 37.29463]]]]} | Open Access 1 | 17490 | Stevens Creek County Park | 28942 | 326 | Santa Clara County Parks and Recreation Dept., County of 472 | County 3 | County Agency - Parks 7 | http://www.sccgov.org/sites/parks/Pages/Welcome-to-Santa-Clara-County-Parks.aspx | County 3 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | http://www.sccgov.org/sites/parks/parkfinder/Pages/StevensCreek.aspx | Santa Clara 19 | 938.051 | Stevens Creek County Park | 1924 | Local Park 2 | 4 |
14002 | 14002 | 14001 | {"type": "MultiPolygon", "coordinates": [[[[-122.08172, 37.29357], [-122.08171, 37.29371], [-122.08113, 37.29428], [-122.08085, 37.29453], [-122.0812, 37.29496], [-122.08313, 37.295], [-122.08389, 37.29535], [-122.08416, 37.29552], [-122.08424, 37.29563], [-122.08426, 37.29571], [-122.08421, 37.29584], [-122.08413, 37.29594], [-122.08402, 37.29603], [-122.08389, 37.29609], [-122.08375, 37.29614], [-122.08359, 37.29616], [-122.08344, 37.29615], [-122.08256, 37.29594], [-122.08237, 37.29593], [-122.08165, 37.29601], [-122.08021, 37.29625], [-122.08016, 37.29628], [-122.08006, 37.29634], [-122.07999, 37.29642], [-122.07995, 37.29652], [-122.07993, 37.29662], [-122.07995, 37.29671], [-122.08014, 37.29719], [-122.08015, 37.29738], [-122.08011, 37.2975], [-122.07999, 37.29766], [-122.07967, 37.29793], [-122.0793, 37.29829], [-122.07857, 37.29918], [-122.07846, 37.2994], [-122.07843, 37.29955], [-122.07842, 37.2997], [-122.07839, 37.29984], [-122.07832, 37.29997], [-122.07817, 37.30014], [-122.07795, 37.30027], [-122.07746, 37.30044], [-122.07507, 37.30043], [-122.07472, 37.29831], [-122.07472, 37.29759], [-122.07564, 37.29687], [-122.07547, 37.29648], [-122.07511, 37.29648], [-122.075, 37.29638], [-122.07513, 37.29622], [-122.0748, 37.29598], [-122.07471, 37.29557], [-122.07472, 37.29508], [-122.07457, 37.29489], [-122.07469, 37.29455], [-122.0749, 37.2943], [-122.07519, 37.29425], [-122.07541, 37.29433], [-122.07562, 37.29431], [-122.07602, 37.2937], [-122.07628, 37.29448], [-122.07682, 37.29478], [-122.07719, 37.29489], [-122.07726, 37.29511], [-122.07743, 37.29519], [-122.07767, 37.29513], [-122.07805, 37.29494], [-122.07828, 37.29488], [-122.07886, 37.29492], [-122.07868, 37.2948], [-122.07852, 37.29452], [-122.07833, 37.29439], [-122.07818, 37.29418], [-122.0782, 37.29356], [-122.07762, 37.29355], [-122.07764, 37.28865], [-122.07736, 37.28857], [-122.07713, 37.28812], [-122.07715, 37.28759], [-122.07735, 37.28703], [-122.07765, 37.28682], [-122.0776, 37.28615], [-122.07788, 37.28622], [-122.07799, 37.28619], [-122.07825, 37.28623], [-122.0783, 37.28616], [-122.07827, 37.28604], [-122.07816, 37.28593], [-122.07821, 37.28591], [-122.07813, 37.28571], [-122.07797, 37.28556], [-122.07759, 37.28539], [-122.07758, 37.28465], [-122.0778, 37.2848], [-122.07784, 37.2851], [-122.07839, 37.2856], [-122.0787, 37.28677], [-122.07813, 37.28759], [-122.0781, 37.28774], [-122.0783, 37.28789], [-122.07953, 37.28792], [-122.07985, 37.28799], [-122.08036, 37.28842], [-122.08082, 37.28952], [-122.08088, 37.2903], [-122.08122, 37.29094], [-122.08131, 37.29169], [-122.08154, 37.29227], [-122.08151, 37.29346], [-122.08147, 37.29356], [-122.08172, 37.29357]]], [[[-122.07934, 37.2851], [-122.079, 37.28584], [-122.07893, 37.28562], [-122.07889, 37.28554], [-122.07879, 37.28539], [-122.07866, 37.28525], [-122.07843, 37.28507], [-122.07758, 37.28451], [-122.07758, 37.28421], [-122.07799, 37.2842], [-122.07828, 37.28463], [-122.07849, 37.28447], [-122.07934, 37.2851]]], [[[-122.07898, 37.3002], [-122.07839, 37.30023], [-122.07819, 37.30027], [-122.07838, 37.30011], [-122.0785, 37.29992], [-122.07855, 37.29978], [-122.07857, 37.29955], [-122.07861, 37.2994], [-122.07886, 37.29955], [-122.07929, 37.29971], [-122.07939, 37.29981], [-122.07942, 37.29994], [-122.0794, 37.30002], [-122.07935, 37.30009], [-122.07928, 37.30015], [-122.07919, 37.30018], [-122.07898, 37.3002]]], [[[-122.08099, 37.28635], [-122.08072, 37.28654], [-122.08047, 37.28686], [-122.08027, 37.28748], [-122.08025, 37.2878], [-122.07994, 37.28757], [-122.07975, 37.2874], [-122.07986, 37.28705], [-122.08003, 37.28684], [-122.08011, 37.28663], [-122.08021, 37.28654], [-122.08023, 37.28649], [-122.08037, 37.28638], [-122.0805, 37.28634], [-122.08099, 37.28635]]]]} | Open Access 1 | 36695 | Stevens Creek County Park | 28942 | 2143 | Santa Clara Valley Water District 483 | Special District 4 | Water District 13 | http://www.valleywater.org/ | Special District 4 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | http://www.sccgov.org/sites/parks/parkfinder/Pages/StevensCreek.aspx | Santa Clara 19 | 141.202 | Stevens Creek County Park | 1924 | Local Park 2 | 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]);