units_with_maps

Table actions

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

3 rows where COUNTY = 15, DES_TP = 132 and MNG_AG_TYP = 5

This data as json, copyable, CSV (advanced)

Suggested facets: UNIT_NAME, PARK_URL, YR_EST

MNG_AG_TYP 1

  • State Agency · 3 ✖

DES_TP 1

  • State Historic or Cultural Area · 3 ✖

ACCESS_TYP 1

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
3191 3191 3190 {"type": "Polygon", "coordinates": [[[-122.51877, 37.53612], [-122.51876, 37.53627], [-122.51829, 37.53627], [-122.51828, 37.53634], [-122.51809, 37.53633], [-122.51811, 37.53611], [-122.51877, 37.53612]]]} Open Access 1 22111 Point Montara Light Station 1691 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.lighthousefriends.com/light.asp?ID=78 San Mateo 15 0.284 Point Montara Light Station 1982 State Historic or Cultural Area 132 4
10562 10562 10561 {"type": "MultiPolygon", "coordinates": [[[[-122.51916, 37.53641], [-122.51915, 37.53651], [-122.51888, 37.5365], [-122.51888, 37.53641], [-122.51916, 37.53641]]], [[[-122.51937, 37.53613], [-122.51935, 37.53634], [-122.51927, 37.53634], [-122.51926, 37.53641], [-122.51918, 37.53641], [-122.51918, 37.53635], [-122.5191, 37.53634], [-122.5191, 37.53611], [-122.5192, 37.53612], [-122.51922, 37.53605], [-122.51927, 37.53605], [-122.51928, 37.53612], [-122.51937, 37.53613]]]]} Open Access 1 18796 Point Montara Light Station 1691 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.lighthousefriends.com/light.asp?ID=78 San Mateo 15 0.227 Point Montara Light Station 1982 State Historic or Cultural Area 132 4
16505 16505 16504 {"type": "MultiPolygon", "coordinates": [[[[-122.39192, 37.18671], [-122.39016, 37.18747], [-122.38906, 37.18582], [-122.39084, 37.18507], [-122.39192, 37.18671]]], [[[-122.39909, 37.19271], [-122.39879, 37.19277], [-122.39843, 37.19282], [-122.39827, 37.19293], [-122.39815, 37.19278], [-122.39754, 37.19212], [-122.39735, 37.19186], [-122.39734, 37.19177], [-122.39741, 37.19164], [-122.39743, 37.19154], [-122.39743, 37.19145], [-122.3974, 37.19127], [-122.39684, 37.18991], [-122.39695, 37.18922], [-122.39695, 37.18831], [-122.3969, 37.188], [-122.39625, 37.18556], [-122.39587, 37.18488], [-122.39466, 37.18341], [-122.39441, 37.18317], [-122.39404, 37.18293], [-122.39349, 37.1828], [-122.39348, 37.18284], [-122.39312, 37.18297], [-122.39231, 37.18345], [-122.39156, 37.18376], [-122.39077, 37.18393], [-122.39056, 37.18312], [-122.39065, 37.18311], [-122.39073, 37.18299], [-122.3909, 37.18302], [-122.39105, 37.18295], [-122.39116, 37.18306], [-122.3915, 37.18302], [-122.39167, 37.18302], [-122.39184, 37.18305], [-122.39227, 37.1828], [-122.39252, 37.1826], [-122.39254, 37.18252], [-122.39225, 37.1824], [-122.39239, 37.18204], [-122.39253, 37.18186], [-122.39273, 37.18167], [-122.39297, 37.18166], [-122.39322, 37.18182], [-122.39343, 37.18174], [-122.39353, 37.1815], [-122.39377, 37.18142], [-122.39401, 37.18151], [-122.39425, 37.18141], [-122.39478, 37.18144], [-122.3949, 37.18161], [-122.39488, 37.18201], [-122.39468, 37.18218], [-122.39464, 37.1822], [-122.39455, 37.18239], [-122.39457, 37.18254], [-122.39461, 37.18268], [-122.39469, 37.1828], [-122.39475, 37.18293], [-122.39495, 37.18317], [-122.39502, 37.18329], [-122.39502, 37.18331], [-122.39537, 37.18348], [-122.39561, 37.18372], [-122.39616, 37.18396], [-122.39617, 37.18399], [-122.39616, 37.18403], [-122.39603, 37.18431], [-122.39602, 37.18437], [-122.39605, 37.18446], [-122.39615, 37.18457], [-122.39668, 37.18487], [-122.39675, 37.18494], [-122.39723, 37.18497], [-122.3973, 37.18496], [-122.39736, 37.18491], [-122.39742, 37.18491], [-122.39747, 37.18492], [-122.39749, 37.18494], [-122.39748, 37.18501], [-122.39737, 37.18511], [-122.39732, 37.18523], [-122.39728, 37.18526], [-122.39719, 37.18527], [-122.39716, 37.1853], [-122.39713, 37.1854], [-122.39709, 37.1857], [-122.39709, 37.18596], [-122.39714, 37.18663], [-122.39725, 37.18741], [-122.39739, 37.18793], [-122.39768, 37.18867], [-122.39783, 37.18913], [-122.39789, 37.18945], [-122.39791, 37.18993], [-122.39796, 37.19032], [-122.39801, 37.19058], [-122.39808, 37.19082], [-122.39821, 37.19116], [-122.39846, 37.19165], [-122.39881, 37.19226], [-122.39909, 37.19271]]], [[[-122.40578, 37.19772], [-122.40558, 37.19794], [-122.40552, 37.19808], [-122.40543, 37.1982], [-122.40537, 37.19847], [-122.40537, 37.19861], [-122.40541, 37.19874], [-122.40543, 37.19888], [-122.40539, 37.19902], [-122.40543, 37.19916], [-122.40551, 37.19928], [-122.4055, 37.19942], [-122.40559, 37.19969], [-122.4056, 37.19982], [-122.40554, 37.19996], [-122.40548, 37.20023], [-122.40547, 37.2005], [-122.4055, 37.20064], [-122.40548, 37.20078], [-122.40552, 37.20134], [-122.40564, 37.20161], [-122.40564, 37.20189], [-122.40556, 37.20231], [-122.4055, 37.20244], [-122.40552, 37.20258], [-122.40544, 37.2027], [-122.40544, 37.20284], [-122.40538, 37.20326], [-122.40538, 37.20341], [-122.40554, 37.20366], [-122.40184, 37.2038], [-122.40143, 37.20285], [-122.40133, 37.20255], [-122.40125, 37.20225], [-122.40219, 37.20215], [-122.40219, 37.20213], [-122.40206, 37.20156], [-122.40118, 37.20168], [-122.40105, 37.19985], [-122.40476, 37.20049], [-122.40487, 37.20034], [-122.40509, 37.19738], [-122.40463, 37.19632], [-122.40478, 37.19595], [-122.4043, 37.19541], [-122.40322, 37.19506], [-122.40354, 37.19495], [-122.40356, 37.19502], [-122.40368, 37.19512], [-122.40402, 37.19514], [-122.40409, 37.19526], [-122.40426, 37.19523], [-122.40439, 37.19532], [-122.40455, 37.19538], [-122.40473, 37.19561], [-122.40484, 37.19572], [-122.40493, 37.19584], [-122.40509, 37.1959], [-122.40512, 37.19604], [-122.40496, 37.19608], [-122.4048, 37.19614], [-122.4049, 37.19624], [-122.40493, 37.19637], [-122.40503, 37.19664], [-122.40514, 37.19674], [-122.40515, 37.19688], [-122.40541, 37.19706], [-122.40551, 37.19718], [-122.40546, 37.19731], [-122.40546, 37.19745], [-122.40562, 37.19751], [-122.40553, 37.19761], [-122.40569, 37.1976], [-122.40578, 37.19772]]]]} Open Access 1 18695 Pigeon Point Light Station State Historic Park 1679 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=533 San Mateo 15 80.347 Pigeon Point Light Station SHP 1981 State Historic or Cultural Area 132 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]);