calands: units_with_maps: 1 row where DES_TP = 65 and MNG

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

1 row where DES_TP = 65 and MNG_AGENCY = 358

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
15972	15972	15971	{"type": "Polygon", "coordinates": [[[-122.03205, 38.21576], [-122.03199, 38.2159], [-122.03163, 38.21621], [-122.03151, 38.21621], [-122.0312, 38.21632], [-122.02996, 38.21683], [-122.02982, 38.21715], [-122.02989, 38.21743], [-122.03, 38.21828], [-122.02988, 38.21849], [-122.03008, 38.21854], [-122.02997, 38.21896], [-122.02979, 38.21912], [-122.02965, 38.21923], [-122.0293, 38.21942], [-122.02899, 38.21912], [-122.02876, 38.21895], [-122.02842, 38.21862], [-122.02802, 38.21838], [-122.02759, 38.21816], [-122.02704, 38.218], [-122.02616, 38.21841], [-122.02546, 38.21854], [-122.02498, 38.2186], [-122.0247, 38.21905], [-122.02456, 38.21939], [-122.02449, 38.21949], [-122.02424, 38.21965], [-122.02444, 38.21995], [-122.0246, 38.22035], [-122.02464, 38.22068], [-122.02503, 38.22075], [-122.02535, 38.22074], [-122.02631, 38.2206], [-122.02662, 38.22052], [-122.02702, 38.22081], [-122.02695, 38.22124], [-122.02682, 38.22172], [-122.02666, 38.22202], [-122.02642, 38.22235], [-122.02612, 38.22229], [-122.02602, 38.22201], [-122.02602, 38.22161], [-122.02594, 38.22134], [-122.02578, 38.2212], [-122.02545, 38.22117], [-122.02506, 38.22117], [-122.02465, 38.22132], [-122.02394, 38.22167], [-122.02374, 38.22182], [-122.02316, 38.22212], [-122.02297, 38.22213], [-122.02257, 38.22221], [-122.02236, 38.22267], [-122.02214, 38.22292], [-122.02183, 38.22353], [-122.02184, 38.22393], [-122.02184, 38.22458], [-122.02197, 38.22501], [-122.02223, 38.22511], [-122.02252, 38.22533], [-122.02299, 38.22561], [-122.02322, 38.22563], [-122.02358, 38.22595], [-122.02342, 38.22609], [-122.02316, 38.22615], [-122.02292, 38.2261], [-122.02254, 38.22589], [-122.02178, 38.22575], [-122.02146, 38.22582], [-122.02121, 38.22602], [-122.02104, 38.22631], [-122.0211, 38.22692], [-122.02113, 38.22742], [-122.02102, 38.22784], [-122.02082, 38.228], [-122.02048, 38.22815], [-122.01981, 38.22829], [-122.01943, 38.22827], [-122.01908, 38.22809], [-122.01902, 38.22767], [-122.01914, 38.22729], [-122.01945, 38.22684], [-122.01948, 38.22656], [-122.01984, 38.22618], [-122.0202, 38.22587], [-122.02035, 38.22571], [-122.02052, 38.22534], [-122.01997, 38.22483], [-122.01969, 38.22454], [-122.01937, 38.22414], [-122.01921, 38.22369], [-122.01907, 38.22316], [-122.01898, 38.22308], [-122.01867, 38.22305], [-122.01791, 38.2228], [-122.01747, 38.22286], [-122.01737, 38.22295], [-122.01697, 38.22313], [-122.01672, 38.22319], [-122.01659, 38.22342], [-122.01653, 38.2236], [-122.01658, 38.22396], [-122.01683, 38.22407], [-122.01709, 38.22409], [-122.01756, 38.22419], [-122.01773, 38.22449], [-122.01769, 38.22496], [-122.01767, 38.22536], [-122.01778, 38.22552], [-122.01793, 38.22587], [-122.01795, 38.2262], [-122.01779, 38.2263], [-122.01618, 38.22606], [-122.01579, 38.22595], [-122.01546, 38.22574], [-122.0151, 38.22524], [-122.01477, 38.22523], [-122.01482, 38.22521], [-122.01484, 38.22468], [-122.01437, 38.2236], [-122.0141, 38.2234], [-122.01411, 38.22336], [-122.01403, 38.22316], [-122.0139, 38.22309], [-122.01369, 38.22307], [-122.01342, 38.22311], [-122.0126, 38.22025], [-122.01138, 38.21489], [-122.00995, 38.20984], [-122.00725, 38.2096], [-122.0092, 38.20838], [-122.01085, 38.20677], [-122.01103, 38.20618], [-122.01111, 38.20527], [-122.0107, 38.20449], [-122.01077, 38.20419], [-122.00984, 38.2012], [-122.00988, 38.20067], [-122.00984, 38.20046], [-122.00968, 38.20013], [-122.00919, 38.19981], [-122.00887, 38.19871], [-122.00914, 38.19868], [-122.01003, 38.19839], [-122.01131, 38.19751], [-122.01221, 38.1968], [-122.01242, 38.19647], [-122.01243, 38.19644], [-122.01245, 38.19643], [-122.01261, 38.19616], [-122.01264, 38.19587], [-122.01299, 38.19559], [-122.01476, 38.19522], [-122.01842, 38.19498], [-122.02227, 38.19512], [-122.02309, 38.1953], [-122.02456, 38.19596], [-122.02561, 38.1966], [-122.02651, 38.19755], [-122.02732, 38.19869], [-122.02729, 38.19956], [-122.02677, 38.2008], [-122.027, 38.20186], [-122.02653, 38.20294], [-122.02575, 38.20342], [-122.02566, 38.2037], [-122.02575, 38.20399], [-122.0261, 38.20441], [-122.02659, 38.20487], [-122.02697, 38.20519], [-122.0281, 38.20569], [-122.02938, 38.20615], [-122.02998, 38.2067], [-122.03045, 38.20725], [-122.03045, 38.20729], [-122.03074, 38.20743], [-122.03134, 38.20828], [-122.03036, 38.20808], [-122.02981, 38.20872], [-122.02978, 38.20901], [-122.02961, 38.2092], [-122.02961, 38.20931], [-122.02978, 38.20947], [-122.03013, 38.20961], [-122.03027, 38.21036], [-122.03036, 38.21048], [-122.03036, 38.21073], [-122.03065, 38.21137], [-122.03076, 38.21167], [-122.03074, 38.21201], [-122.03001, 38.21281], [-122.03001, 38.21359], [-122.03062, 38.21482], [-122.0314, 38.2149], [-122.03205, 38.21576]]]}	Open Access 1	308	Rush Ranch Open Space	12546	3081	Solano Land Trust 361	Non Profit 6	Non Profit - Land Trust 10	http://www.solanolandtrust.org/	Non Governmental Organization 10	3081	Solano Land Trust 358	Non Profit 6	Non Profit - Land Trust 10	http://www.solanolandtrust.org/RushRanch.aspx	Solano 26	1177.494	Rush Ranch OS	1987	Private Recreation or Education 65	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]);