calands: units_with_maps: 1 row where DES_TP = 104, MNG_AGENCY = 279 and SUID

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

1 row where DES_TP = 104, MNG_AGENCY = 279 and SUID_NMA = 24150

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
14745	14745	14744	{"type": "MultiPolygon", "coordinates": [[[[-117.11049, 33.29365], [-117.1103, 33.29404], [-117.11018, 33.29456], [-117.10973, 33.29441], [-117.10966, 33.29574], [-117.10934, 33.29638], [-117.10919, 33.29704], [-117.10856, 33.29701], [-117.1084, 33.29701], [-117.108, 33.29706], [-117.10539, 33.297], [-117.10342, 33.29701], [-117.10349, 33.29514], [-117.09361, 33.29524], [-117.09359, 33.29573], [-117.0939, 33.29709], [-117.09237, 33.29711], [-117.09236, 33.29895], [-117.08717, 33.29898], [-117.08717, 33.299], [-117.08758, 33.2997], [-117.08627, 33.2997], [-117.08578, 33.29899], [-117.08578, 33.29765], [-117.08601, 33.29714], [-117.08607, 33.29696], [-117.08675, 33.29551], [-117.08682, 33.2954], [-117.08689, 33.29514], [-117.08695, 33.29469], [-117.08703, 33.29393], [-117.08691, 33.29353], [-117.08651, 33.29263], [-117.08649, 33.29248], [-117.08633, 33.29237], [-117.08624, 33.29225], [-117.08614, 33.29206], [-117.08592, 33.29176], [-117.08553, 33.29148], [-117.08417, 33.29035], [-117.08402, 33.29019], [-117.08374, 33.2898], [-117.08357, 33.2894], [-117.08345, 33.2891], [-117.08344, 33.28894], [-117.08347, 33.2886], [-117.08347, 33.28849], [-117.08343, 33.2884], [-117.08337, 33.2883], [-117.08379, 33.28608], [-117.08366, 33.28608], [-117.08323, 33.2884], [-117.08322, 33.28867], [-117.08326, 33.28898], [-117.08322, 33.28899], [-117.08323, 33.28913], [-117.08341, 33.28973], [-117.08124, 33.28975], [-117.08127, 33.29053], [-117.08133, 33.29159], [-117.08062, 33.29177], [-117.08021, 33.29189], [-117.07879, 33.29235], [-117.07696, 33.2916], [-117.07696, 33.28976], [-117.07557, 33.28977], [-117.07543, 33.2898], [-117.07501, 33.28999], [-117.07487, 33.29007], [-117.07468, 33.29015], [-117.07438, 33.29036], [-117.07403, 33.29055], [-117.07393, 33.29064], [-117.07384, 33.29074], [-117.07377, 33.2908], [-117.07299, 33.29116], [-117.07275, 33.29112], [-117.07266, 33.29109], [-117.07259, 33.29103], [-117.07252, 33.29085], [-117.0721, 33.29005], [-117.07207, 33.29002], [-117.07148, 33.28984], [-117.07179, 33.28884], [-117.07215, 33.28903], [-117.07231, 33.2893], [-117.07268, 33.2904], [-117.07296, 33.2908], [-117.07345, 33.29061], [-117.0736, 33.29021], [-117.07394, 33.28991], [-117.07375, 33.28943], [-117.07386, 33.28913], [-117.07385, 33.28881], [-117.07414, 33.28832], [-117.07424, 33.28805], [-117.0745, 33.28774], [-117.07523, 33.28763], [-117.07565, 33.28742], [-117.07575, 33.2871], [-117.0762, 33.28686], [-117.07699, 33.28671], [-117.07699, 33.28419], [-117.08377, 33.28415], [-117.08378, 33.28411], [-117.08375, 33.28402], [-117.08356, 33.28372], [-117.0835, 33.28358], [-117.08347, 33.2834], [-117.08349, 33.28312], [-117.08578, 33.28314], [-117.0858, 33.28237], [-117.09026, 33.28235], [-117.09032, 33.28598], [-117.09412, 33.28591], [-117.0936, 33.28821], [-117.09497, 33.28826], [-117.09604, 33.28865], [-117.09643, 33.289], [-117.09718, 33.28857], [-117.09767, 33.28865], [-117.09805, 33.28835], [-117.09809, 33.28783], [-117.0986, 33.28763], [-117.09951, 33.28799], [-117.10078, 33.2877], [-117.10134, 33.28734], [-117.102, 33.2874], [-117.10224, 33.28696], [-117.10221, 33.2864], [-117.10192, 33.28561], [-117.10078, 33.2841], [-117.10097, 33.28334], [-117.09984, 33.28219], [-117.09941, 33.28162], [-117.09963, 33.28147], [-117.10078, 33.281], [-117.10118, 33.27924], [-117.10211, 33.27739], [-117.10345, 33.27742], [-117.1035, 33.27854], [-117.10541, 33.27853], [-117.10554, 33.28213], [-117.10477, 33.28215], [-117.1049, 33.28577], [-117.10488, 33.28619], [-117.10378, 33.28685], [-117.10371, 33.28889], [-117.10394, 33.28921], [-117.10401, 33.28977], [-117.10464, 33.28998], [-117.10631, 33.29012], [-117.10702, 33.29041], [-117.10735, 33.29025], [-117.10764, 33.29071], [-117.10777, 33.29107], [-117.10791, 33.29246], [-117.10809, 33.29246], [-117.10885, 33.29254], [-117.10944, 33.29314], [-117.11009, 33.29351], [-117.11049, 33.29365]], [[-117.09382, 33.28838], [-117.09381, 33.28837], [-117.09373, 33.28837], [-117.09371, 33.28847], [-117.0938, 33.28847], [-117.09382, 33.28838]]], [[[-117.08213, 33.28987], [-117.08177, 33.29006], [-117.08144, 33.29027], [-117.08143, 33.28986], [-117.08213, 33.28987]]], [[[-117.0864, 33.29585], [-117.0863, 33.29593], [-117.0863, 33.29598], [-117.08622, 33.29609], [-117.08608, 33.29602], [-117.08597, 33.29601], [-117.08367, 33.29624], [-117.08343, 33.29622], [-117.08309, 33.29612], [-117.08292, 33.29603], [-117.08276, 33.2959], [-117.08264, 33.29571], [-117.08236, 33.29487], [-117.08152, 33.29279], [-117.08151, 33.29269], [-117.0815, 33.29164], [-117.08145, 33.2905], [-117.08153, 33.29038], [-117.08175, 33.29023], [-117.08203, 33.29007], [-117.08237, 33.28992], [-117.08251, 33.28987], [-117.08347, 33.28987], [-117.08418, 33.29062], [-117.08474, 33.29111], [-117.08495, 33.29134], [-117.08526, 33.29154], [-117.08547, 33.29175], [-117.08559, 33.2919], [-117.08595, 33.29219], [-117.08614, 33.29242], [-117.08617, 33.29249], [-117.08624, 33.29258], [-117.08644, 33.29306], [-117.08658, 33.29329], [-117.08674, 33.29397], [-117.08671, 33.29421], [-117.0866, 33.29439], [-117.08661, 33.29466], [-117.08658, 33.29495], [-117.08649, 33.2953], [-117.08648, 33.2956], [-117.08642, 33.29575], [-117.0864, 33.29585]]]]}	Unknown Access 4	45088	Rancho Lilac Mitigation Site	24150	205	California Department of Transportation 283	State 5	State Agency 5	http://www.dot.ca.gov/	Other State 5	205	California Department of Transportation 279	State 5	State Agency 5		San Diego 4	909.984	Rancho Lilac Mitigation Site	0	State Other or Unknown 104	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]);