trees

Custom SQL query returning 26 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
17997 122419 4 15 2200 San Jose Ave 1 Sidewalk: Curb side : Cutout Tree 3       3x3   5998886 2091075 37.7216297132481 -122.445935857536 (37.7216297132481, -122.445935857536) 9 7 6 28861 25
20288 26672 7 1 495X Geneva Ave 6 Sidewalk: Curb side : Cutout Tree 3     8 3X3   5998682.3051661 2090785.318168 37.7208226804469 -122.446619141783 (37.7208226804469, -122.446619141783) 9 7 6 28861 25
33623 26669 7 1 495X Geneva Ave 3 Sidewalk: Curb side : Cutout Tree 3     8 3X3   5998682.3051661 2090785.318168 37.7208226804469 -122.446619141783 (37.7208226804469, -122.446619141783) 9 7 6 28861 25
36696 25401 7 14 495X Geneva Ave 1 Sidewalk: Curb side : Cutout Tree 3   06/28/1996 12:00:00 AM 8 3X3   5998682.3051661 2090785.318168 37.7208226804469 -122.446619141783 (37.7208226804469, -122.446619141783) 9 7 6 28861 25
39321 120597 6 15 499x Ocean Ave 5 Sidewalk: Curb side : Cutout Tree 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
44800 120594 6 15 499x Ocean Ave 2 Sidewalk: Curb side : Cutout Tree 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
63072 26671 7 1 495X Geneva Ave 5 Sidewalk: Curb side : Cutout Tree 3     8 3X3   5998682.3051661 2090785.318168 37.7208226804469 -122.446619141783 (37.7208226804469, -122.446619141783) 9 7 6 28861 25
80257 122411 6 57 499x Ocean Ave 8 Sidewalk: Curb side : Cutout Tree 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
92548 122410 6 57 499x Ocean Ave 7 Sidewalk: Curb side : Cutout Tree 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
95104 120593 6 16 499x Ocean Ave 4 Sidewalk: Curb side : Cutout Tree 3     34 3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
102801 122418 6 57 499x Ocean Ave 15 Sidewalk: Curb side : Cutout Tree 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
104414 120596 6 15 499x Ocean Ave 1 Sidewalk: Curb side : Cutout Tree 3     36 3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
116578 120595 6 15 499x Ocean Ave 3 Sidewalk: Curb side : Cutout Tree 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
116635 26670 7 1 495X Geneva Ave 4 Sidewalk: Curb side : Cutout Tree 3     8 3X3   5998682.3051661 2090785.318168 37.7208226804469 -122.446619141783 (37.7208226804469, -122.446619141783) 9 7 6 28861 25
121949 25403 7 14 495X Geneva Ave 7 Sidewalk: Curb side : Cutout Tree 3   06/28/1996 12:00:00 AM 6 3X3   5998682.3051661 2090785.318168 37.7208226804469 -122.446619141783 (37.7208226804469, -122.446619141783) 9 7 6 28861 25
123658 25405 7 14 495X Geneva Ave 9 Sidewalk: Curb side : Cutout Tree 3   06/28/1996 12:00:00 AM 12 3X3   5998682.3051661 2090785.318168 37.7208226804469 -122.446619141783 (37.7208226804469, -122.446619141783) 9 7 6 28861 25
134029 25404 7 14 495X Geneva Ave 8 Sidewalk: Curb side : Cutout Tree 3   01/04/2002 12:00:00 AM 8 3X3   5998682.3051661 2090785.318168 37.7208226804469 -122.446619141783 (37.7208226804469, -122.446619141783) 9 7 6 28861 25
136955 122414 6 57 499x Ocean Ave 11 Sidewalk: Curb side : Cutout Tree 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
141801 122417 6 57 499x Ocean Ave 14 Sidewalk: Curb side : Cutout Tree 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
148884 122413 6 57 499x Ocean Ave 10 Sidewalk: Curb side : Cutout Tree 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
149548 122416 6 57 499x Ocean Ave 13 Sidewalk: Curb side : Cutout Tree 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
156105 122412 6 57 499x Ocean Ave 9 Sidewalk: Curb side : Cutout Tree 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
162950 122415 6 57 499x Ocean Ave 12 Sidewalk: Curb side : Cutout Tree 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
166166 120598 6 15 499x Ocean Ave 6 Sidewalk: Curb side : Cutout Tree 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
173056 122420 4 31 2200 San Jose Ave 2 Sidewalk: Curb side : Cutout Tree 3       3x3   5998886 2091075 37.7216297132481 -122.445935857536 (37.7216297132481, -122.445935857536) 9 7 6 28861 25
178605 25402 7 14 495X Geneva Ave 2 Sidewalk: Curb side : Cutout Tree 3   06/28/1996 12:00:00 AM 6 3X3   5998682.3051661 2090785.318168 37.7208226804469 -122.446619141783 (37.7208226804469, -122.446619141783) 9 7 6 28861 25