superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
24 rows where ACCESS_TYP = 1 and MNG_AGENCY = 90 sorted by map
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 24
MNG_AGENCY 1
- San Juan Capistrano, City of · 24 ✖
ACCESS_TYP 1
- Open Access · 24 ✖
Link | rowid | id | map ▼ | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3883 | 3883 | 3882 | {"type": "MultiPolygon", "coordinates": [[[[-117.66596, 33.50768], [-117.66577, 33.5077], [-117.66572, 33.50768], [-117.66541, 33.50707], [-117.66567, 33.50698], [-117.66596, 33.50768]]], [[[-117.66901, 33.51494], [-117.66882, 33.51458], [-117.66808, 33.51326], [-117.66775, 33.51256], [-117.6669, 33.5106], [-117.66646, 33.50942], [-117.66623, 33.50895], [-117.6658, 33.50793], [-117.66583, 33.50788], [-117.66603, 33.50784], [-117.66648, 33.50895], [-117.66686, 33.50979], [-117.66745, 33.51124], [-117.66772, 33.51189], [-117.66779, 33.512], [-117.66792, 33.5123], [-117.66884, 33.51451], [-117.66901, 33.51494]]]]} | Open Access 1 | El Camino Real Park | 18482 | 1305 | San Juan Capistrano, City of 90 | City 2 | City Agency 2 | http://www.sanjuancapistrano.org/ | City 2 | 4.569 | El Camino Real Park | ||
8725 | 8725 | 8724 | {"type": "MultiPolygon", "coordinates": [[[[-117.66958, 33.51154], [-117.66927, 33.51218], [-117.66913, 33.51213], [-117.66906, 33.51208], [-117.66887, 33.51163], [-117.66958, 33.51154]]], [[[-117.67047, 33.51596], [-117.6704, 33.51598], [-117.67034, 33.51594], [-117.67019, 33.51559], [-117.66988, 33.51509], [-117.66934, 33.51381], [-117.66928, 33.51362], [-117.66926, 33.51338], [-117.66929, 33.51257], [-117.66931, 33.51246], [-117.6697, 33.51163], [-117.66977, 33.51145], [-117.66986, 33.5115], [-117.66938, 33.51257], [-117.66937, 33.51337], [-117.66942, 33.51376], [-117.66954, 33.51391], [-117.66966, 33.51423], [-117.66982, 33.51436], [-117.66988, 33.51445], [-117.66997, 33.51473], [-117.67015, 33.5151], [-117.67045, 33.51586], [-117.67044, 33.51591], [-117.67047, 33.51596]]], [[[-117.67323, 33.5196], [-117.67265, 33.51936], [-117.67191, 33.51873], [-117.67159, 33.51827], [-117.67144, 33.51774], [-117.67149, 33.51717], [-117.67179, 33.51657], [-117.67323, 33.5196]]]]} | Open Access 1 | Rio Oso Park | 24384 | 1305 | San Juan Capistrano, City of 90 | City 2 | City Agency 2 | http://www.sanjuancapistrano.org/ | City 2 | 7.594 | Rio Oso Park | ||
7782 | 7782 | 7781 | {"type": "Polygon", "coordinates": [[[-117.63428, 33.50952], [-117.63298, 33.51047], [-117.63266, 33.51016], [-117.63268, 33.51012], [-117.63392, 33.50914], [-117.63415, 33.50893], [-117.63428, 33.50952]]]} | Open Access 1 | San Juan Creek Park | 24918 | 1305 | San Juan Capistrano, City of 90 | City 2 | City Agency 2 | http://www.sanjuancapistrano.org/ | City 2 | 2.229 | San Juan Creek Park | ||
5836 | 5836 | 5835 | {"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 | La Ronda Park | 20806 | 1305 | San Juan Capistrano, City of 90 | City 2 | City Agency 2 | http://www.sanjuancapistrano.org/ | City 2 | 0.428 | La Ronda Park | ||
3173 | 3173 | 3172 | {"type": "Polygon", "coordinates": [[[-117.64041, 33.50751], [-117.64012, 33.50838], [-117.63942, 33.50862], [-117.63923, 33.50871], [-117.6388, 33.50896], [-117.63849, 33.5092], [-117.63822, 33.50946], [-117.63803, 33.5097], [-117.63763, 33.51036], [-117.63744, 33.51055], [-117.63731, 33.51065], [-117.63716, 33.51072], [-117.6369, 33.51081], [-117.63651, 33.51088], [-117.63635, 33.51088], [-117.63638, 33.50923], [-117.64041, 33.50751]]]} | Open Access 1 | Cook Cordova Park | 17613 | 1305 | San Juan Capistrano, City of 90 | City 2 | City Agency 2 | http://www.sanjuancapistrano.org/ | City 2 | 11.654 | Cook Cordova Park | ||
4345 | 4345 | 4344 | {"type": "Polygon", "coordinates": [[[-117.64302, 33.503], [-117.64253, 33.50326], [-117.64249, 33.50326], [-117.64136, 33.5029], [-117.6415, 33.50259], [-117.64157, 33.50229], [-117.64232, 33.50243], [-117.64251, 33.5025], [-117.64268, 33.50259], [-117.64283, 33.50272], [-117.64301, 33.50296], [-117.64302, 33.503]]]} | Open Access 1 | Four Oaks Park | 19025 | 1305 | San Juan Capistrano, City of 90 | City 2 | City Agency 2 | http://www.sanjuancapistrano.org/ | City 2 | 2.498 | Four Oaks Park | ||
3145 | 3145 | 3144 | {"type": "Polygon", "coordinates": [[[-117.64468, 33.50695], [-117.64461, 33.50705], [-117.64459, 33.50716], [-117.6446, 33.50729], [-117.64455, 33.50734], [-117.64287, 33.50736], [-117.64293, 33.50732], [-117.6429, 33.50728], [-117.64318, 33.50706], [-117.6442, 33.50696], [-117.64468, 33.50695]]]} | Open Access 1 | Cook Del Campo Park | 17614 | 1305 | San Juan Capistrano, City of 90 | City 2 | City Agency 2 | http://www.sanjuancapistrano.org/ | City 2 | 1.42 | Cook Del Campo Park | ||
1598 | 1598 | 1597 | {"type": "Polygon", "coordinates": [[[-117.64807, 33.50789], [-117.64575, 33.50712], [-117.64569, 33.50698], [-117.64562, 33.50686], [-117.64549, 33.50672], [-117.64548, 33.50667], [-117.64553, 33.5066], [-117.64799, 33.50741], [-117.64799, 33.50758], [-117.64807, 33.50789]]]} | Open Access 1 | Arroyo Park | 15617 | 1305 | San Juan Capistrano, City of 90 | City 2 | City Agency 2 | http://www.sanjuancapistrano.org/ | City 2 | 2.77 | Arroyo Park | ||
3147 | 3147 | 3146 | {"type": "Polygon", "coordinates": [[[-117.65246, 33.50049], [-117.65088, 33.50136], [-117.64982, 33.50212], [-117.64982, 33.50214], [-117.64995, 33.50227], [-117.64972, 33.50244], [-117.64983, 33.50257], [-117.64975, 33.50264], [-117.64991, 33.50282], [-117.64966, 33.50297], [-117.64906, 33.50327], [-117.64898, 33.50328], [-117.6489, 33.50323], [-117.64845, 33.50252], [-117.64895, 33.50217], [-117.64895, 33.50212], [-117.64992, 33.5015], [-117.65114, 33.50078], [-117.65214, 33.50016], [-117.65246, 33.50049]]]} | Open Access 1 | Cook La Novia Park | 17616 | 1305 | San Juan Capistrano, City of 90 | City 2 | City Agency 2 | http://www.sanjuancapistrano.org/ | City 2 | 6.53 | Cook La Novia Park | ||
1401 | 1401 | 1400 | {"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 | Acu Canyon Park | 15252 | 1305 | San Juan Capistrano, City of 90 | City 2 | City Agency 2 | http://www.sanjuancapistrano.org/ | City 2 | 4.693 | Acu Canyon Park | ||
15554 | 15554 | 15553 | {"type": "Polygon", "coordinates": [[[-117.66179, 33.49999], [-117.66168, 33.50071], [-117.66109, 33.50064], [-117.66106, 33.50058], [-117.66064, 33.50046], [-117.6607, 33.5], [-117.66083, 33.50002], [-117.66099, 33.49984], [-117.66179, 33.49999]]]} | Open Access 1 | Historic Town Center (HTC) Park | 20008 | 1305 | San Juan Capistrano, City of 90 | City 2 | City Agency 2 | http://www.sanjuancapistrano.org/ | City 2 | 1.88 | Historic Town Ctr. (HTC) Park | ||
10831 | 10831 | 10830 | {"type": "Polygon", "coordinates": [[[-117.66247, 33.50051], [-117.66214, 33.5005], [-117.66213, 33.50023], [-117.66244, 33.50023], [-117.66247, 33.50051]]]} | Open Access 1 | Veterans Park | 27049 | 1305 | San Juan Capistrano, City of 90 | City 2 | City Agency 2 | http://www.sanjuancapistrano.org/ | City 2 | 0.22 | Veterans Park | ||
5639 | 5639 | 5638 | {"type": "Polygon", "coordinates": [[[-117.665, 33.51297], [-117.66309, 33.51296], [-117.66291, 33.51257], [-117.66274, 33.51247], [-117.66274, 33.51217], [-117.6643, 33.51204], [-117.66431, 33.51211], [-117.66434, 33.51218], [-117.66442, 33.51232], [-117.66452, 33.51244], [-117.66477, 33.51267], [-117.66491, 33.51283], [-117.665, 33.51297]]]} | Open Access 1 | Junipero Serra Park | 20531 | 1305 | San Juan Capistrano, City of 90 | City 2 | City Agency 2 | http://www.sanjuancapistrano.org/ | City 2 | 3.875 | Junipero Serra Park | ||
9996 | 9996 | 9995 | {"type": "Polygon", "coordinates": [[[-117.66547, 33.50769], [-117.66547, 33.50773], [-117.66539, 33.50776], [-117.66475, 33.50784], [-117.6643, 33.50699], [-117.66499, 33.50678], [-117.66547, 33.50769]]]} | Open Access 1 | Stonefield Park | 25886 | 1305 | San Juan Capistrano, City of 90 | City 2 | City Agency 2 | http://www.sanjuancapistrano.org/ | City 2 | 1.847 | Stonefield Park | ||
3580 | 3580 | 3579 | {"type": "Polygon", "coordinates": [[[-117.66577, 33.49081], [-117.6657, 33.49164], [-117.6653, 33.49163], [-117.66528, 33.4917], [-117.66449, 33.4917], [-117.66526, 33.49095], [-117.66531, 33.49081], [-117.66577, 33.49081]]]} | Open Access 1 | Descanso Park | 18109 | 1305 | San Juan Capistrano, City of 90 | City 2 | City Agency 2 | http://www.sanjuancapistrano.org/ | City 2 | 1.749 | Descanso Park | ||
6423 | 6423 | 6422 | {"type": "Polygon", "coordinates": [[[-117.66692, 33.5023], [-117.66691, 33.50233], [-117.66579, 33.50253], [-117.6657, 33.50208], [-117.66685, 33.50191], [-117.66692, 33.5023]]]} | Open Access 1 | Los Rios Park | 21531 | 1305 | San Juan Capistrano, City of 90 | City 2 | City Agency 2 | http://www.sanjuancapistrano.org/ | City 2 | 1.292 | Los Rios Park | ||
6450 | 6450 | 6449 | {"type": "Polygon", "coordinates": [[[-117.66694, 33.49896], [-117.66685, 33.49947], [-117.66679, 33.49946], [-117.66669, 33.4991], [-117.66666, 33.49892], [-117.66677, 33.4989], [-117.66694, 33.49896]]]} | Open Access 1 | Lucana Good Neighbors Park | 21573 | 1305 | San Juan Capistrano, City of 90 | City 2 | City Agency 2 | http://www.sanjuancapistrano.org/ | City 2 | 0.254 | Lucana Good Neighbors Park | ||
1555 | 1555 | 1554 | {"type": "Polygon", "coordinates": [[[-117.66702, 33.49792], [-117.66702, 33.49797], [-117.66682, 33.49806], [-117.66672, 33.49814], [-117.66665, 33.4983], [-117.66661, 33.49829], [-117.66673, 33.49802], [-117.6668, 33.49795], [-117.66702, 33.49792]]]} | Open Access 1 | Arce Park | 15572 | 1305 | San Juan Capistrano, City of 90 | City 2 | City Agency 2 | http://www.sanjuancapistrano.org/ | City 2 | 0.096 | Arce Park | ||
3481 | 3481 | 3480 | {"type": "Polygon", "coordinates": [[[-117.66753, 33.50437], [-117.66728, 33.50507], [-117.66726, 33.50507], [-117.66739, 33.50468], [-117.66739, 33.50455], [-117.66737, 33.50445], [-117.66707, 33.50373], [-117.66733, 33.50372], [-117.66727, 33.50388], [-117.66736, 33.5042], [-117.66748, 33.5042], [-117.66753, 33.50437]]]} | Open Access 1 | De la Vista Park | 17971 | 1305 | San Juan Capistrano, City of 90 | City 2 | City Agency 2 | http://www.sanjuancapistrano.org/ | City 2 | 0.36 | De la Vista Park | ||
14803 | 14803 | 14802 | {"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.66207, 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.65493, 33.48562], [-117.65395, 33.48563], [-117.65255, 33.48732], [-117.6512, 33.48729], [-117.65016, 33.48585], [-117.64932, 33.48578], [-117.64897, 33.48637], [-117.64757, 33.48676], [-117.64707, 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.49344], [-117.64584, 33.49259], [-117.64524, 33.4923], [-117.64453, 33.49192], [-117.64496, 33.49029], [-117.64494, 33.49028], [-117.64427, 33.49045], [-117.64391, 33.49015], [-117.64415, 33.48915], [-117.64345, 33.48911], [-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.64417, 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.63768, 33.49086], [-117.63989, 33.49156], [-117.6404, 33.49161], [-117.64151, 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.64247, 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.49704], [-117.63745, 33.49471], [-117.63819, 33.49263], [-117.63772, 33.49162], [-117.63481, 33.49114], [-117.63507, 33.49315], [-117.63359, 33.49455], [-117.63594, 33.4961], [-117.63616, 33.49716], [-117.63294, 33.49772], [-117.627, 33.49142], [-117.63103, 33.49067], [-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.63317, 33.48013], [-117.63759, 33.48111], [-117.63885, 33.48102], [-117.64235, 33.47809], [-117.64232, 33.47367], [-117.65552, 33.4736], [-117.65548, 33.47874], [-117.66069, 33.47842], [-117.66323, 33.47499], [-117.66298, 33.48135], [-117.66833, 33.48239]]]} | Open Access 1 | San Juan Capistrano City Open Space | http://www.sjcopenspacefoundation.org/explore.html | 11314 | 1305 | San Juan Capistrano, City of 90 | City 2 | City Agency 2 | http://www.sanjuancapistrano.org/ | City 2 | 1110.104 | San Juan Capistrano City OS |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);