units_with_maps

Table actions

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

5 rows where ACCESS_TYP = 2, COUNTY = 4 and DES_TP = 4

This data as json, copyable, CSV (advanced)

Suggested facets: AGNCY_NAME, AGNCY_TYP, AGNCY_WEB, MNG_AG_ID, MNG_AG_LEV, LABEL_NAME

MNG_AG_TYP 2

DES_TP 1

  • Local Conservation Area · 5 ✖

ACCESS_TYP 1

  • Restricted 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
1429 1429 1428 {"type": "Polygon", "coordinates": [[[-117.00998, 32.57781], [-117.00559, 32.57765], [-117.00559, 32.57912], [-117.00537, 32.57895], [-117.00513, 32.57883], [-117.00486, 32.57878], [-117.0046, 32.57878], [-117.00434, 32.57884], [-117.00415, 32.57892], [-117.00402, 32.579], [-117.00369, 32.57861], [-117.00357, 32.57838], [-117.00352, 32.5782], [-117.0035, 32.57805], [-117.0035, 32.57572], [-117.00456, 32.57575], [-117.00457, 32.57563], [-117.00487, 32.57547], [-117.00504, 32.57543], [-117.00514, 32.57544], [-117.00571, 32.5757], [-117.00584, 32.5757], [-117.00599, 32.57551], [-117.00621, 32.57533], [-117.00643, 32.57533], [-117.00656, 32.57537], [-117.0068, 32.57512], [-117.00705, 32.57482], [-117.00727, 32.57423], [-117.00733, 32.57399], [-117.00696, 32.57363], [-117.00645, 32.57334], [-117.00621, 32.57316], [-117.00602, 32.57284], [-117.00594, 32.57263], [-117.00594, 32.57243], [-117.00626, 32.57237], [-117.00647, 32.57236], [-117.00649, 32.57158], [-117.00647, 32.57157], [-117.00652, 32.57069], [-117.0065, 32.57067], [-117.00652, 32.57059], [-117.00652, 32.57031], [-117.00654, 32.5703], [-117.00654, 32.56915], [-117.00618, 32.56914], [-117.00587, 32.56895], [-117.00586, 32.56882], [-117.00553, 32.56882], [-117.00553, 32.56854], [-117.00572, 32.56854], [-117.00575, 32.56846], [-117.00583, 32.56841], [-117.00749, 32.56842], [-117.00798, 32.56847], [-117.00925, 32.56848], [-117.00925, 32.56886], [-117.00841, 32.56886], [-117.0084, 32.56946], [-117.00888, 32.5703], [-117.00988, 32.5703], [-117.00998, 32.57781]]]} Restricted Access 2 47693 Dennery Preserve 31429 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 98.129 Dennery Preserve 0 Local Conservation Area 4 2
6086 6086 6085 {"type": "MultiPolygon", "coordinates": [[[[-117.00116, 33.01884], [-116.99647, 33.01886], [-116.99635, 33.01507], [-117.00112, 33.01494], [-117.00116, 33.01884]]], [[[-117.01695, 33.01451], [-117.01452, 33.01459], [-117.00983, 33.01471], [-117.00983, 33.01458], [-117.01035, 33.01452], [-117.01054, 33.01217], [-117.01092, 33.01197], [-117.01481, 33.01197], [-117.01603, 33.01335], [-117.01695, 33.01451]]]]} Restricted Access 2 891 Blue Sky Ecological Reserve 29220 319 San Diego, County of 104 County 3 County Agency 3 http://www.sandiegocounty.gov/parks/ County 3 319 San Diego, County of 101 County 3 County Agency 3   San Diego 4 83.938 Blue Sky ER 1991 Local Conservation Area 4 2
7963 7963 7962 {"type": "MultiPolygon", "coordinates": [[[[-116.96231, 32.5888], [-116.95891, 32.58979], [-116.96013, 32.59278], [-116.95959, 32.59293], [-116.95911, 32.5929], [-116.95864, 32.593], [-116.95789, 32.59309], [-116.95733, 32.59319], [-116.95703, 32.59325], [-116.95686, 32.59339], [-116.95657, 32.59347], [-116.95598, 32.59351], [-116.95514, 32.59365], [-116.95421, 32.59393], [-116.95377, 32.59419], [-116.95265, 32.59474], [-116.95221, 32.59489], [-116.95194, 32.59494], [-116.9508, 32.59216], [-116.95833, 32.58995], [-116.95639, 32.58888], [-116.95595, 32.58857], [-116.9523, 32.58586], [-116.95369, 32.58588], [-116.96222, 32.58619], [-116.96231, 32.5888]]], [[[-116.96197, 32.5973], [-116.96128, 32.5975], [-116.96123, 32.59737], [-116.96109, 32.59724], [-116.96094, 32.5972], [-116.96072, 32.59721], [-116.96053, 32.59726], [-116.96038, 32.59735], [-116.96029, 32.59743], [-116.96024, 32.59751], [-116.9602, 32.59766], [-116.96014, 32.59775], [-116.96003, 32.59785], [-116.95988, 32.59786], [-116.95969, 32.5978], [-116.95952, 32.59771], [-116.95914, 32.59765], [-116.95898, 32.59758], [-116.95875, 32.59759], [-116.95844, 32.59767], [-116.95811, 32.59787], [-116.95753, 32.5982], [-116.95669, 32.59855], [-116.95642, 32.59876], [-116.95623, 32.59892], [-116.95384, 32.59959], [-116.95285, 32.59719], [-116.95353, 32.59743], [-116.95424, 32.59722], [-116.95498, 32.59694], [-116.95604, 32.59641], [-116.95638, 32.5962], [-116.95675, 32.59608], [-116.95783, 32.59581], [-116.9586, 32.59566], [-116.95917, 32.59523], [-116.95938, 32.59502], [-116.96077, 32.59435], [-116.96197, 32.5973]]]]} Restricted Access 2 47729 Otay Ranch Preserve 31529 1056 Chula Vista, City of 120 City 2 City Agency 2 http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp City 2 319 San Diego, County of 101 County 3 County Agency 3 http://www.sandiegocounty.gov/parks/openspace/Otay_Ranch.html San Diego 4 179.037 Otay Ranch Preserve 0 Local Conservation Area 4 2
14809 14809 14808 {"type": "Polygon", "coordinates": [[[-117.14066, 33.25449], [-117.14028, 33.2546], [-117.14032, 33.2547], [-117.14037, 33.25475], [-117.14057, 33.25543], [-117.1406, 33.25571], [-117.14058, 33.2559], [-117.14028, 33.25665], [-117.14037, 33.25683], [-117.13807, 33.25672], [-117.13802, 33.25307], [-117.13827, 33.25307], [-117.13853, 33.25318], [-117.13868, 33.25322], [-117.13897, 33.25337], [-117.13918, 33.25314], [-117.13955, 33.25349], [-117.14011, 33.25382], [-117.14025, 33.25392], [-117.14035, 33.25403], [-117.14066, 33.25449]]]} Restricted Access 2 45227 Knollwood Preserve 31493 319 San Diego, County of 104 County 3 County Agency 3 http://www.sandiegocounty.gov/parks/ County 3 319 San Diego, County of 101 County 3 County Agency 3   San Diego 4 20.712 Knollwood Preserve 0 Local Conservation Area 4 2
15638 15638 15637 {"type": "Polygon", "coordinates": [[[-117.02536, 33.01762], [-117.0241, 33.01851], [-117.02409, 33.01859], [-117.02226, 33.01869], [-117.02223, 33.01607], [-117.02353, 33.01605], [-117.02405, 33.01608], [-117.02415, 33.01631], [-117.02426, 33.01652], [-117.02438, 33.01672], [-117.02457, 33.01696], [-117.0249, 33.01729], [-117.02514, 33.01748], [-117.02536, 33.01762]]]} Restricted Access 2 45140 Blue Sky Ecological Reserve 29221 1262 Poway, City of 132 City 2 City Agency 2 http://poway.org/204/Community-Services---Parks-Recreation City 2 1262 Poway, City of 129 City 2 City Agency 2   San Diego 4 15.494 Blue Sky ER 1991 Local Conservation Area 4 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]);