units_with_maps

Table actions

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

10 rows where COUNTY = 17 and DES_TP = 14

This data as json, copyable, CSV (advanced)

Suggested facets: AGNCY_ID, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, MNG_AG_ID, MNG_AG_LEV, YR_EST

ACCESS_TYP 2

DES_TP 1

  • Local Other or Unknown · 10 ✖
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
2719 2719 2718 {"type": "Polygon", "coordinates": [[[-122.15145, 37.62482], [-122.1508, 37.62499], [-122.14973, 37.62515], [-122.14837, 37.62508], [-122.14707, 37.62481], [-122.14004, 37.62225], [-122.13959, 37.62203], [-122.13915, 37.62174], [-122.14433, 37.62003], [-122.14478, 37.62002], [-122.14935, 37.61837], [-122.15103, 37.61782], [-122.15106, 37.61893], [-122.15087, 37.61931], [-122.15075, 37.62021], [-122.15092, 37.62129], [-122.15132, 37.6246], [-122.15145, 37.62482]]]} Restricted Access 2 18348 Oliver Property 23136 2045 Hayward Area Recreation and Park District 257 Special District 4 Recreation/Parks District 4 http://www.haywardrec.org/ Special District 4 2045 Hayward Area Recreation and Park District 253 Special District 4 Recreation/Parks District 4   Alameda 17 118.291 Oliver Property 1977 Local Other or Unknown 14 4
2882 2882 2881 {"type": "Polygon", "coordinates": [[[-121.79106, 37.67722], [-121.79029, 37.67754], [-121.78871, 37.6778], [-121.78807, 37.67784], [-121.78741, 37.67737], [-121.78811, 37.67727], [-121.78838, 37.67755], [-121.78901, 37.67751], [-121.78842, 37.67665], [-121.78831, 37.67628], [-121.78917, 37.67597], [-121.78992, 37.67604], [-121.79005, 37.67635], [-121.79039, 37.67668], [-121.79075, 37.67693], [-121.79106, 37.67722]]]} Open Access 1 22290 Unknown park - Livermore, City of 28714 1178 Livermore, City of 256 City 2 City Agency 2 http://www.larpd.org/parks/parks.html City 2 1178 Livermore, City of 252 City 2 City Agency 2   Alameda 17 8.284   0 Local Other or Unknown 14 4
4548 4548 4547 {"type": "Polygon", "coordinates": [[[-121.79158, 37.67939], [-121.79158, 37.67946], [-121.79149, 37.67979], [-121.79049, 37.6798], [-121.78952, 37.6799], [-121.78852, 37.67912], [-121.78813, 37.67868], [-121.78776, 37.6781], [-121.78856, 37.67806], [-121.78921, 37.67793], [-121.78982, 37.67789], [-121.79032, 37.67778], [-121.79055, 37.67842], [-121.79149, 37.67827], [-121.79153, 37.67865], [-121.79159, 37.67899], [-121.79158, 37.67939]]]} Open Access 1 22291 Unnamed site - Alameda County Flood Control and Water Conservation District 28716 2000 Alameda County Flood Control and Water Conservation District 771 Special District 4 Flood District 8 http://acfloodcontrol.org/ Special District 4 2000 Alameda County Flood Control and Water Conservation District 752 Special District 4 Flood District 9   Alameda 17 13.147   0 Local Other or Unknown 14 4
4791 4791 4790 {"type": "Polygon", "coordinates": [[[-121.99359, 37.55565], [-121.99238, 37.55707], [-121.99233, 37.55709], [-121.99228, 37.55709], [-121.99224, 37.55714], [-121.9905, 37.55623], [-121.99179, 37.55472], [-121.99359, 37.55565]]]} Open Access 1 48264 Unnamed Site - Fremont, City of 32816 1113 Fremont, City of 381 City 2 City Agency 2 http://www.fremont.gov/316/Parks City 2 1113 Fremont, City of 376 City 2 City Agency 2   Alameda 17 9.503   0 Local Other or Unknown 14 4
6737 6737 6736 {"type": "Polygon", "coordinates": [[[-122.03598, 37.62441], [-122.03477, 37.62527], [-122.02785, 37.61905], [-122.0275, 37.61927], [-122.02683, 37.61864], [-122.02714, 37.61843], [-122.02714, 37.61841], [-122.02541, 37.61685], [-122.02383, 37.61546], [-122.025, 37.61493], [-122.02533, 37.61507], [-122.02541, 37.61558], [-122.02606, 37.61578], [-122.02551, 37.6161], [-122.02551, 37.61612], [-122.02586, 37.61626], [-122.02596, 37.61635], [-122.0261, 37.61629], [-122.02619, 37.6165], [-122.027, 37.61691], [-122.02703, 37.61697], [-122.02748, 37.61694], [-122.02752, 37.61708], [-122.0276, 37.61722], [-122.02769, 37.61732], [-122.02793, 37.61754], [-122.02831, 37.61728], [-122.02844, 37.61738], [-122.029, 37.61799], [-122.02907, 37.61807], [-122.02902, 37.61828], [-122.02923, 37.61868], [-122.02909, 37.61922], [-122.02966, 37.6193], [-122.02981, 37.61926], [-122.03015, 37.61907], [-122.0305, 37.61923], [-122.03127, 37.62017], [-122.03116, 37.62025], [-122.03122, 37.62063], [-122.03175, 37.62081], [-122.03201, 37.62079], [-122.03174, 37.62155], [-122.03264, 37.62176], [-122.0328, 37.62189], [-122.03275, 37.62243], [-122.03287, 37.62265], [-122.03458, 37.62408], [-122.03509, 37.62432], [-122.03598, 37.62441]]]} Open Access 1 5068 Taper Park Property 26183 2045 Hayward Area Recreation and Park District 257 Special District 4 Recreation/Parks District 4 http://www.haywardrec.org/ Special District 4 2045 Hayward Area Recreation and Park District 253 Special District 4 Recreation/Parks District 4   Alameda 17 39.626 Taper Park Property 1975 Local Other or Unknown 14 4
13757 13757 13756 {"type": "Polygon", "coordinates": [[[-121.84934, 37.67753], [-121.84925, 37.67858], [-121.8483, 37.67911], [-121.84787, 37.67968], [-121.84777, 37.67993], [-121.84555, 37.67995], [-121.84497, 37.67734], [-121.84513, 37.67742], [-121.84562, 37.67737], [-121.84614, 37.67698], [-121.8464, 37.67694], [-121.84669, 37.67707], [-121.84666, 37.67735], [-121.84681, 37.67764], [-121.84772, 37.67721], [-121.84827, 37.67712], [-121.84934, 37.67753]]]} Open Access 1 36272 Pleasanton holding 3 23806 1257 Pleasanton, City of 32 City 2 City Agency 2 http://www.cityofpleasantonca.gov/ City 2 1257 Pleasanton, City of 31 City 2 City Agency 2   Alameda 17 22.762 Pleasanton holding 3 0 Local Other or Unknown 14 4
13781 13781 13780 {"type": "Polygon", "coordinates": [[[-121.86242, 37.67993], [-121.86223, 37.67999], [-121.86182, 37.68021], [-121.86175, 37.68021], [-121.86156, 37.68003], [-121.8614, 37.67992], [-121.8612, 37.67984], [-121.86096, 37.67978], [-121.86097, 37.67923], [-121.86135, 37.67899], [-121.86162, 37.67876], [-121.86169, 37.67876], [-121.86172, 37.67878], [-121.86149, 37.67898], [-121.8621, 37.67943], [-121.86221, 37.67955], [-121.86234, 37.67986], [-121.86242, 37.67993]]]} Open Access 1 36328 Pleasanton holding 1 23804 1257 Pleasanton, City of 32 City 2 City Agency 2 http://www.cityofpleasantonca.gov/ City 2 1257 Pleasanton, City of 31 City 2 City Agency 2   Alameda 17 2.66 Pleasanton holding 1 0 Local Other or Unknown 14 4
13790 13790 13789 {"type": "Polygon", "coordinates": [[[-121.78627, 37.68568], [-121.78621, 37.68743], [-121.78346, 37.68739], [-121.78349, 37.68561], [-121.78627, 37.68568]]]} Open Access 1 36350 Livermore holding 1 21381 1178 Livermore, City of 256 City 2 City Agency 2 http://www.larpd.org/parks/parks.html City 2 1178 Livermore, City of 252 City 2 City Agency 2   Alameda 17 11.806 Livermore holding 1 0 Local Other or Unknown 14 4
13916 13916 13915 {"type": "Polygon", "coordinates": [[[-121.85023, 37.68137], [-121.84817, 37.68139], [-121.84815, 37.67994], [-121.84777, 37.67993], [-121.84787, 37.67968], [-121.8483, 37.67911], [-121.84925, 37.67858], [-121.84933, 37.67753], [-121.84827, 37.67712], [-121.84772, 37.67721], [-121.8468, 37.67765], [-121.84666, 37.67735], [-121.84669, 37.67707], [-121.8464, 37.67694], [-121.84614, 37.67698], [-121.84562, 37.67737], [-121.84513, 37.67742], [-121.84497, 37.67734], [-121.84477, 37.67645], [-121.8468, 37.67577], [-121.85001, 37.67585], [-121.85023, 37.68137]]]} Open Access 1 36529 Pleasanton holding 4 23807 1257 Pleasanton, City of 32 City 2 City Agency 2 http://www.cityofpleasantonca.gov/ City 2 1257 Pleasanton, City of 31 City 2 City Agency 2   Alameda 17 32.765 Pleasanton holding 4 0 Local Other or Unknown 14 4
13919 13919 13918 {"type": "Polygon", "coordinates": [[[-122.17071, 37.72748], [-122.17036, 37.72728], [-122.17034, 37.72724], [-122.1703, 37.72709], [-122.17031, 37.72703], [-122.17057, 37.72693], [-122.17071, 37.72748]]]} Open Access 1 36534 San Leandro holding 1 24923 1306 San Leandro, City of 183 City 2 City Agency 2 http://www.sanleandro.org/depts/rec/parks/default.asp City 2 1306 San Leandro, City of 179 City 2 City Agency 2   Alameda 17 0.294 San Leandro holding 1 0 Local Other or Unknown 14 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]);