calands: units_with_maps: 1 row where AGNCY

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

1 row where AGNCY_NAME = 907

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	PARK_URL	COUNTY	ACRES	LABEL_NAME	YR_EST	DES_TP	GAP_STS
9293	9293	9292	{"type": "Polygon", "coordinates": [[[-122.33272, 37.80548], [-122.33211, 37.80596], [-122.33226, 37.80633], [-122.33185, 37.80641], [-122.33188, 37.80651], [-122.33128, 37.80669], [-122.33018, 37.80715], [-122.32968, 37.8073], [-122.32911, 37.80741], [-122.32832, 37.80746], [-122.32745, 37.80745], [-122.32667, 37.8074], [-122.3259, 37.8073], [-122.32262, 37.80667], [-122.32252, 37.80661], [-122.3225, 37.80656], [-122.32252, 37.80613], [-122.32248, 37.80579], [-122.32237, 37.80541], [-122.32221, 37.80509], [-122.32267, 37.8052], [-122.32518, 37.79906], [-122.32546, 37.79913], [-122.32636, 37.79902], [-122.32644, 37.79904], [-122.32645, 37.79907], [-122.32628, 37.79949], [-122.32631, 37.79952], [-122.32664, 37.79961], [-122.32677, 37.79957], [-122.32693, 37.79919], [-122.32697, 37.79918], [-122.33, 37.79996], [-122.33008, 37.80006], [-122.33021, 37.80017], [-122.33009, 37.80036], [-122.32992, 37.80033], [-122.32948, 37.80032], [-122.32946, 37.80037], [-122.32976, 37.80065], [-122.32963, 37.80074], [-122.32919, 37.80054], [-122.32896, 37.80052], [-122.32854, 37.80054], [-122.32832, 37.8005], [-122.32818, 37.80045], [-122.32772, 37.80021], [-122.32734, 37.80005], [-122.32673, 37.80033], [-122.32556, 37.80009], [-122.32521, 37.80008], [-122.32516, 37.80009], [-122.32511, 37.80012], [-122.32506, 37.80029], [-122.325, 37.80041], [-122.3248, 37.80067], [-122.32458, 37.80125], [-122.32513, 37.80139], [-122.3251, 37.80146], [-122.32462, 37.80136], [-122.32456, 37.80152], [-122.32456, 37.80169], [-122.32449, 37.80192], [-122.32441, 37.80235], [-122.32443, 37.80279], [-122.32452, 37.80305], [-122.325, 37.80315], [-122.32498, 37.80323], [-122.32462, 37.80316], [-122.32455, 37.80323], [-122.32451, 37.80332], [-122.32449, 37.80342], [-122.3245, 37.8035], [-122.32462, 37.80375], [-122.32496, 37.80462], [-122.32512, 37.80509], [-122.32523, 37.80511], [-122.32525, 37.8051], [-122.32588, 37.80523], [-122.32591, 37.80516], [-122.32639, 37.80526], [-122.32649, 37.80535], [-122.32648, 37.80545], [-122.32494, 37.80666], [-122.32494, 37.80667], [-122.32508, 37.80676], [-122.32539, 37.80685], [-122.32628, 37.80702], [-122.32662, 37.80695], [-122.32665, 37.80696], [-122.32668, 37.807], [-122.32667, 37.80709], [-122.32669, 37.80713], [-122.32672, 37.80716], [-122.32677, 37.80718], [-122.32685, 37.80716], [-122.32692, 37.8071], [-122.32701, 37.80706], [-122.32735, 37.80717], [-122.3277, 37.80724], [-122.32806, 37.80728], [-122.32842, 37.80729], [-122.32873, 37.80726], [-122.32925, 37.80717], [-122.32985, 37.8071], [-122.33004, 37.80705], [-122.33049, 37.80684], [-122.33078, 37.80673], [-122.33098, 37.80662], [-122.33119, 37.80646], [-122.33129, 37.80642], [-122.3314, 37.8064], [-122.33161, 37.80624], [-122.33156, 37.80618], [-122.3326, 37.80538], [-122.33272, 37.80548]]]}	Open Access 1	15481	Middle Harbor Shoreline Park	22208	2286	Port of Oakland 907	Special District 4	Port/Harbor District 15	http://www.portofoakland.com/	Special District 4	2032	East Bay Regional Park District 87	Special District 4	Recreation/Parks District 4		Alameda 17	41.418	Middle Harbor Shoreline Park	2002	Local Park 2	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]);