units_with_maps

Table actions

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

5 rows where ACRES = "1.452"

This data as json, copyable, CSV (advanced)

These facets timed out: ACCESS_TYP, MNG_AGENCY, MNG_AG_TYP, DES_TP

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
4679 4679 4678 {"type": "Polygon", "coordinates": [[[-121.3533, 38.45594], [-121.35327, 38.45595], [-121.35327, 38.45636], [-121.35226, 38.45636], [-121.35227, 38.45624], [-121.3523, 38.45613], [-121.35236, 38.456], [-121.35243, 38.45591], [-121.35251, 38.45582], [-121.35281, 38.45567], [-121.35311, 38.4556], [-121.35318, 38.45561], [-121.35321, 38.45564], [-121.3533, 38.45594]]]} Restricted Access 2 43001 Unnamed site - Sacramento, County of 28659 316 Sacramento, County of 550 County 3 County Agency 3 http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx County 3 316 Sacramento, County of 543 County 3 County Agency 3   Sacramento 41 1.452   0 Local Other or Unknown 14 4
6165 6165 6164 {"type": "Polygon", "coordinates": [[[-117.11078, 32.76765], [-117.11076, 32.76779], [-117.11017, 32.76794], [-117.10991, 32.76759], [-117.10935, 32.76787], [-117.10929, 32.76778], [-117.11037, 32.76711], [-117.11038, 32.76705], [-117.11078, 32.76765]]]} Open Access 1 18949 Kensington/College Open Space 20616 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 1297 San Diego, City of 4 City 2 City Agency 2   San Diego 4 1.452 Kensington/College OS 0 Local Recreation Area 3 4
7853 7853 7852 {"type": "Polygon", "coordinates": [[[-117.72286, 33.54177], [-117.72285, 33.5418], [-117.72226, 33.54275], [-117.7222, 33.54244], [-117.72198, 33.54222], [-117.72209, 33.54181], [-117.72228, 33.54141], [-117.72241, 33.54143], [-117.72252, 33.54143], [-117.72254, 33.54171], [-117.72286, 33.54177]]]} Open Access 1 9946 Ridge View Park 24350 1166 Laguna Niguel, City of 532 City 2 City Agency 2 http://www.cityoflagunaniguel.org/index.aspx?nid=12 City 2 1166 Laguna Niguel, City of 525 City 2 City Agency 2   Orange 3 1.452 Ridge View Park 0 Local Park 2 4
8180 8180 8179 {"type": "Polygon", "coordinates": [[[-117.14409, 32.97117], [-117.14395, 32.97109], [-117.14349, 32.97116], [-117.14334, 32.9712], [-117.14311, 32.97129], [-117.14298, 32.97143], [-117.14283, 32.97134], [-117.14262, 32.97134], [-117.14241, 32.97126], [-117.14226, 32.97152], [-117.14221, 32.97148], [-117.14212, 32.97145], [-117.142, 32.97148], [-117.14191, 32.97142], [-117.14158, 32.97142], [-117.14184, 32.97106], [-117.14409, 32.97105], [-117.14409, 32.97117]]]} No Public Access 3 12386 Land Pres/Mitigation Bank - The Environmental Trust 21002 3088 The Environmental Trust 395 Non Profit 6 Non Profit - Land Trust 10   Non Governmental Organization 10 3088 The Environmental Trust 389 Non Profit 6 Non Profit - Land Trust 10   San Diego 4 1.452 Land Pres/Mitigation Bank - The Environmental Trust 0 Private Conservation 16 2
15270 15270 15269 {"type": "Polygon", "coordinates": [[[-117.90259, 34.14702], [-117.90257, 34.14752], [-117.9016, 34.14798], [-117.9016, 34.14772], [-117.90149, 34.14756], [-117.90205, 34.14721], [-117.90234, 34.14708], [-117.90234, 34.14681], [-117.9024, 34.14683], [-117.90249, 34.14689], [-117.90253, 34.14694], [-117.90254, 34.14702], [-117.90259, 34.14702]]]} Open Access 1 46455 Craftsman Park 32769 1018 Azusa, City of 147 City 2 City Agency 2 http://www.ci.azusa.ca.us/index.aspx?NID=249 City 2 1018 Azusa, City of 143 City 2 City Agency 2   Los Angeles 6 1.452 Craftsman Park 0 Local Park 2 4

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