units_with_maps

Table actions

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

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

This data as json, copyable, CSV (advanced)

ACCESS_TYP 2

MNG_AG_TYP 1

MNG_AGENCY 1

  • San Mateo, City of · 3 ✖

DES_TP 1

  • Local Recreation Area · 3 ✖
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
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

CSV options: 

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]);