units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
46 rows where MNG_AGENCY = 19 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, LABEL_NAME, YR_EST
UNIT_NAME 45 ✖
- Friendship Park 2
- Adams Park 1
- Angeles Park 1
- Birch Park 1
- Bomo Koral Park 1
- Cabrillo Park 1
- Campesino Park 1
- Carl Thornton Park 1
- Centennial Regional Park 1
- Chepa's Park 1
- Delhi Park 1
- Edna Park 1
- El Salvador Park 1
- Familias Corazones Verdes Park and Community Center 1
- Fisher Park 1
- French Park 1
- Garfield Exercise 1
- Griset Park 1
- Hector G. Godinez High School Field 1
- Heritage Park 1
- Jerome Park 1
- Lillie King Park 1
- Mabury Park 1
- Madison Park 1
- Monroe Elementary School Field 1
- Morrison Park 1
- Pacific Electric Park 1
- Portola Park 1
- Prentice Park 1
- River View Park 1
- Rosita Park 1
- Saddleback View Park 1
- Sandpointe Park 1
- Santa Ana Memorial Park 1
- Santa Anita Park 1
- Santiago Creek Park 1
- Sarah May Downie Herb Garden 1
- Sasscer Park 1
- Segerstrom Triangle 1
- Spurgeon Intermediate School Field 1
- Tennis Center 1
- Valley High School Field 1
- Willard Intermediate Park 1
- William Eldridge Park 1
- Windsor Park 1
DES_TP 4
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 46
MNG_AGENCY 1
- Santa Ana, City of · 46 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1031 | 1031 | 1030 | {"type": "Polygon", "coordinates": [[[-117.89901, 33.74171], [-117.89886, 33.74172], [-117.89885, 33.74179], [-117.89876, 33.74179], [-117.89875, 33.74163], [-117.89901, 33.74163], [-117.89901, 33.74171]]]} | Open Access 1 | 5649 | Friendship Park | 19122 | 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.074 | Friendship 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 | ||
14502 | 14502 | 14501 | {"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 | 47387 | 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 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 0.129 | Sarah May Downie Herb Garden | 0 | Local Park 2 | 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 | |
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 | |
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 | |
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 | |
3165 | 3165 | 3164 | {"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.87683, 33.77748], [-117.87759, 33.77824], [-117.87768, 33.77837], [-117.87774, 33.77841]]]} | Open Access 1 | 21955 | William Eldridge Park | 27543 | 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.2 | William Eldridge Park | 0 | Local Park 2 | 4 | |
2953 | 2953 | 2952 | {"type": "Polygon", "coordinates": [[[-117.88143, 33.70905], [-117.8815, 33.70906], [-117.88153, 33.70911], [-117.88152, 33.70962], [-117.88149, 33.70965], [-117.87994, 33.70965], [-117.88027, 33.70954], [-117.88143, 33.70905]]]} | Open Access 1 | 20418 | Segerstrom Triangle | 25286 | 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.234 | Segerstrom Triangle | 0 | Local Other or Unknown 14 | 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 | |
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 |
2459 | 2459 | 2458 | {"type": "Polygon", "coordinates": [[[-117.87752, 33.74703], [-117.87672, 33.74704], [-117.87667, 33.74702], [-117.87664, 33.74697], [-117.87662, 33.74636], [-117.87751, 33.74635], [-117.87752, 33.74703]]]} | Open Access 1 | 17385 | Angeles Park | 15494 | 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.531 | Angeles Park | 0 | Local Park 2 | 4 | |
1022 | 1022 | 1021 | {"type": "Polygon", "coordinates": [[[-117.89958, 33.76217], [-117.89942, 33.76258], [-117.89937, 33.76277], [-117.89924, 33.76363], [-117.89922, 33.76392], [-117.89854, 33.76383], [-117.89853, 33.76343], [-117.89856, 33.76335], [-117.89876, 33.76312], [-117.89885, 33.76298], [-117.89887, 33.76283], [-117.89891, 33.76271], [-117.89947, 33.76213], [-117.89958, 33.76217]]]} | Open Access 1 | 5639 | Edna Park | 18451 | 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.29 | Edna Park | 0 | 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 | |
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 | |
5941 | 5941 | 5940 | {"type": "Polygon", "coordinates": [[[-117.87624, 33.74536], [-117.87445, 33.74536], [-117.87444, 33.74444], [-117.8755, 33.74444], [-117.87551, 33.74454], [-117.87624, 33.74455], [-117.87624, 33.74536]]]} | Open Access 1 | 565 | Tennis Center | 26244 | 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 | 3.988 | Tennis Ctr. | 0 | Local Recreation Area 3 | 4 | |
203 | 203 | 202 | {"type": "Polygon", "coordinates": [[[-117.8759, 33.77057], [-117.8759, 33.77164], [-117.87387, 33.77142], [-117.871, 33.77154], [-117.87088, 33.77167], [-117.87063, 33.77133], [-117.87169, 33.77125], [-117.8717, 33.77141], [-117.87384, 33.77134], [-117.87386, 33.77119], [-117.87472, 33.7711], [-117.8756, 33.77074], [-117.8759, 33.77057]]]} | Open Access 1 | 544 | Fisher Park | 18919 | 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 | 3.993 | Fisher 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 | |
14241 | 14241 | 14240 | {"type": "Polygon", "coordinates": [[[-117.90149, 33.74169], [-117.90036, 33.7417], [-117.90037, 33.74], [-117.90142, 33.73999], [-117.90142, 33.7407], [-117.90149, 33.74074], [-117.90149, 33.74169]]]} | Restricted Access 2 | 44131 | Friendship Park | 19123 | 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 | 4.747 | Friendship Park | 0 | Local Park 2 | 4 | |
10799 | 10799 | 10798 | {"type": "Polygon", "coordinates": [[[-117.919, 33.74414], [-117.9189, 33.74413], [-117.9189, 33.74433], [-117.91792, 33.74433], [-117.9179, 33.74255], [-117.91896, 33.74256], [-117.919, 33.74414]]]} | Open Access 1 | 20417 | Santa Anita Park | 25035 | 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.783 | Santa Anita 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]);