calands: units_with_maps: 1 row where AGNCY_LEV = 2, DES_TP = 4 and MNG

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

1 row where AGNCY_LEV = 2, DES_TP = 4 and MNG_AGENCY = 289

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
6958	6958	6957	{"type": "MultiPolygon", "coordinates": [[[[-118.42448, 33.76712], [-118.42433, 33.76737], [-118.4229, 33.76779], [-118.42242, 33.76828], [-118.42203, 33.76839], [-118.42169, 33.76882], [-118.42167, 33.76956], [-118.42025, 33.76961], [-118.4196, 33.76941], [-118.41953, 33.76935], [-118.41949, 33.76928], [-118.41949, 33.76917], [-118.41951, 33.76913], [-118.42001, 33.76855], [-118.4206, 33.7689], [-118.4208, 33.76898], [-118.42098, 33.76885], [-118.42117, 33.76876], [-118.42134, 33.7685], [-118.42154, 33.76807], [-118.42167, 33.76799], [-118.42204, 33.76794], [-118.42227, 33.76786], [-118.4223, 33.76765], [-118.42239, 33.76756], [-118.42243, 33.76743], [-118.42247, 33.7674], [-118.42255, 33.76735], [-118.42306, 33.76716], [-118.42326, 33.76712], [-118.42345, 33.76714], [-118.4238, 33.76706], [-118.42405, 33.76708], [-118.42408, 33.76703], [-118.42405, 33.767], [-118.42398, 33.76697], [-118.4239, 33.76683], [-118.42355, 33.76673], [-118.42302, 33.7668], [-118.42275, 33.76679], [-118.4223, 33.76672], [-118.42204, 33.76658], [-118.42191, 33.76645], [-118.42167, 33.76629], [-118.42153, 33.76615], [-118.42146, 33.76618], [-118.42134, 33.76629], [-118.42126, 33.76638], [-118.4212, 33.76649], [-118.42114, 33.76667], [-118.42115, 33.7665], [-118.42113, 33.76635], [-118.42109, 33.7661], [-118.42103, 33.76592], [-118.42094, 33.76571], [-118.42064, 33.76521], [-118.42103, 33.76524], [-118.42113, 33.76517], [-118.42113, 33.76503], [-118.42135, 33.76493], [-118.4215, 33.7648], [-118.42164, 33.76461], [-118.42173, 33.76443], [-118.42169, 33.76421], [-118.4218, 33.76398], [-118.42203, 33.76368], [-118.42203, 33.76364], [-118.422, 33.7636], [-118.42196, 33.76358], [-118.42181, 33.76358], [-118.42146, 33.76341], [-118.42101, 33.76334], [-118.42056, 33.76323], [-118.42022, 33.76316], [-118.42001, 33.76318], [-118.41971, 33.7631], [-118.4196, 33.7631], [-118.4192, 33.76323], [-118.41932, 33.7638], [-118.41937, 33.7639], [-118.41946, 33.76401], [-118.4192, 33.76385], [-118.41888, 33.76369], [-118.41772, 33.76324], [-118.41744, 33.76308], [-118.41719, 33.76289], [-118.4171, 33.76279], [-118.417, 33.76264], [-118.41696, 33.7625], [-118.41786, 33.76238], [-118.41832, 33.76271], [-118.41889, 33.76276], [-118.41992, 33.76264], [-118.42117, 33.76306], [-118.42203, 33.76343], [-118.4224, 33.7636], [-118.42233, 33.76392], [-118.4222, 33.76391], [-118.42204, 33.7643], [-118.42196, 33.76485], [-118.42175, 33.7653], [-118.42186, 33.76568], [-118.42246, 33.76615], [-118.42294, 33.76637], [-118.42391, 33.76622], [-118.42418, 33.76628], [-118.42421, 33.7665], [-118.42448, 33.76712]]], [[[-118.42843, 33.77399], [-118.42814, 33.77456], [-118.42655, 33.7761], [-118.42503, 33.77716], [-118.42448, 33.77786], [-118.42413, 33.78032], [-118.42357, 33.78136], [-118.42203, 33.78351], [-118.41945, 33.78541], [-118.41901, 33.78607], [-118.41849, 33.78649], [-118.41732, 33.78705], [-118.41584, 33.78801], [-118.41481, 33.78827], [-118.41406, 33.78867], [-118.41266, 33.78904], [-118.41182, 33.78952], [-118.41047, 33.78995], [-118.4094, 33.79049], [-118.40748, 33.79103], [-118.40701, 33.79048], [-118.40691, 33.79032], [-118.40878, 33.7895], [-118.40962, 33.78913], [-118.41122, 33.78859], [-118.4115, 33.78854], [-118.41215, 33.78803], [-118.41233, 33.78785], [-118.41253, 33.78771], [-118.41264, 33.78767], [-118.41292, 33.7876], [-118.41362, 33.78758], [-118.41413, 33.78754], [-118.41494, 33.7874], [-118.41553, 33.78723], [-118.41618, 33.78697], [-118.41662, 33.78674], [-118.41733, 33.78631], [-118.41775, 33.78601], [-118.41816, 33.78568], [-118.4188, 33.7851], [-118.41932, 33.78455], [-118.41975, 33.78405], [-118.41974, 33.78412], [-118.41977, 33.78417], [-118.41992, 33.78428], [-118.42026, 33.78401], [-118.42043, 33.78395], [-118.4206, 33.78394], [-118.4207, 33.78389], [-118.4208, 33.78388], [-118.42102, 33.78375], [-118.42116, 33.78353], [-118.42112, 33.78342], [-118.42122, 33.78338], [-118.42141, 33.78307], [-118.42142, 33.78297], [-118.42135, 33.78279], [-118.4214, 33.78267], [-118.42177, 33.78248], [-118.42172, 33.78244], [-118.42169, 33.78221], [-118.42163, 33.78208], [-118.42142, 33.78193], [-118.42151, 33.7818], [-118.42177, 33.78197], [-118.42198, 33.78218], [-118.42204, 33.78208], [-118.42206, 33.78192], [-118.42219, 33.78171], [-118.42238, 33.78158], [-118.42255, 33.78142], [-118.42271, 33.78135], [-118.42308, 33.78103], [-118.42318, 33.78074], [-118.42312, 33.78071], [-118.42338, 33.78036], [-118.42335, 33.78033], [-118.42363, 33.78], [-118.42362, 33.77987], [-118.42354, 33.77983], [-118.42368, 33.77926], [-118.42378, 33.77905], [-118.42344, 33.77903], [-118.42328, 33.77906], [-118.42307, 33.77916], [-118.42297, 33.77925], [-118.42291, 33.77933], [-118.42336, 33.77832], [-118.42373, 33.77741], [-118.42384, 33.77707], [-118.42385, 33.77724], [-118.42391, 33.77736], [-118.42406, 33.7775], [-118.42417, 33.77755], [-118.42468, 33.77687], [-118.42504, 33.77671], [-118.42542, 33.77627], [-118.42576, 33.7761], [-118.42587, 33.77598], [-118.42625, 33.7758], [-118.42648, 33.77548], [-118.42687, 33.77524], [-118.42729, 33.77467], [-118.42764, 33.77445], [-118.42781, 33.77426], [-118.42793, 33.77409], [-118.42797, 33.77395], [-118.42796, 33.77377], [-118.42786, 33.77362], [-118.42752, 33.77354], [-118.42734, 33.77342], [-118.42707, 33.77333], [-118.42695, 33.77323], [-118.42678, 33.77307], [-118.42661, 33.77274], [-118.42642, 33.77268], [-118.42541, 33.77288], [-118.42506, 33.7729], [-118.42468, 33.77297], [-118.42415, 33.77294], [-118.42388, 33.77289], [-118.42373, 33.77353], [-118.42373, 33.77367], [-118.42376, 33.77376], [-118.42343, 33.77346], [-118.42379, 33.77242], [-118.4244, 33.77263], [-118.42497, 33.77266], [-118.42532, 33.77253], [-118.42597, 33.77245], [-118.42647, 33.77231], [-118.42686, 33.77239], [-118.4274, 33.77299], [-118.42814, 33.77347], [-118.42843, 33.77399]]], [[[-118.4062, 33.79896], [-118.40542, 33.79972], [-118.40443, 33.80031], [-118.40291, 33.80093], [-118.40124, 33.80175], [-118.40046, 33.80193], [-118.40011, 33.8022], [-118.39947, 33.80219], [-118.39948, 33.802], [-118.3997, 33.80204], [-118.40013, 33.80198], [-118.40034, 33.80179], [-118.40052, 33.80175], [-118.40066, 33.80175], [-118.40122, 33.80161], [-118.40215, 33.80122], [-118.40224, 33.80108], [-118.40277, 33.80086], [-118.40272, 33.80069], [-118.40367, 33.80042], [-118.40397, 33.8003], [-118.40419, 33.80019], [-118.40451, 33.80001], [-118.40473, 33.79982], [-118.40483, 33.79968], [-118.40488, 33.79958], [-118.40496, 33.79933], [-118.40496, 33.79939], [-118.40499, 33.7995], [-118.40507, 33.7996], [-118.40512, 33.79964], [-118.40538, 33.79943], [-118.40597, 33.79875], [-118.4062, 33.79896]]]]}	Open Access 1	5861	Palos Verdes Shoreline Preserve	23374	1244	Palos Verdes Estates, City of 293	City 2	City Agency 2	http://www.pvestates.org/	City 2	1244	Palos Verdes Estates, City of 289	City 2	City Agency 2		Los Angeles 6	90.056	Palos Verdes Shoreline Preserve	0	Local Conservation Area 4	2

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