units_with_maps

Table actions

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

1 row where AGNCY_TYP = 20 and MNG_AGENCY = 4

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 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
16223 16223 16222 {"type": "Polygon", "coordinates": [[[-117.02305, 32.58558], [-117.01876, 32.58555], [-117.01875, 32.58376], [-117.0148, 32.58373], [-117.01465, 32.58363], [-117.01447, 32.58354], [-117.01433, 32.57606], [-117.02242, 32.57628], [-117.0226, 32.57717], [-117.02239, 32.57718], [-117.02228, 32.57717], [-117.02221, 32.57699], [-117.02213, 32.57694], [-117.02176, 32.5769], [-117.02167, 32.57671], [-117.02153, 32.5766], [-117.02143, 32.57654], [-117.02118, 32.57659], [-117.02096, 32.57669], [-117.02085, 32.57684], [-117.02075, 32.57687], [-117.02063, 32.57685], [-117.02049, 32.57678], [-117.02041, 32.57685], [-117.02001, 32.57685], [-117.01955, 32.57696], [-117.01934, 32.57699], [-117.01923, 32.57693], [-117.01911, 32.57693], [-117.01877, 32.57699], [-117.01863, 32.57698], [-117.01838, 32.57678], [-117.01823, 32.57676], [-117.01815, 32.57677], [-117.01807, 32.57664], [-117.01786, 32.57655], [-117.01771, 32.57645], [-117.01764, 32.57652], [-117.01738, 32.57666], [-117.01729, 32.57688], [-117.01729, 32.57695], [-117.01734, 32.57704], [-117.01734, 32.57712], [-117.01724, 32.57724], [-117.01741, 32.57755], [-117.01742, 32.57766], [-117.01757, 32.57781], [-117.01759, 32.5779], [-117.01753, 32.57802], [-117.01754, 32.57808], [-117.01758, 32.57815], [-117.01753, 32.5783], [-117.01751, 32.57859], [-117.01752, 32.57881], [-117.01758, 32.579], [-117.01765, 32.57912], [-117.01759, 32.57929], [-117.0176, 32.57938], [-117.01768, 32.57961], [-117.01774, 32.57987], [-117.01776, 32.58027], [-117.01773, 32.58054], [-117.01774, 32.5806], [-117.01785, 32.58072], [-117.01788, 32.58097], [-117.01792, 32.58102], [-117.01836, 32.58133], [-117.01845, 32.58134], [-117.01871, 32.58129], [-117.01878, 32.58128], [-117.01886, 32.58129], [-117.01895, 32.58138], [-117.019, 32.58147], [-117.01903, 32.58159], [-117.01898, 32.58167], [-117.01891, 32.58169], [-117.01868, 32.58167], [-117.01861, 32.5817], [-117.01852, 32.58188], [-117.01845, 32.58196], [-117.0184, 32.58238], [-117.01849, 32.58265], [-117.01846, 32.58281], [-117.0184, 32.58286], [-117.01873, 32.58324], [-117.0189, 32.58348], [-117.01924, 32.58413], [-117.01932, 32.58433], [-117.01953, 32.58434], [-117.01997, 32.58424], [-117.02013, 32.58427], [-117.02021, 32.58425], [-117.02029, 32.58418], [-117.02055, 32.58382], [-117.02049, 32.58355], [-117.02039, 32.58323], [-117.02075, 32.58311], [-117.02081, 32.58306], [-117.02092, 32.58288], [-117.02094, 32.58281], [-117.02117, 32.58292], [-117.02149, 32.58274], [-117.0214, 32.58198], [-117.0211, 32.58161], [-117.02126, 32.58163], [-117.02136, 32.58158], [-117.02176, 32.58159], [-117.02191, 32.58155], [-117.0221, 32.58145], [-117.02217, 32.58145], [-117.02223, 32.58147], [-117.02224, 32.58151], [-117.0222, 32.58163], [-117.02222, 32.58164], [-117.02267, 32.5816], [-117.023, 32.58154], [-117.02305, 32.58379], [-117.02305, 32.58558]]]} Open Access 1 44861 Hidden Trails Open Space 31665 6075 Western Pacific Housing 1167 Private 7 Commercial 20   Private 14 1297 San Diego, City of 4 City 2 City Agency 2   San Diego 4 106.609 Hidden Trails OS 0 Local Recreation Area 3 4

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