units_with_maps

Table actions

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

2 rows where ACCESS_TYP = 2, MNG_AG_TYP = 2 and YR_EST = 1989

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 2 ✖

MNG_AGENCY 1

ACCESS_TYP 1

  • Restricted Access · 2 ✖
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
9458 9458 9457 {"type": "Polygon", "coordinates": [[[-121.91787, 37.70301], [-121.91749, 37.7032], [-121.91745, 37.7035], [-121.91675, 37.70379], [-121.91628, 37.70412], [-121.91617, 37.70434], [-121.9134, 37.70372], [-121.91278, 37.70359], [-121.91207, 37.70363], [-121.91182, 37.70216], [-121.91671, 37.7022], [-121.91696, 37.70262], [-121.91755, 37.70242], [-121.91787, 37.70301]]]} Restricted Access 2 15814 Dublin Sports Grounds 18293 1090 Dublin, City of 164 City 2 City Agency 2 http://www.ci.dublin.ca.us/index.aspx?nid=1458 City 2 1090 Dublin, City of 160 City 2 City Agency 2   Alameda 17 22.454 Dublin Sports Grounds 1989 None 781  
16120 16120 16119 {"type": "Polygon", "coordinates": [[[-121.92213, 37.72774], [-121.91472, 37.72954], [-121.91488, 37.72937], [-121.91489, 37.72922], [-121.91462, 37.72896], [-121.91451, 37.72879], [-121.91451, 37.72865], [-121.9149, 37.72797], [-121.91497, 37.72771], [-121.91501, 37.72711], [-121.91481, 37.72653], [-121.915, 37.72565], [-121.91513, 37.72526], [-121.91498, 37.72457], [-121.91456, 37.72423], [-121.91415, 37.7233], [-121.91374, 37.72189], [-121.91326, 37.72198], [-121.9128, 37.72245], [-121.91233, 37.72278], [-121.91233, 37.72332], [-121.91214, 37.72362], [-121.91188, 37.72395], [-121.91156, 37.72358], [-121.91177, 37.72344], [-121.91179, 37.72307], [-121.91174, 37.72271], [-121.91185, 37.72236], [-121.91216, 37.72214], [-121.91265, 37.72189], [-121.91302, 37.72152], [-121.91319, 37.72097], [-121.91346, 37.7208], [-121.91356, 37.72071], [-121.91361, 37.72053], [-121.91358, 37.72035], [-121.91349, 37.72024], [-121.91343, 37.72013], [-121.91345, 37.71951], [-121.9134, 37.71937], [-121.91329, 37.71923], [-121.91287, 37.71888], [-121.91262, 37.71854], [-121.9137, 37.71795], [-121.9139, 37.71816], [-121.91466, 37.71777], [-121.91504, 37.71766], [-121.91517, 37.71767], [-121.91618, 37.71882], [-121.91644, 37.71908], [-121.917, 37.71972], [-121.91727, 37.71981], [-121.91753, 37.71983], [-121.91812, 37.71962], [-121.91828, 37.71985], [-121.91834, 37.72002], [-121.91838, 37.72017], [-121.9184, 37.72037], [-121.91834, 37.7204], [-121.91767, 37.7204], [-121.91749, 37.72045], [-121.91729, 37.72056], [-121.91716, 37.72077], [-121.9171, 37.72119], [-121.91704, 37.72176], [-121.91669, 37.72177], [-121.91673, 37.72213], [-121.917, 37.72295], [-121.91741, 37.72286], [-121.91751, 37.72289], [-121.91824, 37.72275], [-121.91853, 37.72271], [-121.91862, 37.72271], [-121.91867, 37.72277], [-121.91888, 37.72346], [-121.91892, 37.72364], [-121.91838, 37.72378], [-121.91789, 37.72403], [-121.91756, 37.72435], [-121.9175, 37.72472], [-121.91779, 37.7252], [-121.91837, 37.7258], [-121.91866, 37.72598], [-121.91901, 37.72603], [-121.92001, 37.72582], [-121.92029, 37.72562], [-121.921, 37.72617], [-121.92148, 37.72667], [-121.92199, 37.72731], [-121.92213, 37.72774]]]} Restricted Access 2 15770 Dougherty Hills Open Space 18241 1090 Dublin, City of 164 City 2 City Agency 2 http://www.ci.dublin.ca.us/index.aspx?nid=1458 City 2 1090 Dublin, City of 160 City 2 City Agency 2   Alameda 17 116.934 Dougherty Hills OS 1989 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]);