superunits_with_maps

Table actions

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)

ACCESS_TYP 2

MNG_AG_TYP 1

MNG_AGENCY 1

  • Santa Ana, City of · 46 ✖
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  
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  
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  
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  
5063 5063 5062 {"type": "Polygon", "coordinates": [[[-117.93514, 33.73981], [-117.93478, 33.74004], [-117.93455, 33.74022], [-117.93426, 33.74049], [-117.93398, 33.7408], [-117.93383, 33.74101], [-117.93354, 33.74148], [-117.93336, 33.74182], [-117.9331, 33.74245], [-117.93308, 33.74147], [-117.93261, 33.74146], [-117.93261, 33.73985], [-117.93299, 33.73995], [-117.93392, 33.73994], [-117.93401, 33.73984], [-117.93402, 33.73981], [-117.93514, 33.73981]]]} Open Access 1 Heritage Park   19854 1316 Santa Ana, City of 19 City 2 City Agency 2 http://www.santa-ana.org/parks/ City 2 6.8 Heritage Park  
5520 5520 5519 {"type": "MultiPolygon", "coordinates": [[[[-117.898, 33.73463], [-117.89798, 33.73688], [-117.896, 33.73688], [-117.896, 33.73629], [-117.89607, 33.73627], [-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 Jerome Park   20399 1316 Santa Ana, City of 19 City 2 City Agency 2 http://www.santa-ana.org/parks/ City 2 20.541 Jerome Park  
6173 6173 6172 {"type": "Polygon", "coordinates": [[[-117.87514, 33.70468], [-117.87508, 33.70483], [-117.87466, 33.70521], [-117.87465, 33.70537], [-117.87317, 33.70536], [-117.87318, 33.70508], [-117.87307, 33.70502], [-117.8731, 33.70494], [-117.87309, 33.7049], [-117.87324, 33.70484], [-117.87324, 33.7043], [-117.87311, 33.70424], [-117.87312, 33.70419], [-117.8731, 33.70413], [-117.87324, 33.70407], [-117.87325, 33.70355], [-117.87311, 33.70348], [-117.87312, 33.70343], [-117.87311, 33.70338], [-117.87325, 33.70332], [-117.87325, 33.70277], [-117.87454, 33.70277], [-117.87471, 33.7028], [-117.87468, 33.70416], [-117.87512, 33.70458], [-117.87514, 33.70468]]]} Open Access 1 Lillie King Park   21237 1316 Santa Ana, City of 19 City 2 City Agency 2 http://www.santa-ana.org/parks/ City 2 10.439 Lillie King Park  
6482 6482 6481 {"type": "Polygon", "coordinates": [[[-117.84375, 33.75726], [-117.84345, 33.75726], [-117.84345, 33.75709], [-117.84364, 33.75702], [-117.84335, 33.75636], [-117.84363, 33.75569], [-117.84344, 33.75561], [-117.84351, 33.75544], [-117.84344, 33.75528], [-117.84364, 33.7552], [-117.84337, 33.75456], [-117.84364, 33.75385], [-117.84235, 33.75346], [-117.84233, 33.75318], [-117.84172, 33.75318], [-117.84171, 33.75289], [-117.84374, 33.75288], [-117.84375, 33.75726]]]} Open Access 1 Mabury Park   21620 1316 Santa Ana, City of 19 City 2 City Agency 2 http://www.santa-ana.org/parks/ City 2 5.454 Mabury Park  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);