units_with_maps

Table actions

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

10 rows where ACCESS_TYP = 1, AGNCY_NAME = 285 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AG_TYP, DES_TP

MNG_AGENCY 1

ACCESS_TYP 1

  • Open Access · 10 ✖
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
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
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
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]);