units_with_maps

Table actions

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

2 rows where ACCESS_TYP = 3, COUNTY = 15 and DES_TP = 15

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

DES_TP 1

  • State Park · 2 ✖

ACCESS_TYP 1

  • No Public Access · 2 ✖
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
16441 16441 16440 {"type": "Polygon", "coordinates": [[[-122.40354, 37.31222], [-122.40323, 37.31448], [-122.40291, 37.31618], [-122.40251, 37.3184], [-122.39697, 37.31667], [-122.39389, 37.31659], [-122.39354, 37.31685], [-122.39213, 37.31831], [-122.39244, 37.31914], [-122.39273, 37.31943], [-122.39299, 37.31965], [-122.39422, 37.32051], [-122.39521, 37.32098], [-122.3963, 37.32204], [-122.3959, 37.32353], [-122.39537, 37.32452], [-122.39399, 37.32451], [-122.39363, 37.32444], [-122.3933, 37.32461], [-122.39188, 37.32464], [-122.39118, 37.32493], [-122.39117, 37.32495], [-122.39068, 37.32516], [-122.39047, 37.32532], [-122.38951, 37.32584], [-122.38902, 37.32488], [-122.38966, 37.32484], [-122.38989, 37.32465], [-122.38979, 37.32431], [-122.38976, 37.32402], [-122.38984, 37.32379], [-122.39092, 37.32343], [-122.39105, 37.32332], [-122.39103, 37.32321], [-122.38864, 37.32389], [-122.38852, 37.32388], [-122.38854, 37.3238], [-122.38853, 37.32371], [-122.38836, 37.3232], [-122.38829, 37.32305], [-122.38774, 37.32208], [-122.38761, 37.3219], [-122.38738, 37.32163], [-122.38733, 37.32151], [-122.38733, 37.32137], [-122.3874, 37.32121], [-122.38762, 37.321], [-122.3877, 37.32088], [-122.38772, 37.32077], [-122.38771, 37.32048], [-122.38773, 37.32041], [-122.38777, 37.32037], [-122.38786, 37.32032], [-122.38822, 37.32023], [-122.38852, 37.32006], [-122.38875, 37.31997], [-122.38886, 37.31991], [-122.38894, 37.31981], [-122.38918, 37.31934], [-122.38925, 37.31927], [-122.38935, 37.31925], [-122.38968, 37.31928], [-122.38987, 37.31923], [-122.39, 37.31915], [-122.39053, 37.31867], [-122.3909, 37.31855], [-122.39104, 37.31846], [-122.39111, 37.31833], [-122.39112, 37.31825], [-122.39111, 37.31818], [-122.39074, 37.31753], [-122.39073, 37.3175], [-122.39075, 37.31745], [-122.39079, 37.31742], [-122.39107, 37.31734], [-122.39118, 37.31728], [-122.39124, 37.31718], [-122.39125, 37.31711], [-122.39124, 37.31706], [-122.39117, 37.31696], [-122.39074, 37.31664], [-122.39064, 37.31643], [-122.39053, 37.31625], [-122.38968, 37.3152], [-122.38904, 37.3148], [-122.38889, 37.31473], [-122.38871, 37.31462], [-122.38858, 37.31452], [-122.38842, 37.31436], [-122.38828, 37.31427], [-122.38806, 37.31417], [-122.38731, 37.31401], [-122.38721, 37.31396], [-122.38703, 37.31382], [-122.38684, 37.31375], [-122.38541, 37.31366], [-122.38532, 37.31363], [-122.38528, 37.31358], [-122.38528, 37.31352], [-122.38539, 37.31335], [-122.38546, 37.31319], [-122.3855, 37.31306], [-122.3855, 37.31289], [-122.38545, 37.31265], [-122.38533, 37.31248], [-122.38516, 37.31229], [-122.38515, 37.31224], [-122.38517, 37.31221], [-122.38523, 37.31219], [-122.38543, 37.3122], [-122.38558, 37.31224], [-122.38575, 37.31235], [-122.38585, 37.31239], [-122.38599, 37.31241], [-122.38611, 37.31239], [-122.38622, 37.31234], [-122.38694, 37.31189], [-122.38703, 37.3118], [-122.38707, 37.31165], [-122.40354, 37.31222]]]} No Public Access 3 413 San Gregorio State Beach 24904 204 California Department of Parks and Recreation 48 State 5 State Agency 5 http://www.parks.ca.gov/ California Department of Parks and Recreation 9 204 California Department of Parks and Recreation 47 State 5 State Agency 5 http://www.parks.ca.gov/?page_id=529 San Mateo 15 290.994 San Gregorio SB 1958 State Park 15 4
16448 16448 16447 {"type": "MultiPolygon", "coordinates": [[[[-122.49631, 37.69491], [-122.49621, 37.69514], [-122.49615, 37.69533], [-122.49611, 37.69552], [-122.4961, 37.69576], [-122.49612, 37.69608], [-122.4963, 37.69694], [-122.49611, 37.69734], [-122.49598, 37.69752], [-122.4958, 37.69769], [-122.49557, 37.69783], [-122.49524, 37.69709], [-122.49514, 37.69681], [-122.49501, 37.69634], [-122.49494, 37.69596], [-122.49493, 37.69587], [-122.49498, 37.69308], [-122.49583, 37.69503], [-122.49631, 37.69491]]], [[[-122.50073, 37.70099], [-122.49662, 37.70102], [-122.49643, 37.70061], [-122.49767, 37.70059], [-122.49744, 37.7001], [-122.49716, 37.69893], [-122.49696, 37.69836], [-122.49681, 37.69798], [-122.49672, 37.69736], [-122.49678, 37.69707], [-122.49679, 37.69679], [-122.49675, 37.69659], [-122.49665, 37.69624], [-122.49663, 37.69602], [-122.49664, 37.69582], [-122.49669, 37.6956], [-122.49716, 37.69425], [-122.49727, 37.69396], [-122.49737, 37.69363], [-122.49744, 37.6932], [-122.49746, 37.69275], [-122.49855, 37.69271], [-122.49886, 37.69376], [-122.49911, 37.69475], [-122.4995, 37.69584], [-122.49993, 37.69732], [-122.50019, 37.69868], [-122.50073, 37.70099]]]]} No Public Access 3 1533 Thornton State Beach 26321 204 California Department of Parks and Recreation 48 State 5 State Agency 5 http://www.parks.ca.gov/ California Department of Parks and Recreation 9 204 California Department of Parks and Recreation 47 State 5 State Agency 5 http://www.parks.ca.gov/?page_id=530 San Mateo 15 62.869 Thornton SB 1955 State Park 15 4

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