superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
46 rows where MNG_AGENCY = 19 sorted by PARK_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: PARK_NAME, LABEL_NAME
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
415 | 415 | 414 | {"type": "Polygon", "coordinates": [[[-117.89784, 33.71694], [-117.89618, 33.71696], [-117.89617, 33.71572], [-117.89619, 33.71566], [-117.89621, 33.71564], [-117.89626, 33.71563], [-117.89784, 33.71561], [-117.89784, 33.71694]]]} | Open Access 1 | Adams Park | 15263 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 5.603 | Adams Park | ||
1497 | 1497 | 1496 | {"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 | Angeles Park | 15494 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1.53 | Angeles Park | ||
2027 | 2027 | 2026 | {"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 | Birch Park | 16117 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 2.353 | Birch Park | ||
2134 | 2134 | 2133 | {"type": "Polygon", "coordinates": [[[-117.88043, 33.69733], [-117.8804, 33.69987], [-117.87871, 33.69989], [-117.87874, 33.69733], [-117.88043, 33.69733]]]} | Open Access 1 | Bomo Koral Park | 16251 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 10.96 | Bomo Koral Park | ||
2462 | 2462 | 2461 | {"type": "MultiPolygon", "coordinates": [[[[-117.84058, 33.75267], [-117.84054, 33.75272], [-117.84047, 33.75273], [-117.84044, 33.75252], [-117.83967, 33.75251], [-117.83965, 33.75274], [-117.83956, 33.75274], [-117.83954, 33.75244], [-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.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.75196], [-117.84109, 33.75139], [-117.84084, 33.75137], [-117.84081, 33.75115], [-117.84077, 33.751], [-117.84074, 33.75073], [-117.8415, 33.75072], [-117.84153, 33.75268]]]]} | Open Access 1 | Cabrillo Park | 16641 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 10.108 | Cabrillo Park | ||
2562 | 2562 | 2561 | {"type": "Polygon", "coordinates": [[[-117.91384, 33.75005], [-117.91354, 33.75006], [-117.91355, 33.75063], [-117.91213, 33.75064], [-117.91213, 33.74905], [-117.9131, 33.74904], [-117.91312, 33.74902], [-117.91336, 33.74902], [-117.91338, 33.74904], [-117.9135, 33.74905], [-117.91354, 33.74909], [-117.91355, 33.74937], [-117.91384, 33.74937], [-117.91384, 33.75005]]]} | Open Access 1 | Campesino Park | 16781 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 6.261 | Campesino Park | ||
2627 | 2627 | 2626 | {"type": "Polygon", "coordinates": [[[-117.8953, 33.70952], [-117.89325, 33.70956], [-117.89332, 33.71161], [-117.89116, 33.71166], [-117.89112, 33.7096], [-117.89113, 33.70755], [-117.89525, 33.70753], [-117.89529, 33.70756], [-117.8953, 33.7076], [-117.89532, 33.70804], [-117.8953, 33.70952]]]} | Open Access 1 | Carl Thornton Park | 16855 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 32.73 | Carl Thornton Park | ||
15077 | 15077 | 15076 | {"type": "Polygon", "coordinates": [[[-117.91604, 33.72383], [-117.91463, 33.72728], [-117.90716, 33.72732], [-117.90654, 33.72725], [-117.90642, 33.72722], [-117.90639, 33.72717], [-117.90639, 33.72714], [-117.90773, 33.72336], [-117.90838, 33.72335], [-117.90855, 33.72329], [-117.90867, 33.72327], [-117.91112, 33.72327], [-117.91113, 33.72289], [-117.91261, 33.72294], [-117.91261, 33.72353], [-117.91455, 33.72358], [-117.91457, 33.72379], [-117.91604, 33.72383]]]} | Open Access 1 | Centennial Regional Park | 17033 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 83.565 | Centennial RP | ||
2869 | 2869 | 2868 | {"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 | Chepa's Park | 17163 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 0.418 | Chepa's Park | ||
3547 | 3547 | 3546 | {"type": "Polygon", "coordinates": [[[-117.86187, 33.71588], [-117.86187, 33.71593], [-117.85943, 33.71591], [-117.85943, 33.71477], [-117.8604, 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.71586], [-117.86187, 33.71588]]]} | Open Access 1 | Delhi Park | 18066 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 6.664 | Delhi Park | ||
3827 | 3827 | 3826 | {"type": "Polygon", "coordinates": [[[-117.89958, 33.76217], [-117.89942, 33.76258], [-117.89938, 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 | Edna Park | 18451 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 2.29 | Edna Park | ||
3923 | 3923 | 3922 | {"type": "Polygon", "coordinates": [[[-117.89558, 33.75242], [-117.89529, 33.75244], [-117.89531, 33.75329], [-117.8936, 33.75333], [-117.89359, 33.75197], [-117.89397, 33.75194], [-117.89398, 33.75162], [-117.89558, 33.75161], [-117.89558, 33.75242]]]} | Open Access 1 | El Salvador Park | 18538 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 7.574 | El Salvador Park | ||
13987 | 13987 | 13986 | {"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 | 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 | 0.572 | Familias Corazones Verdes Park and Community Ctr. | ||
4241 | 4241 | 4240 | {"type": "Polygon", "coordinates": [[[-117.8759, 33.77057], [-117.8759, 33.77164], [-117.87386, 33.77142], [-117.871, 33.77154], [-117.87088, 33.77167], [-117.87063, 33.77133], [-117.87169, 33.77125], [-117.87171, 33.77141], [-117.87383, 33.77134], [-117.87386, 33.77119], [-117.87472, 33.7711], [-117.8756, 33.77074], [-117.8759, 33.77057]]]} | Open Access 1 | Fisher Park | 18919 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 3.997 | Fisher Park | ||
4415 | 4415 | 4414 | {"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 | French Park | 19107 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 0.159 | French Park | ||
4428 | 4428 | 4427 | {"type": "Polygon", "coordinates": [[[-117.89901, 33.74171], [-117.89887, 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 | Friendship Park | 19122 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 0.074 | Friendship Park | ||
4429 | 4429 | 4428 | {"type": "Polygon", "coordinates": [[[-117.90149, 33.74169], [-117.90036, 33.7417], [-117.90037, 33.74], [-117.90142, 33.73999], [-117.90142, 33.74069], [-117.90149, 33.74074], [-117.90149, 33.74169]]]} | Restricted Access 2 | Friendship Park | 19123 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 4.747 | Friendship Park | ||
14393 | 14393 | 14392 | {"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 | Garfield Exercise | https://www.santa-ana.org/parks/parks-location/garfield-exercise | 33565 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 0.096 | Garfield Exercise | |
4768 | 4768 | 4767 | {"type": "Polygon", "coordinates": [[[-117.90172, 33.69991], [-117.90004, 33.69991], [-117.90002, 33.69916], [-117.90004, 33.69834], [-117.9017, 33.69832], [-117.90172, 33.69991]]]} | Open Access 1 | Griset Park | 19521 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 6.744 | Griset Park | ||
13670 | 13670 | 13669 | {"type": "Polygon", "coordinates": [[[-117.91058, 33.72179], [-117.91046, 33.72177], [-117.91041, 33.72186], [-117.91048, 33.72189], [-117.91044, 33.72197], [-117.91045, 33.722], [-117.91032, 33.72232], [-117.91024, 33.72234], [-117.91017, 33.72238], [-117.91007, 33.72251], [-117.90998, 33.7225], [-117.90995, 33.72254], [-117.90986, 33.72251], [-117.90985, 33.72248], [-117.90977, 33.72248], [-117.9096, 33.72254], [-117.90953, 33.72264], [-117.90952, 33.72269], [-117.90941, 33.72267], [-117.90937, 33.72271], [-117.90927, 33.72271], [-117.90916, 33.72291], [-117.90914, 33.72327], [-117.90867, 33.72327], [-117.90855, 33.72329], [-117.90838, 33.72335], [-117.90792, 33.72336], [-117.90848, 33.72176], [-117.90871, 33.72179], [-117.90924, 33.72182], [-117.90951, 33.72176], [-117.90978, 33.72154], [-117.90996, 33.72132], [-117.91058, 33.72179]]]} | Restricted Access 2 | Hector G. Godinez High School Field | 31155 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 6.668 | Hector G. Godinez 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]);