trees

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
382 34903 7 19   4 Sidewalk: Curb side : Cutout Tree 2   09/05/1997 12:00:00 AM     Permit Number 38505                    
1118 36625 7 19   1 Sidewalk: Curb side : Cutout Tree 2   05/20/1998 12:00:00 AM     Permit Number 39461                    
1398 20032 1 19 100 STAIRWAY51 3 Sidewalk: Curb side : Cutout Tree 1     3 3X3ST                      
2140 46192 7 19   6 Sidewalk: Curb side : Cutout Tree 2   12/31/2001 12:00:00 AM     Permit Number 44518                    
3497 46195 7 19   2 Sidewalk: Curb side : Cutout Tree 2   12/31/2001 12:00:00 AM     Permit Number 44518                    
3531 39973 7 19 0 Steiner St 3 Sidewalk: Curb side : Cutout Tree 2         Permit Number 41235                    
3892 39976 7 19 0 Steiner St 5 Sidewalk: Curb side : Cutout Tree 2         Permit Number 41235                    
4058 34900 7 19   2 Sidewalk: Curb side : Cutout Tree 2   09/05/1997 12:00:00 AM     Permit Number 38505                    
4332 30435 7 19 3229 Barker St 1 Sidewalk: Curb side : Cutout Tree 2   05/11/1956 12:00:00 AM     Permit Number 88                    
4959 47411 7 19 2722 Funston Ave 1 Sidewalk: Curb side : Cutout Tree 2   05/14/2002 12:00:00 AM     Permit Number 45322                    
4969 36620 7 19   6 Sidewalk: Curb side : Cutout Tree 2   05/20/1998 12:00:00 AM     Permit Number 39461                    
6196 33080 7 19 221 Greenwood Ave 1 Sidewalk: Curb side : Cutout Tree 2   11/05/1996 12:00:00 AM     Permit Number 37335                    
8285 36624 7 19   2 Sidewalk: Curb side : Cutout Tree 2   05/20/1998 12:00:00 AM     Permit Number 39461                    
8292 261770 1 19 600X Columbus Ave 7 Sidewalk: Curb side : Cutout Tree 1   06/26/2020 11:05:00 AM 3 4x4                      
8825 36621 7 19   5 Sidewalk: Curb side : Cutout Tree 2   05/20/1998 12:00:00 AM     Permit Number 39461                    
8963 36618 7 19   8 Sidewalk: Curb side : Cutout Tree 2   05/20/1998 12:00:00 AM     Permit Number 39461                    
9744 19850 1 19 100 STAIRWAY27 1 Sidewalk: Curb side : Cutout Tree 1     3 10ST                      
9853 46194 7 19   3 Sidewalk: Curb side : Cutout Tree 2   12/31/2001 12:00:00 AM     Permit Number 44518                    
10274 39974 7 19 0 Steiner St 4 Sidewalk: Curb side : Cutout Tree 2         Permit Number 41235                    
10529 46191 7 19   5 Sidewalk: Curb side : Cutout Tree 2   12/31/2001 12:00:00 AM     Permit Number 44518                    
10686 34901 7 19   7 Sidewalk: Curb side : Cutout Tree 2   09/05/1997 12:00:00 AM     Permit Number 38505                    
11435 36622 7 19   4 Sidewalk: Curb side : Cutout Tree 2   05/20/1998 12:00:00 AM     Permit Number 39461                    
11817 33081 7 19 221 Greenwood Ave 2 Sidewalk: Curb side : Cutout Tree 2   11/05/1996 12:00:00 AM     Permit Number 37335                    
11841 34905 7 19   6 Sidewalk: Curb side : Cutout Tree 2   09/05/1997 12:00:00 AM     Permit Number 38505                    
12228 34902 7 19   5 Sidewalk: Curb side : Cutout Tree 2   09/05/1997 12:00:00 AM     Permit Number 38505                    
13013 46193 7 19   4 Sidewalk: Curb side : Cutout Tree 2   12/31/2001 12:00:00 AM     Permit Number 44518                    
13886 34906 7 19   1 Sidewalk: Curb side : Cutout Tree 2   09/05/1997 12:00:00 AM     Permit Number 38505                    
14106 36623 7 19   3 Sidewalk: Curb side : Cutout Tree 2   05/20/1998 12:00:00 AM     Permit Number 39461                    
14123 36635 7 19   10 Sidewalk: Curb side : Cutout Tree 2   05/20/1998 12:00:00 AM     Permit Number 39461                    
15275 36627 7 19   9 Sidewalk: Curb side : Cutout Tree 2   05/20/1998 12:00:00 AM     Permit Number 39461                    
15484 36610 7 19   7 Sidewalk: Curb side : Cutout Tree 2   05/20/1998 12:00:00 AM     Permit Number 39461                    
15890 256718 7 19 927 Brazil Ave   Sidewalk: Curb side : Cutout Tree 2 FUF 11/30/2018 12:00:00 AM 3 3x3 Permit Number 782649                    
17350 34904 7 19   3 Sidewalk: Curb side : Cutout Tree 2   09/05/1997 12:00:00 AM     Permit Number 38505                    
17701 46199 7 19   7 Sidewalk: Curb side : Cutout Tree 2   12/31/2001 12:00:00 AM     Permit Number 44518                    
18716 261769 1 19 600X Columbus Ave 3 Sidewalk: Curb side : Cutout Tree 1   06/26/2020 11:00:00 AM 3 4x4                      
19128 36616 7 19   11 Sidewalk: Curb side : Cutout Tree 2   05/20/1998 12:00:00 AM     Permit Number 39461                    
19157 46202 7 19   1 Sidewalk: Curb side : Cutout Tree 2   12/31/2001 12:00:00 AM     Permit Number 44518                    
76 34164 1 19 2500 Broadway 3 Sidewalk: Curb side : Cutout Tree 2   07/22/1997 12:00:00 AM 5   Permit Number 38230 6001594.91074 2117340.13182 37.7939017096586 -122.438452751501 (37.7939017096586, -122.438452751501) 13 9 1 57 27
510 138618 1 19 1844 BRODERICK ST 3 Sidewalk: Curb side : Cutout Tree 2     2 Width 0ft   6000524.7294 2115065.5231 37.787595296239 -122.441992330061 (37.787595296239, -122.441992330061) 13 6 1 29490 27
867 130823 1 19 2451 Laguna St 3 Sidewalk: Curb side : Cutout Tree 2     5 Width 3ft   6004083.73489 2117213.2991 37.7936947127019 -122.429832130065 (37.7936947127019, -122.429832130065) 13 9 1 29490 27
924 168125 1 19 2329 Baker St 3 Sidewalk: Curb side : Cutout Tree 2     9 Width 3ft   5999732.18095 2116962.81225 37.7927595589676 -122.444870818143 (37.7927595589676, -122.444870818143) 13 6 1 29490 27
1296 114159 5 19 2250 Vallejo St 1 Sidewalk: Curb side : Cutout Tree 2   11/03/2015 12:00:00 AM 3 3x3 Permit Number 770124 6002793.85496 2117859.65506 37.7953963109343 -122.434341453993 (37.7953963109343, -122.434341453993) 13 9 1 57 17
1464 130824 1 19 2451 Laguna St 4 Sidewalk: Curb side : Cutout Tree 2     5 Width 3ft   6004088.29924 2117192.3041 37.7936373242572 -122.429814838808 (37.7936373242572, -122.429814838808) 13 9 1 29490 27
1624 70261 1 19 3828 Sacramento St 1 Sidewalk: Curb side : Cutout Tree 2 FUF   7     5996527.35216 2114976.82048 37.7871231398678 -122.455815970326 (37.7871231398678, -122.455815970326) 11 6 1 54 31
1682 3092 1 19 2980 California St 1 Sidewalk: Curb side : Cutout Tree 1     12 3X3   6000114.43818 2115142.33295 37.7877828069853 -122.443417371621 (37.7877828069853, -122.443417371621) 13 6 1 29490 27
2078 168123 1 19 2329 Baker St 1 Sidewalk: Curb side : Cutout Tree 2     9 Width 3ft   5999728.56043 2116992.74288 37.792841533961 -122.444885497769 (37.792841533961, -122.444885497769) 13 6 1 29490 27
3006 130736 1 19 2456 Broderick St 5 Sidewalk: Curb side : Cutout Tree 2     6 Width 3ft   6000252.0898 2117051.94751 37.793033958294 -122.443078320911 (37.793033958294, -122.443078320911) 13 6 1 29490 27
3139 130835 1 19 2707 Laguna St 2 Sidewalk: Curb side : Cutout Tree 2     15 Width 4ft   6003954.12542 2118159.05361 37.7962841720447 -122.430348098084 (37.7962841720447, -122.430348098084) 13 9 1 57 17
3209 130852 1 19 2400 Octavia St 3 Sidewalk: Curb side : Cutout Tree 2     5 Width 4ft   6004581.36981 2117470.78611 37.7944298743033 -122.42812862796 (37.7944298743033, -122.42812862796) 13 9 1 28858 27
3661 130497 1 19 3536 Scott St 2 Sidewalk: Curb side : Cutout Tree 2     10 Width 3ft   6000731.95465 2120687.25683 37.8030429054598 -122.441678975811 (37.8030429054598, -122.441678975811) 13 9 1 57 17
3833 130643 1 19 2596 Sacramento St 2 Sidewalk: Curb side : Cutout Tree 2     9 Width 3ft   6002472.36463 2115758.47109 37.7896087481804 -122.435303491175 (37.7896087481804, -122.435303491175) 13 9 1 29490 27
4024 114160 5 19 2250 Vallejo St 2 Sidewalk: Curb side : Cutout Tree 2   11/03/2015 12:00:00 AM 3 3x3 Permit Number 770124 6002777.5161 2117854.22202 37.7953804657925 -122.434397600465 (37.7953804657925, -122.434397600465) 13 9 1 57 17
4030 65762 1 19 3002 Laguna St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 04/23/1990 12:00:00 AM 13   Permit Number 28725 6003868.45772 2119096.10509 37.7988522212082 -122.43071142781 (37.7988522212082, -122.43071142781) 13 9 1 57 17
4264 130484 1 19 148 Pixley St 1 Sidewalk: Curb side : Cutout Tree 2     7 Width 3ft   6002643.1953 2119039.17059 37.7986264014436 -122.434947157292 (37.7986264014436, -122.434947157292) 13 9 1 57 17
4515 130841 1 19 2140 Pacific Ave 1 Sidewalk: Property side : Yard Tree 2     5 Width 4ft   6003916.87009 2117324.15419 37.7939896417495 -122.430417409747 (37.7939896417495, -122.430417409747) 13 9 1 29490 27
4555 130513 1 19 213 Walnut St 3 Sidewalk: Curb side : Cutout Tree 2     2 Width 4ft   5998527.12413 2115621.30489 37.7890072896931 -122.448943670531 (37.7890072896931, -122.448943670531) 13 6 1 54 31
4860 168126 1 19 2329 Baker St 4 Sidewalk: Curb side : Cutout Tree 2     9 Width 3ft   5999733.55538 2116947.29263 37.7927170246219 -122.444864946464 (37.7927170246219, -122.444864946464) 13 6 1 29490 27
5002 138596 1 19 1997 Scott St 1 Sidewalk: Curb side : Cutout Tree 2     1 Width 0ft   6001444.315 2115232.308 37.788105604547 -122.438822708512 (37.788105604547, -122.438822708512) 13 6 1 29490 27
5545 130743 1 19 2505 Divisadero St 4 Sidewalk: Property side : Yard Tree 2     15 Width 4ft   6000699.35516 2116964.23908 37.7928186255236 -122.441524465083 (37.7928186255236, -122.441524465083) 13 6 1 29490 27
5873 168127 1 19 2329 Baker St 5 Sidewalk: Curb side : Cutout Tree 2     9 Width 3ft   5999736.35511 2116932.30675 37.7926760371256 -122.444854181598 (37.7926760371256, -122.444854181598) 13 6 1 29490 27
5892 261243 1 19 840 El Camino Del Mar 3 Sidewalk: Curb side : Cutout Tree 2       Width 4ft   5985843 2115056 37.786721565729 -122.492786794237 (37.786721565729, -122.492786794237) 11 6 1 55 33
5958 102480 5 19 1456 Chestnut St 1 Sidewalk: Curb side : Cutout Tree 2   01/25/2013 12:00:00 AM 3 3x3 Permit Number 768914 6004877.03101 2120232.91154 37.8020306879258 -122.427302455863 (37.8020306879258, -122.427302455863) 13 9 1 57 17
6152 68969 1 19 3343 Broderick St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 01/04/1994 12:00:00 AM 9   Permit Number 32959 5999787.27845 2120075.09917 37.8013082157737 -122.44490400674 (37.8013082157737, -122.44490400674) 13 9 1 57 17
6574 65759 1 19 3016 Laguna St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 04/20/1990 12:00:00 AM 13   Permit Number 28722 6003857.62455 2119183.89761 37.7990926630433 -122.430755182511 (37.7990926630433, -122.430755182511) 13 9 1 57 17
6588 46352 1 19 2900 Washington St 3 Sidewalk: Curb side : Cutout Tree 2   02/27/2002 12:00:00 AM 13   Permit Number 44595 6000732.4975 2116220.35681 37.7907780071577 -122.441356390798 (37.7907780071577, -122.441356390798) 13 6 1 29490 27
6642 114245 5 19 54 COMMONWEALTH AVE 1 Sidewalk: Curb side : Cutout Tree 2     0 3x3   5996571 2114184 37.7849487713586 -122.455607632252 (37.7849487713586, -122.455607632252) 11 6 1 54 31
7297 130697 1 19 2311 Baker St 1 Sidewalk: Curb side : Cutout Tree 2     3 Width 3ft   5999746.50713 2116862.80854 37.7924857927226 -122.444814057435 (37.7924857927226, -122.444814057435) 13 6 1 29490 27
7596 137880 1 19 2148 PINE ST 1 Sidewalk: Curb side : Cutout Tree 2     1 Width 0ft   6003654.0545 2115274.6949 37.7883474575543 -122.431180423335 (37.7883474575543, -122.431180423335) 13 9 1 29490 27
8647 146616 5 19 1320 Chestnut St 1 Sidewalk: Curb side : Cutout Tree 2     0 4x4 Permit Number 783073 6005474.41066 2120313.40732 37.8022854748664 -122.425240967805 (37.8022854748664, -122.425240967805) 13 9 1 57 17
9118 120468 1 19 90 West Clay St 1 Sidewalk: Curb side : Yard Tree 2     9 Width 6ft   5988384.0014 2115083.94801 37.7869465618324 -122.483997692017 (37.7869465618324, -122.483997692017) 11 6 1 55 33
9273 28375 1 19 3014 Sacramento St 1 Sidewalk: Curb side : Cutout Tree 2   10/09/2003 12:00:00 AM 3 3x3 Permit Number 54020 6000248.59092 2115494.6796 37.7887579085949 -122.442978542939 (37.7887579085949, -122.442978542939) 13 6 1 29490 27
9614 130665 1 19 3152 Washington St 2 Sidewalk: Curb side : Cutout Tree 2     16 Width 4ft   5999642.12267 2116065.45546 37.7902905134552 -122.445117879904 (37.7902905134552, -122.445117879904) 13 6 1 29490 27
9640 17196 1 19 2235X Octavia St 5 Median : Cutout Tree 1     24 20   6004629.78741 2116932.39582 37.792954330542 -122.427922714666 (37.792954330542, -122.427922714666) 13 9 1 28858 27
9660 94240 1 19 2517 Pacific Ave 2 Sidewalk: Curb side : Cutout Tree 2   10/08/2019 12:00:00 AM 3 3x3 Permit Number 53613 6001913.77798 2116990.99637 37.7929612067506 -122.437324430597 (37.7929612067506, -122.437324430597) 13 6 1 29490 27
9882 110280 1 19 2845 Broadway 2 Sidewalk: Curb side : Cutout Tree 2     10 4x4   5999937.93955 2117050.91929 37.7930132181276 -122.444165220867 (37.7930132181276, -122.444165220867) 13 9 1 29490 27
9977 12786 1 19 1926X Lake St 2 Sidewalk: Curb side : Cutout Tree 1     12 3x3   5989360.57879 2114746.40468 37.7860765689348 -122.480594276512 (37.7860765689348, -122.480594276512) 11 6 1 55 33
9988 87741 1 19 2536 Broadway 2 Sidewalk: Curb side : Cutout Tree 2   05/27/2008 12:00:00 AM 4 3x3 Permit Number 50404 6001459.44727 2117322.47349 37.7938455182068 -122.438920201115 (37.7938455182068, -122.438920201115) 13 9 1 57 27
11241 30330 1 19 2820 Union St 1 Sidewalk: Curb side : Cutout Tree 2   05/25/1990 12:00:00 AM 9   Permit Number 28881 5999458.41568 2118085.66723 37.795826993587 -122.445898848463 (37.795826993587, -122.445898848463) 13 9 1 57 17
11555 250317 1 19 3800 Jackson St 5 Sidewalk: Curb side : Cutout Tree 2     6 Width 3ft   5995989.81412 2115885.19527 37.789586427918 -122.457741476398 (37.789586427918, -122.457741476398) 11 6 1 54 31
11668 140846 1 19 100 COMMONWEALTH AVE 2 Sidewalk: Curb side : Yard Tree 2     8 Width 0ft   5996563.342 2113760.0078 37.7837841621477 -122.455603469395 (37.7837841621477, -122.455603469395) 11 6 1 54 31
11758 41190 1 19 2518 Buchanan St 1 Sidewalk: Curb side : Cutout Tree 2   06/04/2020 12:00:00 AM 3   Permit Number 782407 6003669.72123 2117044.16503 37.7932068601533 -122.431252574158 (37.7932068601533, -122.431252574158) 13 9 1 29490 27
12039 130797 1 19 2420 Pacific Ave 2 Sidewalk: Curb side : Cutout Tree 2     3 Width 4ft   6002334.43206 2117092.48928 37.7932637845338 -122.435876212726 (37.7932637845338, -122.435876212726) 13 9 1 29490 27
12132 88765 1 19 2661 Broadway 3 Sidewalk: Curb side : Cutout Tree 2   08/21/2008 12:00:00 AM 4 3x3 Permit Number 51686 6000918.40593 2117193.70791 37.7934611641623 -122.440783009137 (37.7934611641623, -122.440783009137) 13 9 1 29490 27
12554 130859 1 19 1890 Vallejo St 1 Sidewalk: Curb side : Cutout Tree 2     16 Width 4ft   6004541.87026 2118099.91409 37.7961550644564 -122.428310161511 (37.7961550644564, -122.428310161511) 13 9 1 57 17
12557 168124 1 19 2329 Baker St 2 Sidewalk: Curb side : Cutout Tree 2     9 Width 3ft   5999730.18853 2116975.80992 37.7927951334346 -122.444878646726 (37.7927951334346, -122.444878646726) 13 6 1 29490 27
12707 72459 1 19 414 Spruce St 1 Sidewalk: Curb side : Cutout Tree 2 FUF   7     5997210.21776 2114935.94674 37.7870500780436 -122.45345046559 (37.7870500780436, -122.45345046559) 11 6 1 54 31
13039 130815 1 19 2225 Pacific Ave 3 Sidewalk: Curb side : Cutout Tree 2     6 Width 4ft   6003300.13476 2117178.12968 37.7935537412686 -122.432540939311 (37.7935537412686, -122.432540939311) 13 9 1 29490 27
13133 130551 1 19 3333 Jackson St 1 Sidewalk: Curb side : Cutout Tree 2     14 Width 4ft   5998274.96024 2116157.53474 37.7904652103522 -122.449854780897 (37.7904652103522, -122.449854780897) 13 6 1 54 31
13166 46255 1 19 2161 North Point St 1 Sidewalk: Curb side : Cutout Tree 2     7   Permit Number 44539 6000416.49604 2120605.00843 37.802799094759 -122.442764714729 (37.802799094759, -122.442764714729) 13 9 1 57 17
13367 132936 1 19 2600 Webster St 1 Sidewalk: Property side : Yard Tree 2     15 Width 4ft   6003117.4123 2117569.74013 37.794618639305 -122.433201167605 (37.794618639305, -122.433201167605) 13 9 1 29490 27
13442 95317 1 19 2870@Divisadero Washington St 2 Sidewalk: Curb side : Cutout Tree 2   02/04/2011 12:00:00 AM 3 3x3 Permit Number 54638 6000958.18903 2116249.84914 37.790871839718 -122.440577627377 (37.790871839718, -122.440577627377) 13 6 1 29490 27
13914 130707 1 19 2878 Broadway 2 Sidewalk: Property side : Yard Tree 2     12 Width 4ft   5999875.30316 2117112.77625 37.7931794874933 -122.444386392923 (37.7931794874933, -122.444386392923) 13 9 1 57 27
13932 130564 1 19 290 Maple St 7 Sidewalk: Curb side : Yard Tree 2     4 Width 4ft   5996653.21029 2115422.72042 37.7883546840652 -122.455412770106 (37.7883546840652, -122.455412770106) 11 6 1 54 31
14303 125106 1 19 3167 Jackson St 2 Sidewalk: Curb side : Yard Tree 2   12/01/2019 12:00:00 AM 3 Width 5ft   5999044.89731 2116267.38185 37.7908108440947 -122.447198767233 (37.7908108440947, -122.447198767233) 13 6 1 29490 31
14464 44040 5 19 2504 Jackson St 1 Sidewalk: Curb side : Cutout Tree 2   11/30/2012 12:00:00 AM 3   Permit Number 769379 6002104.9323 2116736.74454 37.7922739619269 -122.436644820121 (37.7922739619269, -122.436644820121) 13 6 1 29490 27
14523 130701 1 19 2897 Broadway 1 Sidewalk: Property side : Yard Tree 2     6 Width 4ft   5999786.03622 2117022.81208 37.7929273760386 -122.444688791774 (37.7929273760386, -122.444688791774) 13 9 1 29490 27
14575 30998 1 19 2101 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 03/13/1995 12:00:00 AM 10   Permit Number 34777 6003940.50328 2117270.99344 37.7938450145991 -122.430331841946 (37.7938450145991, -122.430331841946) 13 9 1 29490 27
14610 138609 1 19 1731 LYON ST 2 Sidewalk: Curb side : Cutout Tree 2     8 Width 0ft   5999525.0921 2114915.5372 37.7871264588152 -122.445440076619 (37.7871264588152, -122.445440076619) 15 6 1 29490 31
15944 94239 1 19 2517 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree 2   10/08/2019 12:00:00 AM 3 3x3 Permit Number 53613 6001890.99196 2116983.84316 37.792940270518 -122.437402758825 (37.792940270518, -122.437402758825) 13 6 1 29490 27
16013 108100 4 19 2390X Green St 2 Sidewalk: Curb side : Cutout Tree 2           6001806.63782 2118043.59498 37.7958452773357 -122.437770563269 (37.7958452773357, -122.437770563269) 13 9 1 57 17
16410 130500 1 19 2143 North Point St 1 Sidewalk: Curb side : Cutout Tree 2     13 Width 3ft   6000509.0654 2120617.57283 37.8028388699826 -122.44244528095 (37.8028388699826, -122.44244528095) 13 9 1 57 17