trees

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
767 100549 4 88 290X Tehama St 4 Sidewalk: Curb side : Cutout Tree 2     3 3x4                      
3669 103667 4 17 350X Hickory St 6 Front Yard : Yard Tree 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
4476 112909 4 17 1899X Beach St 2 Sidewalk: Curb side : Cutout Tree 2                              
4983 112267 4 53 1X Geary St 1 Sidewalk: Curb side : Cutout Tree 2                              
5100 101532 4 17 11323 Palou Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3                      
5748 115724 4 243 250x Octavia St 1 Side Yard : Yard Tree 7                              
6238 103666 4 17 350X Hickory St 5 Front Yard : Yard Tree 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
7827 115725 4 243 250X Octavia St 2 Side Yard : Yard Tree 7                              
9335 112908 4 17 1899X Beach St 1 Sidewalk: Curb side : Cutout Tree 2                              
9557 112910 4 17 1899X Beach St 3 Sidewalk: Curb side : Cutout Tree 2                              
10205 173902 4 57 601x Hearst Ave 2 Sidewalk: Curb side : Cutout Tree 2                              
10489 102839 4 63 1101X Portola Dr 2 Sidewalk: Property side : Yard Tree 1                              
10516 102842 4 16 1101X Portola Dr 8 Sidewalk: Property side : Yard Tree 1                              
10813 100543 4 88 290X Tehama St 3 Sidewalk: Curb side : Cutout Tree 2     3 3x4                      
10916 108180 4 11 835 Sacramento St 2 Sidewalk: Curb side : Cutout Tree 2       3x3                      
10998 100001 4 38 501X 01st St 2 Sidewalk: Curb side : Pot Tree 2         Address is 100 1st Street                    
11335 112269 4 53 1X Geary St 3 Sidewalk: Curb side : Cutout Tree 2                              
12733 102843 4 70 1101X Portola Dr 10 Sidewalk: Property side : Yard Tree 1                              
14524 99746 4 57 4250 Clipper St 1 Sidewalk: Curb side : Cutout Tree 2       3x3                      
15154 102838 4 15 1101X Portola Dr 1 Sidewalk: Property side : Yard Tree 1                              
15233 109923 4 14 214 state st 1 Sidewalk: Curb side : Cutout Tree 2       3x3                      
15258 103665 4 17 350X Hickory St 4 Front Yard : Yard Tree 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
16355 103663 4 17 350X Hickory St 2 Front Yard : Yard Tree 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
18064 103664 4 17 350X Hickory St 3 Front Yard : Yard Tree 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
18422 112268 4 53 1X Geary St 2 Sidewalk: Curb side : Cutout Tree 2                              
18674 103662 4 17 350X Hickory St 1 Front Yard : Yard Tree 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
65 264979 4 35 2450 California St 1 Front Yard : Yard Tree 3           6002592 2115500 37.7889058459562 -122.434871073784 (37.7889058459562, -122.434871073784) 13 9 1 29490 27
117 108152 4 53 2232 Webster St 4 Sidewalk: Curb side : Cutout Tree 2           6003295.44003 2116396.66877 37.7914077834913 -122.432501340527 (37.7914077834913, -122.432501340527) 13 9 1 29490 27
403 108117 4 62 148 28TH AVE 2 Sidewalk: Curb side : Cutout Tree 2           5987142.8 2114987.8 37.7866102289445 -122.488284841308 (37.7866102289445, -122.488284841308) 11 6 1 55 33
475 102627 4 57 2039 Scott St 2 Sidewalk: Curb side : Cutout Tree 2     12 3x3   6001422 2115424 37.7886306717674 -122.438913657053 (37.7886306717674, -122.438913657053) 13 6 1 29490 27
479 122586 4 68 2500X Lyon St 6 Median : Cutout Tree 2     12 10x20   5999276 2117538 37.7943128273924 -122.446490617691 (37.7943128273924, -122.446490617691) 13 9 1 57 27
563 100819 4 27 2430X Jackson St 2 Sidewalk: Curb side : Cutout Tree 2     7 3x3   6002728 2116798 37.7924775418689 -122.434493377265 (37.7924775418689, -122.434493377265) 13 9 1 29490 27
1376 263620 4 59 900 Beach St 3 Side Yard : Yard Tree 1 Rec/Park     3x3   6005896 2121751 37.8062565433008 -122.423884345484 (37.8062565433008, -122.423884345484) 3 1 1 28858 32
1667 101664 4 16 2X Daniel Burnham Ct 4 Sidewalk: Curb side : Cutout Tree 2     8 3x3   6006348.55699 2114768.54675 37.7871100236423 -122.421821900065 (37.7871100236423, -122.421821900065) 13 9 1 28858 41
1730 121323 4 17 3699X Laguna St 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6003556 2121083 37.8042900105203 -122.431934584375 (37.8042900105203, -122.431934584375) 13 9 1 28858 17
2101 117036 4 70 2220x SUTTER ST 4 Sidewalk: Curb side : Cutout Tree 2       3x3   6001781 2114465 37.7860179225956 -122.437602866759 (37.7860179225956, -122.437602866759) 13 6 1 29490 27
2653 100053 4 53 3233X Buchanan St 5 Sidewalk: Curb side : Cutout Tree 2     12 3x3   6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
3825 263630 4 16 1020 Baker St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6000550 2112598 37.7808215534457 -122.441727743189 (37.7808215534457, -122.441727743189) 15 5 1 29490 16
4438 254757 4 35 2450 California St 13 Front Yard : Yard Tree 3           6002592 2115500 37.7889058459562 -122.434871073784 (37.7889058459562, -122.434871073784) 13 9 1 29490 27
4645 107053 4 31 450 Walnut St 4 Sidewalk: Curb side : Cutout Tree 2           5998625.9783 2115075.11894 37.7875132600186 -122.448562297399 (37.7875132600186, -122.448562297399) 13 6 1 54 31
4696 117040 4 122 2220x SUTTER ST 8 Sidewalk: Curb side : Cutout Tree 2       3x3   6001781 2114465 37.7860179225956 -122.437602866759 (37.7860179225956, -122.437602866759) 13 6 1 29490 27
5429 116488 4 70 2149 LYON ST   Sidewalk: Curb side : Cutout Tree 2       3x3   5999319 2116238 37.7907458271484 -122.446248274058 (37.7907458271484, -122.446248274058) 13 6 1 29490 31
5491 125353 4 216 2083 Union St 2 Sidewalk: Curb side : Cutout Tree 2     7 Width 2ft   6003071.4644 2118540.95305 37.7972827324699 -122.43342959001 (37.7972827324699, -122.43342959001) 13 9 1 57 17
5810 111954 4 16 73 SEACLIFF AVE 4 Sidewalk: Curb side : Cutout Tree 2     24     5987709 2115789 37.7888431121968 -122.486384796167 (37.7888431121968, -122.486384796167) 11 6 1 55 33
6793 106402 4 70 163 25TH AVE 1 Sidewalk: Curb side : Cutout Tree 2   08/28/2015 12:00:00 AM 18 3x3   5987994.2 2114906.9 37.7864377375077 -122.485333302781 (37.7864377375077, -122.485333302781) 11 6 1 55 33
7197 116162 4 70 2569 GREENWICH ST 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6000631 2118874 37.7980584318084 -122.441898109379 (37.7980584318084, -122.441898109379) 13 9 1 57 17
7503 115087 4 307 2784X JACKSON ST 2 Sidewalk: Property side : Cutout Tree 2       3x3   6000894 2116629 37.7919092338162 -122.440826927692 (37.7919092338162, -122.440826927692) 13 6 1 29490 27
7782 101433 4 97 2501X Buchanan St 8 Sidewalk: Curb side : Cutout Tree 2       3x3   6003643.1 2116935.1 37.7929058867978 -122.431336896261 (37.7929058867978, -122.431336896261) 13 9 1 29490 27
8229 115016 4 17 201X 29TH AVE 3 Sidewalk: Curb side : Cutout Tree 2   03/22/2016 12:00:00 AM 3 3x10 Permit Number 777784 5986734 2114396 37.7849614572018 -122.489655634459 (37.7849614572018, -122.489655634459) 11 6 1 55 33
8514 250400 4 16 15 Seacliff Ave 1 Sidewalk: Curb side : Yard Tree 2     16 Width 4ft   5988097.76743 2115798.38338 37.7888915289683 -122.485040420476 (37.7888915289683, -122.485040420476) 11 6 1 55 33
8762 97574 4 16 501x Presidio Ave 4 Sidewalk: Curb side : Cutout Tree 2           5999116.8 2114959.9 37.7872249510267 -122.4468558657 (37.7872249510267, -122.4468558657) 15 6 1 54 31
9658 114582 4 62 1501 BEACH ST 4 Sidewalk: Curb side : Cutout Tree 2     16 3x3   6002979 2121285 37.8048119223389 -122.43394578499 (37.8048119223389, -122.43394578499) 13 9 1 57 17
9679 111947 4 16 95 SEACLIFF AVE 4 Sidewalk: Curb side : Cutout Tree 2     30     5987570 2115773 37.7887910778243 -122.486864535179 (37.7887910778243, -122.486864535179) 11 6 1 55 33
10225 263619 4 59 900 Beach St 2 Side Yard : Yard Tree 1 Rec/Park     3x3   6005896 2121751 37.8062565433008 -122.423884345484 (37.8062565433008, -122.423884345484) 3 1 1 28858 32
10392 111979 4 16 39 SEACLIFF AVE 2 Sidewalk: Curb side : Cutout Tree 2           5987939 2115796 37.788875735681 -122.485589552136 (37.788875735681, -122.485589552136) 11 6 1 55 33
10456 118326 4 70 3200 CLAY ST 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5999426 2115708 37.7892966967134 -122.445839927288 (37.7892966967134, -122.445839927288) 13 6 1 29490 31
10567 263621 4 59 900 Beach St 4 Side Yard : Yard Tree 1 Rec/Park     3x3   6005896 2121751 37.8062565433008 -122.423884345484 (37.8062565433008, -122.423884345484) 3 1 1 28858 32
11207 108105 4 53 2390X Green St 7 Sidewalk: Property side : Cutout Tree 2           6001806.63782 2118043.59498 37.7958452773357 -122.437770563269 (37.7958452773357, -122.437770563269) 13 9 1 57 17
11694 263618 4 59 900 Beach St 1 Side Yard : Yard Tree 1 Rec/Park     3x3   6005896 2121751 37.8062565433008 -122.423884345484 (37.8062565433008, -122.423884345484) 3 1 1 28858 32
12499 101675 4 16 2X Daniel Burnham Ct 15 Sidewalk: Curb side : Cutout Tree 2     8 3x3   6006348.55699 2114768.54675 37.7871100236423 -122.421821900065 (37.7871100236423, -122.421821900065) 13 9 1 28858 41
13418 111948 4 16 75 SEACLIFF AVE 1 Sidewalk: Curb side : Cutout Tree 2     22     5987695 2115788 37.7888395504461 -122.486433160149 (37.7888395504461, -122.486433160149) 11 6 1 55 33
14328 104230 4 53 409 Walnut St 1 Sidewalk: Curb side : Cutout Tree 2       14x8   5998587.6 2115205.6 37.787869332154 -122.448704479556 (37.787869332154, -122.448704479556) 13 6 1 54 31
14781 256563 4 1 2504 Bush St   Sidewalk: Curb side : Cutout Tree 2   09/24/2019 12:00:00 AM 3 3x3   6001466 2114633 37.7864612926293 -122.438704721697 (37.7864612926293, -122.438704721697) 13 6 1 29490 27
14879 100801 4 27 2447 Jackson St 2 Sidewalk: Curb side : Cutout Tree 2     18 3x3   6002488 2116745 37.7923183909502 -122.435319990545 (37.7923183909502, -122.435319990545) 13 9 1 29490 27
15126 121049 4 151 2650 Polk St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6006281 2119745 37.8007703072153 -122.422409360755 (37.8007703072153, -122.422409360755) 13 9 1 28858 32
15453 103382 4 70 3199X JACKSON ST 2 Sidewalk: Curb side : Cutout Tree 2           5999158 2116301 37.7909096124749 -122.446809858862 (37.7909096124749, -122.446809858862) 13 6 1 29490 31
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
16046 99287 4 97 2839 Pacific Ave 4 Sidewalk: Property side : Cutout Tree 2           6000564.2 2116779 37.7923023065947 -122.44197880494 (37.7923023065947, -122.44197880494) 13 6 1 29490 27
16378 261659 4 11 2401 Lombard St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6000878 2119196 37.7989566302666 -122.441066533327 (37.7989566302666, -122.441066533327) 13 9 1 57 17
17203 107449 4 63 1130x CHESTNUT ST 1 Unaccepted Street : Yard Tree 2     60     6006351.9 2120450.9 37.8027125282147 -122.422214196597 (37.8027125282147, -122.422214196597) 5 9 1 28858 32
17877 101023 4 70 3024 Baker St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5999465 2119192 37.7988650643156 -122.445955676486 (37.7988650643156, -122.445955676486) 13 9 1 57 17
18974 101400 4 36 2101X Steiner St 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6002392.4 2115430.1 37.7887025838749 -122.435556659004 (37.7887025838749, -122.435556659004) 13 9 1 29490 27
19662 102997 4 27 2430X Jackson St 4 Sidewalk: Curb side : Cutout Tree 2     12 4x4   6002728 2116798 37.7924775418689 -122.434493377265 (37.7924775418689, -122.434493377265) 13 9 1 29490 27
19967 101427 4 97 2501X Buchanan St 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6003643.1 2116935.1 37.7929058867978 -122.431336896261 (37.7929058867978, -122.431336896261) 13 9 1 29490 27
20044 120894 4 170 735 Marina Blvd 2 Sidewalk: Curb side : Cutout Tree 2       3x3   5999444 2121468 37.805113148598 -122.446192149022 (37.805113148598, -122.446192149022) 13 9 1 57 17
20469 114842 4 70 2670 LEAVENWORTH ST 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6007398 2121652 37.8060693936166 -122.418679378695 (37.8060693936166, -122.418679378695) 5 1 1 308 23
20571 95244 4 27 2626 Larkin St 5 Sidewalk: Curb side : Cutout Tree 2   08/12/2010 12:00:00 AM 10 3x3 Permit Number 767140 6006627 2120193 37.802019913523 -122.421243885087 (37.802019913523, -122.421243885087) 5 9 1 28858 32
20799 108149 4 57 2232 Webster St 1 Sidewalk: Curb side : Cutout Tree 2           6003295.44003 2116396.66877 37.7914077834913 -122.432501340527 (37.7914077834913, -122.432501340527) 13 9 1 29490 27
21068 115703 4 17 2820 LAKE ST 2 Sidewalk: Curb side : Cutout Tree 2   03/07/2016 12:00:00 AM 3 3x15 Permit Number 777795 5986689 2114483 37.7851977068092 -122.489817718558 (37.7851977068092, -122.489817718558) 11 6 1 55 33
21279 122585 4 155 2500X Lyon St 5 Median : Cutout Tree 2     70 10x20   5999276 2117538 37.7943128273924 -122.446490617691 (37.7943128273924, -122.446490617691) 13 9 1 57 27
21465 104273 4 70 3675 Washington St 2 Sidewalk: Curb side : Cutout Tree 2       3x3   5997210.1 2115656.5 37.7890285184352 -122.453502918425 (37.7890285184352, -122.453502918425) 11 6 1 54 31
21498 98979 4 53 38 MILEY ST 1 Sidewalk: Curb side : Cutout Tree 2     3 3x3 Permit Number 778225 5999656 2118689 37.7974948649915 -122.4452585722 (37.7974948649915, -122.4452585722) 13 9 1 57 17
21499 102751 4 36 2490X Union St 3 Sidewalk: Curb side : Cutout Tree 2     12 5x6   6001093.5 2118310.7 37.7965381017858 -122.440257311894 (37.7965381017858, -122.440257311894) 13 9 1 57 17
22100 96329 4 58 2432 Pine St 1 Sidewalk: Curb side : Cutout Tree 2     3 3x3   6002300 2115080 37.7877360504613 -122.435851289323 (37.7877360504613, -122.435851289323) 13 6 1 29490 27
22170 100293 4 36 3725 Buchanan St 4 Sidewalk: Curb side : Cutout Tree 2     10 3x3   6003057 2121128 37.8043852677309 -122.433664630457 (37.8043852677309, -122.433664630457) 13 9 1 57 17
22280 121321 4 17 3699X Laguna St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6003556 2121083 37.8042900105203 -122.431934584375 (37.8042900105203, -122.431934584375) 13 9 1 28858 17
22799 101714 4 151 1240 Union St 1 Sidewalk: Curb side : Cutout Tree 2           6006918 2119116 37.7990791449181 -122.420160405591 (37.7990791449181, -122.420160405591) 5 1 1 28858 32
23325 101665 4 16 2X Daniel Burnham Ct 5 Sidewalk: Curb side : Cutout Tree 2     8 3x3   6006348.55699 2114768.54675 37.7871100236423 -122.421821900065 (37.7871100236423, -122.421821900065) 13 9 1 28858 41
23618 112386 4 31 2200 LYON ST 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5999398 2116386 37.7911567075357 -122.445985588475 (37.7911567075357, -122.445985588475) 13 6 1 29490 27
23660 111984 4 16 15 SEACLIFF AVE 2 Sidewalk: Curb side : Cutout Tree 2           5988113 2115801 37.7888996007164 -122.484987910575 (37.7888996007164, -122.484987910575) 11 6 1 55 33
24264 101666 4 16 2X Daniel Burnham Ct 6 Sidewalk: Curb side : Cutout Tree 2     8 3x3   6006348.55699 2114768.54675 37.7871100236423 -122.421821900065 (37.7871100236423, -122.421821900065) 13 9 1 28858 41
24301 117039 4 51 2220x SUTTER ST 7 Sidewalk: Curb side : Cutout Tree 2       3x3   6001781 2114465 37.7860179225956 -122.437602866759 (37.7860179225956, -122.437602866759) 13 6 1 29490 27
24388 103265 4 62 2365 UNION ST   Sidewalk: Curb side : Cutout Tree 2       3x3   6001713 2118319 37.7965961427299 -122.438114305108 (37.7965961427299, -122.438114305108) 13 9 1 57 17
24665 101842 4 16 2X Daniel Burnham Ct 17 Sidewalk: Curb side : Cutout Tree 2     8 3x3   6006348.55699 2114768.54675 37.7871100236423 -122.421821900065 (37.7871100236423, -122.421821900065) 13 9 1 28858 41
24703 121054 4 151 2650 Polk St 6 Sidewalk: Curb side : Cutout Tree 2       3x3   6006281 2119745 37.8007703072153 -122.422409360755 (37.8007703072153, -122.422409360755) 13 9 1 28858 32
24844 95247 4 143 2626 Larkin St 4 Sidewalk: Property side : Cutout Tree 2   08/12/2010 12:00:00 AM 5 3x3 Permit Number 767140 6006627 2120193 37.802019913523 -122.421243885087 (37.802019913523, -122.421243885087) 5 9 1 28858 32
25306 116489 4 70 2149 LYON ST 6 Sidewalk: Curb side : Cutout Tree 2       3x3   5999319 2116238 37.7907458271484 -122.446248274058 (37.7907458271484, -122.446248274058) 13 6 1 29490 31
25404 113493 4 28 2850 LAKE ST 2 Sidewalk: Curb side : Cutout Tree 2       3x3   5986565 2114493 37.7852179229774 -122.490247450243 (37.7852179229774, -122.490247450243) 11 6 1 55 33
25527 117367 4 11 3199X LAGUNA ST 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6003762 2119666 37.8004109732815 -122.431120504486 (37.8004109732815, -122.431120504486) 13 9 1 57 17
25580 117035 4 122 2220x SUTTER ST 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6001781 2114465 37.7860179225956 -122.437602866759 (37.7860179225956, -122.437602866759) 13 6 1 29490 27
25934 135966 4 40 2610 Scott St 3 Sidewalk: Curb side : Cutout Tree 2     4 Width 4ft   6001187.63413 2117406.94715 37.7940619922234 -122.439866757361 (37.7940619922234, -122.439866757361) 13 9 1 57 27