units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
42 rows where MNG_AGENCY = 116 sorted by ACRES
This data as json, copyable, CSV (advanced)
DES_TP 2
MNG_AG_TYP 1
- City Agency 42
MNG_AGENCY 1
- Chino Hills, City of · 42 ✖
ACCESS_TYP 1
- Open Access 42
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5539 | 5539 | 5538 | {"type": "Polygon", "coordinates": [[[-117.73332, 33.98554], [-117.73276, 33.98552], [-117.73268, 33.98589], [-117.73256, 33.98623], [-117.73256, 33.98611], [-117.73266, 33.98575], [-117.73272, 33.98536], [-117.73276, 33.98529], [-117.73286, 33.98526], [-117.73325, 33.98527], [-117.7333, 33.98529], [-117.73332, 33.98533], [-117.73332, 33.98554]]]} | Open Access 1 | 24880 | Morning Field Park | 22489 | 1054 | Chino Hills, City of 119 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | San Bernardino 22 | 0.476 | Morning Field Park | 0 | Local Recreation Area 3 | 4 | |
5538 | 5538 | 5537 | {"type": "Polygon", "coordinates": [[[-117.70499, 33.97848], [-117.7048, 33.97847], [-117.70463, 33.97842], [-117.70433, 33.97828], [-117.70431, 33.97825], [-117.70431, 33.97822], [-117.70444, 33.97804], [-117.70458, 33.978], [-117.70475, 33.97799], [-117.70475, 33.97823], [-117.70499, 33.97823], [-117.70499, 33.97848]]]} | Open Access 1 | 24879 | Covington Park | 17725 | 1054 | Chino Hills, City of 119 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | San Bernardino 22 | 0.504 | Covington Park | 0 | Local Park 2 | 4 | |
12020 | 12020 | 12019 | {"type": "Polygon", "coordinates": [[[-117.76227, 33.99659], [-117.76179, 33.99686], [-117.76167, 33.99681], [-117.76166, 33.99669], [-117.76187, 33.9963], [-117.76198, 33.9962], [-117.76213, 33.99635], [-117.76227, 33.99659]]]} | Open Access 1 | 24689 | Sycamore Glenn Park | 26127 | 1054 | Chino Hills, City of 119 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | San Bernardino 22 | 0.544 | Sycamore Glenn Park | 0 | Local Park 2 | 4 | |
12088 | 12088 | 12087 | {"type": "Polygon", "coordinates": [[[-117.75749, 33.9912], [-117.75744, 33.99133], [-117.7574, 33.99136], [-117.757, 33.99131], [-117.75656, 33.99132], [-117.75622, 33.99138], [-117.75574, 33.99153], [-117.75569, 33.99151], [-117.75558, 33.99134], [-117.75574, 33.99128], [-117.75586, 33.99126], [-117.75615, 33.99124], [-117.7563, 33.99121], [-117.7567, 33.9911], [-117.75681, 33.99109], [-117.75704, 33.9911], [-117.75749, 33.9912]]]} | Open Access 1 | 24881 | Autumn Hill Park | 15716 | 1054 | Chino Hills, City of 119 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | San Bernardino 22 | 0.897 | Autumn Hill Park | 0 | Local Park 2 | 4 | |
12937 | 12937 | 12936 | {"type": "Polygon", "coordinates": [[[-117.769, 33.95871], [-117.76849, 33.9593], [-117.76833, 33.95902], [-117.76807, 33.95874], [-117.76809, 33.9587], [-117.76841, 33.95846], [-117.76883, 33.9581], [-117.76889, 33.95843], [-117.769, 33.95871]]]} | Open Access 1 | 30394 | Western Hills Park | 27391 | 1054 | Chino Hills, City of 119 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | San Bernardino 22 | 1.341 | Western Hills Park | 0 | Local Park 2 | 4 | |
12938 | 12938 | 12937 | {"type": "Polygon", "coordinates": [[[-117.74309, 33.95438], [-117.74277, 33.95454], [-117.74209, 33.95494], [-117.74179, 33.95457], [-117.74184, 33.95432], [-117.74243, 33.95406], [-117.74309, 33.95438]]]} | Open Access 1 | 30395 | Overlook Park | 23272 | 1054 | Chino Hills, City of 119 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | San Bernardino 22 | 1.525 | Overlook Park | 0 | Local Park 2 | 4 | |
6652 | 6652 | 6651 | {"type": "Polygon", "coordinates": [[[-117.77165, 33.99205], [-117.7716, 33.99231], [-117.77152, 33.99253], [-117.77058, 33.99229], [-117.77062, 33.99093], [-117.77073, 33.99093], [-117.77073, 33.9912], [-117.77096, 33.99122], [-117.77117, 33.99131], [-117.7714, 33.99153], [-117.77152, 33.9917], [-117.77165, 33.99205]]]} | Open Access 1 | 4770 | Terrace Park | 26260 | 1054 | Chino Hills, City of 119 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | San Bernardino 22 | 2.774 | Terrace Park | 0 | Local Park 2 | 4 | |
12019 | 12019 | 12018 | {"type": "Polygon", "coordinates": [[[-117.66569, 33.92686], [-117.66551, 33.92698], [-117.66524, 33.92709], [-117.66504, 33.92684], [-117.66483, 33.92646], [-117.66473, 33.92619], [-117.6646, 33.92562], [-117.66511, 33.92559], [-117.66555, 33.92561], [-117.66569, 33.92686]]]} | Open Access 1 | 24688 | Mystic Canyon Park | 22621 | 1054 | Chino Hills, City of 119 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | San Bernardino 22 | 2.888 | Mystic Canyon Park | 0 | Local Park 2 | 4 | |
6665 | 6665 | 6664 | {"type": "Polygon", "coordinates": [[[-117.74862, 34.00697], [-117.74857, 34.00768], [-117.74817, 34.00765], [-117.74777, 34.00764], [-117.74747, 34.00766], [-117.74687, 34.00773], [-117.74682, 34.00771], [-117.74681, 34.00769], [-117.74677, 34.00705], [-117.74681, 34.00701], [-117.74805, 34.00696], [-117.74862, 34.00697]]]} | Open Access 1 | 4761 | Calle San Marcos Park | 16737 | 1054 | Chino Hills, City of 119 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | San Bernardino 22 | 3.16 | Calle San Marcos Park | 0 | Local Park 2 | 4 | |
733 | 733 | 732 | {"type": "Polygon", "coordinates": [[[-117.71808, 33.97952], [-117.71777, 33.9796], [-117.71778, 33.9808], [-117.71766, 33.98078], [-117.7175, 33.98069], [-117.71737, 33.98058], [-117.71712, 33.98077], [-117.71706, 33.9807], [-117.71731, 33.98053], [-117.71721, 33.98041], [-117.71713, 33.98027], [-117.71707, 33.98012], [-117.71704, 33.97997], [-117.71703, 33.97946], [-117.7167, 33.97946], [-117.7167, 33.97898], [-117.71674, 33.97883], [-117.7168, 33.97872], [-117.71684, 33.9787], [-117.71688, 33.9787], [-117.7172, 33.97887], [-117.71703, 33.97909], [-117.71703, 33.97911], [-117.71767, 33.97946], [-117.7179, 33.97927], [-117.71801, 33.97938], [-117.71808, 33.97952]]]} | Open Access 1 | 4750 | Glenmeade Park | 19332 | 1054 | Chino Hills, City of 119 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | San Bernardino 22 | 3.203 | Glenmeade Park | 0 | Local Park 2 | 4 | |
732 | 732 | 731 | {"type": "Polygon", "coordinates": [[[-117.73548, 33.96926], [-117.73534, 33.96932], [-117.73492, 33.96967], [-117.73479, 33.96981], [-117.73471, 33.96993], [-117.73464, 33.97009], [-117.73461, 33.97027], [-117.73461, 33.97041], [-117.73464, 33.97058], [-117.73467, 33.97066], [-117.73473, 33.97071], [-117.73486, 33.97073], [-117.73496, 33.9707], [-117.73497, 33.97073], [-117.73465, 33.97086], [-117.7346, 33.97084], [-117.73376, 33.96937], [-117.7336, 33.96922], [-117.73359, 33.96916], [-117.73368, 33.969], [-117.73372, 33.96887], [-117.73375, 33.96888], [-117.7338, 33.96897], [-117.73412, 33.96907], [-117.73414, 33.96905], [-117.73439, 33.96914], [-117.73501, 33.96925], [-117.73512, 33.96925], [-117.73547, 33.96921], [-117.73548, 33.96926]]]} | Open Access 1 | 4749 | Valle Vista Park | 26772 | 1054 | Chino Hills, City of 119 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | San Bernardino 22 | 3.295 | Valle Vista Park | 0 | Local Park 2 | 4 | |
12934 | 12934 | 12933 | {"type": "Polygon", "coordinates": [[[-117.77303, 33.98133], [-117.77296, 33.98135], [-117.77263, 33.98135], [-117.77241, 33.98147], [-117.77233, 33.98167], [-117.77232, 33.98176], [-117.77234, 33.98191], [-117.77243, 33.98203], [-117.77184, 33.98246], [-117.77171, 33.98266], [-117.77168, 33.98247], [-117.77163, 33.9823], [-117.77146, 33.98199], [-117.77142, 33.98185], [-117.77107, 33.98191], [-117.77105, 33.98179], [-117.77105, 33.98166], [-117.77107, 33.98152], [-117.77113, 33.98139], [-117.77143, 33.98149], [-117.77169, 33.98123], [-117.77202, 33.98112], [-117.77276, 33.98093], [-117.77282, 33.98112], [-117.77303, 33.98133]]]} | Open Access 1 | 30390 | Sunset Park | 26051 | 1054 | Chino Hills, City of 119 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | San Bernardino 22 | 3.547 | Sunset Park | 0 | Local Park 2 | 4 | |
7981 | 7981 | 7980 | {"type": "Polygon", "coordinates": [[[-117.6994, 33.95798], [-117.69915, 33.9583], [-117.69841, 33.95846], [-117.69791, 33.95861], [-117.69732, 33.95884], [-117.69693, 33.95902], [-117.6967, 33.95914], [-117.69659, 33.95913], [-117.69593, 33.95844], [-117.69602, 33.95838], [-117.69659, 33.95869], [-117.697, 33.95866], [-117.69902, 33.95764], [-117.6994, 33.95798]]]} | Open Access 1 | 12881 | Alterra Park | 15426 | 1054 | Chino Hills, City of 119 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | San Bernardino 22 | 3.607 | Alterra Park | 0 | Local Park 2 | 4 | |
12940 | 12940 | 12939 | {"type": "Polygon", "coordinates": [[[-117.73615, 33.95613], [-117.73607, 33.95627], [-117.73603, 33.95641], [-117.73572, 33.95636], [-117.7356, 33.95646], [-117.73545, 33.9565], [-117.73511, 33.95648], [-117.73474, 33.9564], [-117.7347, 33.95625], [-117.73456, 33.95606], [-117.73433, 33.95579], [-117.73425, 33.95561], [-117.73427, 33.95539], [-117.73452, 33.95531], [-117.73473, 33.95536], [-117.73496, 33.95536], [-117.73504, 33.95525], [-117.73509, 33.95506], [-117.73522, 33.9552], [-117.73573, 33.95552], [-117.73572, 33.95594], [-117.73615, 33.95613]]]} | Open Access 1 | 30396 | Vellano Park | 26844 | 1054 | Chino Hills, City of 119 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | San Bernardino 22 | 3.975 | Vellano Park | 0 | Local Park 2 | 4 | |
6656 | 6656 | 6655 | {"type": "Polygon", "coordinates": [[[-117.69912, 33.96323], [-117.69891, 33.96329], [-117.69878, 33.96334], [-117.69861, 33.96343], [-117.69849, 33.96353], [-117.69849, 33.96346], [-117.69817, 33.96313], [-117.6976, 33.96276], [-117.69732, 33.96247], [-117.69665, 33.96167], [-117.69681, 33.96145], [-117.69703, 33.96155], [-117.69733, 33.96195], [-117.69753, 33.96216], [-117.69778, 33.96253], [-117.69788, 33.96252], [-117.69814, 33.96227], [-117.69843, 33.96221], [-117.69868, 33.9622], [-117.69877, 33.96216], [-117.69912, 33.96323]]]} | Open Access 1 | 4753 | Torrey Pines Park | 26474 | 1054 | Chino Hills, City of 119 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | San Bernardino 22 | 4.17 | Torrey Pines Park | 0 | Local Park 2 | 4 | |
6041 | 6041 | 6040 | {"type": "Polygon", "coordinates": [[[-117.68081, 33.9576], [-117.6807, 33.95757], [-117.678, 33.95652], [-117.67932, 33.9557], [-117.68081, 33.9576]]]} | Open Access 1 | 47364 | Chino Hills Skate Park | 31087 | 1054 | Chino Hills, City of 119 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | https://www.chinohills.org/index.aspx?NID=409 | San Bernardino 22 | 4.768 | Chino Hills Skate Park | 0 | Local Recreation Area 3 | 4 |
12017 | 12017 | 12016 | {"type": "Polygon", "coordinates": [[[-117.6729, 33.93758], [-117.67247, 33.93796], [-117.67251, 33.93806], [-117.67235, 33.93814], [-117.67224, 33.93826], [-117.67221, 33.93833], [-117.67219, 33.93842], [-117.67224, 33.93869], [-117.67198, 33.93876], [-117.67154, 33.93897], [-117.6712, 33.93829], [-117.67123, 33.93821], [-117.6712, 33.93815], [-117.67131, 33.93808], [-117.67119, 33.9377], [-117.67151, 33.93743], [-117.67151, 33.93741], [-117.67164, 33.93727], [-117.67164, 33.93725], [-117.67174, 33.93709], [-117.67173, 33.93707], [-117.6718, 33.93691], [-117.67179, 33.93689], [-117.67182, 33.93676], [-117.67195, 33.93684], [-117.6729, 33.93758]]]} | Open Access 1 | 24685 | Hunters Hill Park | 20154 | 1054 | Chino Hills, City of 119 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | San Bernardino 22 | 5.016 | Hunters Hill Park | 0 | Local Park 2 | 4 | |
6668 | 6668 | 6667 | {"type": "Polygon", "coordinates": [[[-117.72007, 33.97105], [-117.71973, 33.9712], [-117.71968, 33.97116], [-117.71962, 33.97113], [-117.71955, 33.97113], [-117.7195, 33.97115], [-117.71946, 33.97118], [-117.71942, 33.97123], [-117.71942, 33.97128], [-117.71944, 33.97133], [-117.71915, 33.97129], [-117.71904, 33.97177], [-117.71873, 33.9718], [-117.71847, 33.97187], [-117.71859, 33.97212], [-117.71843, 33.97218], [-117.71837, 33.97216], [-117.71819, 33.97192], [-117.718, 33.97159], [-117.71786, 33.97132], [-117.71812, 33.97124], [-117.71849, 33.97106], [-117.71883, 33.97083], [-117.71898, 33.9707], [-117.71912, 33.97057], [-117.71887, 33.97039], [-117.71896, 33.97031], [-117.71921, 33.97048], [-117.71971, 33.96999], [-117.71986, 33.9699], [-117.72003, 33.96987], [-117.72006, 33.96987], [-117.72007, 33.97105]]]} | Open Access 1 | 4777 | Cinnamon Park | 17260 | 1054 | Chino Hills, City of 119 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | San Bernardino 22 | 5.194 | Cinnamon Park | 0 | Local Park 2 | 4 | |
4989 | 4989 | 4988 | {"type": "Polygon", "coordinates": [[[-117.68132, 33.94556], [-117.68126, 33.9456], [-117.6808, 33.94553], [-117.68056, 33.94554], [-117.6803, 33.9456], [-117.67981, 33.94579], [-117.67971, 33.94576], [-117.67917, 33.94483], [-117.67898, 33.94444], [-117.67902, 33.94436], [-117.67908, 33.94435], [-117.67952, 33.94428], [-117.67991, 33.94421], [-117.68008, 33.94416], [-117.68014, 33.94417], [-117.68039, 33.94444], [-117.68107, 33.94501], [-117.68116, 33.9451], [-117.68123, 33.9452], [-117.68129, 33.94532], [-117.68132, 33.94544], [-117.68132, 33.94556]]]} | Open Access 1 | 47370 | Vila Borba Park | 31094 | 1054 | Chino Hills, City of 119 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | https://www.chinohills.org/index.aspx?NID=1182 | San Bernardino 22 | 5.676 | Vila Borba Park | 0 | Local Park 2 | 4 |
621 | 621 | 620 | {"type": "Polygon", "coordinates": [[[-117.73737, 34.00859], [-117.73716, 34.0088], [-117.73654, 34.00931], [-117.7361, 34.00901], [-117.73615, 34.00868], [-117.73585, 34.00834], [-117.73537, 34.00773], [-117.7352, 34.00753], [-117.73497, 34.00743], [-117.73453, 34.00683], [-117.73509, 34.00652], [-117.73578, 34.00736], [-117.73597, 34.00757], [-117.7363, 34.00786], [-117.73667, 34.0082], [-117.73737, 34.00859]]]} | Open Access 1 | 4760 | Skyview Park | 25547 | 1054 | Chino Hills, City of 119 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | San Bernardino 22 | 5.71 | Skyview Park | 0 | Local Park 2 | 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]);