superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
35 rows where MNG_AGENCY = 164 sorted by map
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
6823 | 6823 | 6822 | {"type": "MultiPolygon", "coordinates": [[[[-117.49927, 34.12037], [-117.49925, 34.12135], [-117.49702, 34.12135], [-117.49702, 34.12124], [-117.49696, 34.1212], [-117.49698, 34.12087], [-117.49702, 34.12069], [-117.49709, 34.1205], [-117.49726, 34.12017], [-117.49741, 34.11995], [-117.49745, 34.11993], [-117.4975, 34.11992], [-117.49755, 34.11993], [-117.49828, 34.12035], [-117.49927, 34.12037]]], [[[-117.49927, 34.11885], [-117.49927, 34.12022], [-117.49845, 34.12022], [-117.49829, 34.12019], [-117.49814, 34.12011], [-117.49784, 34.11983], [-117.49771, 34.11975], [-117.49767, 34.11972], [-117.49767, 34.11968], [-117.49768, 34.11964], [-117.49786, 34.11947], [-117.49812, 34.11926], [-117.49837, 34.1191], [-117.49856, 34.11901], [-117.49878, 34.11894], [-117.49902, 34.11888], [-117.49927, 34.11885]]], [[[-117.50056, 34.10927], [-117.50052, 34.1096], [-117.50045, 34.10989], [-117.50037, 34.11016], [-117.50019, 34.11063], [-117.50013, 34.1107], [-117.50007, 34.11071], [-117.50001, 34.1107], [-117.49995, 34.11065], [-117.49987, 34.11045], [-117.49977, 34.11031], [-117.49973, 34.11021], [-117.49958, 34.10969], [-117.49951, 34.10929], [-117.50056, 34.10927]]], [[[-117.50044, 34.10899], [-117.49959, 34.109], [-117.49958, 34.10873], [-117.50043, 34.10871], [-117.50044, 34.10899]]], [[[-117.50056, 34.11327], [-117.50059, 34.11358], [-117.5006, 34.11382], [-117.50058, 34.11413], [-117.50053, 34.11442], [-117.50044, 34.11472], [-117.50028, 34.11515], [-117.50022, 34.11521], [-117.50013, 34.11522], [-117.50004, 34.11517], [-117.49995, 34.11497], [-117.49986, 34.11484], [-117.49982, 34.11474], [-117.49969, 34.11426], [-117.49964, 34.11378], [-117.49965, 34.11342], [-117.49971, 34.113], [-117.49978, 34.11276], [-117.49995, 34.11231], [-117.5, 34.11225], [-117.50006, 34.11224], [-117.50012, 34.11224], [-117.50017, 34.11226], [-117.50021, 34.11231], [-117.50029, 34.11249], [-117.50039, 34.11264], [-117.50042, 34.11272], [-117.50056, 34.11327]]], [[[-117.50073, 34.11845], [-117.49969, 34.11845], [-117.49973, 34.11789], [-117.49982, 34.11742], [-117.49991, 34.11707], [-117.50003, 34.1167], [-117.50006, 34.11665], [-117.50011, 34.11661], [-117.5002, 34.11661], [-117.50027, 34.11665], [-117.50036, 34.11687], [-117.50047, 34.11707], [-117.50064, 34.1178], [-117.50073, 34.11845]]], [[[-117.50016, 34.11216], [-117.50015, 34.11218], [-117.50001, 34.11218], [-117.49999, 34.11217], [-117.50003, 34.11194], [-117.50006, 34.11168], [-117.50007, 34.11168], [-117.50011, 34.11193], [-117.50016, 34.11216]]], [[[-117.50015, 34.11079], [-117.50011, 34.11099], [-117.50009, 34.11126], [-117.49999, 34.11078], [-117.50001, 34.11077], [-117.50014, 34.11077], [-117.50015, 34.11079]]], [[[-117.50023, 34.11532], [-117.50019, 34.11552], [-117.50018, 34.11574], [-117.50008, 34.11529], [-117.5001, 34.11528], [-117.50022, 34.11528], [-117.50023, 34.11532]]], [[[-117.50024, 34.11653], [-117.5001, 34.11654], [-117.50009, 34.11653], [-117.50012, 34.11634], [-117.50014, 34.1161], [-117.50024, 34.11653]]]]} | Open Access 1 | McDermontt Sports Complex & McDermontt Park West | 22020 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 22.459 | McDermontt Sports Complex & McDermontt Park West | ||
2837 | 2837 | 2836 | {"type": "MultiPolygon", "coordinates": [[[[-117.50174, 34.0463], [-117.4978, 34.04629], [-117.49778, 34.04569], [-117.50116, 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 | Chaparral Park | 17128 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 8.621 | Chaparral Park | ||
4206 | 4206 | 4205 | {"type": "Polygon", "coordinates": [[[-117.41151, 34.1144], [-117.41136, 34.11441], [-117.41135, 34.11491], [-117.40981, 34.11491], [-117.40981, 34.11452], [-117.40978, 34.1145], [-117.40977, 34.11418], [-117.40982, 34.11413], [-117.41151, 34.11412], [-117.41151, 34.1144]]]} | Open Access 1 | Fernandez Park | 18877 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 3.208 | Fernandez Park | ||
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 | ||
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 | ||
4220 | 4220 | 4219 | {"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.04472], [-117.43106, 34.04439], [-117.43119, 34.04425], [-117.43134, 34.04412], [-117.43146, 34.04431]]]} | Open Access 1 | Fiesta Park | 18893 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1.288 | Fiesta Park | ||
2533 | 2533 | 2532 | {"type": "Polygon", "coordinates": [[[-117.43156, 34.13275], [-117.43156, 34.13439], [-117.43154, 34.13441], [-117.43154, 34.13378], [-117.43132, 34.13359], [-117.4311, 34.13358], [-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.43033, 34.1336], [-117.42996, 34.13361], [-117.42995, 34.13349], [-117.43025, 34.13348], [-117.43025, 34.13301], [-117.43027, 34.13289], [-117.43041, 34.13288], [-117.43041, 34.13265], [-117.43072, 34.13265], [-117.43069, 34.13305], [-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 | Cambria Park | 16748 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 2.188 | Cambria Park | ||
7001 | 7001 | 7000 | {"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 | Miller Park | 22242 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 5.606 | Miller 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 | ||
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 | ||
5436 | 5436 | 5435 | {"type": "Polygon", "coordinates": [[[-117.44432, 34.08121], [-117.44225, 34.08122], [-117.44224, 34.08207], [-117.44016, 34.08206], [-117.44015, 34.07941], [-117.44431, 34.0794], [-117.44432, 34.08121]]]} | Open Access 1 | Jack Bulik Park | 20301 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 23.538 | Jack Bulik 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 | ||
2015 | 2015 | 2014 | {"type": "Polygon", "coordinates": [[[-117.44445, 34.11025], [-117.44445, 34.11116], [-117.44234, 34.11117], [-117.44233, 34.11207], [-117.44029, 34.11208], [-117.44029, 34.11061], [-117.44108, 34.1106], [-117.44109, 34.11026], [-117.44445, 34.11025]]]} | Open Access 1 | Bill Martin Park | 16106 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 13.564 | Bill Martin 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 | ||
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 | ||
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 | ||
2704 | 2704 | 2703 | {"type": "Polygon", "coordinates": [[[-117.46226, 34.04585], [-117.46226, 34.04666], [-117.45697, 34.0467], [-117.45696, 34.04589], [-117.45786, 34.04588], [-117.45786, 34.04525], [-117.45828, 34.04525], [-117.45825, 34.04531], [-117.45826, 34.04538], [-117.45832, 34.04544], [-117.45839, 34.04546], [-117.45848, 34.04546], [-117.45853, 34.04543], [-117.45857, 34.04538], [-117.45858, 34.04533], [-117.45861, 34.04588], [-117.46226, 34.04585]]]} | Open Access 1 | Catawba Park | 16971 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 11.903 | Catawba Park | ||
650 | 650 | 649 | {"type": "Polygon", "coordinates": [[[-117.4623, 34.12153], [-117.46228, 34.12319], [-117.46027, 34.12319], [-117.46027, 34.12167], [-117.46059, 34.12166], [-117.4606, 34.12153], [-117.4623, 34.12153]]]} | Open Access 1 | Almeria Park | 15396 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 8.39 | Almeria 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]);