units_with_maps

Table actions

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

1 row where ACRES = "1276.75", MNG_AGENCY = 4 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 1 ✖

MNG_AGENCY 1

  • San Diego, City of · 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
5384 5384 5383 {"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.72053, 32.62112], [-116.72052, 32.62207], [-116.72052, 32.62295], [-116.7117, 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.69112, 32.64286], [-116.69177, 32.64642], [-116.68717, 32.64646], [-116.68654, 32.64172], [-116.68619, 32.63925], [-116.68626, 32.63596], [-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.69491, 32.62661], [-116.69487, 32.61949], [-116.69897, 32.61962], [-116.69898, 32.61612], [-116.70769, 32.61631], [-116.71809, 32.61565], [-116.71841, 32.61579], [-116.71976, 32.61606], [-116.72042, 32.61573], [-116.72048, 32.61573], [-116.7205, 32.61766], [-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.73243, 32.61755], [-116.73313, 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 7400 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 1297 San Diego, City of 4 City 2 City Agency 2   San Diego 4 1276.75 MSCP OSP Land 0 Local Conservation Area 4 2

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