superunits_with_maps

Table actions

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

1 row where ACCESS_TYP = 3, LABEL_NAME = "MSCP OSP Land" and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 1 ✖

MNG_AGENCY 1

ACCESS_TYP 1

  • No Public Access · 1 ✖
Link rowid ▼ id map ACCESS_TYP PARK_NAME PARK_URL SUID_NMA MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP AGNCY_WEB LAYER ACRES LABEL_NAME YR_EST
14712 14712 14711 {"type": "MultiPolygon", "coordinates": [[[[-116.68414, 32.63592], [-116.68408, 32.63754], [-116.68186, 32.63754], [-116.68193, 32.63587], [-116.68414, 32.63592]]], [[[-116.73738, 32.62107], [-116.72054, 32.62112], [-116.72052, 32.62207], [-116.72052, 32.62295], [-116.71171, 32.62354], [-116.71149, 32.62647], [-116.70719, 32.6268], [-116.70737, 32.63295], [-116.69486, 32.63301], [-116.6948, 32.63927], [-116.69518, 32.64285], [-116.69113, 32.64286], [-116.69177, 32.64642], [-116.68717, 32.64646], [-116.68654, 32.64172], [-116.68619, 32.63925], [-116.68626, 32.63597], [-116.68515, 32.63593], [-116.6852, 32.63414], [-116.68522, 32.63386], [-116.68629, 32.63392], [-116.68627, 32.63595], [-116.69052, 32.63602], [-116.6907, 32.62656], [-116.6949, 32.62661], [-116.69487, 32.61949], [-116.69896, 32.61962], [-116.69898, 32.61612], [-116.70769, 32.61631], [-116.71809, 32.61565], [-116.71841, 32.61579], [-116.71975, 32.61606], [-116.72042, 32.61573], [-116.72048, 32.61573], [-116.72051, 32.61765], [-116.72724, 32.61758], [-116.72721, 32.61799], [-116.72733, 32.61851], [-116.72734, 32.61863], [-116.7274, 32.6188], [-116.72749, 32.61894], [-116.7276, 32.61905], [-116.72772, 32.61914], [-116.72798, 32.61926], [-116.72822, 32.61931], [-116.72844, 32.61931], [-116.72863, 32.61927], [-116.72879, 32.61922], [-116.72899, 32.6191], [-116.72916, 32.61894], [-116.72964, 32.61831], [-116.73109, 32.61792], [-116.73167, 32.61772], [-116.73242, 32.61755], [-116.73312, 32.61755], [-116.73314, 32.61739], [-116.73495, 32.61697], [-116.73551, 32.61686], [-116.73599, 32.6168], [-116.73648, 32.61676], [-116.737, 32.61675], [-116.73737, 32.61677], [-116.73738, 32.62107]]], [[[-116.73102, 32.61755], [-116.72988, 32.61781], [-116.72962, 32.6179], [-116.72943, 32.61801], [-116.72935, 32.61808], [-116.72835, 32.61869], [-116.72789, 32.61859], [-116.72763, 32.61823], [-116.72768, 32.61763], [-116.72773, 32.61758], [-116.73102, 32.61755]]], [[[-116.73736, 32.61645], [-116.73617, 32.61654], [-116.73521, 32.61659], [-116.73314, 32.61707], [-116.73303, 32.61407], [-116.73736, 32.61399], [-116.73736, 32.61645]]]]} No Public Access 3 MSCP Open Space Preserve Land   22572 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 1277.083 MSCP OSP Land  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
    ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
    ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
    ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
    ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
    ON [superunits_with_maps] ([ACCESS_TYP]);