superunits_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

32 rows where ACCESS_TYP = 1 and MNG_AGENCY = 242

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Redondo Beach, City of · 32 ✖

ACCESS_TYP 1

  • Open Access · 32 ✖
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
1154 1154 1153 {"type": "Polygon", "coordinates": [[[-118.38008, 33.86755], [-118.37992, 33.86755], [-118.37992, 33.86714], [-118.38008, 33.86714], [-118.38008, 33.86755]]]} Open Access 1 Beverly Parkette   16058 1270 Redondo Beach, City of 242 City 2 City Agency 2 http://www.redondo.org City 2 0.168 Beverly Parkette  
1177 1177 1176 {"type": "Polygon", "coordinates": [[[-118.37269, 33.88366], [-118.37002, 33.88368], [-118.37002, 33.88279], [-118.37268, 33.88279], [-118.37268, 33.88285], [-118.37269, 33.88366]]]} Open Access 1 Anderson Park   15477 1270 Redondo Beach, City of 242 City 2 City Agency 2 http://www.redondo.org City 2 5.938 Anderson Park  
1492 1492 1491 {"type": "Polygon", "coordinates": [[[-118.38047, 33.86996], [-118.38045, 33.87099], [-118.38003, 33.87098], [-118.38003, 33.87073], [-118.37996, 33.87071], [-118.37997, 33.87005], [-118.38047, 33.86996]]]} Open Access 1 Andrews Park   15486 1270 Redondo Beach, City of 242 City 2 City Agency 2 http://www.redondo.org City 2 1.185 Andrews Park  
1696 1696 1695 {"type": "Polygon", "coordinates": [[[-118.3785, 33.89082], [-118.3774, 33.89083], [-118.3774, 33.89044], [-118.37725, 33.89043], [-118.37724, 33.88957], [-118.37638, 33.89028], [-118.37594, 33.88991], [-118.3769, 33.88911], [-118.3769, 33.88752], [-118.37843, 33.88752], [-118.37849, 33.88757], [-118.3785, 33.89082]]]} Open Access 1 Aviation Park   15730 1270 Redondo Beach, City of 242 City 2 City Agency 2 http://www.redondo.org City 2 13.62 Aviation Park  
3399 3399 3398 {"type": "Polygon", "coordinates": [[[-118.39221, 33.84318], [-118.39195, 33.84326], [-118.39175, 33.84296], [-118.39143, 33.84308], [-118.39148, 33.84336], [-118.39128, 33.84303], [-118.39096, 33.84321], [-118.39075, 33.84337], [-118.39059, 33.84351], [-118.39056, 33.84359], [-118.39061, 33.84369], [-118.39061, 33.84375], [-118.39059, 33.8438], [-118.39043, 33.84398], [-118.39024, 33.84413], [-118.38996, 33.84388], [-118.38956, 33.84345], [-118.38975, 33.84342], [-118.39001, 33.84333], [-118.3903, 33.8432], [-118.39059, 33.84303], [-118.39088, 33.8428], [-118.39107, 33.84259], [-118.39119, 33.84237], [-118.39121, 33.84231], [-118.39121, 33.84223], [-118.39135, 33.84218], [-118.39163, 33.84271], [-118.39191, 33.84262], [-118.39193, 33.84266], [-118.39197, 33.84265], [-118.39221, 33.84318]]]} Open Access 1 Czuleger Park   17888 1270 Redondo Beach, City of 242 City 2 City Agency 2 http://www.redondo.org City 2 3.671 Czuleger Park  
3406 3406 3405 {"type": "Polygon", "coordinates": [[[-118.36599, 33.88112], [-118.3656, 33.8815], [-118.3656, 33.88015], [-118.36599, 33.88015], [-118.36599, 33.88112]]]} Open Access 1 Dale Page Park   17894 1270 Redondo Beach, City of 242 City 2 City Agency 2 http://www.redondo.org City 2 1.163 Dale Page Park  
3647 3647 3646 {"type": "Polygon", "coordinates": [[[-118.37876, 33.85826], [-118.37549, 33.85827], [-118.37531, 33.85739], [-118.37483, 33.85727], [-118.37483, 33.85698], [-118.3749, 33.85669], [-118.37504, 33.8564], [-118.37523, 33.85615], [-118.37538, 33.85602], [-118.37564, 33.85587], [-118.37587, 33.85577], [-118.37813, 33.85513], [-118.37876, 33.85826]]]} Open Access 1 Dominguez Park   18197 1270 Redondo Beach, City of 242 City 2 City Agency 2 http://www.redondo.org City 2 22.865 Dominguez Park  
4037 4037 4036 {"type": "Polygon", "coordinates": [[[-118.38316, 33.85905], [-118.38291, 33.85906], [-118.38291, 33.85878], [-118.38315, 33.85878], [-118.38316, 33.85905]]]} Open Access 1 Ensenada Parkette   18681 1270 Redondo Beach, City of 242 City 2 City Agency 2 http://www.redondo.org City 2 0.176 Ensenada Parkette  
4087 4087 4086 {"type": "Polygon", "coordinates": [[[-118.38235, 33.86755], [-118.38219, 33.86754], [-118.38219, 33.86714], [-118.38235, 33.86714], [-118.38235, 33.86755]]]} Open Access 1 General Eaton #1 Parkette   19253 1270 Redondo Beach, City of 242 City 2 City Agency 2 http://www.redondo.org City 2 0.168 General Eaton #1 Parkette  
4219 4219 4218 {"type": "Polygon", "coordinates": [[[-118.38219, 33.86754], [-118.38219, 33.86796], [-118.38186, 33.86796], [-118.38186, 33.86755], [-118.38219, 33.86754]]]} Open Access 1 General Eaton #2 Parkette   19254 1270 Redondo Beach, City of 242 City 2 City Agency 2 http://www.redondo.org City 2 0.347 General Eaton #2 Parkette  
4305 4305 4304 {"type": "Polygon", "coordinates": [[[-118.38535, 33.86841], [-118.38506, 33.86854], [-118.38499, 33.86842], [-118.38527, 33.86828], [-118.38535, 33.86841]]]} Open Access 1 Ford Parkette   18988 1270 Redondo Beach, City of 242 City 2 City Agency 2 http://www.redondo.org City 2 0.115 Ford Parkette  
4314 4314 4313 {"type": "Polygon", "coordinates": [[[-118.3602, 33.86163], [-118.35988, 33.86164], [-118.35987, 33.86189], [-118.359, 33.86189], [-118.359, 33.8606], [-118.3602, 33.8606], [-118.3602, 33.86163]]]} Open Access 1 Franklin Park   19065 1270 Redondo Beach, City of 242 City 2 City Agency 2 http://www.redondo.org City 2 3.736 Franklin Park  
4451 4451 4450 {"type": "Polygon", "coordinates": [[[-118.3727, 33.86126], [-118.37269, 33.86142], [-118.37262, 33.86173], [-118.3726, 33.86177], [-118.37254, 33.86182], [-118.37209, 33.86205], [-118.37203, 33.86204], [-118.37195, 33.8619], [-118.37193, 33.86179], [-118.37193, 33.86126], [-118.3727, 33.86126]]]} Open Access 1 Fulton Playfield   19148 1270 Redondo Beach, City of 242 City 2 City Agency 2 http://www.redondo.org City 2 1.216 Fulton Playfield  
4710 4710 4709 {"type": "Polygon", "coordinates": [[[-118.37797, 33.86434], [-118.37796, 33.86475], [-118.37764, 33.86475], [-118.37763, 33.86434], [-118.37797, 33.86434]]]} Open Access 1 Gregg Parkette   19500 1270 Redondo Beach, City of 242 City 2 City Agency 2 http://www.redondo.org City 2 0.343 Gregg Parkette  
4726 4726 4725 {"type": "Polygon", "coordinates": [[[-118.37763, 33.86101], [-118.37763, 33.86143], [-118.37747, 33.86143], [-118.37746, 33.86101], [-118.37763, 33.86101]]]} Open Access 1 La Paz Parkette   20785 1270 Redondo Beach, City of 242 City 2 City Agency 2 http://www.redondo.org City 2 0.176 La Paz Parkette  
5252 5252 5251 {"type": "Polygon", "coordinates": [[[-118.37563, 33.82957], [-118.3743, 33.83077], [-118.37429, 33.8313], [-118.37368, 33.83139], [-118.37311, 33.82856], [-118.37351, 33.82804], [-118.37387, 33.82825], [-118.37422, 33.82848], [-118.37563, 33.82957]]]} Open Access 1 Hopkins Wilderness Park   20088 1270 Redondo Beach, City of 242 City 2 City Agency 2 http://www.redondo.org City 2 10.985 Hopkins Wilderness Park  
5307 5307 5306 {"type": "Polygon", "coordinates": [[[-118.37992, 33.86807], [-118.37992, 33.86849], [-118.37975, 33.86849], [-118.37976, 33.86808], [-118.37992, 33.86807]]]} Open Access 1 Huntington Parkette   20158 1270 Redondo Beach, City of 242 City 2 City Agency 2 http://www.redondo.org City 2 0.17 Huntington Parkette  
5808 5808 5807 {"type": "Polygon", "coordinates": [[[-118.3842, 33.86131], [-118.38404, 33.86131], [-118.38403, 33.86103], [-118.38419, 33.86103], [-118.3842, 33.86131]]]} Open Access 1 McNeill Parkette   22065 1270 Redondo Beach, City of 242 City 2 City Agency 2 http://www.redondo.org City 2 0.115 McNeill Parkette  
6169 6169 6168 {"type": "Polygon", "coordinates": [[[-118.36568, 33.86009], [-118.36552, 33.86011], [-118.36552, 33.86188], [-118.36536, 33.86188], [-118.36536, 33.85842], [-118.36568, 33.85842], [-118.36568, 33.86009]]]} Open Access 1 Lilienthal Park   21234 1270 Redondo Beach, City of 242 City 2 City Agency 2 http://www.redondo.org City 2 2.131 Lilienthal Park  
6758 6758 6757 {"type": "Polygon", "coordinates": [[[-118.3775, 33.87385], [-118.3775, 33.87426], [-118.37734, 33.87426], [-118.37733, 33.87385], [-118.3775, 33.87385]]]} Open Access 1 Mathews Parkette   21952 1270 Redondo Beach, City of 242 City 2 City Agency 2 http://www.redondo.org City 2 0.177 Mathews Parkette  

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