units_with_maps

Table actions

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

6 rows where ACCESS_TYP = 1 and AGNCY_ID = 1128

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, DES_TP

MNG_AG_TYP 1

ACCESS_TYP 1

  • Open Access · 6 ✖
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
1868 1868 1867 {"type": "Polygon", "coordinates": [[[-122.43844, 37.4616], [-122.43838, 37.46201], [-122.43776, 37.46195], [-122.43782, 37.46154], [-122.43844, 37.4616]]]} Open Access 1 14359 Ocean View Park 23059 1128 Half Moon Bay, City of 439 City 2 City Agency 2 http://www.half-moon-bay.ca.us/ City 2 1128 Half Moon Bay, City of 433 City 2 City Agency 2   San Mateo 15 0.618 Ocean View Park 0 Local Park 2 4
3209 3209 3208 {"type": "Polygon", "coordinates": [[[-122.43836, 37.44933], [-122.43398, 37.44988], [-122.43362, 37.4472], [-122.438, 37.44665], [-122.43836, 37.44933]]]} Open Access 1 28142 Smith Field 25569 1128 Half Moon Bay, City of 439 City 2 City Agency 2 http://www.half-moon-bay.ca.us/ City 2 1128 Half Moon Bay, City of 433 City 2 City Agency 2   San Mateo 15 28.963 Smith Field 0 Local Recreation Area 3 4
4256 4256 4255 {"type": "Polygon", "coordinates": [[[-122.42874, 37.466], [-122.4287, 37.46625], [-122.42874, 37.4663], [-122.42844, 37.4662], [-122.42835, 37.46619], [-122.42819, 37.46619], [-122.42801, 37.46624], [-122.4279, 37.46624], [-122.42764, 37.46615], [-122.42751, 37.46607], [-122.42741, 37.46598], [-122.42728, 37.4658], [-122.42721, 37.46555], [-122.42715, 37.46546], [-122.42706, 37.46547], [-122.42684, 37.46547], [-122.42672, 37.46542], [-122.42661, 37.46549], [-122.42663, 37.46553], [-122.42653, 37.46563], [-122.42648, 37.46577], [-122.42641, 37.46591], [-122.42657, 37.46622], [-122.42537, 37.46661], [-122.4252, 37.46628], [-122.42524, 37.46626], [-122.42533, 37.46599], [-122.42564, 37.46589], [-122.4258, 37.46593], [-122.42606, 37.46572], [-122.42641, 37.46519], [-122.42675, 37.46518], [-122.42689, 37.46522], [-122.42705, 37.46518], [-122.42743, 37.46519], [-122.42768, 37.46526], [-122.42786, 37.46539], [-122.42808, 37.46548], [-122.42821, 37.46563], [-122.4286, 37.46592], [-122.42874, 37.466]]]} Open Access 1 14366 John L Carter Memorial Park 20450 1128 Half Moon Bay, City of 439 City 2 City Agency 2 http://www.half-moon-bay.ca.us/ City 2 1128 Half Moon Bay, City of 433 City 2 City Agency 2   San Mateo 15 5.002 John L Carter Memorial Park 0 Local Park 2 4
8816 8816 8815 {"type": "Polygon", "coordinates": [[[-122.44522, 37.48322], [-122.44519, 37.48328], [-122.4447, 37.48368], [-122.4447, 37.48377], [-122.44435, 37.48381], [-122.44379, 37.48396], [-122.44303, 37.48401], [-122.44283, 37.48404], [-122.44265, 37.48411], [-122.44206, 37.48438], [-122.44143, 37.48459], [-122.44121, 37.48473], [-122.44026, 37.48551], [-122.44018, 37.48531], [-122.44054, 37.48498], [-122.44067, 37.48494], [-122.44095, 37.4848], [-122.44108, 37.48463], [-122.44124, 37.48416], [-122.4413, 37.48405], [-122.44155, 37.48409], [-122.44182, 37.48429], [-122.44201, 37.48425], [-122.44222, 37.48397], [-122.44248, 37.48387], [-122.44287, 37.48365], [-122.44315, 37.48357], [-122.44372, 37.48356], [-122.44429, 37.48334], [-122.4445, 37.48335], [-122.44502, 37.48322], [-122.44522, 37.48322]]]} Open Access 1 14368 Frenchmans Creek Common Park 19110 1128 Half Moon Bay, City of 439 City 2 City Agency 2 http://www.half-moon-bay.ca.us/ City 2 1128 Half Moon Bay, City of 433 City 2 City Agency 2   San Mateo 15 4.191 Frenchmans Creek Common Park 0 Local Park 2 4
10621 10621 10620 {"type": "Polygon", "coordinates": [[[-122.44604, 37.46514], [-122.44474, 37.46502], [-122.4448, 37.46461], [-122.44379, 37.46451], [-122.44452, 37.45959], [-122.44451, 37.45958], [-122.44382, 37.45967], [-122.44354, 37.45826], [-122.44345, 37.45827], [-122.44343, 37.45813], [-122.44351, 37.45811], [-122.44284, 37.45476], [-122.44407, 37.4546], [-122.44411, 37.45541], [-122.445, 37.45532], [-122.44514, 37.45654], [-122.44514, 37.45732], [-122.44526, 37.45784], [-122.44528, 37.45827], [-122.44461, 37.45834], [-122.4446, 37.45835], [-122.44481, 37.45961], [-122.445, 37.45984], [-122.4452, 37.46089], [-122.44544, 37.46227], [-122.44546, 37.46308], [-122.44557, 37.46346], [-122.44573, 37.46377], [-122.44593, 37.46432], [-122.44604, 37.46514]]]} Open Access 1 48636 Poplar Beach 33340 1128 Half Moon Bay, City of 439 City 2 City Agency 2 http://www.half-moon-bay.ca.us/ City 2 1128 Half Moon Bay, City of 433 City 2 City Agency 2 https://www.visithalfmoonbay.org/discover/poplar-beach San Mateo 15 35.36 Poplar Beach 0 Local Park 2 4
11584 11584 11583 {"type": "Polygon", "coordinates": [[[-122.43615, 37.46803], [-122.43611, 37.46833], [-122.43586, 37.46831], [-122.43575, 37.46861], [-122.43551, 37.4687], [-122.43527, 37.46858], [-122.43523, 37.46846], [-122.4353, 37.46795], [-122.43615, 37.46803]]]} Open Access 1 23679 Oak Avenue 22956 1128 Half Moon Bay, City of 439 City 2 City Agency 2 http://www.half-moon-bay.ca.us/ City 2 1128 Half Moon Bay, City of 433 City 2 City Agency 2   San Mateo 15 1.133 Oak Avenue   None 1033  

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