calands: units_with_maps: 7 rows where ACCESS_TYP = 2, COUNTY = 26 and MNG_AG

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

7 rows where ACCESS_TYP = 2, COUNTY = 26 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	COUNTY	ACRES	LABEL_NAME	DES_TP	GAP_STS
2551	2551	2550	{"type": "Polygon", "coordinates": [[[-122.19184, 38.13515], [-122.19158, 38.13526], [-122.19131, 38.13478], [-122.19123, 38.13468], [-122.19099, 38.1342], [-122.19079, 38.13407], [-122.19041, 38.13416], [-122.1903, 38.13436], [-122.18981, 38.13471], [-122.18936, 38.13477], [-122.18846, 38.13375], [-122.18772, 38.13324], [-122.18704, 38.13336], [-122.18679, 38.13315], [-122.18649, 38.13293], [-122.18554, 38.13206], [-122.1861, 38.13174], [-122.18524, 38.13097], [-122.18589, 38.13091], [-122.18631, 38.13097], [-122.18726, 38.13107], [-122.18796, 38.13157], [-122.18847, 38.13188], [-122.18936, 38.13246], [-122.19034, 38.13316], [-122.19067, 38.13331], [-122.1909, 38.13352], [-122.19133, 38.13422], [-122.19156, 38.13457], [-122.19184, 38.13515]]]}	Restricted Access 2	17806	McIntyre Ranch	22040	1365	Vallejo, City of 531	City 2	City Agency 2	http://www.ci.vallejo.ca.us/attractions___events/sports___recreation/parks___trails	City 2	1365	Vallejo, City of 524	City 2	City Agency 2	Solano 26	23.753	McIntyre Ranch	Local Other or Unknown 14	4
3546	3546	3545	{"type": "Polygon", "coordinates": [[[-121.94776, 38.35645], [-121.94605, 38.35706], [-121.94576, 38.3565], [-121.94534, 38.35665], [-121.94491, 38.35597], [-121.94666, 38.35525], [-121.94676, 38.35524], [-121.94734, 38.35568], [-121.94757, 38.3557], [-121.94774, 38.35584], [-121.94776, 38.35645]]]}	Restricted Access 2	28309	Cooper School Park	31609	1364	Vacaville, City of 151	City 2	City Agency 2	http://www.cityofvacaville.com/index.aspx?page=374	City 2	1364	Vacaville, City of 147	City 2	City Agency 2	Solano 26	7.337	Cooper School Park	Local Park 2	4
12476	12476	12475	{"type": "Polygon", "coordinates": [[[-122.00372, 38.35245], [-122.00296, 38.35252], [-122.00294, 38.3523], [-122.00275, 38.35231], [-122.00272, 38.35216], [-122.00244, 38.35216], [-122.00227, 38.35204], [-122.00224, 38.35177], [-122.00199, 38.35177], [-122.00197, 38.35154], [-122.00179, 38.35153], [-122.00176, 38.35144], [-122.00151, 38.35143], [-122.00148, 38.35103], [-122.0019, 38.35074], [-122.00199, 38.35076], [-122.00224, 38.35092], [-122.00243, 38.35107], [-122.00248, 38.35121], [-122.00263, 38.35141], [-122.00357, 38.35193], [-122.00365, 38.352], [-122.00372, 38.35245]]]}	Restricted Access 2	28306	Alamo School Park	31601	1364	Vacaville, City of 151	City 2	City Agency 2	http://www.cityofvacaville.com/index.aspx?page=374	City 2	1364	Vacaville, City of 147	City 2	City Agency 2	Solano 26	4.025	Alamo School Park	Local Park 2	4
12494	12494	12493	{"type": "Polygon", "coordinates": [[[-121.95197, 38.33224], [-121.9516, 38.33235], [-121.95152, 38.33221], [-121.95135, 38.33224], [-121.95129, 38.33217], [-121.95113, 38.33221], [-121.95058, 38.3326], [-121.95066, 38.33278], [-121.95007, 38.33302], [-121.95032, 38.33339], [-121.94992, 38.33336], [-121.94998, 38.33173], [-121.9501, 38.33154], [-121.95021, 38.33142], [-121.95046, 38.33125], [-121.95048, 38.33103], [-121.95196, 38.331], [-121.95197, 38.33224]]]}	Restricted Access 2	28307	Cambridge School Park	31605	1364	Vacaville, City of 151	City 2	City Agency 2	http://www.cityofvacaville.com/index.aspx?page=374	City 2	1364	Vacaville, City of 147	City 2	City Agency 2	Solano 26	6.902	Cambridge School Park	Local Park 2	4
12497	12497	12496	{"type": "Polygon", "coordinates": [[[-122.0039, 38.3646], [-122.00387, 38.36624], [-122.00154, 38.3662], [-122.00153, 38.36566], [-122.00163, 38.36566], [-122.00165, 38.36592], [-122.00216, 38.36593], [-122.00217, 38.36567], [-122.00267, 38.36566], [-122.00267, 38.36535], [-122.00318, 38.36535], [-122.00318, 38.36517], [-122.00274, 38.36462], [-122.00284, 38.36458], [-122.0039, 38.3646]]]}	Restricted Access 2	28311	Hemlock School Park	31596	1364	Vacaville, City of 151	City 2	City Agency 2	http://www.cityofvacaville.com/index.aspx?page=374	City 2	1364	Vacaville, City of 147	City 2	City Agency 2	Solano 26	5.323	Hemlock School Park	Local Park 2	4
12858	12858	12857	{"type": "Polygon", "coordinates": [[[-122.03267, 38.31034], [-122.03263, 38.31122], [-122.03261, 38.31135], [-122.03212, 38.3133], [-122.02898, 38.31232], [-122.02885, 38.31231], [-122.02696, 38.31291], [-122.0254, 38.31237], [-122.02458, 38.31092], [-122.02115, 38.30989], [-122.0203, 38.30958], [-122.01987, 38.30887], [-122.01952, 38.30865], [-122.01898, 38.3085], [-122.01805, 38.30781], [-122.01789, 38.30725], [-122.0191, 38.30705], [-122.02055, 38.30706], [-122.02129, 38.30724], [-122.02334, 38.30805], [-122.02476, 38.30814], [-122.02476, 38.30826], [-122.02483, 38.30887], [-122.0281, 38.30887], [-122.02811, 38.30884], [-122.02937, 38.30929], [-122.02941, 38.30957], [-122.02961, 38.30975], [-122.02986, 38.30979], [-122.03025, 38.30968], [-122.0305, 38.30968], [-122.03063, 38.31002], [-122.03106, 38.31005], [-122.03113, 38.30985], [-122.03152, 38.31008], [-122.03182, 38.31012], [-122.03188, 38.3105], [-122.03204, 38.31066], [-122.03224, 38.31115], [-122.03235, 38.31105], [-122.03267, 38.31034]]]}	Restricted Access 2	22288	Lagoon Valley Gateway Open Space	30789	1364	Vacaville, City of 151	City 2	City Agency 2	http://www.cityofvacaville.com/index.aspx?page=374	City 2	1364	Vacaville, City of 147	City 2	City Agency 2	Solano 26	96.658	Lagoon Valley Gateway OS	Local Recreation Area 3	4
16190	16190	16189	{"type": "Polygon", "coordinates": [[[-122.07441, 38.2671], [-122.07432, 38.26712], [-122.07414, 38.26795], [-122.07374, 38.26798], [-122.07347, 38.2683], [-122.07341, 38.26849], [-122.07314, 38.26846], [-122.07313, 38.26825], [-122.07257, 38.26801], [-122.0722, 38.26781], [-122.07206, 38.26811], [-122.07198, 38.26848], [-122.07166, 38.26846], [-122.07073, 38.2676], [-122.07082, 38.26741], [-122.0699, 38.26709], [-122.06978, 38.26736], [-122.06967, 38.26749], [-122.06963, 38.26774], [-122.06984, 38.26789], [-122.06993, 38.26838], [-122.07034, 38.26877], [-122.06881, 38.26882], [-122.06879, 38.26881], [-122.06831, 38.26887], [-122.06813, 38.26805], [-122.06893, 38.26793], [-122.06894, 38.26789], [-122.06912, 38.26784], [-122.06927, 38.26732], [-122.06918, 38.26687], [-122.06911, 38.26677], [-122.06925, 38.26673], [-122.06995, 38.2666], [-122.07006, 38.26643], [-122.07042, 38.26639], [-122.07077, 38.26616], [-122.07043, 38.2659], [-122.07087, 38.2659], [-122.07109, 38.26574], [-122.07267, 38.26569], [-122.07292, 38.26616], [-122.07349, 38.26677], [-122.07396, 38.26677], [-122.07441, 38.2671]]]}	Restricted Access 2	29160	Spyglass Open Space	25758	1105	Fairfield, City of 208	City 2	City Agency 2	http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp	City 2	1105	Fairfield, City of 204	City 2	City Agency 2	Solano 26	24.304	Spyglass OS	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]);