units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
6 rows where ACCESS_TYP = 2, GAP_STS = 4 and MNG_AGENCY = 120
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6425 | 6425 | 6424 | {"type": "Polygon", "coordinates": [[[-117.24324, 33.10452], [-117.24295, 33.10466], [-117.24254, 33.10499], [-117.2424, 33.10498], [-117.24176, 33.10484], [-117.24171, 33.10478], [-117.24165, 33.10475], [-117.24152, 33.10476], [-117.24146, 33.10481], [-117.24127, 33.10477], [-117.24119, 33.10472], [-117.24122, 33.10468], [-117.24122, 33.10467], [-117.24082, 33.10455], [-117.24083, 33.10447], [-117.24077, 33.10443], [-117.2408, 33.10434], [-117.24077, 33.10432], [-117.24092, 33.10403], [-117.24145, 33.10412], [-117.24144, 33.10416], [-117.24172, 33.10428], [-117.24255, 33.10361], [-117.24285, 33.10394], [-117.24324, 33.10452]]]} | Restricted Access 2 | 1929 | Fuerte Park | 31613 | 1045 | Carlsbad, City of 123 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | San Diego 4 | 4.633 | Fuerte Park | 0 | Local Park 2 | 4 | |
15396 | 15396 | 15395 | {"type": "Polygon", "coordinates": [[[-117.27642, 33.10482], [-117.27601, 33.10477], [-117.2759, 33.10472], [-117.27538, 33.10439], [-117.27531, 33.10432], [-117.27516, 33.104], [-117.27491, 33.10395], [-117.27475, 33.10394], [-117.27475, 33.10338], [-117.27481, 33.10333], [-117.27618, 33.1033], [-117.27625, 33.1034], [-117.27624, 33.10399], [-117.27633, 33.10406], [-117.27642, 33.10482]]]} | Restricted Access 2 | 46650 | Aviara Oaks Middle School Park | 31948 | 2399 | Carlsbad Unified School District 1157 | Special District 4 | School District 14 | http://www.carlsbadusd.k12.ca.us/ | Special District 4 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | San Diego 4 | 4.374 | Aviara Oaks Middle School Park | 0 | Local Park 2 | 4 | |
15418 | 15418 | 15417 | {"type": "Polygon", "coordinates": [[[-117.33206, 33.16323], [-117.33174, 33.16369], [-117.33078, 33.16284], [-117.33123, 33.16249], [-117.33206, 33.16323]]]} | Restricted Access 2 | 46651 | Carlsbad High School Tennis Courts | 32247 | 2399 | Carlsbad Unified School District 1157 | Special District 4 | School District 14 | http://www.carlsbadusd.k12.ca.us/ | Special District 4 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | San Diego 4 | 1.727 | Carlsbad High School Tennis Courts | 0 | Local Recreation Area 3 | 4 | |
15420 | 15420 | 15419 | {"type": "Polygon", "coordinates": [[[-117.2429, 33.08001], [-117.24288, 33.08032], [-117.24286, 33.08034], [-117.24286, 33.08075], [-117.24204, 33.08076], [-117.24201, 33.07859], [-117.24207, 33.07859], [-117.24218, 33.07904], [-117.24283, 33.07906], [-117.24279, 33.07988], [-117.2429, 33.08001]]]} | Restricted Access 2 | 46658 | Levante School Park | 29992 | 2399 | Carlsbad Unified School District 1157 | Special District 4 | School District 14 | http://www.carlsbadusd.k12.ca.us/ | Special District 4 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | San Diego 4 | 3.673 | Levante School Park | 0 | Local Park 2 | 4 | |
15421 | 15421 | 15420 | {"type": "Polygon", "coordinates": [[[-117.33023, 33.15686], [-117.33022, 33.157], [-117.33015, 33.15709], [-117.33003, 33.1572], [-117.32987, 33.15728], [-117.32972, 33.1573], [-117.3295, 33.15728], [-117.3294, 33.15725], [-117.32929, 33.15717], [-117.32917, 33.15701], [-117.32785, 33.15762], [-117.32731, 33.15675], [-117.32718, 33.15651], [-117.32716, 33.15642], [-117.32727, 33.15627], [-117.3275, 33.15625], [-117.32782, 33.1562], [-117.32795, 33.15615], [-117.32929, 33.15552], [-117.33023, 33.15686]]]} | Restricted Access 2 | 46659 | Magnolia Athletic Field | 31624 | 1045 | Carlsbad, City of 123 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | San Diego 4 | 9.19 | Magnolia Athletic Field | 0 | Local Recreation Area 3 | 4 | |
15656 | 15656 | 15655 | {"type": "MultiPolygon", "coordinates": [[[[-117.30136, 33.12431], [-117.30109, 33.12548], [-117.30099, 33.12581], [-117.3009, 33.12606], [-117.30077, 33.1263], [-117.30063, 33.12653], [-117.30041, 33.12683], [-117.30016, 33.1271], [-117.29988, 33.12736], [-117.29943, 33.12767], [-117.29912, 33.12785], [-117.29879, 33.128], [-117.29844, 33.12813], [-117.29799, 33.12825], [-117.29689, 33.12844], [-117.29653, 33.12854], [-117.29611, 33.12871], [-117.29546, 33.12906], [-117.29516, 33.12919], [-117.29485, 33.1293], [-117.29455, 33.12937], [-117.29393, 33.12948], [-117.29388, 33.12931], [-117.29366, 33.12931], [-117.29348, 33.12914], [-117.2928, 33.12894], [-117.29075, 33.12924], [-117.29021, 33.12955], [-117.29004, 33.12945], [-117.28923, 33.12912], [-117.28822, 33.12843], [-117.2879, 33.12839], [-117.29047, 33.12797], [-117.29037, 33.12753], [-117.29114, 33.12727], [-117.29117, 33.12721], [-117.29105, 33.12678], [-117.29103, 33.12657], [-117.29388, 33.12611], [-117.29434, 33.12505], [-117.29475, 33.12451], [-117.29521, 33.12385], [-117.29436, 33.1232], [-117.29415, 33.12299], [-117.29467, 33.12313], [-117.29552, 33.12331], [-117.29988, 33.12403], [-117.30074, 33.12415], [-117.30085, 33.1242], [-117.30129, 33.12426], [-117.30134, 33.12428], [-117.30136, 33.12431]]], [[[-117.30821, 33.12981], [-117.30818, 33.12985], [-117.30818, 33.12992], [-117.30821, 33.13008], [-117.30827, 33.13574], [-117.30791, 33.13835], [-117.30763, 33.13858], [-117.30741, 33.13879], [-117.30725, 33.13898], [-117.3072, 33.139], [-117.30688, 33.13882], [-117.30658, 33.13862], [-117.30647, 33.13853], [-117.30624, 33.13828], [-117.30605, 33.13801], [-117.30591, 33.13774], [-117.30568, 33.13712], [-117.30553, 33.13682], [-117.30542, 33.13664], [-117.30519, 33.13635], [-117.30492, 33.1361], [-117.30461, 33.13589], [-117.30357, 33.13528], [-117.30323, 33.13506], [-117.30163, 33.13361], [-117.30136, 33.1334], [-117.30105, 33.13321], [-117.30081, 33.13309], [-117.30039, 33.13293], [-117.30012, 33.13286], [-117.29975, 33.13279], [-117.29928, 33.13275], [-117.29891, 33.13276], [-117.29836, 33.13285], [-117.29809, 33.13292], [-117.29774, 33.13304], [-117.29674, 33.13352], [-117.29634, 33.13378], [-117.29605, 33.13401], [-117.29585, 33.1342], [-117.29567, 33.1344], [-117.2954, 33.13476], [-117.29519, 33.13514], [-117.29465, 33.13281], [-117.29201, 33.13101], [-117.29222, 33.13079], [-117.29302, 33.13088], [-117.29334, 33.13079], [-117.29375, 33.13063], [-117.29486, 33.13138], [-117.29564, 33.13095], [-117.29622, 33.13071], [-117.29622, 33.13069], [-117.29569, 33.13037], [-117.29544, 33.13028], [-117.29554, 33.12974], [-117.29521, 33.12948], [-117.29563, 33.1293], [-117.29635, 33.12892], [-117.29665, 33.1288], [-117.29689, 33.12873], [-117.29722, 33.12866], [-117.2982, 33.12849], [-117.29851, 33.12841], [-117.29881, 33.1283], [-117.2992, 33.12813], [-117.29957, 33.12794], [-117.29983, 33.12777], [-117.30012, 33.12755], [-117.30045, 33.12725], [-117.30078, 33.12687], [-117.30079, 33.12685], [-117.30095, 33.12665], [-117.30115, 33.12628], [-117.30133, 33.12584], [-117.30159, 33.1248], [-117.30164, 33.12472], [-117.30169, 33.12449], [-117.30173, 33.12437], [-117.3018, 33.12434], [-117.30193, 33.12432], [-117.30244, 33.12435], [-117.30277, 33.12434], [-117.30376, 33.12426], [-117.30415, 33.12421], [-117.30475, 33.12408], [-117.30523, 33.12395], [-117.30593, 33.12373], [-117.306, 33.12376], [-117.30601, 33.12378], [-117.30639, 33.12491], [-117.30643, 33.12505], [-117.30675, 33.12506], [-117.30722, 33.12647], [-117.30727, 33.12686], [-117.30726, 33.12705], [-117.30712, 33.12705], [-117.30698, 33.12724], [-117.30691, 33.12971], [-117.30713, 33.12967], [-117.3082, 33.12935], [-117.30821, 33.12981]]]]} | Restricted Access 2 | 804 | The Crossings Golf Course | 30002 | 1045 | Carlsbad, City of 123 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | San Diego 4 | 391.552 | The Crossings GC | 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]);