superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where MNG_AGENCY = 117 and PARK_URL = "http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/rancho-del-rey-park"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8513 | 8513 | 8512 | {"type": "Polygon", "coordinates": [[[-117.00274, 32.63678], [-117.00236, 32.63691], [-117.0021, 32.63708], [-117.00207, 32.63715], [-117.00196, 32.63715], [-117.0019, 32.63717], [-117.00187, 32.63722], [-117.00178, 32.63718], [-117.00147, 32.63726], [-117.00139, 32.63705], [-117.00171, 32.63697], [-117.00176, 32.6368], [-117.00183, 32.63678], [-117.00193, 32.63693], [-117.002, 32.63694], [-117.00263, 32.6366], [-117.00274, 32.63678]]]} | Open Access 1 | Rancho Del Rey Finger | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/rancho-del-rey-park | 24139 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 0.748 | Rancho Del Rey Finger | |
8514 | 8514 | 8513 | {"type": "Polygon", "coordinates": [[[-117.0056, 32.63624], [-117.00513, 32.63582], [-117.00502, 32.63576], [-117.0046, 32.63569], [-117.00423, 32.63587], [-117.00342, 32.63602], [-117.00316, 32.63618], [-117.00295, 32.63637], [-117.0028, 32.63655], [-117.00278, 32.63652], [-117.00292, 32.63635], [-117.00312, 32.63616], [-117.0034, 32.63599], [-117.00399, 32.63586], [-117.00393, 32.63562], [-117.00387, 32.63559], [-117.00389, 32.63551], [-117.00387, 32.63546], [-117.00383, 32.63543], [-117.00383, 32.63532], [-117.00342, 32.63483], [-117.0034, 32.63476], [-117.00332, 32.6347], [-117.00288, 32.6342], [-117.00288, 32.63414], [-117.00285, 32.63409], [-117.00265, 32.63385], [-117.0024, 32.63364], [-117.00258, 32.63353], [-117.0029, 32.63337], [-117.00317, 32.63336], [-117.00324, 32.63329], [-117.00326, 32.63322], [-117.00374, 32.63319], [-117.00374, 32.63389], [-117.00368, 32.63423], [-117.00397, 32.63498], [-117.00412, 32.63516], [-117.00417, 32.63515], [-117.0042, 32.6352], [-117.00418, 32.63523], [-117.00447, 32.63557], [-117.00525, 32.63536], [-117.0056, 32.63624]]]} | Open Access 1 | Rancho Del Rey South | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/rancho-del-rey-park | 24141 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 5.741 | Rancho Del Rey South | |
12802 | 12802 | 12801 | {"type": "Polygon", "coordinates": [[[-117.00515, 32.63973], [-117.00476, 32.63984], [-117.00456, 32.63937], [-117.00446, 32.63933], [-117.00448, 32.63928], [-117.00448, 32.63921], [-117.00445, 32.63916], [-117.00436, 32.63903], [-117.00429, 32.63883], [-117.00427, 32.63865], [-117.00424, 32.63859], [-117.00416, 32.63852], [-117.00424, 32.63842], [-117.00404, 32.63797], [-117.00397, 32.63795], [-117.00399, 32.63788], [-117.00396, 32.63782], [-117.00386, 32.63776], [-117.00377, 32.63777], [-117.00367, 32.63752], [-117.00298, 32.6374], [-117.00298, 32.63737], [-117.00399, 32.63755], [-117.00407, 32.63752], [-117.0044, 32.63734], [-117.00451, 32.63759], [-117.00455, 32.63761], [-117.00452, 32.63768], [-117.00452, 32.63776], [-117.00455, 32.63782], [-117.00465, 32.63793], [-117.00471, 32.63815], [-117.00471, 32.63828], [-117.00475, 32.63835], [-117.00482, 32.6384], [-117.00476, 32.63855], [-117.00494, 32.63895], [-117.00486, 32.63899], [-117.00483, 32.63904], [-117.00483, 32.63912], [-117.00486, 32.63917], [-117.00495, 32.6392], [-117.00515, 32.63973]]]} | Open Access 1 | Rancho del Rey Park | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/rancho-del-rey-park | 30012 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 3.408 | Rancho del Rey 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]);