units_with_maps

Table actions

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

5 rows where COUNTY = 10, DES_TP = 8 and MNG_AGENCY = 51

This data as json, copyable, CSV (advanced)

Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, PARK_URL, LABEL_NAME

MNG_AG_TYP 1

MNG_AGENCY 1

  • University of California · 5 ✖

DES_TP 1

  • State Conservation Area · 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
1331 1331 1330 {"type": "Polygon", "coordinates": [[[-117.30505, 33.972], [-117.30065, 33.97196], [-117.30065, 33.97556], [-117.29645, 33.97552], [-117.2965, 33.96463], [-117.30083, 33.96465], [-117.30087, 33.96815], [-117.30505, 33.96813], [-117.30505, 33.972]]]} No Public Access 3 47644 Box Springs Reserve 31388 217 University of California 53 State 5 State Agency 5 http://nrs.ucop.edu/ Other State 5 217 University of California 51 State 5 State Agency 5 http://www.ucnrs.org/reserves/box-springs-reserve.html Riverside 10 159.828 Box Springs Reserve 0 State Conservation Area 8 2
6872 6872 6871 {"type": "MultiPolygon", "coordinates": [[[[-117.24826, 33.80281], [-117.24825, 33.80455], [-117.24606, 33.80457], [-117.24603, 33.8029], [-117.24629, 33.80289], [-117.24664, 33.80296], [-117.2467, 33.80295], [-117.24675, 33.80291], [-117.24679, 33.80281], [-117.24826, 33.80281]]], [[[-117.26806, 33.81916], [-117.26585, 33.81919], [-117.26585, 33.81556], [-117.26579, 33.81188], [-117.26141, 33.81189], [-117.26146, 33.81559], [-117.25705, 33.81565], [-117.25704, 33.81374], [-117.25263, 33.81378], [-117.25261, 33.81197], [-117.24922, 33.81201], [-117.24922, 33.81118], [-117.24944, 33.81116], [-117.24944, 33.81101], [-117.24934, 33.811], [-117.24936, 33.80968], [-117.24914, 33.80927], [-117.24891, 33.80927], [-117.24891, 33.80833], [-117.24841, 33.80795], [-117.24847, 33.80788], [-117.24838, 33.80781], [-117.24813, 33.80745], [-117.24906, 33.8073], [-117.24907, 33.80729], [-117.2488, 33.80702], [-117.24874, 33.80676], [-117.24778, 33.80691], [-117.2474, 33.80529], [-117.24836, 33.80515], [-117.24825, 33.80463], [-117.24993, 33.80461], [-117.25255, 33.80464], [-117.25252, 33.80114], [-117.25412, 33.8011], [-117.25412, 33.79918], [-117.25422, 33.79917], [-117.25422, 33.79849], [-117.25412, 33.79848], [-117.25411, 33.79593], [-117.25253, 33.79592], [-117.25253, 33.79622], [-117.2504, 33.79625], [-117.25039, 33.79599], [-117.25053, 33.79578], [-117.25039, 33.79575], [-117.25038, 33.79556], [-117.24996, 33.79556], [-117.24931, 33.79527], [-117.24881, 33.79534], [-117.24862, 33.79556], [-117.24821, 33.79556], [-117.24808, 33.78924], [-117.25025, 33.78924], [-117.25029, 33.79101], [-117.25252, 33.79101], [-117.25253, 33.79438], [-117.26128, 33.79438], [-117.26134, 33.80817], [-117.26358, 33.80819], [-117.2636, 33.81004], [-117.26579, 33.81005], [-117.2658, 33.81188], [-117.26689, 33.81188], [-117.26694, 33.81554], [-117.26801, 33.81554], [-117.26806, 33.81916]], [[-117.25355, 33.79496], [-117.25355, 33.79482], [-117.25339, 33.79482], [-117.25339, 33.79496], [-117.25355, 33.79496]]]]} Restricted Access 2 5523 Motte Rimrock Reserve 22519 217 University of California 53 State 5 State Agency 5 http://nrs.ucop.edu/ Other State 5 217 University of California 51 State 5 State Agency 5 https://ucnrs.org/reserves/motte-rimrock-reserve/ Riverside 10 639.088 Motte Rimrock Reserve 0 State Conservation Area 8 2
7756 7756 7755 {"type": "Polygon", "coordinates": [[[-117.04819, 33.46996], [-117.04601, 33.46999], [-117.04383, 33.47], [-117.04258, 33.47004], [-117.03519, 33.47001], [-117.03512, 33.46655], [-117.03512, 33.46296], [-117.04814, 33.46288], [-117.04819, 33.46996]], [[-117.04266, 33.46696], [-117.04265, 33.46697], [-117.04274, 33.46733], [-117.04314, 33.46728], [-117.04307, 33.46691], [-117.04266, 33.46696]]]} Restricted Access 2 48472 Emerson Oaks Reserve 33183 217 University of California 53 State 5 State Agency 5 http://nrs.ucop.edu/ Other State 5 217 University of California 51 State 5 State Agency 5 https://ucnrs.org/reserves/emerson-oaks-reserve/ Riverside 10 234.781 Emerson Oaks Reserve 0 State Conservation Area 8 2
8349 8349 8348 {"type": "Polygon", "coordinates": [[[-116.77797, 33.80726], [-116.77791, 33.81103], [-116.77358, 33.81102], [-116.77357, 33.80908], [-116.77583, 33.80892], [-116.77583, 33.80728], [-116.77797, 33.80726]]]} Restricted Access 2 48473 James San Jacinto Mountains Reserve 33184 217 University of California 53 State 5 State Agency 5 http://nrs.ucop.edu/ Other State 5 217 University of California 51 State 5 State Agency 5 https://ucnrs.org/reserves/james-san-jacinto-mountains-reserve/ Riverside 10 31.718 James San Jacinto Mtns. Reserve 0 State Conservation Area 8 2
15052 15052 15051 {"type": "MultiPolygon", "coordinates": [[[[-117.25255, 33.80464], [-117.24993, 33.80461], [-117.24825, 33.80463], [-117.24827, 33.80108], [-117.25252, 33.80114], [-117.25255, 33.80464]]], [[[-117.26585, 33.81556], [-117.26585, 33.81919], [-117.26149, 33.81923], [-117.26146, 33.81559], [-117.26585, 33.81556]]]]} Restricted Access 2 48493 Motte Rimrock Reserve 22519 102 United States Bureau of Land Management 1 Federal 1 Federal Agency 1 http://www.blm.gov/wo/st/en.html US Bureau of Land Management 1 217 University of California 51 State 5 State Agency 5 https://ucnrs.org/reserves/motte-rimrock-reserve/ Riverside 10 78.529 Motte Rimrock Reserve 0 State Conservation Area 8 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]);