units_with_maps

Table actions

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

5 rows where ACCESS_TYP = 2, LAYER = 10 and MNG_AG_TYP = 20

This data as json, copyable, CSV (advanced)

Suggested facets: UNIT_NAME, AGNCY_ID, COUNTY, GAP_STS

MNG_AG_TYP 1

  • Non Profit - Other · 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
4471 4471 4470 {"type": "Polygon", "coordinates": [[[-116.62024, 32.8546], [-116.62023, 32.85532], [-116.61829, 32.85533], [-116.61829, 32.85491], [-116.618, 32.85491], [-116.61799, 32.85435], [-116.61875, 32.85434], [-116.61914, 32.85341], [-116.61924, 32.85343], [-116.6193, 32.85399], [-116.61991, 32.8542], [-116.6198, 32.85446], [-116.62024, 32.8546]]]} Restricted Access 2 1199 Unnamed site - Nonprofit Organization - Unknown 28649 3048 Nonprofit Organization - Unknown 765 Non Profit 6 Non Profit - Other 22   Non Governmental Organization 10 3048 Nonprofit Organization - Unknown 746 Non Profit 6 Non Profit - Other 20   San Diego 4 6.306   0 Private Other or Unknown 399 4
4472 4472 4471 {"type": "Polygon", "coordinates": [[[-116.31558, 33.3251], [-116.31551, 33.33963], [-116.29816, 33.3395], [-116.29841, 33.32503], [-116.31558, 33.3251]]]} Restricted Access 2 1208 Unnamed site - Nonprofit Organization - Unknown 28649 3048 Nonprofit Organization - Unknown 765 Non Profit 6 Non Profit - Other 22   Non Governmental Organization 10 3048 Nonprofit Organization - Unknown 746 Non Profit 6 Non Profit - Other 20   San Diego 4 638.799   0 Private Other or Unknown 399 4
5753 5753 5752 {"type": "Polygon", "coordinates": [[[-119.54118, 36.51798], [-119.54116, 36.52003], [-119.54018, 36.52002], [-119.54021, 36.51798], [-119.54118, 36.51798]]]} Restricted Access 2 3683 Kingsburg Historical Park 32675 3138 Kingsburg Historical Society 817 Non Profit 6 Non Profit - Other 22 http://www.kingsburghistoricalpark.org/ Non Governmental Organization 10 3138 Kingsburg Historical Society 795 Non Profit 6 Non Profit - Other 20 http://kingsburghistoricalpark.org/ Fresno 9 4.887 Kingsburg Historical Park 0 Private Recreation or Education 65 4
12587 12587 12586 {"type": "Polygon", "coordinates": [[[-117.18941, 33.5381], [-117.18772, 33.53937], [-117.1867, 33.53844], [-117.18884, 33.53681], [-117.1892, 33.53738], [-117.18941, 33.5381]]]} Restricted Access 2 48772 Murrieta Valley Pony Baseball 33498 3397 Murrieta Valley PONY Baseball, Inc 1031 Non Profit 6 Non Profit - Other 22 https://www.mvpb.org/ Non Governmental Organization 10 3397 Murrieta Valley PONY Baseball, Inc 992 Non Profit 6 Non Profit - Other 20 https://www.mvpb.org/ Riverside 10 8.519 Murrieta Valley Pony Baseball 0 Private Conservation 16 2
16986 16986 16985 {"type": "Polygon", "coordinates": [[[-122.33796, 37.45405], [-122.33784, 37.45482], [-122.3369, 37.45579], [-122.33616, 37.45669], [-122.33589, 37.45776], [-122.33615, 37.45885], [-122.33668, 37.45965], [-122.31809, 37.47368], [-122.31807, 37.47367], [-122.3133, 37.47728], [-122.30701, 37.47208], [-122.30873, 37.47076], [-122.30803, 37.46999], [-122.30845, 37.46868], [-122.30961, 37.46678], [-122.31148, 37.46868], [-122.31435, 37.46651], [-122.3146, 37.46658], [-122.31482, 37.46659], [-122.31543, 37.46654], [-122.3156, 37.46558], [-122.33576, 37.45033], [-122.33575, 37.45149], [-122.33668, 37.45179], [-122.33796, 37.45405]]]} Restricted Access 2 16413 Filoli Center 18900 3047 National Trust for Historic Preservation 1184 Non Profit 6 Non Profit - Other 22 http://www.preservationnation.org/ Non Governmental Organization 10 3047 National Trust for Historic Preservation 1122 Non Profit 6 Non Profit - Other 20   San Mateo 15 657.331 Filoli Ctr. 1975 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]);