superunits_with_maps

Table actions

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

13 rows where MNG_AGENCY = 281 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

Suggested facets: PARK_NAME, PARK_URL, LABEL_NAME

MNG_AG_TYP 1

  • City Agency · 13 ✖

MNG_AGENCY 1

  • Paramount, City of · 13 ✖
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
1146 1146 1145 {"type": "Polygon", "coordinates": [[[-118.15686, 33.91279], [-118.15558, 33.9145], [-118.15396, 33.91378], [-118.15439, 33.91307], [-118.15686, 33.91279]]]} Open Access 1 All American Park   15376 1245 Paramount, City of 281 City 2 City Agency 2 http://www.paramountcity.com/ps.parksrecreation.cfm?ID=6 City 2 6.775 All American Park  
3552 3552 3551 {"type": "Polygon", "coordinates": [[[-118.16982, 33.89865], [-118.16899, 33.89865], [-118.16899, 33.89833], [-118.16906, 33.89827], [-118.16982, 33.89827], [-118.16982, 33.89865]]]} Open Access 1 Garfield Park   19214 1245 Paramount, City of 281 City 2 City Agency 2 http://www.paramountcity.com/ps.parksrecreation.cfm?ID=6 City 2 0.794 Garfield Park  
7940 7940 7939 {"type": "Polygon", "coordinates": [[[-118.16001, 33.90337], [-118.15581, 33.90123], [-118.1558, 33.90088], [-118.15612, 33.90103], [-118.15998, 33.90099], [-118.16001, 33.90337]]]} Open Access 1 Paramount Park   23412 1245 Paramount, City of 281 City 2 City Agency 2 http://www.paramountcity.com/ps.parksrecreation.cfm?ID=6 City 2 13.665 Paramount Park  
8085 8085 8084 {"type": "Polygon", "coordinates": [[[-118.15217, 33.90569], [-118.15162, 33.9057], [-118.15162, 33.9057], [-118.15162, 33.90562], [-118.15217, 33.90561], [-118.15217, 33.90569]]]} Open Access 1 Pequeno Park   23602 1245 Paramount, City of 281 City 2 City Agency 2 http://www.paramountcity.com/ps.parksrecreation.cfm?ID=6 City 2 0.107 Pequeno Park  
8418 8418 8417 {"type": "Polygon", "coordinates": [[[-118.15132, 33.89221], [-118.1513, 33.89223], [-118.1513, 33.8927], [-118.15125, 33.89275], [-118.1494, 33.89275], [-118.14939, 33.89231], [-118.14861, 33.89231], [-118.1486, 33.89214], [-118.14829, 33.89214], [-118.14827, 33.89195], [-118.14739, 33.89195], [-118.14739, 33.89147], [-118.1507, 33.89147], [-118.15081, 33.8914], [-118.15132, 33.8914], [-118.15132, 33.89221]]]} Open Access 1 Progress Park http://www.paramountcity.com/Home/Components/FacilityDirectory/FacilityDirectory/38/97 24013 1245 Paramount, City of 281 City 2 City Agency 2 http://www.paramountcity.com/ps.parksrecreation.cfm?ID=6 City 2 9.64 Progress Park  
8480 8480 8479 {"type": "Polygon", "coordinates": [[[-118.18554, 33.89653], [-118.18539, 33.89655], [-118.18527, 33.89725], [-118.18528, 33.89753], [-118.18519, 33.89807], [-118.18515, 33.89846], [-118.18499, 33.89927], [-118.18465, 33.90011], [-118.18429, 33.9007], [-118.18413, 33.90092], [-118.18381, 33.90128], [-118.18345, 33.90166], [-118.1823, 33.90266], [-118.1818, 33.90308], [-118.18155, 33.90325], [-118.18127, 33.9033], [-118.18108, 33.90339], [-118.18088, 33.90342], [-118.18179, 33.90263], [-118.18184, 33.90253], [-118.18186, 33.90244], [-118.18291, 33.9015], [-118.18327, 33.90113], [-118.18355, 33.90079], [-118.18383, 33.90038], [-118.18407, 33.89998], [-118.18423, 33.89964], [-118.18439, 33.89922], [-118.1849, 33.89755], [-118.18489, 33.89753], [-118.18486, 33.89753], [-118.18485, 33.89719], [-118.18501, 33.89719], [-118.18505, 33.89705], [-118.18405, 33.89705], [-118.18405, 33.89636], [-118.18437, 33.89635], [-118.18439, 33.89632], [-118.1854, 33.8963], [-118.18554, 33.89653]]]} Open Access 1 Ralph C. Dills Park   24099 1245 Paramount, City of 281 City 2 City Agency 2 http://www.paramountcity.com/ps.parksrecreation.cfm?ID=6 City 2 11.777 Ralph C. Dills Park  
9844 9844 9843 {"type": "Polygon", "coordinates": [[[-118.17676, 33.90345], [-118.17674, 33.90348], [-118.1767, 33.90349], [-118.17524, 33.90349], [-118.17523, 33.90215], [-118.17604, 33.90206], [-118.17676, 33.90345]]]} Open Access 1 Spane Park   25711 1245 Paramount, City of 281 City 2 City Agency 2 http://www.paramountcity.com/ps.parksrecreation.cfm?ID=6 City 2 4.2 Spane Park  
11762 11762 11761 {"type": "Polygon", "coordinates": [[[-118.1754, 33.88972], [-118.17485, 33.88973], [-118.17485, 33.88933], [-118.17486, 33.88929], [-118.17492, 33.88926], [-118.1754, 33.88926], [-118.1754, 33.88972]]]} Open Access 1 Meadows Park http://www.paramountcity.com/parks.cfm?task=detail&ID=10 28374 1245 Paramount, City of 281 City 2 City Agency 2 http://www.paramountcity.com/ps.parksrecreation.cfm?ID=6 City 2 0.645 Meadows Park  
12672 12672 12671 {"type": "Polygon", "coordinates": [[[-118.16529, 33.89628], [-118.16456, 33.89628], [-118.16456, 33.89546], [-118.16528, 33.89546], [-118.16529, 33.89628]]]} Open Access 1 Village Skate Park http://www.paramountcity.com/parks.cfm?task=detail&ID=10 29810 1245 Paramount, City of 281 City 2 City Agency 2 http://www.paramountcity.com/ps.parksrecreation.cfm?ID=6 City 2 1.514 Village Skate Park  
12674 12674 12673 {"type": "Polygon", "coordinates": [[[-118.15776, 33.90102], [-118.15612, 33.90103], [-118.15579, 33.90087], [-118.15578, 33.89949], [-118.15753, 33.8995], [-118.15754, 33.89955], [-118.15769, 33.89956], [-118.15768, 33.89971], [-118.15775, 33.89973], [-118.15776, 33.90102]]]} Restricted Access 2 Paramount Park   29813 1245 Paramount, City of 281 City 2 City Agency 2 http://www.paramountcity.com/ps.parksrecreation.cfm?ID=6 City 2 7.536 Paramount Park  
12675 12675 12674 {"type": "Polygon", "coordinates": [[[-118.17428, 33.89646], [-118.17425, 33.89715], [-118.17427, 33.89978], [-118.17318, 33.89977], [-118.17316, 33.89651], [-118.17318, 33.89648], [-118.17322, 33.89647], [-118.17428, 33.89646]]]} Open Access 1 Salud Park http://www.paramountcity.com/parks.cfm?task=detail&ID=10 29814 1245 Paramount, City of 281 City 2 City Agency 2 http://www.paramountcity.com/ps.parksrecreation.cfm?ID=6 City 2 9.169 Salud Park  
12676 12676 12675 {"type": "Polygon", "coordinates": [[[-118.17744, 33.90073], [-118.17695, 33.90073], [-118.17695, 33.90052], [-118.17744, 33.90051], [-118.17744, 33.90073]]]} Open Access 1 Orange Avenue Splash Zone   29816 1245 Paramount, City of 281 City 2 City Agency 2 http://www.paramountcity.com/ps.parksrecreation.cfm?ID=6 City 2 0.271 Orange Avenue Splash Zone  
14331 14331 14330 {"type": "Polygon", "coordinates": [[[-118.1743, 33.90349], [-118.17321, 33.9035], [-118.17318, 33.89977], [-118.17427, 33.89978], [-118.1743, 33.90349]]]} No Public Access 3 Unnamed site - Paramount, City of   29815 1245 Paramount, City of 281 City 2 City Agency 2 http://www.paramountcity.com/ps.parksrecreation.cfm?ID=6 City 2 10.253    

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