units_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: UNIT_NAME, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, PARK_URL, LABEL_NAME

MNG_AG_TYP 1

  • City Agency · 13 ✖

MNG_AGENCY 1

  • Paramount, City of · 13 ✖
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
913 913 912 {"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 5847 Spane Park 25711 1245 Paramount, City of 285 City 2 City Agency 2 http://www.paramountcity.com/ps.parksrecreation.cfm?ID=6 City 2 1245 Paramount, City of 281 City 2 City Agency 2   Los Angeles 6 4.201 Spane Park 0 Local Park 2 4
1178 1178 1177 {"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 7676 Paramount Park 23412 1245 Paramount, City of 285 City 2 City Agency 2 http://www.paramountcity.com/ps.parksrecreation.cfm?ID=6 City 2 1245 Paramount, City of 281 City 2 City Agency 2   Los Angeles 6 13.668 Paramount Park 0 Local Park 2 4
3099 3099 3098 {"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 22157 Pequeno Park 23602 1245 Paramount, City of 285 City 2 City Agency 2 http://www.paramountcity.com/ps.parksrecreation.cfm?ID=6 City 2 1245 Paramount, City of 281 City 2 City Agency 2   Los Angeles 6 0.107 Pequeno Park 0 Local Park 2 4
3541 3541 3540 {"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 20601 All American Park 15376 1245 Paramount, City of 285 City 2 City Agency 2 http://www.paramountcity.com/ps.parksrecreation.cfm?ID=6 City 2 1245 Paramount, City of 281 City 2 City Agency 2   Los Angeles 6 6.776 All American Park 0 Local Park 2 4
3542 3542 3541 {"type": "Polygon", "coordinates": [[[-118.15132, 33.89221], [-118.1513, 33.89222], [-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.14828, 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 20603 Progress Park 24013 1245 Paramount, City of 285 City 2 City Agency 2 http://www.paramountcity.com/ps.parksrecreation.cfm?ID=6 City 2 1245 Paramount, City of 281 City 2 City Agency 2 http://www.paramountcity.com/Home/Components/FacilityDirectory/FacilityDirectory/38/97 Los Angeles 6 9.632 Progress Park 0 Local Park 2 4
3893 3893 3892 {"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 35807 Village Skate Park 29810 1245 Paramount, City of 285 City 2 City Agency 2 http://www.paramountcity.com/ps.parksrecreation.cfm?ID=6 City 2 1245 Paramount, City of 281 City 2 City Agency 2 http://www.paramountcity.com/parks.cfm?task=detail&ID=10 Los Angeles 6 1.514 Village Skate Park 0 Local Recreation Area 3 4
4756 4756 4755 {"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 46526 Unnamed site - Paramount, City of 29815 6073 Southern California Edison 655 Private 7 Utility 21 https://www.sce.com Private 14 1245 Paramount, City of 281 City 2 City Agency 2   Los Angeles 6 10.254   0 Local Other or Unknown 14 4
12512 12512 12511 {"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.18185, 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.89963], [-118.18439, 33.89922], [-118.1849, 33.89754], [-118.1849, 33.89753], [-118.18486, 33.89753], [-118.18485, 33.89719], [-118.18501, 33.89719], [-118.18505, 33.89704], [-118.18405, 33.89705], [-118.18405, 33.89636], [-118.18438, 33.89635], [-118.18439, 33.89632], [-118.1854, 33.8963], [-118.18554, 33.89653]]]} Open Access 1 28344 Ralph C. Dills Park 24099 1245 Paramount, City of 285 City 2 City Agency 2 http://www.paramountcity.com/ps.parksrecreation.cfm?ID=6 City 2 1245 Paramount, City of 281 City 2 City Agency 2   Los Angeles 6 11.763 Ralph C. Dills Park 0 Local Park 2 4
12610 12610 12609 {"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 29325 Garfield Park 19214 1245 Paramount, City of 285 City 2 City Agency 2 http://www.paramountcity.com/ps.parksrecreation.cfm?ID=6 City 2 1245 Paramount, City of 281 City 2 City Agency 2   Los Angeles 6 0.795 Garfield Park 0 Local Park 2 4
13127 13127 13126 {"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 45069 Salud Park 29814 6073 Southern California Edison 655 Private 7 Utility 21 https://www.sce.com Private 14 1245 Paramount, City of 281 City 2 City Agency 2 http://www.paramountcity.com/parks.cfm?task=detail&ID=10 Los Angeles 6 9.17 Salud Park 0 Local Park 2 4
14944 14944 14943 {"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 45544 Meadows Park 28374 1245 Paramount, City of 285 City 2 City Agency 2 http://www.paramountcity.com/ps.parksrecreation.cfm?ID=6 City 2 1245 Paramount, City of 281 City 2 City Agency 2 http://www.paramountcity.com/parks.cfm?task=detail&ID=10 Los Angeles 6 0.645 Meadows Park 0 Local Park 2 4
15342 15342 15341 {"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.89972], [-118.15775, 33.89973], [-118.15776, 33.90102]]]} Restricted Access 2 46525 Paramount Park 29813 2397 Paramount Unified School District 1155 Special District 4 School District 14 http://www.paramount.k12.ca.us/ Special District 4 1245 Paramount, City of 281 City 2 City Agency 2   Los Angeles 6 7.536 Paramount Park 0 Local Park 2 4
15343 15343 15342 {"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 46527 Orange Avenue Splash Zone 29816 1245 Paramount, City of 285 City 2 City Agency 2 http://www.paramountcity.com/ps.parksrecreation.cfm?ID=6 City 2 1245 Paramount, City of 281 City 2 City Agency 2   Los Angeles 6 0.272 Orange Avenue Splash Zone   None 1355  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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