superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
35 rows where MNG_AGENCY = 164 sorted by YR_EST
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7471 | 7471 | 7470 | {"type": "Polygon", "coordinates": [[[-117.42263, 34.10852], [-117.4205, 34.10853], [-117.4205, 34.10758], [-117.42163, 34.10758], [-117.42165, 34.10759], [-117.42263, 34.10759], [-117.42263, 34.10852]]]} | Open Access 1 | North Tamarind Park | 22862 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 5.047 | North Tamarind Park | ||
7479 | 7479 | 7478 | {"type": "Polygon", "coordinates": [[[-117.45142, 34.11234], [-117.45138, 34.11239], [-117.45135, 34.11245], [-117.45104, 34.11232], [-117.45073, 34.11232], [-117.45072, 34.11111], [-117.45108, 34.11111], [-117.45109, 34.11203], [-117.45136, 34.11204], [-117.45136, 34.11228], [-117.45142, 34.11234]]]} | Open Access 1 | Northgate Park | 22871 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1.366 | Northgate Park | ||
7581 | 7581 | 7580 | {"type": "Polygon", "coordinates": [[[-117.49797, 34.03513], [-117.49753, 34.03552], [-117.49748, 34.03551], [-117.497, 34.03593], [-117.49702, 34.03597], [-117.49689, 34.03608], [-117.49555, 34.03502], [-117.49576, 34.03499], [-117.49733, 34.03499], [-117.4976, 34.03502], [-117.49765, 34.03505], [-117.49769, 34.03511], [-117.49777, 34.03514], [-117.49786, 34.03514], [-117.49794, 34.0351], [-117.49797, 34.03513]]]} | Open Access 1 | Oak Park | 22998 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 3.382 | Oak Park | ||
8009 | 8009 | 8008 | {"type": "Polygon", "coordinates": [[[-117.45335, 34.14633], [-117.45335, 34.1474], [-117.45228, 34.1474], [-117.45197, 34.14791], [-117.45211, 34.14817], [-117.4518, 34.14826], [-117.45166, 34.14804], [-117.45156, 34.14793], [-117.45145, 34.14784], [-117.45121, 34.14771], [-117.45087, 34.14761], [-117.45086, 34.14754], [-117.45103, 34.14714], [-117.45168, 34.14733], [-117.45202, 34.14727], [-117.45251, 34.14637], [-117.45249, 34.1463], [-117.45219, 34.14619], [-117.45222, 34.14615], [-117.45273, 34.14633], [-117.45335, 34.14633]]]} | Open Access 1 | Patricia Marrujo Park | 23509 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 5.057 | Patricia Marrujo Park | ||
8010 | 8010 | 8009 | {"type": "Polygon", "coordinates": [[[-117.51325, 34.10711], [-117.51312, 34.10776], [-117.51302, 34.10801], [-117.51285, 34.10804], [-117.51257, 34.10776], [-117.51241, 34.10757], [-117.51227, 34.10733], [-117.51221, 34.10714], [-117.51228, 34.10705], [-117.51247, 34.10703], [-117.51316, 34.10703], [-117.51325, 34.10711]]]} | Open Access 1 | Patricia Murray Park | 23510 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1.803 | Patricia Murray Park | ||
8482 | 8482 | 8481 | {"type": "Polygon", "coordinates": [[[-117.45571, 34.13934], [-117.4557, 34.14315], [-117.45377, 34.14315], [-117.45377, 34.14305], [-117.4537, 34.14299], [-117.4537, 34.14225], [-117.45372, 34.14223], [-117.45372, 34.14186], [-117.45381, 34.14177], [-117.4538, 34.14168], [-117.4537, 34.1416], [-117.4537, 34.14095], [-117.45372, 34.14094], [-117.45372, 34.14057], [-117.45381, 34.14048], [-117.45381, 34.14038], [-117.45371, 34.1403], [-117.45375, 34.13931], [-117.45387, 34.1392], [-117.45406, 34.1392], [-117.4542, 34.13923], [-117.45443, 34.13923], [-117.45456, 34.1392], [-117.45477, 34.1392], [-117.45531, 34.13925], [-117.45539, 34.13934], [-117.45554, 34.13937], [-117.45566, 34.13933], [-117.45571, 34.13934]]]} | Open Access 1 | Ralph M Lewis Sports Complex | 24101 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 19.549 | Ralph M Lewis Sports Complex | ||
8952 | 8952 | 8951 | {"type": "MultiPolygon", "coordinates": [[[[-117.47469, 34.14318], [-117.47284, 34.14489], [-117.47226, 34.14447], [-117.47195, 34.14431], [-117.47176, 34.14425], [-117.47164, 34.14422], [-117.4716, 34.14414], [-117.47153, 34.14409], [-117.47091, 34.14402], [-117.47071, 34.14395], [-117.47041, 34.1438], [-117.47044, 34.14377], [-117.47042, 34.14369], [-117.47046, 34.14364], [-117.47055, 34.14358], [-117.47068, 34.14342], [-117.47072, 34.14332], [-117.47083, 34.14314], [-117.47093, 34.14294], [-117.47095, 34.14315], [-117.47469, 34.14318]]], [[[-117.47614, 34.14539], [-117.47552, 34.1459], [-117.47542, 34.14597], [-117.47535, 34.14597], [-117.47502, 34.14573], [-117.47492, 34.14561], [-117.47485, 34.14558], [-117.47476, 34.14557], [-117.47474, 34.14552], [-117.47442, 34.14528], [-117.47518, 34.14457], [-117.47555, 34.14484], [-117.47557, 34.14492], [-117.47561, 34.14497], [-117.47577, 34.14505], [-117.47614, 34.14532], [-117.47614, 34.14539]]]]} | Open Access 1 | Rosena Park | 24625 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 13.58 | Rosena Park | ||
9258 | 9258 | 9257 | {"type": "Polygon", "coordinates": [[[-117.48634, 34.15655], [-117.48601, 34.15655], [-117.48202, 34.15653], [-117.48215, 34.15623], [-117.48235, 34.15589], [-117.4826, 34.15556], [-117.48281, 34.15535], [-117.48322, 34.15502], [-117.48436, 34.15431], [-117.4846, 34.15433], [-117.48566, 34.15525], [-117.48586, 34.15545], [-117.48606, 34.15571], [-117.4862, 34.15598], [-117.4863, 34.15629], [-117.48634, 34.15655]]]} | Open Access 1 | San Sevaine Park | 24992 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 15.659 | San Sevaine Park | ||
9315 | 9315 | 9314 | {"type": "Polygon", "coordinates": [[[-117.43672, 34.09576], [-117.43589, 34.09576], [-117.43589, 34.09529], [-117.4367, 34.09527], [-117.43672, 34.09576]]]} | Open Access 1 | Santa Fe Park | 25085 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 0.998 | Santa Fe Park | ||
9529 | 9529 | 9528 | {"type": "Polygon", "coordinates": [[[-117.4444, 34.10153], [-117.44026, 34.10155], [-117.44026, 34.10118], [-117.4444, 34.10117], [-117.4444, 34.10153]]]} | Open Access 1 | Seville Park | 25329 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 3.789 | Seville Park | ||
9540 | 9540 | 9539 | {"type": "Polygon", "coordinates": [[[-117.49514, 34.04543], [-117.49513, 34.04629], [-117.49346, 34.04629], [-117.49346, 34.04568], [-117.49412, 34.04567], [-117.49412, 34.04426], [-117.49495, 34.04426], [-117.49502, 34.04431], [-117.49502, 34.04512], [-117.49499, 34.04526], [-117.49504, 34.04537], [-117.49514, 34.04543]]]} | Open Access 1 | Shadow Park | 25340 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 5.909 | Shadow Park | ||
9832 | 9832 | 9831 | {"type": "Polygon", "coordinates": [[[-117.48692, 34.03902], [-117.48673, 34.03936], [-117.48657, 34.03971], [-117.48646, 34.04008], [-117.48641, 34.04033], [-117.48639, 34.04057], [-117.48636, 34.0406], [-117.48633, 34.04061], [-117.48525, 34.04061], [-117.48483, 34.04066], [-117.48456, 34.04071], [-117.48429, 34.04079], [-117.48402, 34.0409], [-117.48376, 34.04104], [-117.48371, 34.04104], [-117.48365, 34.04099], [-117.4836, 34.0409], [-117.48358, 34.04081], [-117.4836, 34.04069], [-117.48417, 34.03928], [-117.48421, 34.03923], [-117.48434, 34.03916], [-117.48438, 34.0391], [-117.48436, 34.03901], [-117.48429, 34.03895], [-117.4842, 34.03894], [-117.48411, 34.03897], [-117.48406, 34.03903], [-117.48295, 34.04178], [-117.48232, 34.04284], [-117.48249, 34.0423], [-117.48259, 34.04174], [-117.48262, 34.04118], [-117.48258, 34.04061], [-117.48249, 34.04015], [-117.48235, 34.03969], [-117.4819, 34.03861], [-117.48182, 34.03835], [-117.4818, 34.03816], [-117.48159, 34.03807], [-117.48165, 34.03797], [-117.48318, 34.03856], [-117.48519, 34.03858], [-117.48562, 34.03861], [-117.48596, 34.03867], [-117.48629, 34.03876], [-117.48654, 34.03885], [-117.48692, 34.03902]]]} | Open Access 1 | Southridge Park | 25694 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 24.81 | Southridge Park | ||
10178 | 10178 | 10177 | {"type": "Polygon", "coordinates": [[[-117.42992, 34.05372], [-117.42991, 34.05376], [-117.42985, 34.0538], [-117.42973, 34.05386], [-117.42961, 34.05389], [-117.42948, 34.05391], [-117.42894, 34.05391], [-117.42898, 34.05387], [-117.42897, 34.05243], [-117.4289, 34.05238], [-117.42967, 34.05236], [-117.42973, 34.05241], [-117.42975, 34.05333], [-117.42981, 34.05354], [-117.42992, 34.05372]]]} | Open Access 1 | Sycamore Hills Park | 26130 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 3.082 | Sycamore Hills Park | ||
10805 | 10805 | 10804 | {"type": "Polygon", "coordinates": [[[-117.43128, 34.09033], [-117.43029, 34.09035], [-117.43029, 34.09206], [-117.42712, 34.09208], [-117.42712, 34.09035], [-117.42919, 34.09033], [-117.42919, 34.08853], [-117.43127, 34.08852], [-117.43128, 34.09033]]]} | Open Access 1 | Veteran's Park | 27018 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 23.487 | Veteran's Park | ||
13479 | 13479 | 13478 | {"type": "Polygon", "coordinates": [[[-117.43803, 34.10064], [-117.43802, 34.10099], [-117.43591, 34.10101], [-117.43591, 34.10067], [-117.43803, 34.10064]]]} | Open Access 1 | Fontana Memorial Rose Garden | 33615 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1.86 | Fontana Memorial Rose Garden |
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]);