units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
24 rows where MNG_AGENCY = 90
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12822 | 12822 | 12821 | {"type": "Polygon", "coordinates": [[[-117.67952, 33.47923], [-117.67924, 33.47995], [-117.67882, 33.48179], [-117.67839, 33.48178], [-117.67854, 33.48129], [-117.67894, 33.47938], [-117.67904, 33.47912], [-117.67905, 33.4791], [-117.67913, 33.47909], [-117.67952, 33.47923]]]} | Open Access 1 | 30267 | Mission Bell Park | 22293 | 1305 | San Juan Capistrano, City of 92 | City 2 | City Agency 2 | http://www.sanjuancapistrano.org/ | City 2 | 1305 | San Juan Capistrano, City of 90 | City 2 | City Agency 2 | Orange 3 | 2.884 | Mission Bell Park | 0 | Local Park 2 | 4 | |
12823 | 12823 | 12822 | {"type": "Polygon", "coordinates": [[[-117.63774, 33.49728], [-117.6374, 33.49738], [-117.63724, 33.49716], [-117.63721, 33.49701], [-117.63771, 33.49694], [-117.63774, 33.49728]]]} | Open Access 1 | 30268 | La Ronda Park | 20806 | 1305 | San Juan Capistrano, City of 92 | City 2 | City Agency 2 | http://www.sanjuancapistrano.org/ | City 2 | 1305 | San Juan Capistrano, City of 90 | City 2 | City Agency 2 | Orange 3 | 0.428 | La Ronda Park | 0 | Local Park 2 | 4 | |
12824 | 12824 | 12823 | {"type": "Polygon", "coordinates": [[[-117.65747, 33.47102], [-117.65702, 33.47091], [-117.65653, 33.47084], [-117.65637, 33.47091], [-117.65617, 33.47091], [-117.65611, 33.47088], [-117.65603, 33.47082], [-117.65576, 33.47071], [-117.65435, 33.47072], [-117.6544, 33.47021], [-117.65505, 33.47026], [-117.65569, 33.47024], [-117.65711, 33.47005], [-117.6572, 33.47011], [-117.65723, 33.47025], [-117.65746, 33.4706], [-117.65735, 33.47067], [-117.65747, 33.47102]]]} | Open Access 1 | 30269 | Acu Canyon Park | 15252 | 1305 | San Juan Capistrano, City of 92 | City 2 | City Agency 2 | http://www.sanjuancapistrano.org/ | City 2 | 1305 | San Juan Capistrano, City of 90 | City 2 | City Agency 2 | Orange 3 | 4.692 | Acu Canyon Park | 0 | Local Park 2 | 4 | |
16097 | 16097 | 16096 | {"type": "Polygon", "coordinates": [[[-117.66833, 33.48239], [-117.66753, 33.48349], [-117.66636, 33.48315], [-117.66522, 33.48358], [-117.66332, 33.48553], [-117.66332, 33.48643], [-117.66267, 33.4871], [-117.66177, 33.4874], [-117.66187, 33.4882], [-117.66208, 33.48854], [-117.66304, 33.48862], [-117.66279, 33.48938], [-117.66144, 33.49124], [-117.66074, 33.49125], [-117.65966, 33.48948], [-117.65845, 33.48856], [-117.65703, 33.48785], [-117.65532, 33.48752], [-117.65451, 33.48701], [-117.65494, 33.48562], [-117.65395, 33.48563], [-117.65255, 33.48732], [-117.6512, 33.48729], [-117.65017, 33.48585], [-117.64931, 33.48578], [-117.64897, 33.48637], [-117.64757, 33.48676], [-117.64706, 33.48744], [-117.64769, 33.48996], [-117.64704, 33.49115], [-117.6475, 33.49233], [-117.64727, 33.49452], [-117.64656, 33.49482], [-117.64626, 33.49449], [-117.6461, 33.49343], [-117.64584, 33.49259], [-117.64524, 33.4923], [-117.64453, 33.49192], [-117.64496, 33.49029], [-117.64495, 33.49028], [-117.64427, 33.49045], [-117.64391, 33.49015], [-117.64415, 33.48914], [-117.64345, 33.4891], [-117.64295, 33.49008], [-117.64139, 33.48953], [-117.64167, 33.48747], [-117.64267, 33.48569], [-117.64337, 33.48564], [-117.64353, 33.48601], [-117.64418, 33.48559], [-117.64392, 33.4845], [-117.64315, 33.48252], [-117.64103, 33.48203], [-117.63903, 33.48355], [-117.63817, 33.48309], [-117.63701, 33.4831], [-117.63525, 33.48366], [-117.63441, 33.48455], [-117.63391, 33.48531], [-117.63427, 33.48658], [-117.63428, 33.48754], [-117.63498, 33.48826], [-117.63559, 33.48884], [-117.63666, 33.48939], [-117.63761, 33.49044], [-117.63767, 33.49086], [-117.63989, 33.49156], [-117.6404, 33.49161], [-117.64152, 33.49282], [-117.64186, 33.49273], [-117.64187, 33.49388], [-117.64213, 33.49459], [-117.64259, 33.49522], [-117.64325, 33.49559], [-117.6437, 33.49581], [-117.6433, 33.49611], [-117.64265, 33.49615], [-117.64246, 33.49628], [-117.6433, 33.49665], [-117.64396, 33.49669], [-117.64426, 33.49677], [-117.64441, 33.49702], [-117.64393, 33.49905], [-117.64262, 33.49911], [-117.64131, 33.49949], [-117.63798, 33.49757], [-117.63773, 33.49708], [-117.63772, 33.49706], [-117.63797, 33.49705], [-117.63745, 33.49471], [-117.63819, 33.49263], [-117.63773, 33.49162], [-117.6348, 33.49114], [-117.63507, 33.49315], [-117.63358, 33.49455], [-117.63594, 33.4961], [-117.63616, 33.49716], [-117.63294, 33.49772], [-117.627, 33.49142], [-117.63103, 33.49068], [-117.63212, 33.48865], [-117.63214, 33.48579], [-117.62945, 33.48335], [-117.62627, 33.48104], [-117.62721, 33.48003], [-117.62851, 33.47993], [-117.62872, 33.47897], [-117.63304, 33.47912], [-117.63316, 33.48013], [-117.63759, 33.48111], [-117.63885, 33.48102], [-117.64236, 33.47809], [-117.64232, 33.47367], [-117.65552, 33.4736], [-117.65547, 33.47875], [-117.66069, 33.47842], [-117.66323, 33.47499], [-117.66298, 33.48136], [-117.66833, 33.48239]]]} | Open Access 1 | 12607 | San Juan Capistrano City Open Space | 11314 | 1305 | San Juan Capistrano, City of 92 | City 2 | City Agency 2 | http://www.sanjuancapistrano.org/ | City 2 | 1305 | San Juan Capistrano, City of 90 | City 2 | City Agency 2 | http://www.sjcopenspacefoundation.org/explore.html | Orange 3 | 1109.775 | San Juan Capistrano City 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]);