units_with_maps

Table actions

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

7 rows where AGNCY_TYP = 2, COUNTY = 12 and MNG_AGENCY = 466

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Danville, Town of · 7 ✖

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
2057 2057 2056 {"type": "Polygon", "coordinates": [[[-121.92375, 37.78824], [-121.92371, 37.79157], [-121.92282, 37.79279], [-121.92257, 37.79317], [-121.92246, 37.79338], [-121.92238, 37.79339], [-121.92136, 37.79311], [-121.92102, 37.79304], [-121.92085, 37.79303], [-121.92051, 37.79305], [-121.92034, 37.79308], [-121.92004, 37.79317], [-121.91971, 37.79243], [-121.92063, 37.79058], [-121.92103, 37.79031], [-121.92183, 37.78958], [-121.92185, 37.78914], [-121.92215, 37.78874], [-121.92211, 37.78833], [-121.92375, 37.78824]]]} Open Access 1 15693 Diablo Vista Park 18136 1080 Danville, Town of 473 City 2 City Agency 2 http://www.danville.ca.gov/Things-To-Do/Parks/ City 2 1080 Danville, Town of 466 City 2 City Agency 2   Contra Costa 12 31.879 Diablo Vista Park 1988 Local Park 2 4
2702 2702 2701 {"type": "Polygon", "coordinates": [[[-121.98702, 37.84243], [-121.98682, 37.8427], [-121.98682, 37.84458], [-121.98515, 37.84459], [-121.98438, 37.84461], [-121.98427, 37.84188], [-121.98417, 37.83749], [-121.9868, 37.83743], [-121.98681, 37.84188], [-121.98674, 37.84189], [-121.98676, 37.84226], [-121.98682, 37.84239], [-121.98682, 37.84245], [-121.98702, 37.84243]]]} Open Access 1 18284 Oak Hill Park 22979 1080 Danville, Town of 473 City 2 City Agency 2 http://www.danville.ca.gov/Things-To-Do/Parks/ City 2 1080 Danville, Town of 466 City 2 City Agency 2   Contra Costa 12 43.825 Oak Hill Park 1988 Local Park 2 4
6723 6723 6722 {"type": "Polygon", "coordinates": [[[-121.94839, 37.80697], [-121.94726, 37.80857], [-121.94826, 37.80902], [-121.94773, 37.80924], [-121.94754, 37.80949], [-121.94725, 37.80958], [-121.94687, 37.80964], [-121.94661, 37.8095], [-121.94631, 37.80916], [-121.94594, 37.80897], [-121.94559, 37.80886], [-121.94517, 37.80893], [-121.94466, 37.80909], [-121.94434, 37.80913], [-121.94383, 37.80895], [-121.9439, 37.80869], [-121.94437, 37.80802], [-121.94444, 37.80804], [-121.94523, 37.80686], [-121.94514, 37.80604], [-121.94551, 37.80552], [-121.94684, 37.80612], [-121.94687, 37.8061], [-121.94839, 37.80697]]]} Open Access 1 5039 Sycamore Valley Park 26143 1080 Danville, Town of 473 City 2 City Agency 2 http://www.danville.ca.gov/Things-To-Do/Parks/ City 2 1080 Danville, Town of 466 City 2 City Agency 2   Contra Costa 12 24.657 Sycamore Valley Park 1990 Local Park 2 4
8063 8063 8062 {"type": "Polygon", "coordinates": [[[-121.97946, 37.78878], [-121.97921, 37.78892], [-121.97907, 37.78894], [-121.97885, 37.78879], [-121.97875, 37.7888], [-121.97857, 37.78871], [-121.97847, 37.78851], [-121.97846, 37.78837], [-121.97883, 37.78806], [-121.97946, 37.78878]]]} Open Access 1 11857 Danville South Park 17923 1080 Danville, Town of 473 City 2 City Agency 2 http://www.danville.ca.gov/Things-To-Do/Parks/ City 2 1080 Danville, Town of 466 City 2 City Agency 2   Contra Costa 12 1.13 Danville South Park 1992 Local Park 2 4
8064 8064 8063 {"type": "Polygon", "coordinates": [[[-121.98834, 37.82338], [-121.98797, 37.82358], [-121.98781, 37.82371], [-121.98767, 37.82384], [-121.98754, 37.82399], [-121.98744, 37.82414], [-121.98744, 37.82312], [-121.98772, 37.82326], [-121.98788, 37.82331], [-121.98804, 37.82335], [-121.98834, 37.82338]]]} Open Access 1 11868 Bret Harte Park 16365 1080 Danville, Town of 473 City 2 City Agency 2 http://www.danville.ca.gov/Things-To-Do/Parks/ City 2 1080 Danville, Town of 466 City 2 City Agency 2   Contra Costa 12 0.871 Bret Harte Park 1988 Local Park 2 4
9239 9239 9238 {"type": "Polygon", "coordinates": [[[-121.98155, 37.80527], [-121.97896, 37.80538], [-121.9786, 37.80534], [-121.97827, 37.80535], [-121.97806, 37.80538], [-121.9774, 37.80533], [-121.97689, 37.80511], [-121.97665, 37.80346], [-121.97708, 37.80344], [-121.97708, 37.80338], [-121.97718, 37.80319], [-121.97732, 37.80305], [-121.97747, 37.80302], [-121.97789, 37.80301], [-121.97818, 37.80304], [-121.97876, 37.80274], [-121.97935, 37.8027], [-121.97927, 37.80133], [-121.98122, 37.80125], [-121.98133, 37.80333], [-121.98155, 37.80527]]]} Open Access 1 15367 Osage Station Park 23232 1080 Danville, Town of 473 City 2 City Agency 2 http://www.danville.ca.gov/Things-To-Do/Parks/ City 2 1080 Danville, Town of 466 City 2 City Agency 2   Contra Costa 12 34.231 Osage Station Park 1988 Local Park 2 4
9814 9814 9813 {"type": "Polygon", "coordinates": [[[-122.02134, 37.84108], [-122.02082, 37.84183], [-122.02025, 37.8414], [-122.01902, 37.84036], [-122.0171, 37.83916], [-122.01664, 37.83898], [-122.01707, 37.83824], [-122.01706, 37.83823], [-122.01709, 37.83816], [-122.01709, 37.83805], [-122.01708, 37.83798], [-122.01692, 37.83774], [-122.01737, 37.83776], [-122.01798, 37.83769], [-122.01814, 37.83773], [-122.01834, 37.83784], [-122.01784, 37.83855], [-122.01828, 37.83876], [-122.01895, 37.83828], [-122.01909, 37.83843], [-122.01934, 37.83881], [-122.01908, 37.83933], [-122.01871, 37.83953], [-122.01879, 37.83989], [-122.01927, 37.8399], [-122.01984, 37.83961], [-122.02006, 37.83962], [-122.02022, 37.83958], [-122.02041, 37.83971], [-122.02067, 37.84021], [-122.0205, 37.84039], [-122.02047, 37.8407], [-122.02063, 37.8409], [-122.0208, 37.84101], [-122.02126, 37.84108], [-122.02134, 37.84108]]]} Open Access 1 16861 Hap Magee Ranch 19654 1080 Danville, Town of 473 City 2 City Agency 2 http://www.danville.ca.gov/Things-To-Do/Parks/ City 2 1080 Danville, Town of 466 City 2 City Agency 2   Contra Costa 12 14.057 Hap Magee Ranch 0 Local Park 2 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]);