units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
64 rows where AGNCY_LEV = 2 and MNG_AGENCY = 52 sorted by ACRES
This data as json, copyable, CSV (advanced)
DES_TP 8
- Local Park 32
- Local Recreation Area 6
- Local Conservation Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AG_TYP 1
- City Agency 44
MNG_AGENCY 1
- Newport Beach, City of · 44 ✖
ACCESS_TYP 1
- Open Access 44
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6651 | 6651 | 6650 | {"type": "Polygon", "coordinates": [[[-117.87837, 33.59536], [-117.87829, 33.59549], [-117.87823, 33.59548], [-117.87796, 33.59574], [-117.87786, 33.59557], [-117.87787, 33.59553], [-117.87785, 33.5955], [-117.87783, 33.59546], [-117.87777, 33.59543], [-117.87717, 33.5953], [-117.87709, 33.59527], [-117.87713, 33.59521], [-117.87725, 33.59517], [-117.87731, 33.59512], [-117.87751, 33.5951], [-117.87769, 33.59511], [-117.87775, 33.59511], [-117.87787, 33.59515], [-117.87794, 33.5952], [-117.87806, 33.59524], [-117.87806, 33.59527], [-117.87812, 33.59531], [-117.87813, 33.59538], [-117.87817, 33.59535], [-117.87831, 33.59533], [-117.87837, 33.59536]]]} | Open Access 1 | 4684 | Lookout Point | 21462 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 0.842 | Lookout Point | None 539 | |||
9191 | 9191 | 9190 | {"type": "Polygon", "coordinates": [[[-117.88213, 33.59545], [-117.88199, 33.59549], [-117.88212, 33.59589], [-117.88179, 33.59596], [-117.8815, 33.59507], [-117.88175, 33.59512], [-117.88176, 33.59507], [-117.8818, 33.59508], [-117.88182, 33.59513], [-117.88205, 33.5952], [-117.88213, 33.59545]]]} | Open Access 1 | 15256 | West Jetty View Park | 27365 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 0.855 | West Jetty View Park | 0 | Local Park 2 | 4 | |
7314 | 7314 | 7313 | {"type": "Polygon", "coordinates": [[[-117.93517, 33.61789], [-117.93509, 33.61794], [-117.93498, 33.61796], [-117.93491, 33.61795], [-117.93482, 33.61791], [-117.93424, 33.61727], [-117.93418, 33.61712], [-117.93418, 33.61708], [-117.93421, 33.61704], [-117.93424, 33.61702], [-117.93439, 33.61697], [-117.93516, 33.61784], [-117.93517, 33.61789]]]} | Open Access 1 | 6628 | 38th Street Park | 15197 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 0.922 | 38th Street Park | 0 | Local Park 2 | 4 | |
299 | 299 | 298 | {"type": "Polygon", "coordinates": [[[-117.89118, 33.62744], [-117.89109, 33.6275], [-117.89102, 33.62758], [-117.89077, 33.62794], [-117.89073, 33.62809], [-117.89075, 33.62825], [-117.8904, 33.62835], [-117.8906, 33.62779], [-117.89072, 33.62716], [-117.8909, 33.6271], [-117.89118, 33.62744]]]} | Open Access 1 | 803 | Galaxy View Park | 19171 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 0.948 | Galaxy View Park | 0 | Local Park 2 | 4 | |
1738 | 1738 | 1737 | {"type": "Polygon", "coordinates": [[[-117.84482, 33.61091], [-117.84442, 33.6108], [-117.84419, 33.6107], [-117.84396, 33.61058], [-117.8442, 33.61028], [-117.84435, 33.6102], [-117.84453, 33.61016], [-117.84464, 33.61024], [-117.84461, 33.61032], [-117.84464, 33.61041], [-117.8447, 33.61045], [-117.84478, 33.61046], [-117.84482, 33.61091]]]} | Open Access 1 | 12947 | Spyglass Hill Reservoir Park | 25757 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 0.949 | Spyglass Hill Reservoir Park | 0 | Local Park 2 | 4 | |
4848 | 4848 | 4847 | {"type": "Polygon", "coordinates": [[[-117.93748, 33.62363], [-117.93728, 33.62371], [-117.9371, 33.62381], [-117.93693, 33.62393], [-117.9367, 33.62416], [-117.93646, 33.62403], [-117.93612, 33.6238], [-117.93624, 33.6237], [-117.93632, 33.62366], [-117.93648, 33.6236], [-117.93665, 33.62356], [-117.93691, 33.62355], [-117.93729, 33.62357], [-117.93748, 33.62359], [-117.93748, 33.62363]]]} | Open Access 1 | 47424 | Sunset Ridge Park | 31140 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 1.077 | Sunset Ridge Park | 0 | Local Park 2 | 4 | |
9223 | 9223 | 9222 | {"type": "Polygon", "coordinates": [[[-117.93779, 33.62105], [-117.93766, 33.6216], [-117.93705, 33.62146], [-117.93662, 33.62098], [-117.93669, 33.62088], [-117.93779, 33.62105]]]} | Open Access 1 | 15344 | Channel Place Park | 17122 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 1.279 | Channel Place Park | 0 | Local Park 2 | 4 | |
8350 | 8350 | 8349 | {"type": "Polygon", "coordinates": [[[-117.84757, 33.61287], [-117.84709, 33.61286], [-117.84708, 33.61282], [-117.84703, 33.6128], [-117.8469, 33.61279], [-117.84658, 33.61231], [-117.84724, 33.61224], [-117.84742, 33.61225], [-117.84764, 33.6123], [-117.84767, 33.61232], [-117.84768, 33.61236], [-117.84757, 33.61287]]]} | Open Access 1 | 12935 | Spyglass Hill Park | 25756 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 1.299 | Spyglass Hill Park | 0 | Local Park 2 | 4 | |
4843 | 4843 | 4842 | {"type": "Polygon", "coordinates": [[[-117.8722, 33.59222], [-117.87161, 33.59281], [-117.87148, 33.59262], [-117.87135, 33.59248], [-117.87115, 33.59212], [-117.87162, 33.59175], [-117.8722, 33.59222]]]} | Open Access 1 | 2168 | Inspiration Point | 20222 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 1.448 | Inspiration Point | None 405 | |||
1745 | 1745 | 1744 | {"type": "Polygon", "coordinates": [[[-117.92184, 33.60768], [-117.92172, 33.60823], [-117.92104, 33.60813], [-117.92107, 33.60796], [-117.9206, 33.60789], [-117.92068, 33.60751], [-117.92184, 33.60768]]]} | Open Access 1 | 15014 | Veterans Memorial Park | 27029 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 1.457 | Veterans Memorial Park | 0 | Local Park 2 | 4 | |
6349 | 6349 | 6348 | {"type": "Polygon", "coordinates": [[[-117.84516, 33.60647], [-117.84512, 33.6066], [-117.84389, 33.6063], [-117.84397, 33.60618], [-117.84398, 33.60601], [-117.84411, 33.60589], [-117.84429, 33.60579], [-117.84447, 33.60574], [-117.84455, 33.60573], [-117.84463, 33.60576], [-117.84472, 33.60583], [-117.84493, 33.60624], [-117.84502, 33.60636], [-117.84516, 33.60647]]]} | Open Access 1 | 47501 | Harbor Watch Park | 31216 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://nbgis.newportbeachca.gov/gispub/recreation/facilities/default.aspx | Orange 3 | 1.529 | Harbor Watch Park | 0 | Local Park 2 | 4 |
12788 | 12788 | 12787 | {"type": "Polygon", "coordinates": [[[-117.87411, 33.65187], [-117.87364, 33.65234], [-117.87338, 33.65216], [-117.87333, 33.65216], [-117.87331, 33.65209], [-117.87326, 33.65206], [-117.87319, 33.65205], [-117.87312, 33.65208], [-117.87308, 33.65213], [-117.87307, 33.65218], [-117.87281, 33.65212], [-117.87253, 33.65194], [-117.87254, 33.65162], [-117.87276, 33.65157], [-117.87298, 33.65154], [-117.87336, 33.65157], [-117.8736, 33.65162], [-117.87377, 33.65168], [-117.87393, 33.65176], [-117.87411, 33.65187]]]} | Open Access 1 | 30219 | Bayview Park | 15902 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 1.991 | Bayview Park | 0 | Local Park 2 | 4 | |
126 | 126 | 125 | {"type": "Polygon", "coordinates": [[[-117.92158, 33.62047], [-117.92075, 33.62131], [-117.92059, 33.62077], [-117.92003, 33.62037], [-117.92034, 33.62006], [-117.92071, 33.62032], [-117.92089, 33.62015], [-117.92158, 33.62047]]]} | Open Access 1 | 318 | Ensign View Park | 18682 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 2.134 | Ensign View Park | 0 | Local Park 2 | 4 | |
6550 | 6550 | 6549 | {"type": "Polygon", "coordinates": [[[-117.8785, 33.60028], [-117.87806, 33.60073], [-117.87786, 33.60084], [-117.87749, 33.60122], [-117.87699, 33.60086], [-117.87695, 33.60081], [-117.87698, 33.60076], [-117.87721, 33.60066], [-117.87743, 33.60053], [-117.87756, 33.60038], [-117.8778, 33.60002], [-117.87786, 33.60001], [-117.87806, 33.60003], [-117.87847, 33.59996], [-117.87837, 33.60002], [-117.87827, 33.60018], [-117.8785, 33.60028]]]} | Open Access 1 | 3277 | Begonia Park | 15955 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 2.145 | Begonia Park | 0 | Local Park 2 | 4 | |
346 | 346 | 345 | {"type": "Polygon", "coordinates": [[[-117.83498, 33.59186], [-117.83357, 33.592], [-117.83332, 33.59203], [-117.83324, 33.59168], [-117.83368, 33.59129], [-117.8341, 33.59125], [-117.83427, 33.59117], [-117.83438, 33.59126], [-117.83475, 33.59141], [-117.83496, 33.59132], [-117.83498, 33.59186]]]} | Open Access 1 | 47415 | Los Trancos Canyon View Park (Upper) | 31132 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 2.623 | Los Trancos Canyon View Park (Upper) | None 35 | |||
9199 | 9199 | 9198 | {"type": "Polygon", "coordinates": [[[-117.89951, 33.62209], [-117.89873, 33.62219], [-117.89842, 33.62226], [-117.89814, 33.62236], [-117.89787, 33.6225], [-117.89762, 33.62265], [-117.89743, 33.62283], [-117.89748, 33.62305], [-117.89738, 33.62307], [-117.89734, 33.62311], [-117.89731, 33.62317], [-117.89733, 33.62325], [-117.89744, 33.62336], [-117.89711, 33.6238], [-117.89694, 33.62397], [-117.89678, 33.6239], [-117.89695, 33.62354], [-117.897, 33.62335], [-117.89703, 33.62301], [-117.89707, 33.62287], [-117.89714, 33.62275], [-117.8973, 33.62258], [-117.89795, 33.62213], [-117.89848, 33.6218], [-117.89863, 33.62174], [-117.89887, 33.62171], [-117.89904, 33.62172], [-117.89913, 33.62175], [-117.8992, 33.62181], [-117.89951, 33.62209]]]} | Open Access 1 | 15290 | Westcliff Park | 27387 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 2.984 | Westcliff Park | 0 | Local Park 2 | 4 | |
6519 | 6519 | 6518 | {"type": "MultiPolygon", "coordinates": [[[[-117.87277, 33.59691], [-117.87259, 33.59708], [-117.87225, 33.5969], [-117.87241, 33.59671], [-117.87277, 33.59691]]], [[[-117.87361, 33.59735], [-117.87343, 33.59752], [-117.87272, 33.59715], [-117.8729, 33.59698], [-117.8734, 33.59722], [-117.87361, 33.59735]]], [[[-117.87442, 33.59782], [-117.87425, 33.59799], [-117.87356, 33.59762], [-117.87372, 33.59744], [-117.87442, 33.59782]]], [[[-117.87765, 33.59996], [-117.87753, 33.60014], [-117.8752, 33.59854], [-117.87436, 33.59808], [-117.87453, 33.59788], [-117.87536, 33.59825], [-117.87553, 33.59837], [-117.87609, 33.59883], [-117.87627, 33.59901], [-117.87639, 33.59916], [-117.87674, 33.59945], [-117.8774, 33.59978], [-117.87764, 33.59992], [-117.87765, 33.59996]]]]} | Open Access 1 | 2757 | Bayside Park | 15897 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 3.525 | Bayside Park | 0 | Local Park 2 | 4 | |
6324 | 6324 | 6323 | {"type": "Polygon", "coordinates": [[[-117.84273, 33.60606], [-117.84233, 33.60601], [-117.84193, 33.60598], [-117.84011, 33.60593], [-117.83941, 33.60594], [-117.8394, 33.60578], [-117.83942, 33.60564], [-117.83954, 33.60542], [-117.83967, 33.60539], [-117.83994, 33.60557], [-117.84034, 33.60575], [-117.84049, 33.60576], [-117.84059, 33.60573], [-117.84067, 33.60568], [-117.84084, 33.60551], [-117.84114, 33.60531], [-117.8412, 33.60528], [-117.84132, 33.60527], [-117.84139, 33.60529], [-117.84152, 33.60538], [-117.8416, 33.60541], [-117.84212, 33.60542], [-117.84232, 33.6055], [-117.84238, 33.60558], [-117.84242, 33.60576], [-117.84263, 33.60582], [-117.84273, 33.60594], [-117.84273, 33.60606]]]} | Open Access 1 | 47410 | Canyon Watch Park | 31125 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 3.694 | Canyon Watch Park | 0 | Local Park 2 | 4 | |
5227 | 5227 | 5226 | {"type": "Polygon", "coordinates": [[[-117.86524, 33.60879], [-117.86483, 33.60907], [-117.86416, 33.6095], [-117.86411, 33.60951], [-117.86405, 33.60949], [-117.86372, 33.60917], [-117.86319, 33.60873], [-117.86378, 33.60813], [-117.86428, 33.60812], [-117.86524, 33.60879]]]} | Open Access 1 | 47423 | San Joaquin Hills Park and Lawn Bowling Center | 31139 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 4.07 | San Joaquin Hills Park and Lawn Bowling Ctr. | 0 | Local Recreation Area 3 | 4 | |
5510 | 5510 | 5509 | {"type": "Polygon", "coordinates": [[[-117.83634, 33.58461], [-117.83594, 33.58498], [-117.83559, 33.58538], [-117.8353, 33.58581], [-117.83507, 33.58626], [-117.83418, 33.58568], [-117.83411, 33.58547], [-117.83418, 33.58524], [-117.83466, 33.58521], [-117.83482, 33.58515], [-117.83517, 33.58471], [-117.83546, 33.58475], [-117.83576, 33.58467], [-117.83598, 33.58445], [-117.83609, 33.5844], [-117.83634, 33.58461]]]} | Open Access 1 | 47417 | Los Trancos Canyon View Park (Lower) | 31134 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 4.083 | Los Trancos Canyon View Park (Lower) | None 447 |
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]);