units_with_maps

Table actions

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

24 rows where ACCESS_TYP = 1, AGNCY_WEB = "http://www.ssf.net/377/Parks-Recreation" and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

These facets timed out: ACCESS_TYP, MNG_AGENCY, MNG_AG_TYP, DES_TP

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
150 150 149 {"type": "Polygon", "coordinates": [[[-122.37823, 37.65795], [-122.37809, 37.65808], [-122.37717, 37.65723], [-122.37692, 37.65689], [-122.37681, 37.65671], [-122.37658, 37.65623], [-122.37649, 37.65598], [-122.37644, 37.65557], [-122.37631, 37.65525], [-122.37614, 37.65507], [-122.37557, 37.65506], [-122.37555, 37.65493], [-122.3765, 37.65493], [-122.37663, 37.65527], [-122.37674, 37.65581], [-122.37692, 37.65629], [-122.37762, 37.65744], [-122.37776, 37.65752], [-122.37823, 37.65795]]]} Open Access 1 388 San Bruno Point Park 24841 1341 South San Francisco, City of 60 City 2 City Agency 2 http://www.ssf.net/377/Parks-Recreation City 2 1341 South San Francisco, City of 58 City 2 City Agency 2   San Mateo 15 2.521 San Bruno Point Park 0 Local Park 2 4
1768 1768 1767 {"type": "Polygon", "coordinates": [[[-122.45497, 37.66843], [-122.45478, 37.66855], [-122.4547, 37.66847], [-122.45464, 37.66833], [-122.45454, 37.66839], [-122.45421, 37.6682], [-122.45421, 37.66809], [-122.45418, 37.668], [-122.45447, 37.66792], [-122.45403, 37.66686], [-122.45429, 37.6668], [-122.45497, 37.66843]]]} Open Access 1 15288 Winston Manor Park 27651 1341 South San Francisco, City of 60 City 2 City Agency 2 http://www.ssf.net/377/Parks-Recreation City 2 1341 South San Francisco, City of 58 City 2 City Agency 2   San Mateo 15 1.481 Winston Manor Park 0 Local Park 2 4
1998 1998 1997 {"type": "Polygon", "coordinates": [[[-122.38615, 37.66234], [-122.38604, 37.66244], [-122.38546, 37.66259], [-122.38531, 37.66261], [-122.38516, 37.6626], [-122.38494, 37.66254], [-122.3848, 37.66246], [-122.38461, 37.6623], [-122.38449, 37.66216], [-122.38418, 37.66178], [-122.38419, 37.66176], [-122.38414, 37.66171], [-122.384, 37.66158], [-122.38383, 37.66146], [-122.3836, 37.66136], [-122.38332, 37.66129], [-122.38303, 37.66126], [-122.38275, 37.66129], [-122.38275, 37.66088], [-122.38533, 37.66089], [-122.38529, 37.66104], [-122.38525, 37.66105], [-122.38525, 37.66108], [-122.38539, 37.6611], [-122.38535, 37.6613], [-122.38537, 37.6614], [-122.3854, 37.6615], [-122.38549, 37.6615], [-122.38569, 37.66183], [-122.38595, 37.66219], [-122.38615, 37.66234]]]} Open Access 1 15308 Oyster Point Park 23285 1341 South San Francisco, City of 60 City 2 City Agency 2 http://www.ssf.net/377/Parks-Recreation City 2 1341 South San Francisco, City of 58 City 2 City Agency 2   San Mateo 15 7.052 Oyster Point Park 2000 Local Park 2 4
2042 2042 2041 {"type": "Polygon", "coordinates": [[[-122.41421, 37.65619], [-122.41393, 37.65698], [-122.41226, 37.65661], [-122.41254, 37.65582], [-122.41421, 37.65619]]]} Open Access 1 15574 City Hall Tot Lot 17299 1341 South San Francisco, City of 60 City 2 City Agency 2 http://www.ssf.net/377/Parks-Recreation City 2 1341 South San Francisco, City of 58 City 2 City Agency 2   San Mateo 15 3.439 City Hall Tot Lot 0 Local Recreation Area 3 4
4246 4246 4245 {"type": "Polygon", "coordinates": [[[-122.45852, 37.65833], [-122.45843, 37.65862], [-122.45812, 37.65853], [-122.45806, 37.65848], [-122.45803, 37.65841], [-122.45827, 37.65833], [-122.45852, 37.65833]]]} Open Access 1 47231 Dundee Playlot 30939 1341 South San Francisco, City of 60 City 2 City Agency 2 http://www.ssf.net/377/Parks-Recreation City 2 1341 South San Francisco, City of 58 City 2 City Agency 2   San Mateo 15 0.223 Dundee Playlot 0 Local Recreation Area 3 4
5081 5081 5080 {"type": "Polygon", "coordinates": [[[-122.45903, 37.6453], [-122.45838, 37.64534], [-122.45836, 37.64531], [-122.45811, 37.64533], [-122.4581, 37.64537], [-122.45738, 37.64542], [-122.45736, 37.6454], [-122.45608, 37.64547], [-122.45658, 37.64439], [-122.45723, 37.64335], [-122.45728, 37.64333], [-122.4578, 37.64347], [-122.4581, 37.64353], [-122.45841, 37.64358], [-122.45886, 37.6436], [-122.45903, 37.6453]]]} Open Access 1 15294 Westborough Recreation Park 33382 1341 South San Francisco, City of 60 City 2 City Agency 2 http://www.ssf.net/377/Parks-Recreation City 2 1341 South San Francisco, City of 58 City 2 City Agency 2 http://www.ssf.net/departments/parks-recreation/recreation-division/rentals/westborough-recreation-building San Mateo 15 10.787 Westborough Rec. Park 1988 Local Recreation Area 3 4
5193 5193 5192 {"type": "Polygon", "coordinates": [[[-122.42275, 37.64511], [-122.42239, 37.64563], [-122.42222, 37.64588], [-122.42208, 37.64571], [-122.4227, 37.64509], [-122.42275, 37.64511]]]} Open Access 1 15578 Francisco Terrace Playlot 19046 1341 South San Francisco, City of 60 City 2 City Agency 2 http://www.ssf.net/377/Parks-Recreation City 2 1341 South San Francisco, City of 58 City 2 City Agency 2   San Mateo 15 0.301 Francisco Terrace Playlot 0 Local Recreation Area 3 4
5194 5194 5193 {"type": "Polygon", "coordinates": [[[-122.40018, 37.66434], [-122.40011, 37.66463], [-122.39923, 37.66446], [-122.39958, 37.66423], [-122.40018, 37.66434]]]} Open Access 1 15580 Gardiner Lot 19209 1341 South San Francisco, City of 60 City 2 City Agency 2 http://www.ssf.net/377/Parks-Recreation City 2 1341 South San Francisco, City of 58 City 2 City Agency 2   San Mateo 15 0.528 Gardiner Lot 0 Local Other or Unknown 14 4
5195 5195 5194 {"type": "Polygon", "coordinates": [[[-122.42524, 37.66988], [-122.4246, 37.67055], [-122.42363, 37.67039], [-122.42299, 37.6698], [-122.42258, 37.6689], [-122.42434, 37.66836], [-122.42454, 37.6687], [-122.42436, 37.66885], [-122.42524, 37.66988]]]} Open Access 1 15582 Hillside Athletic Field 19979 1341 South San Francisco, City of 60 City 2 City Agency 2 http://www.ssf.net/377/Parks-Recreation City 2 1341 South San Francisco, City of 58 City 2 City Agency 2   San Mateo 15 8.293 Hillside Athletic Field 0 Local Recreation Area 3 4
5231 5231 5230 {"type": "Polygon", "coordinates": [[[-122.41794, 37.66954], [-122.41782, 37.66978], [-122.41736, 37.66965], [-122.41732, 37.6697], [-122.41724, 37.66968], [-122.41714, 37.66987], [-122.41715, 37.66992], [-122.41649, 37.66992], [-122.41638, 37.66991], [-122.4161, 37.66983], [-122.41588, 37.66969], [-122.41577, 37.66958], [-122.41559, 37.66928], [-122.41543, 37.6691], [-122.41558, 37.6688], [-122.41725, 37.66927], [-122.41725, 37.66931], [-122.41728, 37.66934], [-122.41794, 37.66954]]]} Open Access 1 15584 Terrabay Gymnasium 26256 1341 South San Francisco, City of 60 City 2 City Agency 2 http://www.ssf.net/377/Parks-Recreation City 2 1341 South San Francisco, City of 58 City 2 City Agency 2   San Mateo 15 3.663 Terrabay Gymnasium 0 Local Recreation Area 3 4
5332 5332 5331 {"type": "Polygon", "coordinates": [[[-122.44991, 37.66066], [-122.44807, 37.66234], [-122.4475, 37.66015], [-122.44784, 37.65985], [-122.44694, 37.65923], [-122.44733, 37.65888], [-122.44744, 37.65894], [-122.44991, 37.66066]]]} Open Access 1 15568 Alta Loma Park 15415 1341 South San Francisco, City of 60 City 2 City Agency 2 http://www.ssf.net/377/Parks-Recreation City 2 1341 South San Francisco, City of 58 City 2 City Agency 2   San Mateo 15 9.811 Alta Loma Park 0 Local Park 2 4
5333 5333 5332 {"type": "Polygon", "coordinates": [[[-122.40699, 37.65869], [-122.40686, 37.65906], [-122.40654, 37.65898], [-122.40672, 37.65863], [-122.40699, 37.65869]]]} Open Access 1 15576 Cypress and Pine Playlot 17870 1341 South San Francisco, City of 60 City 2 City Agency 2 http://www.ssf.net/377/Parks-Recreation City 2 1341 South San Francisco, City of 58 City 2 City Agency 2   San Mateo 15 0.283 Cypress and Pine Playlot 0 Local Recreation Area 3 4
6072 6072 6071 {"type": "Polygon", "coordinates": [[[-122.42394, 37.66276], [-122.4236, 37.66382], [-122.42337, 37.66377], [-122.42279, 37.66405], [-122.42255, 37.66412], [-122.42234, 37.66415], [-122.42203, 37.66416], [-122.42176, 37.66413], [-122.42111, 37.66404], [-122.42093, 37.66398], [-122.42076, 37.66389], [-122.42013, 37.66344], [-122.42032, 37.66322], [-122.41986, 37.66289], [-122.41932, 37.66323], [-122.41925, 37.66378], [-122.41982, 37.66422], [-122.42033, 37.66421], [-122.42065, 37.66439], [-122.42201, 37.66456], [-122.42245, 37.66472], [-122.4232, 37.66619], [-122.42314, 37.66632], [-122.42194, 37.6658], [-122.42139, 37.66606], [-122.42127, 37.66604], [-122.42103, 37.66576], [-122.42049, 37.66579], [-122.42005, 37.66565], [-122.41941, 37.66631], [-122.41916, 37.66626], [-122.41897, 37.66616], [-122.41887, 37.66596], [-122.41889, 37.66506], [-122.4186, 37.66487], [-122.41821, 37.66499], [-122.41789, 37.66494], [-122.41762, 37.66451], [-122.4171, 37.66411], [-122.41695, 37.6639], [-122.41704, 37.66318], [-122.4169, 37.66317], [-122.41655, 37.66287], [-122.41637, 37.66301], [-122.41522, 37.66251], [-122.41543, 37.66213], [-122.41547, 37.66214], [-122.41563, 37.66191], [-122.41556, 37.66187], [-122.41575, 37.66148], [-122.41595, 37.66167], [-122.41627, 37.6619], [-122.41661, 37.66208], [-122.41767, 37.66246], [-122.4181, 37.66259], [-122.41845, 37.66262], [-122.41881, 37.66261], [-122.41949, 37.66252], [-122.41991, 37.66249], [-122.41994, 37.66265], [-122.42044, 37.66282], [-122.4209, 37.66294], [-122.42117, 37.66299], [-122.42156, 37.66305], [-122.42192, 37.66306], [-122.42213, 37.66303], [-122.42235, 37.66295], [-122.42256, 37.66283], [-122.4227, 37.6627], [-122.42283, 37.66251], [-122.42394, 37.66276]]]} Open Access 1 810 Sign Hill Park 25475 1341 South San Francisco, City of 60 City 2 City Agency 2 http://www.ssf.net/377/Parks-Recreation City 2 1341 South San Francisco, City of 58 City 2 City Agency 2   San Mateo 15 41.244 Sign Hill Park 0 Local Park 2 4
8482 8482 8481 {"type": "Polygon", "coordinates": [[[-122.44262, 37.65196], [-122.44151, 37.65257], [-122.44172, 37.65284], [-122.44153, 37.65298], [-122.44106, 37.65264], [-122.44116, 37.65242], [-122.44118, 37.6519], [-122.44114, 37.65167], [-122.44187, 37.6505], [-122.44201, 37.65058], [-122.44199, 37.65087], [-122.44225, 37.65137], [-122.44262, 37.65196]]]} Open Access 1 15299 Buri Buri Park 16519 1341 South San Francisco, City of 60 City 2 City Agency 2 http://www.ssf.net/377/Parks-Recreation City 2 1341 South San Francisco, City of 58 City 2 City Agency 2   San Mateo 15 4.449 Buri Buri Park 0 Local Park 2 4
9164 9164 9163 {"type": "Polygon", "coordinates": [[[-122.46344, 37.66183], [-122.46339, 37.66197], [-122.46341, 37.6623], [-122.46328, 37.66235], [-122.46298, 37.6623], [-122.46288, 37.66226], [-122.46328, 37.66174], [-122.46344, 37.66183]]]} Open Access 1 15285 Clay Avenue Park 17396 1341 South San Francisco, City of 60 City 2 City Agency 2 http://www.ssf.net/377/Parks-Recreation City 2 1341 South San Francisco, City of 58 City 2 City Agency 2   San Mateo 15 0.473 Clay Avenue Park 0 Local Park 2 4
9200 9200 9199 {"type": "Polygon", "coordinates": [[[-122.46786, 37.64523], [-122.46718, 37.64576], [-122.46656, 37.64621], [-122.46629, 37.64592], [-122.46629, 37.64591], [-122.46601, 37.64564], [-122.46625, 37.64547], [-122.46625, 37.64545], [-122.46633, 37.6454], [-122.46633, 37.64538], [-122.46687, 37.645], [-122.46726, 37.64511], [-122.46786, 37.64523]]]} Open Access 1 15291 Callan Park 16733 1341 South San Francisco, City of 60 City 2 City Agency 2 http://www.ssf.net/377/Parks-Recreation City 2 1341 South San Francisco, City of 58 City 2 City Agency 2   San Mateo 15 2.563 Callan Park 0 Local Park 2 4
9207 9207 9206 {"type": "Polygon", "coordinates": [[[-122.43455, 37.63576], [-122.43382, 37.63627], [-122.43337, 37.63686], [-122.43296, 37.6372], [-122.43285, 37.6374], [-122.43301, 37.63752], [-122.43285, 37.6377], [-122.43275, 37.63791], [-122.43271, 37.63793], [-122.43265, 37.63791], [-122.43251, 37.6377], [-122.43245, 37.63741], [-122.43268, 37.63738], [-122.43274, 37.63721], [-122.43271, 37.63703], [-122.43338, 37.63633], [-122.43345, 37.63615], [-122.43346, 37.63594], [-122.43333, 37.63581], [-122.43407, 37.63532], [-122.43455, 37.63576]]]} Open Access 1 15319 Brentwood Park 16360 1341 South San Francisco, City of 60 City 2 City Agency 2 http://www.ssf.net/377/Parks-Recreation City 2 1341 South San Francisco, City of 58 City 2 City Agency 2   San Mateo 15 3.036 Brentwood Park 0 Local Park 2 4
9212 9212 9211 {"type": "Polygon", "coordinates": [[[-122.45012, 37.64323], [-122.44997, 37.64418], [-122.44975, 37.64424], [-122.44961, 37.64426], [-122.44944, 37.64425], [-122.44931, 37.64422], [-122.4482, 37.64366], [-122.44809, 37.64348], [-122.44752, 37.64319], [-122.44762, 37.64304], [-122.44753, 37.64223], [-122.44771, 37.64225], [-122.44796, 37.6423], [-122.44832, 37.64243], [-122.44865, 37.64259], [-122.44914, 37.64292], [-122.4494, 37.64305], [-122.44975, 37.64317], [-122.45012, 37.64323]]]} Open Access 1 15297 Sellick Park 25289 1341 South San Francisco, City of 60 City 2 City Agency 2 http://www.ssf.net/377/Parks-Recreation City 2 1341 South San Francisco, City of 58 City 2 City Agency 2   San Mateo 15 7.001 Sellick Park 0 Local Park 2 4
9213 9213 9212 {"type": "Polygon", "coordinates": [[[-122.42934, 37.65342], [-122.42888, 37.65473], [-122.42854, 37.65581], [-122.42848, 37.6558], [-122.4284, 37.65581], [-122.42728, 37.6556], [-122.42439, 37.65498], [-122.42698, 37.65215], [-122.42694, 37.6521], [-122.42697, 37.65207], [-122.42787, 37.65262], [-122.42934, 37.65342]]]} Open Access 1 15302 Orange Memorial Park 23177 1341 South San Francisco, City of 60 City 2 City Agency 2 http://www.ssf.net/377/Parks-Recreation City 2 1341 South San Francisco, City of 58 City 2 City Agency 2   San Mateo 15 25.117 Orange Memorial Park 0 Local Park 2 4
9214 9214 9213 {"type": "Polygon", "coordinates": [[[-122.43749, 37.6417], [-122.43708, 37.64219], [-122.43677, 37.64236], [-122.43671, 37.64168], [-122.43693, 37.64167], [-122.43694, 37.64171], [-122.43697, 37.64175], [-122.43706, 37.64178], [-122.43716, 37.64175], [-122.4372, 37.64168], [-122.43749, 37.6417]]]} Open Access 1 15316 Zamora Playlot 27853 1341 South San Francisco, City of 60 City 2 City Agency 2 http://www.ssf.net/377/Parks-Recreation City 2 1341 South San Francisco, City of 58 City 2 City Agency 2   San Mateo 15 0.712 Zamora Playlot 0 Local Recreation Area 3 4

Next page

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