units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
32 rows where MNG_AGENCY = 114 sorted by LABEL_NAME
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 12
MNG_AGENCY 1
- Costa Mesa, City of · 12 ✖
DES_TP 1
- Local Park 12
ACCESS_TYP 1
- Open Access 12
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7295 | 7295 | 7294 | {"type": "Polygon", "coordinates": [[[-117.90125, 33.6842], [-117.90105, 33.6842], [-117.90105, 33.68448], [-117.90086, 33.68448], [-117.90086, 33.68421], [-117.90077, 33.68421], [-117.90076, 33.68247], [-117.90123, 33.68247], [-117.90125, 33.6842]]]} | Open Access 1 | 8122 | Paularino Park | 23534 | 1071 | Costa Mesa, City of 117 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | Orange 3 | 2.231 | Paularino Park | 0 | Local Park 2 | 4 | |
3555 | 3555 | 3554 | {"type": "Polygon", "coordinates": [[[-117.91502, 33.63059], [-117.91441, 33.6312], [-117.91347, 33.63056], [-117.9137, 33.63033], [-117.91372, 33.63034], [-117.9141, 33.62995], [-117.91502, 33.63059]]]} | Open Access 1 | 8521 | Pinkley Park | 23698 | 1071 | Costa Mesa, City of 117 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | Orange 3 | 2.465 | Pinkley Park | 0 | Local Park 2 | 4 | |
12786 | 12786 | 12785 | {"type": "Polygon", "coordinates": [[[-117.93128, 33.63885], [-117.9311, 33.63884], [-117.9311, 33.63844], [-117.93127, 33.63844], [-117.93128, 33.63885]]]} | Open Access 1 | 30217 | Shalimar Park | 25353 | 1071 | Costa Mesa, City of 117 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | Orange 3 | 0.179 | Shalimar Park | 0 | Local Park 2 | 4 | |
7860 | 7860 | 7859 | {"type": "Polygon", "coordinates": [[[-117.89382, 33.68704], [-117.89249, 33.68704], [-117.89243, 33.68687], [-117.89228, 33.68538], [-117.89228, 33.68471], [-117.89294, 33.68471], [-117.89295, 33.68543], [-117.89381, 33.68544], [-117.89381, 33.68569], [-117.89372, 33.68564], [-117.89352, 33.68565], [-117.89348, 33.68569], [-117.89347, 33.68584], [-117.89351, 33.6859], [-117.89355, 33.68592], [-117.89375, 33.68591], [-117.8938, 33.68586], [-117.89382, 33.68642], [-117.89373, 33.68637], [-117.89353, 33.68638], [-117.89348, 33.68644], [-117.89348, 33.68657], [-117.89352, 33.68664], [-117.89358, 33.68665], [-117.89374, 33.68664], [-117.89382, 33.68659], [-117.89382, 33.68704]]]} | Open Access 1 | 12529 | Shiffer Park | 25410 | 1071 | Costa Mesa, City of 117 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | Orange 3 | 6.721 | Shiffer Park | 0 | Local Park 2 | 4 | |
10766 | 10766 | 10765 | {"type": "Polygon", "coordinates": [[[-117.92531, 33.68344], [-117.92503, 33.68345], [-117.92498, 33.68337], [-117.92488, 33.68332], [-117.92475, 33.68332], [-117.92467, 33.68334], [-117.92447, 33.68333], [-117.92445, 33.68309], [-117.92444, 33.68194], [-117.92531, 33.68194], [-117.92531, 33.68344]]]} | Open Access 1 | 20079 | Smallwood Park | 25563 | 1071 | Costa Mesa, City of 117 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | Orange 3 | 3.142 | Smallwood Park | 0 | Local Park 2 | 4 | |
2994 | 2994 | 2993 | {"type": "Polygon", "coordinates": [[[-117.9364, 33.69109], [-117.93599, 33.69171], [-117.93587, 33.69157], [-117.93559, 33.69172], [-117.93551, 33.69166], [-117.93541, 33.69167], [-117.93579, 33.69145], [-117.93609, 33.69122], [-117.93629, 33.69102], [-117.93637, 33.69105], [-117.9364, 33.69109]]]} | Open Access 1 | 20095 | Suburbia Park | 25940 | 1071 | Costa Mesa, City of 117 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | Orange 3 | 0.515 | Suburbia Park | 0 | Local Park 2 | 4 | |
8927 | 8927 | 8926 | {"type": "Polygon", "coordinates": [[[-117.92995, 33.67064], [-117.92995, 33.67067], [-117.92989, 33.6707], [-117.92974, 33.67077], [-117.92949, 33.67085], [-117.92907, 33.67085], [-117.92906, 33.67093], [-117.92817, 33.67094], [-117.92814, 33.66884], [-117.92882, 33.66884], [-117.9289, 33.66887], [-117.92917, 33.66905], [-117.92942, 33.66912], [-117.92946, 33.6695], [-117.92956, 33.66991], [-117.92967, 33.67017], [-117.92978, 33.67038], [-117.92995, 33.67064]]]} | Open Access 1 | 14664 | Tanager Park | 26178 | 1071 | Costa Mesa, City of 117 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | Orange 3 | 7.313 | Tanager Park | 0 | Local Park 2 | 4 | |
8931 | 8931 | 8930 | {"type": "MultiPolygon", "coordinates": [[[[-117.89506, 33.66917], [-117.89502, 33.66945], [-117.89484, 33.66981], [-117.89453, 33.6701], [-117.89438, 33.67027], [-117.89424, 33.67046], [-117.89409, 33.67092], [-117.89407, 33.67114], [-117.89405, 33.67149], [-117.89236, 33.67151], [-117.89236, 33.67062], [-117.8927, 33.6706], [-117.89242, 33.66996], [-117.89278, 33.66984], [-117.89269, 33.66962], [-117.89279, 33.6695], [-117.89292, 33.66951], [-117.89292, 33.66924], [-117.89309, 33.66923], [-117.89309, 33.6691], [-117.89495, 33.66907], [-117.89506, 33.66917]]], [[[-117.8996, 33.67125], [-117.89837, 33.67127], [-117.89834, 33.67128], [-117.89831, 33.67133], [-117.89829, 33.67146], [-117.89432, 33.6715], [-117.89433, 33.67095], [-117.89438, 33.67073], [-117.89447, 33.67053], [-117.89464, 33.67028], [-117.8951, 33.66981], [-117.89518, 33.66969], [-117.89528, 33.66942], [-117.89532, 33.66918], [-117.89545, 33.66906], [-117.89958, 33.669], [-117.8996, 33.67125]]]]} | Open Access 1 | 14677 | Te Winkle Park | 26208 | 1071 | Costa Mesa, City of 117 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | Orange 3 | 40.98 | Te Winkle Park | 0 | Local Park 2 | 4 | |
12787 | 12787 | 12786 | {"type": "Polygon", "coordinates": [[[-117.94969, 33.6509], [-117.94959, 33.6521], [-117.94949, 33.65231], [-117.94736, 33.65233], [-117.94732, 33.65228], [-117.94726, 33.65226], [-117.94726, 33.65187], [-117.94811, 33.65141], [-117.94841, 33.65127], [-117.94899, 33.65107], [-117.94969, 33.6509]]]} | Open Access 1 | 30218 | Vista Park | 27181 | 1071 | Costa Mesa, City of 117 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | Orange 3 | 6.041 | Vista Park | 0 | Local Park 2 | 4 | |
10763 | 10763 | 10762 | {"type": "Polygon", "coordinates": [[[-117.9008, 33.69206], [-117.90077, 33.69207], [-117.90076, 33.69241], [-117.89863, 33.69242], [-117.89863, 33.69057], [-117.90077, 33.69059], [-117.9008, 33.69206]]]} | Open Access 1 | 20074 | Wakeham Park | 27212 | 1071 | Costa Mesa, City of 117 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | Orange 3 | 10.046 | Wakeham Park | 0 | Local Park 2 | 4 | |
10753 | 10753 | 10752 | {"type": "Polygon", "coordinates": [[[-117.91515, 33.65803], [-117.91463, 33.65803], [-117.91462, 33.6573], [-117.91415, 33.6573], [-117.91414, 33.65665], [-117.91411, 33.65664], [-117.9141, 33.65627], [-117.91513, 33.65627], [-117.91515, 33.65803]]]} | Open Access 1 | 20081 | Wilson Park | 27608 | 1071 | Costa Mesa, City of 117 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | Orange 3 | 3.637 | Wilson Park | 0 | Local Park 2 | 4 | |
10764 | 10764 | 10763 | {"type": "Polygon", "coordinates": [[[-117.9062, 33.69358], [-117.90623, 33.6938], [-117.90617, 33.69417], [-117.90608, 33.69433], [-117.90596, 33.69446], [-117.90579, 33.69458], [-117.90568, 33.69463], [-117.90541, 33.69469], [-117.9052, 33.69469], [-117.90518, 33.6944], [-117.90501, 33.69441], [-117.905, 33.69412], [-117.90509, 33.69404], [-117.90513, 33.69395], [-117.90511, 33.6932], [-117.90511, 33.69313], [-117.90515, 33.69306], [-117.9052, 33.69305], [-117.90535, 33.69307], [-117.90547, 33.69307], [-117.90548, 33.6934], [-117.90551, 33.69342], [-117.90568, 33.69342], [-117.90568, 33.69356], [-117.90571, 33.69358], [-117.9062, 33.69358]]]} | Open Access 1 | 20075 | Wimbledon Park | 27615 | 1071 | Costa Mesa, City of 117 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | Orange 3 | 3.324 | Wimbledon 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]);