superunits_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 | 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
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 | |
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 |
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]);