calands: units_with_maps: 1 row where COUNTY = 40, DES_TP = 132 and MNG

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

1 row where COUNTY = 40, DES_TP = 132 and MNG_AGENCY = 47

Search:

descending

This data as json, copyable, CSV (advanced)

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
16501	16501	16500	{"type": "MultiPolygon", "coordinates": [[[[-122.6137, 38.92436], [-122.61259, 38.92436], [-122.6125, 38.9241], [-122.61244, 38.92371], [-122.61213, 38.92371], [-122.61214, 38.92357], [-122.61214, 38.92289], [-122.61212, 38.92272], [-122.61175, 38.92101], [-122.61177, 38.92085], [-122.61196, 38.92047], [-122.61199, 38.92036], [-122.612, 38.92028], [-122.61198, 38.92016], [-122.61194, 38.92004], [-122.61174, 38.91971], [-122.6116, 38.9195], [-122.6114, 38.91928], [-122.6112, 38.91909], [-122.61098, 38.91891], [-122.61044, 38.91858], [-122.61079, 38.91823], [-122.612, 38.91871], [-122.61208, 38.91925], [-122.61215, 38.91954], [-122.61217, 38.91955], [-122.6123, 38.92006], [-122.6125, 38.92076], [-122.61249, 38.92078], [-122.61278, 38.92183], [-122.61279, 38.92211], [-122.61286, 38.92233], [-122.61361, 38.92419], [-122.61367, 38.92426], [-122.6137, 38.92436]]], [[[-122.65537, 38.93773], [-122.65528, 38.93797], [-122.65412, 38.93822], [-122.65316, 38.93918], [-122.6531, 38.93971], [-122.65177, 38.94069], [-122.65153, 38.94055], [-122.65137, 38.94049], [-122.65095, 38.94038], [-122.65064, 38.94023], [-122.65003, 38.94003], [-122.64934, 38.93952], [-122.6491, 38.93941], [-122.64865, 38.93892], [-122.64818, 38.9386], [-122.6479, 38.93836], [-122.64712, 38.93799], [-122.64669, 38.93775], [-122.64621, 38.9373], [-122.64604, 38.9372], [-122.64573, 38.93691], [-122.64572, 38.93683], [-122.64563, 38.93675], [-122.6456, 38.93677], [-122.64558, 38.93676], [-122.64551, 38.93666], [-122.64556, 38.93651], [-122.64553, 38.93641], [-122.64561, 38.93602], [-122.64571, 38.93582], [-122.64568, 38.93552], [-122.64448, 38.93519], [-122.64444, 38.93532], [-122.64426, 38.93564], [-122.6442, 38.93569], [-122.64398, 38.93582], [-122.64373, 38.93606], [-122.64367, 38.93613], [-122.64367, 38.93621], [-122.64362, 38.93628], [-122.64349, 38.93633], [-122.64342, 38.93633], [-122.64336, 38.93631], [-122.64327, 38.93621], [-122.64327, 38.9361], [-122.64325, 38.93605], [-122.64108, 38.93787], [-122.63677, 38.938], [-122.63673, 38.93807], [-122.63623, 38.9383], [-122.6363, 38.93853], [-122.63621, 38.93876], [-122.63392, 38.9387], [-122.63313, 38.93878], [-122.63304, 38.93906], [-122.6315, 38.93908], [-122.63149, 38.93901], [-122.631, 38.93905], [-122.631, 38.93894], [-122.63135, 38.9389], [-122.63138, 38.93777], [-122.63193, 38.93776], [-122.63194, 38.93763], [-122.63196, 38.93767], [-122.63201, 38.93769], [-122.63309, 38.93765], [-122.6331, 38.93585], [-122.63202, 38.93584], [-122.63198, 38.93586], [-122.63195, 38.9359], [-122.63195, 38.93576], [-122.63139, 38.93576], [-122.63141, 38.93353], [-122.63153, 38.9318], [-122.63103, 38.93199], [-122.6307, 38.93203], [-122.63043, 38.93185], [-122.63022, 38.93122], [-122.62962, 38.9308], [-122.62921, 38.93029], [-122.62782, 38.93007], [-122.62721, 38.92968], [-122.6265, 38.9295], [-122.62443, 38.92868], [-122.62369, 38.92807], [-122.62331, 38.92795], [-122.62319, 38.92795], [-122.62264, 38.92777], [-122.62224, 38.92768], [-122.62146, 38.92763], [-122.62104, 38.92756], [-122.62076, 38.92743], [-122.6206, 38.9273], [-122.62043, 38.92711], [-122.62038, 38.92691], [-122.62037, 38.92669], [-122.62002, 38.92625], [-122.61971, 38.92619], [-122.61926, 38.92617], [-122.61902, 38.92622], [-122.61874, 38.92619], [-122.61842, 38.92606], [-122.61803, 38.9258], [-122.61733, 38.92555], [-122.61648, 38.9253], [-122.61589, 38.92523], [-122.61549, 38.92531], [-122.61464, 38.92533], [-122.61451, 38.92514], [-122.61468, 38.92519], [-122.61496, 38.9252], [-122.61505, 38.92516], [-122.61511, 38.92505], [-122.6147, 38.92459], [-122.61437, 38.92413], [-122.61402, 38.92358], [-122.61374, 38.92299], [-122.61363, 38.92274], [-122.61297, 38.92043], [-122.61267, 38.91929], [-122.61274, 38.91919], [-122.61286, 38.91916], [-122.61305, 38.91917], [-122.61332, 38.91925], [-122.6136, 38.9194], [-122.61379, 38.91948], [-122.61397, 38.91953], [-122.61416, 38.91955], [-122.61417, 38.92043], [-122.61898, 38.92044], [-122.619, 38.91759], [-122.6323, 38.91758], [-122.64189, 38.9176], [-122.64171, 38.91871], [-122.64529, 38.91946], [-122.64519, 38.92016], [-122.64726, 38.9204], [-122.65082, 38.91744], [-122.65089, 38.92472], [-122.65125, 38.93212], [-122.65138, 38.9352], [-122.65035, 38.9352], [-122.65037, 38.93623], [-122.65142, 38.93624], [-122.65142, 38.93608], [-122.65198, 38.93609], [-122.65197, 38.93585], [-122.65504, 38.93587], [-122.65532, 38.93687], [-122.65501, 38.93735], [-122.65444, 38.93792], [-122.65445, 38.93792], [-122.65537, 38.93773]]]]}	Open Access 1	14884	Anderson Marsh State Historic Park	1391	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=483	Lake 40	1354.255	Anderson Marsh SHP	1982	State Historic or Cultural Area 132	4

Advanced export

JSON shape: default, array, newline-delimited

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