trees

Custom SQL query returning 36 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
23293 101516 7 97 610 Leavenworth St 3 Sidewalk: Curb side : Cutout Tree 2     12 3x3 Permit Number 28301 6008387 2114552 37.7866301828456 -122.414753982265 (37.7866301828456, -122.414753982265) 5 1 10 28858 36
145583 101515 7 97 610 Leavenworth St 2 Sidewalk: Curb side : Cutout Tree 2     12 3x3 Permit Number 28301 6008387 2114552 37.7866301828456 -122.414753982265 (37.7866301828456, -122.414753982265) 5 1 10 28858 36
189489 100475 1 97 340 Mason St 1 Sidewalk: Curb side : Cutout Tree 2     10 3x3 Permit Number 781547 6009838.89839 2114609.02446 37.7868682279306 -122.409734770741 (37.7868682279306, -122.409734770741) 5 10 10 28852 36
158586 100476 1 97 340 Mason St 2 Sidewalk: Curb side : Cutout Tree 2     8 3x3 Permit Number 781547 6009833.38685 2114620.58318 37.7868996565447 -122.409754655664 (37.7868996565447, -122.409754655664) 5 10 10 28852 36
56711 100477 1 97 340 Mason St 3 Sidewalk: Curb side : Cutout Tree 2     8 3x3 Permit Number 781547 6009834.90147 2114634.4517 37.7869378210564 -122.409750394691 (37.7869378210564, -122.409750394691) 5 10 10 28852 36
102943 100479 1 97 340 Mason St 4 Sidewalk: Curb side : Cutout Tree 2     8 3x3 Permit Number 781547 6009830.08403 2114659.89537 37.7870074133103 -122.409768858656 (37.7870074133103, -122.409768858656) 5 10 10 28852 36
102755 62037 1 97 395 Geary St 1 Sidewalk: Curb side : Cutout Tree 2   07/01/1985 12:00:00 AM 14 3x3 Permit Number 781547 6009850.4646 2114693.00092 37.7870994553217 -122.409700683759 (37.7870994553217, -122.409700683759) 5 1 10 28852 36
86785 47045 7 97 111 Maiden Ln 3 Sidewalk: Curb side : Cutout Tree 2   05/02/2002 12:00:00 AM     Permit Number 45035 6011125.92683466 2115044.13243826 37.7881349707775 -122.405312579096 (37.7881349707775, -122.405312579096) 5 1 10 28857 6
107326 66869 7 97 640 Sutter St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 11/18/1991 12:00:00 AM     Permit Number 30178 6009507.57601331 2115392.34348399 37.789000460867 -122.410936420318 (37.789000460867, -122.410936420318) 5 1 10 28857 21
176360 53343 7 97 620 Sutter St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 05/13/1995 12:00:00 AM     Permit Number 30179 6009598.94591555 2115405.06508937 37.7890405143898 -122.410621189952 (37.7890405143898, -122.410621189952) 5 1 10 28857 21
20155 98985 4 97 847 Bush St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6009438.4 2115684 37.7897973999496 -122.411196371815 (37.7897973999496, -122.411196371815) 5 1 10 28857 21
129528 98986 4 97 847 Bush St 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6009438.4 2115684 37.7897973999496 -122.411196371815 (37.7897973999496, -122.411196371815) 5 1 10 28857 21
148031 98988 4 97 847 Bush St 4 Sidewalk: Curb side : Cutout Tree 2       3x3   6009438.4 2115684 37.7897973999496 -122.411196371815 (37.7897973999496, -122.411196371815) 5 1 10 28857 21
170940 98987 4 97 847 Bush St 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6009438.4 2115684 37.7897973999496 -122.411196371815 (37.7897973999496, -122.411196371815) 5 1 10 28857 21
84852 65486 7 97 801 Bush St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 12/15/1989 12:00:00 AM     Permit Number 28370 6009649.36997858 2115707.80146662 37.7898745823318 -122.410468114048 (37.7898745823318, -122.410468114048) 5 1 10 28857 21
83298 65478 7 97 601 Stockton St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 12/12/1989 12:00:00 AM     Permit Number 28359 6010541.36110634 2116214.27782437 37.7913152098094 -122.407417612453 (37.7913152098094, -122.407417612453) 5 1 10 28857 21
27124 33817 7 97 1201 California St 2 Sidewalk: Curb side : Cutout Tree 2   01/21/1997 12:00:00 AM     Permit Number 37831 6008598.80477101 2116262.85239853 37.7913396656633 -122.414142270961 (37.7913396656633, -122.414142270961) 5 1 10 28858 21
41504 33816 7 97 1201 California St 1 Sidewalk: Curb side : Cutout Tree 2   01/21/1997 12:00:00 AM     Permit Number 37831 6008598.80477101 2116262.85239853 37.7913396656633 -122.414142270961 (37.7913396656633, -122.414142270961) 5 1 10 28858 21
178511 116038 1 97 1401x Sacramento St 1 Sidewalk: Curb side : Cutout Tree 2     15 3x3   6008011.06753 2116537.17208 37.7920598504338 -122.416195270994 (37.7920598504338, -122.416195270994) 5 1 10 28858 21
30441 116039 1 97 1401x Sacramento St 2 Sidewalk: Curb side : Cutout Tree 2     16 3x3   6008038.31567 2116541.76159 37.7920739841803 -122.416101317043 (37.7920739841803, -122.416101317043) 5 1 10 28858 21
36271 126620 1 97 1430 Sacramento St 1 Sidewalk: Curb side : Cutout Tree 2     20 Width 3ft   6007903.30397 2116551.24821 37.7920924400618 -122.416569132658 (37.7920924400618, -122.416569132658) 5 1 10 28858 21
10858 128369 1 97 843 California St 3 Sidewalk: Curb side : Pot Tree 2     15 Width 4ft   6010471.73552 2116514.30785 37.7921351227858 -122.4076796805 (37.7921351227858, -122.4076796805) 5 1 10 28857 21
152169 65423 7 97 801 California St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 12/05/1989 12:00:00 AM     Permit Number 28281 6010517.63649674 2116529.16048818 37.7921784739149 -122.407521909343 (37.7921784739149, -122.407521909343) 5 1 10 28857 21
87294 99016 7 97 1133 Taylor St 3 Sidewalk: Curb side : Cutout Tree 2         Permit Number 29980 6008997 2116859 37.7929988993441 -122.41280668477 (37.7929988993441, -122.41280668477) 5 1 10 28857 21
37424 48789 7 97 1405 Taylor St 2 Sidewalk: Curb side : Cutout Tree 2   10/30/2002 12:00:00 AM     Permit Number 46040 6008874.44924411 2117680.29283989 37.7952470886304 -122.413288823995 (37.7952470886304, -122.413288823995) 5 1 10 308 21
41084 48790 7 97 1405 Taylor St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 01/21/2006 12:00:00 AM     Permit Number 46040 6008874.44924411 2117680.29283989 37.7952470886304 -122.413288823995 (37.7952470886304, -122.413288823995) 5 1 10 308 21
50226 48785 7 97 1405 Taylor St 3 Sidewalk: Curb side : Cutout Tree 2   10/30/2002 12:00:00 AM     Permit Number 46040 6008874.44924411 2117680.29283989 37.7952470886304 -122.413288823995 (37.7952470886304, -122.413288823995) 5 1 10 308 21
58028 48791 7 97 1405 Taylor St 5 Sidewalk: Curb side : Cutout Tree 2   10/30/2002 12:00:00 AM     Permit Number 46040 6008874.44924411 2117680.29283989 37.7952470886304 -122.413288823995 (37.7952470886304, -122.413288823995) 5 1 10 308 21
181146 48788 7 97 1405 Taylor St 4 Sidewalk: Curb side : Cutout Tree 2   10/30/2002 12:00:00 AM     Permit Number 46040 6008874.44924411 2117680.29283989 37.7952470886304 -122.413288823995 (37.7952470886304, -122.413288823995) 5 1 10 308 21
160598 34453 1 97 1167 Green St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 07/15/1997 12:00:00 AM 10   Permit Number 38197 6007453.34661 2118811.22971 37.7982724714417 -122.418286300874 (37.7982724714417, -122.418286300874) 5 1 10 28858 32
125743 35237 1 97 1198 Filbert St 2 Sidewalk: Curb side : Cutout Tree 2 FUF 02/17/1998 12:00:00 AM 8   Permit Number 38733 6007256.14978 2119525.96271 37.8002238465228 -122.419019384135 (37.8002238465228, -122.419019384135) 5 1 1 28858 32
80740 35236 1 97 1198 Filbert St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 02/17/1998 12:00:00 AM 10   Permit Number 38733 6007268.58471 2119527.95161 37.8002300077587 -122.418976495462 (37.8002300077587, -122.418976495462) 5 1 1 28858 32
27553 97723 1 97 1000X Bay St 2 Sidewalk: Property side : Cutout Tree 4 DPW for City Agency   14 7x57   6005985.5 2121074.1 37.8044030021841 -122.42352646028 (37.8044030021841, -122.42352646028) 5 1 1 28858 32
79131 97722 1 97 1000X Bay St 1 Sidewalk: Property side : Cutout Tree 4 DPW for City Agency   14 7x57   6005985.5 2121074.1 37.8044030021841 -122.42352646028 (37.8044030021841, -122.42352646028) 5 1 1 28858 32
91578 97725 1 97 1000X Bay St 4 Sidewalk: Property side : Cutout Tree 4 DPW for City Agency     7x82   6005985.5 2121074.1 37.8044030021841 -122.42352646028 (37.8044030021841, -122.42352646028) 5 1 1 28858 32
167189 97724 1 97 1000X Bay St 3 Sidewalk: Property side : Cutout Tree 4 DPW for City Agency   14 7x82   6005985.5 2121074.1 37.8044030021841 -122.42352646028 (37.8044030021841, -122.42352646028) 5 1 1 28858 32