superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
42 rows where MNG_AGENCY = 116 sorted by map descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4685 | 4685 | 4684 | {"type": "Polygon", "coordinates": [[[-117.77627, 33.99237], [-117.77626, 33.99546], [-117.7734, 33.99403], [-117.77247, 33.99348], [-117.77189, 33.99319], [-117.77186, 33.99316], [-117.77184, 33.99312], [-117.77184, 33.99308], [-117.77189, 33.99299], [-117.77222, 33.99307], [-117.77236, 33.99274], [-117.77246, 33.99236], [-117.77255, 33.99237], [-117.77253, 33.99251], [-117.77274, 33.99275], [-117.77303, 33.9928], [-117.77333, 33.99273], [-117.77343, 33.99265], [-117.77355, 33.99243], [-117.77355, 33.99237], [-117.77627, 33.99237]]]} | Open Access 1 | Grand Avenue Park | 19421 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 20.291 | Grand Avenue Park | ||
10125 | 10125 | 10124 | {"type": "Polygon", "coordinates": [[[-117.77303, 33.98133], [-117.77295, 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.98186], [-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 | Sunset Park | 26051 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 3.552 | Sunset Park | ||
10288 | 10288 | 10287 | {"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 | Terrace Park | 26260 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 2.776 | Terrace Park | ||
11125 | 11125 | 11124 | {"type": "Polygon", "coordinates": [[[-117.769, 33.95871], [-117.76849, 33.9593], [-117.76833, 33.95902], [-117.76807, 33.95874], [-117.76809, 33.95869], [-117.76841, 33.95846], [-117.76883, 33.9581], [-117.76889, 33.95843], [-117.769, 33.95871]]]} | Open Access 1 | Western Hills Park | 27391 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 1.341 | Western Hills Park | ||
10983 | 10983 | 10982 | {"type": "Polygon", "coordinates": [[[-117.76767, 33.9939], [-117.76743, 33.99408], [-117.76716, 33.99425], [-117.7669, 33.99438], [-117.76663, 33.99449], [-117.76611, 33.99463], [-117.76546, 33.99473], [-117.76546, 33.99517], [-117.76528, 33.99517], [-117.76524, 33.9952], [-117.76523, 33.99524], [-117.76455, 33.99539], [-117.76419, 33.99539], [-117.76413, 33.99543], [-117.76406, 33.99538], [-117.76398, 33.99537], [-117.7639, 33.9954], [-117.76385, 33.99546], [-117.76359, 33.9954], [-117.76277, 33.99509], [-117.76247, 33.995], [-117.76227, 33.99495], [-117.76191, 33.99492], [-117.76213, 33.99468], [-117.76249, 33.99437], [-117.76256, 33.99442], [-117.76256, 33.99445], [-117.76284, 33.99455], [-117.76313, 33.99449], [-117.76325, 33.9945], [-117.76361, 33.99471], [-117.76376, 33.99465], [-117.76405, 33.99471], [-117.76415, 33.99464], [-117.76426, 33.99469], [-117.76433, 33.99468], [-117.7644, 33.99464], [-117.76481, 33.99466], [-117.76496, 33.99454], [-117.76537, 33.99452], [-117.7654, 33.99449], [-117.76548, 33.99451], [-117.76598, 33.99447], [-117.76606, 33.99438], [-117.76638, 33.99437], [-117.76648, 33.99434], [-117.7665, 33.9943], [-117.76657, 33.99429], [-117.76663, 33.99427], [-117.76668, 33.99419], [-117.76683, 33.99421], [-117.76748, 33.99384], [-117.7675, 33.99375], [-117.76753, 33.99375], [-117.76767, 33.9939]]]} | Open Access 1 | Walnut Creek Nature Park | 27227 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 6.916 | Walnut Creek Nature Park | ||
5111 | 5111 | 5110 | {"type": "Polygon", "coordinates": [[[-117.76483, 33.98946], [-117.76477, 33.98953], [-117.75971, 33.98958], [-117.75971, 33.98955], [-117.76013, 33.98947], [-117.76029, 33.98935], [-117.76042, 33.9892], [-117.76091, 33.98851], [-117.76098, 33.98814], [-117.76129, 33.98816], [-117.76126, 33.98842], [-117.76127, 33.98844], [-117.76241, 33.98854], [-117.76319, 33.98851], [-117.76359, 33.98865], [-117.76448, 33.98928], [-117.76483, 33.98946]]]} | Open Access 1 | Hidden Hills Park | 19907 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 9.876 | Hidden Hills Park | ||
10175 | 10175 | 10174 | {"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 | Sycamore Glenn Park | 26127 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 0.544 | Sycamore Glenn Park | ||
13613 | 13613 | 13612 | {"type": "Polygon", "coordinates": [[[-117.75856, 33.97696], [-117.75822, 33.97713], [-117.75791, 33.97734], [-117.75762, 33.97757], [-117.75707, 33.97812], [-117.75614, 33.97752], [-117.75601, 33.97746], [-117.75575, 33.97738], [-117.75581, 33.97713], [-117.75592, 33.97696], [-117.75585, 33.97641], [-117.75603, 33.97636], [-117.7561, 33.97613], [-117.75625, 33.97626], [-117.75642, 33.97649], [-117.75655, 33.97656], [-117.75676, 33.9766], [-117.75692, 33.97656], [-117.75704, 33.97634], [-117.75729, 33.9765], [-117.75747, 33.977], [-117.75778, 33.97704], [-117.75833, 33.97678], [-117.75856, 33.97696]]]} | Open Access 1 | Hope For The Hills Park | https://www.chinohills.org/index.aspx?NID=391 | 31075 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 6.36 | Hope For The Hills Park | |
1670 | 1670 | 1669 | {"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 | Autumn Hill Park | 15716 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 0.897 | Autumn Hill Park | ||
13628 | 13628 | 13627 | {"type": "Polygon", "coordinates": [[[-117.74983, 33.98171], [-117.74983, 33.98173], [-117.74917, 33.98211], [-117.7487, 33.98234], [-117.74822, 33.9825], [-117.74765, 33.98266], [-117.74706, 33.98292], [-117.74679, 33.98308], [-117.74634, 33.98341], [-117.74612, 33.98362], [-117.7458, 33.98398], [-117.74576, 33.984], [-117.74571, 33.98399], [-117.74532, 33.98373], [-117.74293, 33.9821], [-117.74291, 33.98201], [-117.74313, 33.98179], [-117.74377, 33.98124], [-117.74409, 33.98175], [-117.74983, 33.98171]]]} | Open Access 1 | Veterans Park | https://www.chinohills.org/index.aspx?NID=1083 | 31090 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 20.048 | Veterans Park | |
2543 | 2543 | 2542 | {"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 | Calle San Marcos Park | 16737 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 3.16 | Calle San Marcos Park | ||
3353 | 3353 | 3352 | {"type": "Polygon", "coordinates": [[[-117.74366, 33.98107], [-117.74298, 33.98167], [-117.74275, 33.98189], [-117.74264, 33.9819], [-117.7419, 33.9814], [-117.74165, 33.98124], [-117.74134, 33.98108], [-117.74131, 33.98104], [-117.74132, 33.981], [-117.74193, 33.98005], [-117.74207, 33.97987], [-117.74236, 33.97957], [-117.74262, 33.97933], [-117.74366, 33.98107]]]} | Open Access 1 | Crossroads Park | 17832 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 8.092 | Crossroads Park | ||
7820 | 7820 | 7819 | {"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 | Overlook Park | 23272 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 1.524 | Overlook Park | ||
7610 | 7610 | 7609 | {"type": "Polygon", "coordinates": [[[-117.73977, 33.97454], [-117.73937, 33.97455], [-117.73931, 33.97514], [-117.73921, 33.97521], [-117.73901, 33.97504], [-117.73916, 33.97464], [-117.73901, 33.97457], [-117.73895, 33.97468], [-117.73864, 33.97457], [-117.73834, 33.97457], [-117.73835, 33.97454], [-117.73834, 33.97453], [-117.7371, 33.97452], [-117.7376, 33.97422], [-117.73776, 33.97409], [-117.73788, 33.97392], [-117.73795, 33.97373], [-117.73798, 33.97354], [-117.73799, 33.97336], [-117.73797, 33.9733], [-117.73831, 33.97326], [-117.73836, 33.97322], [-117.73875, 33.97313], [-117.73909, 33.97302], [-117.73976, 33.97422], [-117.73977, 33.97454]]]} | Open Access 1 | Oakridge Park | 23036 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 6.606 | Oakridge Park | ||
7214 | 7214 | 7213 | {"type": "Polygon", "coordinates": [[[-117.73899, 33.97523], [-117.73905, 33.97525], [-117.73908, 33.97529], [-117.73917, 33.97544], [-117.73921, 33.97563], [-117.73918, 33.97581], [-117.73908, 33.97597], [-117.73833, 33.97686], [-117.73818, 33.97706], [-117.73787, 33.97771], [-117.73779, 33.97782], [-117.7377, 33.97792], [-117.73703, 33.97844], [-117.73688, 33.97859], [-117.73622, 33.97938], [-117.73603, 33.97957], [-117.73589, 33.97968], [-117.73566, 33.97983], [-117.73562, 33.97984], [-117.73557, 33.97982], [-117.73536, 33.97963], [-117.73592, 33.9791], [-117.73699, 33.9779], [-117.73724, 33.97732], [-117.73722, 33.97716], [-117.73752, 33.97715], [-117.7377, 33.97705], [-117.73783, 33.97691], [-117.738, 33.97663], [-117.73815, 33.97646], [-117.73829, 33.97607], [-117.73844, 33.97584], [-117.73845, 33.97578], [-117.73852, 33.97578], [-117.73858, 33.97575], [-117.73862, 33.97571], [-117.73865, 33.9756], [-117.73867, 33.97556], [-117.73894, 33.97526], [-117.73899, 33.97523]]]} | Open Access 1 | Morningside Park | 22490 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 6.804 | Morningside Park | ||
6809 | 6809 | 6808 | {"type": "Polygon", "coordinates": [[[-117.73754, 33.99481], [-117.73284, 33.99484], [-117.73283, 33.99323], [-117.73754, 33.9932], [-117.73754, 33.99481]]]} | Open Access 1 | McCoy Equestrian Center | 22011 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 19.201 | McCoy Equestrian Ctr. | ||
2906 | 2906 | 2905 | {"type": "Polygon", "coordinates": [[[-117.73754, 33.9932], [-117.73475, 33.99321], [-117.73428, 33.99286], [-117.73402, 33.99249], [-117.7338, 33.99203], [-117.73365, 33.99164], [-117.73331, 33.99059], [-117.73344, 33.99034], [-117.73335, 33.99008], [-117.73335, 33.98986], [-117.73369, 33.98984], [-117.73415, 33.98976], [-117.73751, 33.98975], [-117.73754, 33.9932]]]} | Open Access 1 | Chino Hills Community Park | 17208 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 33.185 | Chino Hills Community Park | ||
9729 | 9729 | 9728 | {"type": "Polygon", "coordinates": [[[-117.73737, 34.00859], [-117.73716, 34.0088], [-117.73654, 34.00931], [-117.7361, 34.00901], [-117.73614, 34.00868], [-117.73585, 34.00834], [-117.73537, 34.00773], [-117.7352, 34.00754], [-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 | Skyview Park | 25547 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 5.712 | Skyview Park | ||
10669 | 10669 | 10668 | {"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 | Vellano Park | 26844 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 3.978 | Vellano Park | ||
10609 | 10609 | 10608 | {"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.97059], [-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.73411, 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 | Valle Vista Park | 26772 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 3.296 | Valle Vista 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]);