units_with_maps

Table actions

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

3 rows where AGNCY_NAME = 63, COUNTY = 4, DES_TP = 16 and MNG_AG_TYP = 10

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Non Profit - Land Trust · 3 ✖

MNG_AGENCY 1

DES_TP 1

  • Private Conservation · 3 ✖
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
154 154 153 {"type": "Polygon", "coordinates": [[[-116.74026, 33.1805], [-116.73988, 33.18051], [-116.73975, 33.18053], [-116.73967, 33.18056], [-116.7395, 33.18056], [-116.73938, 33.18052], [-116.73921, 33.18041], [-116.73814, 33.18041], [-116.73818, 33.18262], [-116.73708, 33.18261], [-116.73375, 33.18275], [-116.73377, 33.17923], [-116.74025, 33.17921], [-116.74026, 33.1805]]]} No Public Access 3 416 Ewing Oak Preserve 18771 3091 The Nature Conservancy 63 Non Profit 6 Non Profit - Land Trust 10 http://www.nature.org/ Non Governmental Organization 10 3091 The Nature Conservancy 61 Non Profit 6 Non Profit - Land Trust 10   San Diego 4 45.451 Ewing Oak Preserve 0 Private Conservation 16 2
4033 4033 4032 {"type": "MultiPolygon", "coordinates": [[[[-116.43699, 32.64546], [-116.43674, 32.66028], [-116.42828, 32.6603], [-116.42816, 32.64566], [-116.43699, 32.64546]]], [[[-116.45411, 32.66395], [-116.4541, 32.66484], [-116.44972, 32.66482], [-116.44972, 32.66394], [-116.45411, 32.66395]]]]} No Public Access 3 46971 La Posta - Cameron Preserve 30601 3091 The Nature Conservancy 63 Non Profit 6 Non Profit - Land Trust 10 http://www.nature.org/ Non Governmental Organization 10 3091 The Nature Conservancy 61 Non Profit 6 Non Profit - Land Trust 10   San Diego 4 337.313 La Posta - Cameron Preserve 0 Private Conservation 16 2
6769 6769 6768 {"type": "MultiPolygon", "coordinates": [[[[-116.87056, 32.73716], [-116.86583, 32.73711], [-116.86553, 32.73354], [-116.87, 32.73358], [-116.87056, 32.73716]]], [[[-116.86613, 32.74077], [-116.86448, 32.74076], [-116.86425, 32.74118], [-116.86327, 32.74076], [-116.86447, 32.74076], [-116.86509, 32.73962], [-116.86605, 32.74], [-116.86613, 32.74077]]], [[[-116.86623, 32.74204], [-116.86596, 32.74191], [-116.86619, 32.74151], [-116.86623, 32.74204], [-116.86623, 32.74204]]], [[[-116.86641, 32.74443], [-116.86663, 32.75147], [-116.85716, 32.75147], [-116.85758, 32.7585], [-116.8533, 32.7585], [-116.85303, 32.75147], [-116.85255, 32.75145], [-116.84475, 32.75143], [-116.84406, 32.74438], [-116.84852, 32.74441], [-116.84849, 32.74083], [-116.85084, 32.74079], [-116.85271, 32.74079], [-116.85277, 32.74444], [-116.85672, 32.74447], [-116.86175, 32.74445], [-116.86166, 32.74238], [-116.86163, 32.74219], [-116.86156, 32.74075], [-116.8624, 32.74076], [-116.86172, 32.74196], [-116.86343, 32.7427], [-116.86309, 32.74335], [-116.86309, 32.74337], [-116.86397, 32.74372], [-116.86497, 32.74376], [-116.86514, 32.74342], [-116.86572, 32.74366], [-116.86628, 32.74265], [-116.86641, 32.74443]]]]} Restricted Access 2 5224 McGinty Mountain Preserve 30607 3091 The Nature Conservancy 63 Non Profit 6 Non Profit - Land Trust 10 http://www.nature.org/ Non Governmental Organization 10 3091 The Nature Conservancy 61 Non Profit 6 Non Profit - Land Trust 10   San Diego 4 577.956 McGinty Mtn. Preserve 0 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]);