units_with_maps

Table actions

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

1 row where AGNCY_ID = 1297, DES_TP = 657 and MNG_AGENCY = 4

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • San Diego, City of · 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
7856 7856 7855 {"type": "MultiPolygon", "coordinates": [[[[-116.93658, 32.65831], [-116.93658, 32.65948], [-116.9331, 32.65944], [-116.9334, 32.65894], [-116.93354, 32.65873], [-116.93365, 32.65861], [-116.93385, 32.65843], [-116.93416, 32.65828], [-116.93436, 32.6582], [-116.93464, 32.65813], [-116.93494, 32.65809], [-116.93575, 32.65812], [-116.93601, 32.65816], [-116.93658, 32.65831]]], [[[-116.94225, 32.64831], [-116.94055, 32.64938], [-116.9405, 32.65025], [-116.93964, 32.64997], [-116.9393, 32.65], [-116.93889, 32.65053], [-116.93851, 32.65043], [-116.93816, 32.65059], [-116.93773, 32.65091], [-116.93735, 32.65137], [-116.93725, 32.65163], [-116.93741, 32.6519], [-116.93945, 32.65199], [-116.93892, 32.65245], [-116.93806, 32.65288], [-116.93725, 32.65338], [-116.93681, 32.65376], [-116.93684, 32.65404], [-116.93709, 32.65421], [-116.93856, 32.65439], [-116.93929, 32.65419], [-116.93906, 32.65482], [-116.9395, 32.65512], [-116.94073, 32.65541], [-116.93973, 32.65549], [-116.93785, 32.65555], [-116.93777, 32.65605], [-116.93682, 32.65603], [-116.93678, 32.65633], [-116.93706, 32.65639], [-116.93724, 32.65649], [-116.9378, 32.65714], [-116.93806, 32.65723], [-116.93834, 32.65765], [-116.93789, 32.65742], [-116.93762, 32.65749], [-116.93753, 32.65766], [-116.93772, 32.658], [-116.93774, 32.65835], [-116.93796, 32.6586], [-116.93804, 32.65879], [-116.93836, 32.65931], [-116.93844, 32.65949], [-116.93794, 32.6591], [-116.93762, 32.65906], [-116.93758, 32.65884], [-116.93729, 32.65869], [-116.93693, 32.65833], [-116.93659, 32.65807], [-116.93658, 32.65808], [-116.93658, 32.6582], [-116.93604, 32.65805], [-116.93589, 32.65802], [-116.93516, 32.65799], [-116.93479, 32.65799], [-116.93457, 32.65803], [-116.93431, 32.6581], [-116.93393, 32.65826], [-116.93372, 32.65838], [-116.93357, 32.65852], [-116.93348, 32.65862], [-116.93325, 32.65895], [-116.93296, 32.65946], [-116.93286, 32.65969], [-116.93255, 32.66064], [-116.93093, 32.66437], [-116.93106, 32.66441], [-116.93216, 32.66184], [-116.93217, 32.66684], [-116.92827, 32.66678], [-116.92782, 32.66679], [-116.92782, 32.67322], [-116.92354, 32.67321], [-116.92351, 32.67684], [-116.91917, 32.67683], [-116.91915, 32.67321], [-116.91491, 32.6732], [-116.91492, 32.6703], [-116.9191, 32.67035], [-116.92346, 32.67044], [-116.92351, 32.6668], [-116.91914, 32.66676], [-116.91915, 32.66401], [-116.91924, 32.66404], [-116.91925, 32.66312], [-116.92781, 32.66319], [-116.9278, 32.65583], [-116.93158, 32.65592], [-116.93153, 32.65584], [-116.93126, 32.65572], [-116.93098, 32.65548], [-116.93094, 32.65536], [-116.93077, 32.65474], [-116.93084, 32.65458], [-116.93119, 32.65423], [-116.93117, 32.65407], [-116.93129, 32.65396], [-116.93172, 32.65328], [-116.93182, 32.6529], [-116.93218, 32.65251], [-116.93217, 32.65222], [-116.93218, 32.65221], [-116.93218, 32.65195], [-116.93224, 32.65149], [-116.93224, 32.65144], [-116.93221, 32.65142], [-116.93192, 32.65122], [-116.93148, 32.65096], [-116.92996, 32.65084], [-116.92965, 32.65036], [-116.93244, 32.64889], [-116.93407, 32.64789], [-116.9349, 32.64813], [-116.93561, 32.6482], [-116.93638, 32.64855], [-116.93691, 32.648], [-116.93754, 32.64776], [-116.93787, 32.64846], [-116.93844, 32.64854], [-116.93923, 32.6478], [-116.94011, 32.64821], [-116.94117, 32.64801], [-116.94165, 32.64797], [-116.94223, 32.6481], [-116.94225, 32.64831]]]]} Open Access 1 47713 Upper Otay Lakes 31494 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 575.207 Upper Otay Lakes 0 None 657  

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