calands: units_with_maps: 3 rows where AGNCY_TYP = 2, DES_TP = 3 and MNG

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

3 rows where AGNCY_TYP = 2, DES_TP = 3 and MNG_AGENCY = 96

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	YR_EST	DES_TP	GAP_STS
4105	4105	4104	{"type": "Polygon", "coordinates": [[[-122.33426, 37.52088], [-122.33353, 37.52137], [-122.33341, 37.52122], [-122.33305, 37.52137], [-122.33302, 37.52132], [-122.33338, 37.52116], [-122.33334, 37.52099], [-122.33315, 37.52069], [-122.33336, 37.5206], [-122.33307, 37.52029], [-122.33287, 37.51998], [-122.33303, 37.51991], [-122.33426, 37.52088]]]}	Open Access 1	47228	Timberland Open Space	30936	1310	San Mateo, City of 98	City 2	City Agency 2	http://www.cityofsanmateo.org/index.aspx?nid=324	City 2	1310	San Mateo, City of 96	City 2	City Agency 2	San Mateo 15	1.894	Timberland OS	0	Local Recreation Area 3	4
15680	15680	15679	{"type": "Polygon", "coordinates": [[[-122.3278, 37.584], [-122.32787, 37.58495], [-122.32785, 37.58503], [-122.3278, 37.58512], [-122.32454, 37.58738], [-122.32439, 37.58746], [-122.32426, 37.58749], [-122.32339, 37.58752], [-122.32316, 37.58757], [-122.32295, 37.58766], [-122.32265, 37.58791], [-122.32253, 37.58797], [-122.32238, 37.58802], [-122.32142, 37.58816], [-122.32145, 37.58826], [-122.32097, 37.58825], [-122.32072, 37.58807], [-122.3202, 37.58694], [-122.31931, 37.58631], [-122.31857, 37.58615], [-122.31794, 37.58639], [-122.31797, 37.58625], [-122.31788, 37.58596], [-122.31775, 37.58567], [-122.31758, 37.5851], [-122.3241, 37.5806], [-122.3278, 37.584]]]}	Restricted Access 2	14014	San Mateo Municipal Golf Course	33037	1310	San Mateo, City of 98	City 2	City Agency 2	http://www.cityofsanmateo.org/index.aspx?nid=324	City 2	1310	San Mateo, City of 96	City 2	City Agency 2	San Mateo 15	105.785	San Mateo Municipal GC	1933	Local Recreation Area 3	4
15993	15993	15992	{"type": "Polygon", "coordinates": [[[-122.29376, 37.57208], [-122.29375, 37.5721], [-122.29368, 37.57216], [-122.29354, 37.57217], [-122.29315, 37.57217], [-122.29283, 37.57201], [-122.29283, 37.57196], [-122.29274, 37.57193], [-122.29272, 37.5719], [-122.29252, 37.57204], [-122.29247, 37.5721], [-122.29245, 37.57219], [-122.29245, 37.57227], [-122.29249, 37.57238], [-122.29247, 37.57244], [-122.2924, 37.57248], [-122.29229, 37.57248], [-122.29218, 37.57251], [-122.29215, 37.57255], [-122.29214, 37.57261], [-122.29216, 37.57276], [-122.29209, 37.57288], [-122.29195, 37.57302], [-122.29189, 37.57315], [-122.2919, 37.57329], [-122.29219, 37.57352], [-122.29226, 37.57353], [-122.29231, 37.57357], [-122.29233, 37.57364], [-122.29229, 37.57372], [-122.29217, 37.57387], [-122.29196, 37.57404], [-122.29188, 37.57416], [-122.2918, 37.57434], [-122.29169, 37.57447], [-122.29148, 37.57462], [-122.29127, 37.57475], [-122.29105, 37.57486], [-122.29093, 37.57488], [-122.28789, 37.5746], [-122.28789, 37.57075], [-122.28998, 37.57076], [-122.29112, 37.57112], [-122.29202, 37.57144], [-122.29283, 37.57162], [-122.29327, 37.57176], [-122.29349, 37.57185], [-122.2937, 37.57196], [-122.29375, 37.57201], [-122.29376, 37.57208]]]}	Open Access 1	47230	Bay Marshes Open Space	30938	1310	San Mateo, City of 98	City 2	City Agency 2	http://www.cityofsanmateo.org/index.aspx?nid=324	City 2	1310	San Mateo, City of 96	City 2	City Agency 2	San Mateo 15	40.282	Bay Marshes OS	0	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]);