superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
46 rows where MNG_AGENCY = 19
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6520 | 6520 | 6519 | {"type": "Polygon", "coordinates": [[[-117.85825, 33.72699], [-117.85823, 33.72841], [-117.85656, 33.72842], [-117.85658, 33.72705], [-117.8566, 33.727], [-117.85666, 33.72698], [-117.85825, 33.72699]]]} | Open Access 1 | Madison Park | 21659 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 6.057 | Madison Park | ||
7222 | 7222 | 7221 | {"type": "Polygon", "coordinates": [[[-117.88029, 33.77453], [-117.88029, 33.77595], [-117.87873, 33.77595], [-117.87869, 33.7759], [-117.87867, 33.77536], [-117.8788, 33.77504], [-117.8788, 33.77496], [-117.87918, 33.77495], [-117.87918, 33.77454], [-117.88029, 33.77453]]]} | Open Access 1 | Morrison Park | 22500 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 5.149 | Morrison Park | ||
8072 | 8072 | 8071 | {"type": "Polygon", "coordinates": [[[-117.88153, 33.70911], [-117.88152, 33.70962], [-117.88149, 33.70965], [-117.87994, 33.70965], [-117.88027, 33.70954], [-117.88143, 33.70905], [-117.8815, 33.70906], [-117.88153, 33.70911]]]} | Open Access 1 | Segerstrom Triangle | 25286 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1.234 | Segerstrom Triangle | ||
8329 | 8329 | 8328 | {"type": "Polygon", "coordinates": [[[-117.84454, 33.76473], [-117.84453, 33.76707], [-117.84317, 33.76707], [-117.84318, 33.76477], [-117.84329, 33.76474], [-117.84333, 33.7647], [-117.84334, 33.76464], [-117.84333, 33.76458], [-117.84329, 33.76454], [-117.84318, 33.7645], [-117.84318, 33.7643], [-117.84402, 33.76431], [-117.84403, 33.76453], [-117.84406, 33.76459], [-117.84411, 33.76465], [-117.84419, 33.7647], [-117.84429, 33.76473], [-117.84454, 33.76473]]]} | Open Access 1 | Portola Park | 23912 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 8.957 | Portola Park | ||
8394 | 8394 | 8393 | {"type": "Polygon", "coordinates": [[[-117.84375, 33.74542], [-117.84305, 33.74542], [-117.84218, 33.74442], [-117.84174, 33.74394], [-117.84116, 33.74342], [-117.84038, 33.74289], [-117.84036, 33.74214], [-117.84257, 33.74211], [-117.8437, 33.74211], [-117.84375, 33.74542]]]} | Open Access 1 | Prentice Park | 23983 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 18.523 | Prentice Park | ||
8767 | 8767 | 8766 | {"type": "Polygon", "coordinates": [[[-117.89696, 33.76234], [-117.89368, 33.76487], [-117.8934, 33.76471], [-117.89336, 33.76466], [-117.89451, 33.76336], [-117.89488, 33.76291], [-117.89616, 33.76156], [-117.89685, 33.76135], [-117.89631, 33.76207], [-117.8964, 33.76213], [-117.89696, 33.76234]]]} | Open Access 1 | River View Park | 24427 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 8.118 | River View Park | ||
8999 | 8999 | 8998 | {"type": "MultiPolygon", "coordinates": [[[[-117.93099, 33.75064], [-117.93019, 33.75124], [-117.92901, 33.75214], [-117.929, 33.75066], [-117.93099, 33.75064]]], [[[-117.93104, 33.75232], [-117.93104, 33.75232], [-117.92911, 33.75234], [-117.93103, 33.75087], [-117.93104, 33.75232]]]]} | Open Access 1 | Rosita Park | 24672 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 7.322 | Rosita Park | ||
9097 | 9097 | 9096 | {"type": "Polygon", "coordinates": [[[-117.88016, 33.7181], [-117.88011, 33.71974], [-117.87667, 33.71973], [-117.8767, 33.71808], [-117.88016, 33.7181]]]} | Open Access 1 | Santa Ana Memorial Park | 25031 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 14.458 | Santa Ana Memorial Park | ||
9111 | 9111 | 9110 | {"type": "Polygon", "coordinates": [[[-117.84737, 33.75203], [-117.84691, 33.75172], [-117.84623, 33.75118], [-117.8459, 33.75088], [-117.84631, 33.75087], [-117.84635, 33.75098], [-117.84641, 33.75106], [-117.84691, 33.75144], [-117.8472, 33.75164], [-117.84728, 33.75167], [-117.84736, 33.75167], [-117.84737, 33.75203]]]} | Open Access 1 | Saddleback View Park | 24777 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 0.943 | Saddleback View Park | ||
9271 | 9271 | 9270 | {"type": "Polygon", "coordinates": [[[-117.87303, 33.69988], [-117.87183, 33.69988], [-117.87178, 33.69986], [-117.87174, 33.69983], [-117.87173, 33.6992], [-117.87172, 33.69911], [-117.87167, 33.69891], [-117.87162, 33.69879], [-117.8714, 33.69846], [-117.87137, 33.69837], [-117.87135, 33.69826], [-117.87135, 33.6979], [-117.87141, 33.69773], [-117.87145, 33.69767], [-117.87157, 33.69755], [-117.87197, 33.69717], [-117.87207, 33.69704], [-117.87219, 33.69681], [-117.87233, 33.69683], [-117.87259, 33.69684], [-117.87259, 33.6971], [-117.87272, 33.69711], [-117.87271, 33.69717], [-117.87248, 33.6973], [-117.87239, 33.69748], [-117.87241, 33.69781], [-117.87238, 33.69794], [-117.8721, 33.69822], [-117.87209, 33.69848], [-117.87245, 33.6985], [-117.87245, 33.6988], [-117.87256, 33.69899], [-117.87265, 33.69911], [-117.87271, 33.69952], [-117.87287, 33.69973], [-117.87303, 33.69988]]]} | Open Access 1 | Sandpointe Park | 25022 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 6.661 | Sandpointe Park | ||
9281 | 9281 | 9280 | {"type": "Polygon", "coordinates": [[[-117.919, 33.74414], [-117.9189, 33.74414], [-117.9189, 33.74433], [-117.91792, 33.74433], [-117.9179, 33.74255], [-117.91896, 33.74256], [-117.919, 33.74414]]]} | Open Access 1 | Santa Anita Park | 25035 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 4.784 | Santa Anita Park | ||
9352 | 9352 | 9351 | {"type": "MultiPolygon", "coordinates": [[[[-117.85718, 33.7767], [-117.85662, 33.77637], [-117.85616, 33.77615], [-117.85612, 33.77617], [-117.85509, 33.77567], [-117.85575, 33.7752], [-117.8558, 33.77508], [-117.85588, 33.77434], [-117.85592, 33.77434], [-117.85596, 33.77447], [-117.85615, 33.77484], [-117.8568, 33.77603], [-117.85689, 33.77602], [-117.85718, 33.7767]]], [[[-117.86022, 33.77371], [-117.86021, 33.77429], [-117.86015, 33.77451], [-117.86007, 33.77468], [-117.85974, 33.7751], [-117.85959, 33.77533], [-117.85904, 33.77548], [-117.85847, 33.7757], [-117.858, 33.77591], [-117.85769, 33.77607], [-117.8573, 33.77632], [-117.8571, 33.77589], [-117.85659, 33.77495], [-117.8574, 33.77476], [-117.85751, 33.77464], [-117.85752, 33.77472], [-117.85753, 33.77473], [-117.85784, 33.77465], [-117.85831, 33.77449], [-117.86022, 33.77371]]], [[[-117.86723, 33.77124], [-117.86608, 33.77168], [-117.86541, 33.77234], [-117.86514, 33.77265], [-117.86516, 33.77267], [-117.86547, 33.77264], [-117.86543, 33.77279], [-117.86527, 33.7728], [-117.86445, 33.77299], [-117.86404, 33.77307], [-117.86263, 33.77317], [-117.86244, 33.77323], [-117.86198, 33.77336], [-117.86168, 33.7735], [-117.86117, 33.77378], [-117.86041, 33.77428], [-117.86042, 33.77402], [-117.86046, 33.77371], [-117.86046, 33.77324], [-117.86044, 33.77273], [-117.86114, 33.77263], [-117.86132, 33.77251], [-117.86132, 33.77236], [-117.86154, 33.77236], [-117.86191, 33.7721], [-117.86258, 33.7721], [-117.8626, 33.77224], [-117.86277, 33.77226], [-117.86413, 33.77208], [-117.86586, 33.77125], [-117.86587, 33.77114], [-117.86698, 33.77053], [-117.86723, 33.77048], [-117.86723, 33.77124]]]]} | Open Access 1 | Santiago Creek Park | 25151 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 32.219 | Santiago Creek Park | ||
9374 | 9374 | 9373 | {"type": "Polygon", "coordinates": [[[-117.87428, 33.7479], [-117.87383, 33.748], [-117.87347, 33.74814], [-117.87305, 33.7484], [-117.87271, 33.74867], [-117.87266, 33.74869], [-117.87262, 33.74866], [-117.87262, 33.74811], [-117.87264, 33.74806], [-117.87262, 33.74804], [-117.87261, 33.748], [-117.87255, 33.748], [-117.87255, 33.74791], [-117.87428, 33.7479]]]} | Open Access 1 | Sasscer Park | 25164 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1.345 | Sasscer Park | ||
10284 | 10284 | 10283 | {"type": "Polygon", "coordinates": [[[-117.87624, 33.74536], [-117.87445, 33.74536], [-117.87444, 33.74444], [-117.8755, 33.74444], [-117.87552, 33.74454], [-117.87624, 33.74455], [-117.87624, 33.74536]]]} | Open Access 1 | Tennis Center | 26244 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 3.987 | Tennis Ctr. | ||
11229 | 11229 | 11228 | {"type": "Polygon", "coordinates": [[[-117.87454, 33.75583], [-117.87451, 33.75779], [-117.87357, 33.75779], [-117.8736, 33.75583], [-117.87454, 33.75583]]]} | Open Access 1 | Willard Intermediate Park | 27531 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 4.693 | Willard Intermediate Park | ||
11247 | 11247 | 11246 | {"type": "Polygon", "coordinates": [[[-117.87774, 33.77841], [-117.87719, 33.77827], [-117.87698, 33.77808], [-117.87623, 33.77734], [-117.87668, 33.77726], [-117.87672, 33.77734], [-117.87684, 33.77748], [-117.87759, 33.77824], [-117.87768, 33.77837], [-117.87774, 33.77841]]]} | Open Access 1 | William Eldridge Park | 27543 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1.2 | William Eldridge Park | ||
11330 | 11330 | 11329 | {"type": "Polygon", "coordinates": [[[-117.91042, 33.73013], [-117.90986, 33.73213], [-117.90907, 33.73211], [-117.90907, 33.73154], [-117.90759, 33.73153], [-117.90716, 33.73008], [-117.91017, 33.73009], [-117.91038, 33.73011], [-117.91042, 33.73013]]]} | Open Access 1 | Windsor Park | 27638 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 11.804 | Windsor Park | ||
12478 | 12478 | 12477 | {"type": "Polygon", "coordinates": [[[-117.87596, 33.76955], [-117.87596, 33.76981], [-117.87593, 33.76984], [-117.87588, 33.76983], [-117.87566, 33.76963], [-117.87596, 33.76955]]]} | Open Access 1 | Sarah May Downie Herb Garden | 31112 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 0.128 | Sarah May Downie Herb Garden | ||
13302 | 13302 | 13301 | {"type": "Polygon", "coordinates": [[[-117.865, 33.73375], [-117.86499, 33.73389], [-117.86457, 33.7339], [-117.86456, 33.73403], [-117.86354, 33.73405], [-117.86354, 33.73356], [-117.86456, 33.73363], [-117.86494, 33.7337], [-117.865, 33.73375]]]} | Open Access 1 | Pacific Electric Park | https://www.santa-ana.org/parks/parks-location/pacific-electric | 33426 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1.405 | Pacific Electric Park | 2019 |
13667 | 13667 | 13666 | {"type": "Polygon", "coordinates": [[[-117.89836, 33.72183], [-117.8983, 33.72317], [-117.89798, 33.72315], [-117.89796, 33.72317], [-117.89797, 33.72354], [-117.89832, 33.72355], [-117.89835, 33.72428], [-117.8943, 33.72425], [-117.8943, 33.72338], [-117.89435, 33.72295], [-117.89452, 33.72237], [-117.89471, 33.72195], [-117.89481, 33.72179], [-117.89488, 33.72177], [-117.89525, 33.72176], [-117.89683, 33.72176], [-117.897, 33.72177], [-117.89752, 33.72184], [-117.89836, 33.72183]]]} | Restricted Access 2 | Valley High School Field | 31152 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 24.282 | Valley High School Field |
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]);