units_with_maps

Table actions

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

1 row where COUNTY = 23 and DES_TP = 153

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 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
1874 1874 1873 {"type": "MultiPolygon", "coordinates": [[[[-122.61561, 38.09426], [-122.61442, 38.09946], [-122.61303, 38.0978], [-122.61249, 38.09808], [-122.61247, 38.09805], [-122.61306, 38.09774], [-122.61342, 38.09727], [-122.6135, 38.09715], [-122.61413, 38.09738], [-122.6146, 38.09657], [-122.61398, 38.09633], [-122.61426, 38.09579], [-122.61395, 38.09568], [-122.61396, 38.09562], [-122.61438, 38.09555], [-122.61416, 38.09521], [-122.61357, 38.09523], [-122.61307, 38.09534], [-122.61282, 38.09479], [-122.6123, 38.09499], [-122.61222, 38.09517], [-122.61218, 38.09516], [-122.61255, 38.09437], [-122.61169, 38.09409], [-122.61165, 38.09402], [-122.61152, 38.09387], [-122.61139, 38.09378], [-122.61161, 38.09349], [-122.61119, 38.09339], [-122.61084, 38.09339], [-122.61016, 38.09354], [-122.60989, 38.09372], [-122.60966, 38.09393], [-122.60951, 38.09416], [-122.6094, 38.09464], [-122.6094, 38.09491], [-122.60923, 38.09494], [-122.6091, 38.09501], [-122.60864, 38.09462], [-122.60839, 38.09496], [-122.60841, 38.09591], [-122.60821, 38.09675], [-122.6083, 38.09729], [-122.60888, 38.09728], [-122.60899, 38.09741], [-122.60885, 38.09747], [-122.60887, 38.09751], [-122.60838, 38.09754], [-122.60836, 38.09807], [-122.60867, 38.09849], [-122.60888, 38.09905], [-122.60877, 38.09906], [-122.60848, 38.09941], [-122.60858, 38.0998], [-122.60908, 38.09999], [-122.60961, 38.10011], [-122.6097, 38.10001], [-122.61007, 38.10029], [-122.61033, 38.10081], [-122.61076, 38.10069], [-122.61084, 38.10086], [-122.6102, 38.10106], [-122.60996, 38.10099], [-122.60951, 38.10025], [-122.60877, 38.10009], [-122.60845, 38.09995], [-122.60828, 38.09962], [-122.60827, 38.09932], [-122.60866, 38.09894], [-122.60851, 38.09855], [-122.60845, 38.09847], [-122.6063, 38.09751], [-122.60833, 38.09474], [-122.60859, 38.09448], [-122.609, 38.09481], [-122.60929, 38.09441], [-122.60931, 38.09405], [-122.60954, 38.09375], [-122.60981, 38.09368], [-122.61029, 38.09335], [-122.61123, 38.093], [-122.6116, 38.09279], [-122.61368, 38.09432], [-122.61449, 38.09381], [-122.61561, 38.09426]]], [[[-122.61166, 38.09956], [-122.61166, 38.09957], [-122.61109, 38.09958], [-122.61092, 38.09951], [-122.61105, 38.09944], [-122.6114, 38.09953], [-122.61166, 38.09956]]], [[[-122.61422, 38.10051], [-122.61422, 38.10064], [-122.6141, 38.10125], [-122.613, 38.10123], [-122.61246, 38.10146], [-122.61187, 38.10159], [-122.61149, 38.1014], [-122.61134, 38.1013], [-122.61255, 38.10103], [-122.613, 38.10064], [-122.61273, 38.1003], [-122.61294, 38.10019], [-122.61298, 38.10003], [-122.61249, 38.0994], [-122.61252, 38.09939], [-122.61281, 38.09974], [-122.61289, 38.09975], [-122.61364, 38.10067], [-122.61422, 38.10051]]], [[[-122.61482, 38.10239], [-122.61404, 38.10248], [-122.61368, 38.10266], [-122.6136, 38.10252], [-122.61389, 38.10236], [-122.61407, 38.10217], [-122.6141, 38.10204], [-122.61397, 38.10191], [-122.61408, 38.1018], [-122.61412, 38.10178], [-122.6142, 38.1018], [-122.61414, 38.10209], [-122.61457, 38.10212], [-122.61476, 38.10202], [-122.61482, 38.10239]]], [[[-122.61463, 38.09971], [-122.61455, 38.10011], [-122.6143, 38.10025], [-122.61425, 38.10019], [-122.61449, 38.10006], [-122.61458, 38.09964], [-122.61463, 38.09971]]]]} Open Access 1 16029 Novato Lands 008 22918 1226 Novato, City of 444 City 2 City Agency 2 http://www.ci.novato.ca.us/Index.aspx?page=520 City 2 1226 Novato, City of 438 City 2 City Agency 2   Marin 23 40.983 Novato Lands 008   None 153  

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