units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
46 rows where MNG_AGENCY = 19 and MNG_AG_TYP = 2 sorted by map
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, LABEL_NAME, YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8457 | 8457 | 8456 | {"type": "MultiPolygon", "coordinates": [[[[-117.84047, 33.75273], [-117.84045, 33.75252], [-117.83966, 33.75251], [-117.83965, 33.75274], [-117.83956, 33.75274], [-117.83955, 33.75243], [-117.83902, 33.75243], [-117.839, 33.75072], [-117.84046, 33.75072], [-117.84048, 33.75096], [-117.84057, 33.75136], [-117.84058, 33.75267], [-117.84054, 33.75272], [-117.84047, 33.75273]]], [[[-117.8415, 33.75072], [-117.84153, 33.75268], [-117.84151, 33.75272], [-117.84148, 33.75273], [-117.84092, 33.75273], [-117.84088, 33.75271], [-117.84086, 33.75268], [-117.84086, 33.75198], [-117.8411, 33.75197], [-117.84109, 33.75138], [-117.84084, 33.75137], [-117.84081, 33.75115], [-117.84077, 33.751], [-117.84074, 33.75073], [-117.8415, 33.75072]]]]} | Open Access 1 | 13154 | Cabrillo Park | 16641 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 10.096 | Cabrillo Park | 0 | Local Park 2 | 4 | |
8050 | 8050 | 8049 | {"type": "MultiPolygon", "coordinates": [[[[-117.85718, 33.7767], [-117.85662, 33.77637], [-117.85616, 33.77614], [-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.85681, 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.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.77266], [-117.86515, 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.86133, 33.7725], [-117.86132, 33.77249], [-117.86132, 33.77236], [-117.86153, 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.77124], [-117.86587, 33.77114], [-117.86698, 33.77053], [-117.86723, 33.77048], [-117.86723, 33.77124]]]]} | Open Access 1 | 11776 | Santiago Creek Park | 25151 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 32.214 | Santiago Creek Park | 0 | Local Park 2 | 4 | |
626 | 626 | 625 | {"type": "MultiPolygon", "coordinates": [[[[-117.898, 33.73463], [-117.89798, 33.73688], [-117.896, 33.73688], [-117.896, 33.73629], [-117.89607, 33.73628], [-117.89607, 33.7346], [-117.89791, 33.7346], [-117.89792, 33.73463], [-117.898, 33.73463]]], [[[-117.89922, 33.73798], [-117.89813, 33.73798], [-117.89812, 33.7346], [-117.8992, 33.7346], [-117.89922, 33.73798]]]]} | Open Access 1 | 2440 | Jerome Park | 20399 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 20.542 | Jerome Park | 0 | Local Park 2 | 4 | |
1303 | 1303 | 1302 | {"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.93042, 33.75232], [-117.92911, 33.75234], [-117.93103, 33.75087], [-117.93104, 33.75232]]]]} | Open Access 1 | 10471 | Rosita Park | 24672 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 7.322 | Rosita Park | 0 | Local Park 2 | 4 | |
6690 | 6690 | 6689 | {"type": "Polygon", "coordinates": [[[-117.84375, 33.75726], [-117.84345, 33.75726], [-117.84345, 33.75709], [-117.84364, 33.75703], [-117.84335, 33.75636], [-117.84363, 33.75568], [-117.84344, 33.75561], [-117.84351, 33.75544], [-117.84344, 33.75528], [-117.84364, 33.75521], [-117.84337, 33.75456], [-117.84364, 33.75385], [-117.84235, 33.75346], [-117.84234, 33.75318], [-117.84172, 33.75318], [-117.84171, 33.75289], [-117.84374, 33.75288], [-117.84375, 33.75726]]]} | Open Access 1 | 4925 | Mabury Park | 21620 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 5.436 | Mabury Park | 0 | Local Park 2 | 4 | |
1416 | 1416 | 1415 | {"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 | 8907 | Prentice Park | 23983 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 18.524 | Prentice Park | 0 | Local Park 2 | 4 | |
1407 | 1407 | 1406 | {"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 | 8825 | Portola Park | 23912 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 8.958 | Portola Park | 0 | Local Park 2 | 4 | |
7730 | 7730 | 7729 | {"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.84642, 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 | 8086 | Saddleback View Park | 24777 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 0.943 | Saddleback View Park | 0 | Local Park 2 | 4 | |
725 | 725 | 724 | {"type": "Polygon", "coordinates": [[[-117.85796, 33.75435], [-117.85756, 33.75436], [-117.85755, 33.75394], [-117.85795, 33.75394], [-117.85796, 33.75435]]]} | Open Access 1 | 4606 | Chepa's Park | 17163 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 0.418 | Chepa's Park | 0 | Local Park 2 | 4 | |
5377 | 5377 | 5376 | {"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 | 5703 | Madison Park | 21659 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 6.057 | Madison Park | 0 | Local Park 2 | 4 | |
3979 | 3979 | 3978 | {"type": "Polygon", "coordinates": [[[-117.85936, 33.75016], [-117.85918, 33.75024], [-117.85907, 33.75004], [-117.85927, 33.75002], [-117.85936, 33.75016]]]} | Open Access 1 | 48845 | Garfield Exercise | 33565 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | https://www.santa-ana.org/parks/parks-location/garfield-exercise | Orange 3 | 0.096 | Garfield Exercise | None 344 | ||
2775 | 2775 | 2774 | {"type": "Polygon", "coordinates": [[[-117.86187, 33.71588], [-117.86187, 33.71593], [-117.85943, 33.71591], [-117.85943, 33.71477], [-117.86041, 33.71478], [-117.86042, 33.71469], [-117.86078, 33.71471], [-117.86106, 33.71478], [-117.86186, 33.7148], [-117.86187, 33.71531], [-117.8616, 33.71552], [-117.8614, 33.71553], [-117.86139, 33.71587], [-117.86187, 33.71588]]]} | Open Access 1 | 18530 | Delhi Park | 18066 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 6.656 | Delhi Park | 0 | Local Park 2 | 4 | |
16258 | 16258 | 16257 | {"type": "Polygon", "coordinates": [[[-117.86265, 33.7479], [-117.86231, 33.7479], [-117.86231, 33.74722], [-117.86264, 33.74722], [-117.86265, 33.7479]]]} | Open Access 1 | 45062 | Familias Corazones Verdes Park and Community Center | 32567 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 0.573 | Familias Corazones Verdes Park and Community Ctr. | 0 | Local Recreation Area 3 | 4 | |
5739 | 5739 | 5738 | {"type": "Polygon", "coordinates": [[[-117.86368, 33.71492], [-117.86366, 33.71591], [-117.86257, 33.71591], [-117.86257, 33.715], [-117.86248, 33.71499], [-117.86248, 33.71487], [-117.86359, 33.71488], [-117.86359, 33.71492], [-117.86368, 33.71492]]]} | Restricted Access 2 | 47437 | Monroe Elementary School Field | 31153 | 2308 | Santa Ana Unified School District 816 | Special District 4 | School District 14 | http://www.sausd.us/site/default.aspx?PageID=1 | Special District 4 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 2.918 | Monroe Elementary School Field | 0 | Local Recreation Area 3 | 4 | |
5992 | 5992 | 5991 | {"type": "Polygon", "coordinates": [[[-117.86446, 33.75326], [-117.86421, 33.75286], [-117.86445, 33.75275], [-117.86445, 33.75275], [-117.86446, 33.75326]]]} | Open Access 1 | 693 | French Park | 19107 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 0.159 | French Park | 0 | Local Park 2 | 4 | |
11120 | 11120 | 11119 | {"type": "Polygon", "coordinates": [[[-117.86456, 33.73363], [-117.86494, 33.7337], [-117.865, 33.73375], [-117.86499, 33.73389], [-117.86456, 33.7339], [-117.86456, 33.73403], [-117.86354, 33.73405], [-117.86354, 33.73356], [-117.86456, 33.73363]]]} | Open Access 1 | 48687 | Pacific Electric Park | 33426 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | https://www.santa-ana.org/parks/parks-location/pacific-electric | Orange 3 | 1.404 | Pacific Electric Park | 2019 | Local Park 2 | 4 |
774 | 774 | 773 | {"type": "Polygon", "coordinates": [[[-117.87227, 33.7464], [-117.87227, 33.74703], [-117.87226, 33.74705], [-117.87221, 33.74708], [-117.87092, 33.74709], [-117.87092, 33.7464], [-117.87227, 33.7464]]]} | Open Access 1 | 5035 | Birch Park | 16117 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 2.354 | Birch Park | 0 | Local Park 2 | 4 | |
8020 | 8020 | 8019 | {"type": "Polygon", "coordinates": [[[-117.87303, 33.69988], [-117.87183, 33.69988], [-117.87178, 33.69986], [-117.87174, 33.69983], [-117.87173, 33.69919], [-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.87146, 33.69767], [-117.87157, 33.69755], [-117.87197, 33.69718], [-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.69766], [-117.87241, 33.69781], [-117.87238, 33.69794], [-117.8721, 33.69822], [-117.87209, 33.69849], [-117.87245, 33.6985], [-117.87245, 33.6988], [-117.87256, 33.69899], [-117.87265, 33.69911], [-117.87271, 33.69952], [-117.87287, 33.69974], [-117.87303, 33.69988]]]} | Open Access 1 | 11353 | Sandpointe Park | 25022 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 6.658 | Sandpointe Park | 0 | Local Park 2 | 4 | |
8052 | 8052 | 8051 | {"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.74805], [-117.87262, 33.74804], [-117.87261, 33.748], [-117.87255, 33.748], [-117.87255, 33.74791], [-117.87428, 33.7479]]]} | Open Access 1 | 11810 | Sasscer Park | 25164 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 1.345 | Sasscer Park | 0 | Local Park 2 | 4 | |
14855 | 14855 | 14854 | {"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 | 45365 | Willard Intermediate Park | 27531 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 4.693 | Willard Intermediate 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]);