units_with_maps

Table actions

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

1 row where AGNCY_NAME = 352, DES_TP = 796 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 1 ✖

MNG_AGENCY 1

DES_TP 1

ACCESS_TYP 1

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
9564 9564 9563 {"type": "MultiPolygon", "coordinates": [[[[-122.47967, 37.99133], [-122.47876, 37.99149], [-122.47847, 37.99139], [-122.4781, 37.99207], [-122.47802, 37.99231], [-122.47801, 37.99248], [-122.47802, 37.99258], [-122.47807, 37.99274], [-122.47814, 37.99288], [-122.47797, 37.99295], [-122.47797, 37.99297], [-122.47775, 37.99307], [-122.47782, 37.99319], [-122.4777, 37.99323], [-122.47771, 37.99326], [-122.47747, 37.99338], [-122.47732, 37.9935], [-122.477, 37.99325], [-122.47696, 37.9933], [-122.4772, 37.99354], [-122.47695, 37.99371], [-122.47667, 37.9938], [-122.47618, 37.99389], [-122.4759, 37.99402], [-122.47562, 37.99422], [-122.47534, 37.99439], [-122.47503, 37.99451], [-122.4747, 37.99459], [-122.47435, 37.99463], [-122.47417, 37.99463], [-122.47374, 37.99457], [-122.47368, 37.99448], [-122.47378, 37.99422], [-122.47366, 37.99418], [-122.4735, 37.99442], [-122.47337, 37.99446], [-122.47315, 37.99433], [-122.47354, 37.99367], [-122.47536, 37.99304], [-122.47626, 37.99247], [-122.47643, 37.9919], [-122.47667, 37.99171], [-122.47687, 37.99105], [-122.47651, 37.99043], [-122.47619, 37.99007], [-122.47521, 37.99], [-122.47538, 37.98977], [-122.47566, 37.98967], [-122.47596, 37.98963], [-122.47617, 37.98963], [-122.47639, 37.98966], [-122.47662, 37.98974], [-122.47689, 37.98989], [-122.47719, 37.98965], [-122.47719, 37.98959], [-122.47724, 37.98958], [-122.47764, 37.98988], [-122.4781, 37.98923], [-122.47779, 37.98908], [-122.47762, 37.98892], [-122.47741, 37.98889], [-122.47738, 37.9889], [-122.47717, 37.9888], [-122.47724, 37.98828], [-122.4791, 37.98917], [-122.47967, 37.99133]]], [[[-122.48487, 37.99127], [-122.48339, 37.99239], [-122.48339, 37.99591], [-122.4832, 37.99591], [-122.48246, 37.9954], [-122.48252, 37.99532], [-122.48218, 37.99509], [-122.48221, 37.99504], [-122.4825, 37.9951], [-122.48261, 37.99501], [-122.48265, 37.99469], [-122.48194, 37.99375], [-122.48157, 37.99353], [-122.48091, 37.9927], [-122.48085, 37.99217], [-122.4809, 37.99195], [-122.48118, 37.992], [-122.48152, 37.99172], [-122.48187, 37.992], [-122.48273, 37.9915], [-122.48271, 37.99114], [-122.48206, 37.9909], [-122.48206, 37.99035], [-122.48264, 37.99001], [-122.4829, 37.99038], [-122.48358, 37.99016], [-122.48487, 37.99127]]], [[[-122.48271, 37.98413], [-122.48201, 37.98442], [-122.48181, 37.98346], [-122.48254, 37.98297], [-122.48271, 37.98413]]]]} Open Access 1 16089 San Rafael Lands 009 24980 1312 San Rafael, City of 352 City 2 City Agency 2 http://www.cityofsanrafael.org/comsvcs-home/ City 2 1312 San Rafael, City of 349 City 2 City Agency 2   Marin 23 58.47 San Rafael Lands 009   None 796  

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