calands: units_with_maps: 4 rows where DES_TP = 3, GAP_STS = 4, MNG_AGENCY = 194 and MNG_AG

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

4 rows where DES_TP = 3, GAP_STS = 4, MNG_AGENCY = 194 and MNG_AG_TYP = 2

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
3300	3300	3299	{"type": "Polygon", "coordinates": [[[-122.29705, 37.50541], [-122.29705, 37.50546], [-122.29697, 37.50559], [-122.29687, 37.50551], [-122.29678, 37.50541], [-122.29685, 37.50536], [-122.29697, 37.50534], [-122.29703, 37.50536], [-122.29705, 37.50541]]]}	Open Access 1	48212	Hastings Tot Lot	32752	1025	Belmont, City of 198	City 2	City Agency 2	http://www.belmont.gov/city-hall/park-and-recreation	City 2	1025	Belmont, City of 194	City 2	City Agency 2		San Mateo 15	0.096	Hastings Tot Lot	0	Local Recreation Area 3	4
5455	5455	5454	{"type": "MultiPolygon", "coordinates": [[[[-122.27307, 37.52937], [-122.273, 37.52939], [-122.27271, 37.52934], [-122.27162, 37.52955], [-122.27088, 37.5296], [-122.27068, 37.52954], [-122.27045, 37.52929], [-122.27037, 37.52892], [-122.2712, 37.52894], [-122.27189, 37.52842], [-122.27229, 37.5287], [-122.27262, 37.52896], [-122.27307, 37.52937]]], [[[-122.27363, 37.53109], [-122.27353, 37.53128], [-122.27228, 37.53127], [-122.2718, 37.53075], [-122.27046, 37.53075], [-122.27047, 37.52973], [-122.27089, 37.52987], [-122.27152, 37.52989], [-122.27224, 37.52973], [-122.27264, 37.52966], [-122.27297, 37.52965], [-122.27314, 37.52971], [-122.27339, 37.52994], [-122.27358, 37.53028], [-122.27359, 37.53035], [-122.27356, 37.53076], [-122.27363, 37.53109]]]]}	Open Access 1	24975	Belmont Sports Complex	15996	1025	Belmont, City of 198	City 2	City Agency 2	http://www.belmont.gov/city-hall/park-and-recreation	City 2	1025	Belmont, City of 194	City 2	City Agency 2		San Mateo 15	13.231	Belmont Sports Complex	0	Local Recreation Area 3	4
6447	6447	6446	{"type": "Polygon", "coordinates": [[[-122.31858, 37.50826], [-122.3184, 37.50828], [-122.31742, 37.50808], [-122.31706, 37.50821], [-122.31668, 37.50859], [-122.31616, 37.50867], [-122.31595, 37.50899], [-122.31615, 37.50957], [-122.31609, 37.50994], [-122.31592, 37.50987], [-122.31551, 37.50927], [-122.31494, 37.509], [-122.31446, 37.50912], [-122.31425, 37.50958], [-122.31363, 37.50959], [-122.31324, 37.50998], [-122.313, 37.50955], [-122.30871, 37.51013], [-122.30522, 37.51002], [-122.30536, 37.50954], [-122.30537, 37.50947], [-122.30488, 37.50944], [-122.30458, 37.50929], [-122.30423, 37.50924], [-122.30341, 37.50887], [-122.30307, 37.50882], [-122.3029, 37.50882], [-122.30158, 37.50568], [-122.30093, 37.50585], [-122.30104, 37.5053], [-122.30095, 37.50489], [-122.30035, 37.50437], [-122.30004, 37.50406], [-122.29996, 37.5037], [-122.29918, 37.50395], [-122.29869, 37.50284], [-122.29859, 37.50187], [-122.29749, 37.50218], [-122.29989, 37.50765], [-122.29968, 37.50768], [-122.29967, 37.50738], [-122.29956, 37.50723], [-122.2992, 37.50739], [-122.29918, 37.50736], [-122.29952, 37.5072], [-122.29931, 37.50706], [-122.29926, 37.50688], [-122.29885, 37.50661], [-122.29855, 37.50652], [-122.29842, 37.5064], [-122.29826, 37.50634], [-122.29812, 37.50633], [-122.29772, 37.50634], [-122.2976, 37.50626], [-122.29743, 37.50638], [-122.29719, 37.50585], [-122.29725, 37.50583], [-122.2974, 37.50608], [-122.29762, 37.506], [-122.29784, 37.50587], [-122.29759, 37.50541], [-122.29742, 37.50541], [-122.29731, 37.50544], [-122.29719, 37.50545], [-122.29707, 37.5055], [-122.29721, 37.50578], [-122.29716, 37.5058], [-122.29707, 37.50568], [-122.29697, 37.50559], [-122.29705, 37.50546], [-122.29705, 37.50541], [-122.29703, 37.50536], [-122.29697, 37.50534], [-122.29689, 37.50535], [-122.29678, 37.50541], [-122.29672, 37.50527], [-122.29669, 37.50487], [-122.29693, 37.50475], [-122.29697, 37.50459], [-122.2969, 37.50442], [-122.29682, 37.50431], [-122.2967, 37.50423], [-122.2963, 37.50418], [-122.29614, 37.50428], [-122.29555, 37.50357], [-122.29595, 37.50328], [-122.29577, 37.50306], [-122.29609, 37.50311], [-122.29616, 37.50281], [-122.29589, 37.50276], [-122.29587, 37.50281], [-122.29578, 37.50279], [-122.29577, 37.50281], [-122.29546, 37.50276], [-122.29543, 37.50285], [-122.29522, 37.50267], [-122.29503, 37.50262], [-122.29488, 37.50248], [-122.29435, 37.50216], [-122.29412, 37.50241], [-122.29399, 37.50234], [-122.29436, 37.50194], [-122.29431, 37.5019], [-122.29429, 37.50157], [-122.29413, 37.50141], [-122.29399, 37.50142], [-122.29391, 37.50152], [-122.29405, 37.50178], [-122.2938, 37.50162], [-122.29336, 37.50194], [-122.2933, 37.5019], [-122.29329, 37.50189], [-122.2935, 37.50174], [-122.29341, 37.50141], [-122.29289, 37.50104], [-122.29266, 37.50118], [-122.29264, 37.50107], [-122.29265, 37.50074], [-122.29263, 37.5006], [-122.29258, 37.50049], [-122.29241, 37.5002], [-122.29229, 37.50009], [-122.2921, 37.49997], [-122.29217, 37.49971], [-122.29216, 37.49963], [-122.29212, 37.49954], [-122.29376, 37.49871], [-122.29418, 37.49827], [-122.29456, 37.49849], [-122.29479, 37.49857], [-122.29496, 37.49858], [-122.29512, 37.49857], [-122.29528, 37.49853], [-122.29544, 37.49847], [-122.29564, 37.49831], [-122.29571, 37.49822], [-122.29576, 37.49812], [-122.29531, 37.49793], [-122.29565, 37.49742], [-122.29569, 37.49739], [-122.29623, 37.49732], [-122.29632, 37.49728], [-122.2964, 37.49723], [-122.30055, 37.49991], [-122.30112, 37.4995], [-122.30192, 37.49956], [-122.30232, 37.49954], [-122.30292, 37.49923], [-122.30308, 37.49935], [-122.30323, 37.49949], [-122.30305, 37.49961], [-122.30314, 37.49982], [-122.30329, 37.5], [-122.30377, 37.5004], [-122.3043, 37.50052], [-122.30463, 37.50021], [-122.30487, 37.50027], [-122.3051, 37.50039], [-122.30441, 37.50104], [-122.30378, 37.5016], [-122.30343, 37.50136], [-122.30212, 37.50251], [-122.30247, 37.50276], [-122.30272, 37.50255], [-122.30362, 37.50252], [-122.30381, 37.50265], [-122.30343, 37.50336], [-122.30347, 37.50365], [-122.30375, 37.5037], [-122.30515, 37.5036], [-122.30543, 37.5038], [-122.30517, 37.50455], [-122.3054, 37.50467], [-122.30613, 37.5043], [-122.3065, 37.50457], [-122.30659, 37.50462], [-122.30505, 37.50711], [-122.30592, 37.50792], [-122.30768, 37.508], [-122.30923, 37.5068], [-122.30881, 37.5059], [-122.30777, 37.50541], [-122.30842, 37.5038], [-122.30856, 37.50373], [-122.30916, 37.5046], [-122.30938, 37.50456], [-122.30975, 37.50396], [-122.31054, 37.50373], [-122.3109, 37.50454], [-122.31117, 37.5047], [-122.31265, 37.50443], [-122.31302, 37.50461], [-122.31246, 37.50543], [-122.31236, 37.5075], [-122.31388, 37.50723], [-122.31738, 37.50714], [-122.31775, 37.50703], [-122.31826, 37.50792], [-122.31858, 37.50826]]]}	Open Access 1	1974	Water Dog Lake Canyon	534	1025	Belmont, City of 198	City 2	City Agency 2	http://www.belmont.gov/city-hall/park-and-recreation	City 2	1025	Belmont, City of 194	City 2	City Agency 2	http://www.belmont.gov/Home/Components/FacilityDirectory/FacilityDirectory/10/702	San Mateo 15	276.281	Water Dog Lake Canyon	1975	Local Recreation Area 3	4
8548	8548	8547	{"type": "Polygon", "coordinates": [[[-122.30643, 37.5152], [-122.3063, 37.51554], [-122.30563, 37.51589], [-122.30555, 37.51599], [-122.30558, 37.51659], [-122.30571, 37.51676], [-122.30528, 37.51679], [-122.30504, 37.51605], [-122.30535, 37.51597], [-122.30526, 37.51583], [-122.30523, 37.51565], [-122.30527, 37.5155], [-122.30573, 37.51505], [-122.30599, 37.51496], [-122.30615, 37.51495], [-122.30643, 37.5152]]]}	Open Access 1	13483	Cipriani Field	17261	1025	Belmont, City of 198	City 2	City Agency 2	http://www.belmont.gov/city-hall/park-and-recreation	City 2	1025	Belmont, City of 194	City 2	City Agency 2		San Mateo 15	2.609	Cipriani Field	1985	Local Recreation Area 3	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]);