units_with_maps

Table actions

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

5 rows where ACCESS_TYP = 1, COUNTY = 4 and MNG_AG_TYP = 20

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP

ACCESS_TYP 1

  • Open Access · 5 ✖
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
3568 3568 3567 {"type": "Polygon", "coordinates": [[[-117.12444, 32.57552], [-117.12422, 32.57552], [-117.12425, 32.57652], [-117.12305, 32.57652], [-117.12307, 32.5737], [-117.12357, 32.57366], [-117.12388, 32.57374], [-117.12399, 32.57387], [-117.12401, 32.57408], [-117.12442, 32.57408], [-117.12444, 32.57552]]]} Open Access 1 439 Imperial Beach Sports Park 31474 1143 Imperial Beach, City of 630 City 2 City Agency 2 http://www.imperialbeachca.gov/index.asp?Type=B_BASIC&SEC={9F232DF8-5366-4BA2-A4B8-8795196F6D81} City 2 7018 Boys and Girls Clubs of South County 649 Non Profit 6 Non Profit - Other 20 http://www.bgcscounty.org/portal/home San Diego 4 8.985 Imperial Beach Sports Park   None 298  
5266 5266 5265 {"type": "Polygon", "coordinates": [[[-117.35459, 33.20901], [-117.35406, 33.21043], [-117.35407, 33.21045], [-117.35412, 33.21045], [-117.3539, 33.21053], [-117.35388, 33.21048], [-117.35389, 33.21042], [-117.35409, 33.20978], [-117.35417, 33.20964], [-117.35418, 33.20959], [-117.35417, 33.20953], [-117.35411, 33.20946], [-117.35404, 33.20943], [-117.35393, 33.20943], [-117.35337, 33.20918], [-117.35314, 33.20899], [-117.35395, 33.20875], [-117.35416, 33.20875], [-117.35447, 33.20877], [-117.35455, 33.20899], [-117.35459, 33.20901]]]} Open Access 1 949 North County Humane Society and SPCA Dog Park 29112 3361 San Diego Humane Society and SPCA 803 Non Profit 6 Non Profit - Other 22 http://www.sdhumane.org/ Non Governmental Organization 10 3361 San Diego Humane Society and SPCA 783 Non Profit 6 Non Profit - Other 20 http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/dogpark.asp San Diego 4 2.32 North County Humane Society and SPCA Dog Park 0 Private Recreation or Education 65 4
7613 7613 7612 {"type": "MultiPolygon", "coordinates": [[[[-116.98432, 32.76701], [-116.98411, 32.76731], [-116.98404, 32.76739], [-116.98377, 32.76752], [-116.9836, 32.76758], [-116.98348, 32.76759], [-116.98317, 32.76758], [-116.98293, 32.76749], [-116.98281, 32.76741], [-116.98257, 32.76721], [-116.9825, 32.7671], [-116.9825, 32.76698], [-116.98252, 32.76694], [-116.98265, 32.76674], [-116.98268, 32.76671], [-116.9829, 32.76674], [-116.98319, 32.76662], [-116.98334, 32.7666], [-116.98362, 32.76663], [-116.98411, 32.76677], [-116.98423, 32.76685], [-116.98432, 32.76701]]], [[[-116.98313, 32.76651], [-116.98288, 32.76661], [-116.98266, 32.76658], [-116.98257, 32.76662], [-116.98253, 32.76666], [-116.98238, 32.76693], [-116.98236, 32.76703], [-116.98238, 32.76715], [-116.98245, 32.76726], [-116.98277, 32.76752], [-116.98302, 32.76765], [-116.98294, 32.76763], [-116.98228, 32.76735], [-116.98219, 32.76715], [-116.98236, 32.76689], [-116.98254, 32.76651], [-116.98266, 32.76646], [-116.98313, 32.76651]]], [[[-116.98413, 32.76749], [-116.98404, 32.76755], [-116.98385, 32.76773], [-116.98381, 32.76769], [-116.98369, 32.76768], [-116.98333, 32.76772], [-116.98326, 32.7677], [-116.9835, 32.7677], [-116.98373, 32.76766], [-116.98405, 32.76752], [-116.98412, 32.76747], [-116.98413, 32.76749]]], [[[-116.98087, 32.76954], [-116.98087, 32.76954], [-116.98049, 32.76998], [-116.9807, 32.7694], [-116.98087, 32.76954]]], [[[-116.98059, 32.7693], [-116.98028, 32.77017], [-116.98022, 32.77025], [-116.98028, 32.77002], [-116.98028, 32.76978], [-116.98025, 32.76951], [-116.98022, 32.76942], [-116.98014, 32.76934], [-116.98008, 32.76931], [-116.97977, 32.76924], [-116.97988, 32.76911], [-116.98017, 32.76898], [-116.98059, 32.7693]]], [[[-116.98014, 32.76944], [-116.98017, 32.76955], [-116.9802, 32.76977], [-116.9802, 32.76996], [-116.98018, 32.77009], [-116.98013, 32.77025], [-116.98007, 32.77023], [-116.97955, 32.76984], [-116.97941, 32.76978], [-116.97929, 32.76976], [-116.97953, 32.76954], [-116.97972, 32.7693], [-116.98004, 32.76937], [-116.98014, 32.76944]]], [[[-116.98007, 32.77041], [-116.97968, 32.77033], [-116.97914, 32.77013], [-116.97923, 32.76989], [-116.97934, 32.7699], [-116.97948, 32.76997], [-116.98007, 32.77041]]]]} Open Access 1 7353 Mt. Helix Park 22579 3024 Foundation for Preservation of Mt. Helix Nature Theatre 874 Non Profit 6 Non Profit - Other 22 http://www.mthelixpark.org/ Non Governmental Organization 10 3024 Foundation for Preservation of Mt. Helix Nature Theatre 852 Non Profit 6 Non Profit - Other 20 https://www.mthelixpark.org/ San Diego 4 6.584 Mt. Helix Park 0 Private Recreation or Education 65 4
7950 7950 7949 {"type": "Polygon", "coordinates": [[[-117.01166, 33.09834], [-117.00724, 33.09846], [-117.00721, 33.10173], [-117.00292, 33.10171], [-117.00293, 33.1048], [-117.00284, 33.10489], [-117.00279, 33.10502], [-117.00276, 33.10523], [-117.00281, 33.1053], [-116.99808, 33.10533], [-116.99803, 33.10898], [-116.98097, 33.10899], [-116.98096, 33.10543], [-116.96332, 33.10566], [-116.96371, 33.09511], [-116.96367, 33.09348], [-116.96393, 33.09332], [-116.96428, 33.09317], [-116.96446, 33.09312], [-116.96564, 33.09286], [-116.96609, 33.09274], [-116.96856, 33.0918], [-116.96876, 33.09173], [-116.96925, 33.09162], [-116.97152, 33.09125], [-116.97191, 33.09117], [-116.97461, 33.09036], [-116.97866, 33.08928], [-116.97854, 33.08932], [-116.97856, 33.09035], [-116.98186, 33.09031], [-116.99163, 33.08849], [-116.99171, 33.08887], [-116.99197, 33.08955], [-116.99249, 33.09015], [-116.99317, 33.09071], [-116.99366, 33.09108], [-116.99411, 33.09135], [-116.99459, 33.0916], [-116.99501, 33.09177], [-116.99945, 33.09342], [-117.00223, 33.09441], [-117.00239, 33.09428], [-117.00232, 33.09447], [-117.00438, 33.09522], [-117.00503, 33.09542], [-117.00567, 33.09558], [-117.00623, 33.09569], [-117.00687, 33.09579], [-117.01086, 33.09625], [-117.01126, 33.09635], [-117.01148, 33.09642], [-117.01165, 33.0965], [-117.01166, 33.09834]]]} Open Access 1 47725 San Diego Safari Park 31513 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 7020 San Diego Zoo Global 858 Non Profit 6 Non Profit - Other 20 http://sdzsafaripark.org/ San Diego 4 1699.918 San Diego Safari Park   None 662  
15558 15558 15557 {"type": "MultiPolygon", "coordinates": [[[[-117.23623, 33.03472], [-117.23609, 33.03514], [-117.23477, 33.03601], [-117.23459, 33.03653], [-117.23385, 33.03634], [-117.23455, 33.03424], [-117.23623, 33.03472]]], [[[-117.23374, 33.03631], [-117.23309, 33.03834], [-117.23296, 33.03831], [-117.23292, 33.03841], [-117.23201, 33.03818], [-117.23209, 33.03792], [-117.23191, 33.03787], [-117.23251, 33.03599], [-117.23374, 33.03631]]]]} Open Access 1 1247 San Elijo Lagoon Ecological Reserve 24880 3058 Rancho Santa Fe Community Foundation 1159 Non Profit 6 Non Profit - Other 22 http://www.rsffoundation.org/ Non Governmental Organization 10 3058 Rancho Santa Fe Community Foundation 1101 Non Profit 6 Non Profit - Other 20 https://www.sanelijo.org/home San Diego 4 14.074 San Elijo Lagoon ER 1983 Private Conservation 16 2

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