units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
35 rows where MNG_AGENCY = 164 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: ACRES
DES_TP 4
MNG_AG_TYP 1
- City Agency 35
MNG_AGENCY 1
- Fontana, City of · 35 ✖
ACCESS_TYP 1
- Open Access 35
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5307 | 5307 | 5306 | {"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 | 5783 | Santa Fe Park | 25085 | 1109 | Fontana, City of 168 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | San Bernardino 22 | 0.999 | Santa Fe Park | 0 | Local Park 2 | 4 | |
12021 | 12021 | 12020 | {"type": "Polygon", "coordinates": [[[-117.43146, 34.04431], [-117.43139, 34.04433], [-117.43134, 34.04437], [-117.43113, 34.04479], [-117.43114, 34.04514], [-117.43066, 34.04517], [-117.43045, 34.04515], [-117.43032, 34.04512], [-117.43028, 34.04505], [-117.43055, 34.0446], [-117.43084, 34.04473], [-117.43106, 34.04439], [-117.43119, 34.04425], [-117.43134, 34.04412], [-117.43146, 34.04431]]]} | Open Access 1 | 24690 | Fiesta Park | 18893 | 1109 | Fontana, City of 168 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | San Bernardino 22 | 1.285 | Fiesta Park | 0 | Local Park 2 | 4 | |
6919 | 6919 | 6918 | {"type": "Polygon", "coordinates": [[[-117.50592, 34.12164], [-117.50587, 34.12179], [-117.50569, 34.12196], [-117.50544, 34.12227], [-117.50497, 34.12308], [-117.50498, 34.12305], [-117.50494, 34.12303], [-117.50493, 34.123], [-117.50504, 34.12272], [-117.50508, 34.12247], [-117.50509, 34.12167], [-117.50514, 34.12164], [-117.50592, 34.12164]]]} | Open Access 1 | 5884 | North Heritage Park | 22821 | 1109 | Fontana, City of 168 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | San Bernardino 22 | 1.343 | North Heritage Park | 0 | Local Park 2 | 4 | |
703 | 703 | 702 | {"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 | 3856 | Northgate Park | 22871 | 1109 | Fontana, City of 168 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | San Bernardino 22 | 1.363 | Northgate Park | 0 | Local Park 2 | 4 | |
12921 | 12921 | 12920 | {"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 | 30375 | Patricia Murray Park | 23510 | 1109 | Fontana, City of 168 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | San Bernardino 22 | 1.804 | Patricia Murray Park | 0 | Local Park 2 | 4 | |
6388 | 6388 | 6387 | {"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 | 48898 | Fontana Memorial Rose Garden | 33615 | 1109 | Fontana, City of 168 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | San Bernardino 22 | 1.861 | Fontana Memorial Rose Garden | 0 | Local Park 2 | 4 | |
682 | 682 | 681 | {"type": "Polygon", "coordinates": [[[-117.43156, 34.13275], [-117.43156, 34.13439], [-117.43154, 34.13441], [-117.43154, 34.13377], [-117.43132, 34.13359], [-117.4311, 34.13357], [-117.4311, 34.13381], [-117.43107, 34.13382], [-117.43099, 34.13359], [-117.43081, 34.13363], [-117.43069, 34.13381], [-117.43052, 34.13367], [-117.43032, 34.1336], [-117.42996, 34.13361], [-117.42995, 34.13349], [-117.43025, 34.13349], [-117.43025, 34.13301], [-117.43027, 34.13289], [-117.43041, 34.13289], [-117.43041, 34.13265], [-117.43072, 34.13265], [-117.43068, 34.13304], [-117.43089, 34.13324], [-117.43116, 34.13327], [-117.43141, 34.13321], [-117.43154, 34.1331], [-117.43154, 34.13273], [-117.43156, 34.13275]]]} | Open Access 1 | 3665 | Cambria Park | 16748 | 1109 | Fontana, City of 168 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | San Bernardino 22 | 2.176 | Cambria Park | 0 | Local Park 2 | 4 | |
429 | 429 | 428 | {"type": "Polygon", "coordinates": [[[-117.49266, 34.11629], [-117.4928, 34.1163], [-117.49293, 34.11635], [-117.49305, 34.11641], [-117.49313, 34.11648], [-117.49322, 34.11658], [-117.49327, 34.11668], [-117.4933, 34.11678], [-117.4933, 34.11692], [-117.49327, 34.11701], [-117.49322, 34.11712], [-117.49313, 34.11722], [-117.49304, 34.11729], [-117.49292, 34.11736], [-117.4928, 34.11739], [-117.49267, 34.11741], [-117.49253, 34.11741], [-117.4923, 34.11734], [-117.49218, 34.11728], [-117.49209, 34.1172], [-117.49201, 34.1171], [-117.49197, 34.11701], [-117.49195, 34.11691], [-117.49195, 34.11678], [-117.49197, 34.11669], [-117.49202, 34.11659], [-117.49209, 34.1165], [-117.49219, 34.11642], [-117.49238, 34.11632], [-117.4925, 34.11629], [-117.49266, 34.11629]]]} | Open Access 1 | 1717 | Heritage Circle Park | 19833 | 1109 | Fontana, City of 168 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | San Bernardino 22 | 3.008 | Heritage Circle Park | 0 | Local Park 2 | 4 | |
12338 | 12338 | 12337 | {"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 | 26030 | Sycamore Hills Park | 26130 | 1109 | Fontana, City of 168 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | San Bernardino 22 | 3.081 | Sycamore Hills Park | 0 | Local Park 2 | 4 | |
12917 | 12917 | 12916 | {"type": "Polygon", "coordinates": [[[-117.41151, 34.1144], [-117.41136, 34.11441], [-117.41135, 34.11491], [-117.40981, 34.11491], [-117.40981, 34.11451], [-117.40978, 34.1145], [-117.40977, 34.11418], [-117.40982, 34.11413], [-117.41151, 34.11412], [-117.41151, 34.1144]]]} | Open Access 1 | 30371 | Fernandez Park | 18877 | 1109 | Fontana, City of 168 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | San Bernardino 22 | 3.207 | Fernandez Park | 0 | Local Park 2 | 4 | |
1655 | 1655 | 1654 | {"type": "Polygon", "coordinates": [[[-117.49797, 34.03513], [-117.49753, 34.03552], [-117.49749, 34.0355], [-117.497, 34.03594], [-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 | 12527 | Oak Park | 22998 | 1109 | Fontana, City of 168 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | San Bernardino 22 | 3.382 | Oak Park | 0 | Local Park 2 | 4 | |
5025 | 5025 | 5024 | {"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 | 12337 | Seville Park | 25329 | 1109 | Fontana, City of 168 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | San Bernardino 22 | 3.795 | Seville Park | 0 | Local Park 2 | 4 | |
3911 | 3911 | 3910 | {"type": "Polygon", "coordinates": [[[-117.48339, 34.15874], [-117.48338, 34.16039], [-117.48238, 34.16038], [-117.48236, 34.16004], [-117.48232, 34.15979], [-117.48208, 34.15873], [-117.48339, 34.15874]]]} | Open Access 1 | 2021 | Hunters Ridge Park | 20156 | 1109 | Fontana, City of 168 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | San Bernardino 22 | 4.715 | Hunters Ridge Park | 0 | Local Park 2 | 4 | |
4944 | 4944 | 4943 | {"type": "Polygon", "coordinates": [[[-117.42263, 34.10852], [-117.4205, 34.10853], [-117.4205, 34.10758], [-117.42164, 34.10758], [-117.42165, 34.10759], [-117.42263, 34.10759], [-117.42263, 34.10852]]]} | Open Access 1 | 14657 | North Tamarind Park | 22862 | 1109 | Fontana, City of 168 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | San Bernardino 22 | 5.049 | North Tamarind Park | 0 | Local Park 2 | 4 | |
12920 | 12920 | 12919 | {"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.14728], [-117.45251, 34.14637], [-117.45249, 34.14631], [-117.45219, 34.14619], [-117.45222, 34.14615], [-117.45273, 34.14633], [-117.45335, 34.14633]]]} | Open Access 1 | 30374 | Patricia Marrujo Park | 23509 | 1109 | Fontana, City of 168 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | San Bernardino 22 | 5.049 | Patricia Marrujo Park | 0 | Local Park 2 | 4 | |
1292 | 1292 | 1291 | {"type": "Polygon", "coordinates": [[[-117.43451, 34.10096], [-117.43301, 34.10097], [-117.43284, 34.10095], [-117.43283, 34.09946], [-117.43395, 34.09946], [-117.43395, 34.1], [-117.43451, 34.1], [-117.43451, 34.10096]]]} | Open Access 1 | 5718 | Miller Park | 22242 | 1109 | Fontana, City of 168 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | San Bernardino 22 | 5.604 | Miller Park | 0 | Local Park 2 | 4 | |
8177 | 8177 | 8176 | {"type": "Polygon", "coordinates": [[[-117.49514, 34.04543], [-117.49513, 34.04629], [-117.49346, 34.04629], [-117.49346, 34.04568], [-117.49412, 34.04568], [-117.49412, 34.04426], [-117.49495, 34.04426], [-117.49502, 34.04431], [-117.49502, 34.04512], [-117.49499, 34.04527], [-117.49504, 34.04537], [-117.49514, 34.04543]]]} | Open Access 1 | 12381 | Shadow Park | 25340 | 1109 | Fontana, City of 168 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | San Bernardino 22 | 5.903 | Shadow Park | 0 | Local Park 2 | 4 | |
12916 | 12916 | 12915 | {"type": "Polygon", "coordinates": [[[-117.4623, 34.12153], [-117.46228, 34.12319], [-117.46027, 34.12319], [-117.46027, 34.12167], [-117.4606, 34.12166], [-117.4606, 34.12153], [-117.4623, 34.12153]]]} | Open Access 1 | 30370 | Almeria Park | 15396 | 1109 | Fontana, City of 168 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | San Bernardino 22 | 8.389 | Almeria Park | 0 | Local Park 2 | 4 | |
867 | 867 | 866 | {"type": "MultiPolygon", "coordinates": [[[[-117.50174, 34.0463], [-117.4978, 34.04629], [-117.49778, 34.04569], [-117.50117, 34.0457], [-117.50118, 34.04427], [-117.50167, 34.04427], [-117.50171, 34.0443], [-117.50174, 34.0463]]], [[[-117.50233, 34.0463], [-117.50194, 34.0463], [-117.50193, 34.0457], [-117.50232, 34.0457], [-117.50233, 34.0463]]]]} | Open Access 1 | 5606 | Chaparral Park | 17128 | 1109 | Fontana, City of 168 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | San Bernardino 22 | 8.61 | Chaparral Park | 0 | Local Park 2 | 4 | |
8276 | 8276 | 8275 | {"type": "Polygon", "coordinates": [[[-117.49063, 34.0335], [-117.49062, 34.03354], [-117.48958, 34.03402], [-117.48708, 34.0347], [-117.48662, 34.03406], [-117.48481, 34.03406], [-117.48481, 34.03351], [-117.49063, 34.0335]]]} | Open Access 1 | 12875 | Jurupa Hills Open Space | 20536 | 1109 | Fontana, City of 168 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | San Bernardino 22 | 9.652 | Jurupa Hills 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]);