trees

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

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                    
75255 118899 4 62 7300 Fulton St 1 Sidewalk: Curb side : Cutout Tree 2       Width 4ft   5980716.90165 2109609.13106 37.771464998604 -122.510116727255 (37.771464998604, -122.510116727255) 11 6 2 55 26
158077 109510 4 62 7200X FULTON ST 3 Sidewalk: Curb side : Cutout Tree 2       3x3   5980935 2109588 37.7714198408482 -122.509360757847 (37.7714198408482, -122.509360757847) 11 6 2 55 8
146510 183256 4 45 4741 Irving St 1 Sidewalk: Curb side : Cutout Tree 2     0 Width 0ft   5980967.1327 2106185.8677 37.7620804693646 -122.508996949452 (37.7620804693646, -122.508996949452) 1 8 3 56 35
127150 105337 4 17 4701X LINCOLN WAY 1 Sidewalk: Curb side : Cutout Tree 2       9x4   5981020 2106919 37.7640965553617 -122.508868541389 (37.7640965553617, -122.508868541389) 11 8 3 55 35
102900 255186 4 16 4650 Balboa St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5981093 2111000 37.7753060927233 -122.50891909698 (37.7753060927233, -122.50891909698) 11 6 2 55 26
157176 118688 4 38 4645 Balboa St 3 Sidewalk: Curb side : Cutout Tree 2       Width 3ft   5981105.94918 2110928.32696 37.7751100630106 -122.508868980798 (37.7751100630106, -122.508868980798) 11 6 2 55 26
17829 106868 4 17 1956 GREAT HWY   Sidewalk: Property side : Cutout Tree 2           5981193.7 2101737.6 37.7498801477899 -122.507883225183 (37.7498801477899, -122.507883225183) 1 8 3 29491 35
838 264883 4 41 1624 48th Ave 1 Sidewalk: Property side : Cutout Tree 2       3x3   5981321 2103997 37.7560913197894 -122.50761065519 (37.7560913197894, -122.50761065519) 1 8 3 56 35
13893 264884 4 41 1624 48th Ave 2 Sidewalk: Property side : Cutout Tree 2       3x3   5981321 2103997 37.7560913197894 -122.50761065519 (37.7560913197894, -122.50761065519) 1 8 3 56 35
46138 106666 4 17 1878 48TH AVE 1 Sidewalk: Curb side : Cutout Tree 2           5981378.4 2102298.1 37.7514300033234 -122.507286113612 (37.7514300033234, -122.507286113612) 1 8 3 56 35
154876 112809 4 62 666 47TH AVE 1 Sidewalk: Curb side : Cutout Tree 2   11/17/2015 12:00:00 AM   3x3 Permit Number 776751 5981389 2111175 37.7758040356864 -122.507908173068 (37.7758040356864, -122.507908173068) 11 6 2 55 26
170569 112810 4 62 666 47TH AVE 2 Sidewalk: Curb side : Cutout Tree 2   11/17/2015 12:00:00 AM   3x3 Permit Number 776751 5981389 2111175 37.7758040356864 -122.507908173068 (37.7758040356864, -122.507908173068) 11 6 2 55 26
58052 105132 4 62 1619 47th Ave 1 Sidewalk: Curb side : Cutout Tree 2   01/14/2016 12:00:00 AM   3x3 Permit Number 777355 5981562.16 2104041.1764 37.756226819608 -122.506779933984 (37.756226819608, -122.506779933984) 1 8 3 56 35
81816 118419 4 45 5507 Anza St 1 Sidewalk: Curb side : Yard Tree 2       Width 3ft   5981562.4785 2111629.449 37.7770620385939 -122.507341801673 (37.7770620385939, -122.507341801673) 11 6 2 55 26
39528 184186 4 62 1651 47th Ave 2 Sidewalk: Curb side : Yard Tree 2     13 Width 0ft   5981569.4938 2103830.3301 37.7556483274352 -122.50673893378 (37.7556483274352, -122.50673893378) 1 8 3 56 35
104855 107143 4 16 1506 47TH AVE 4 Sidewalk: Curb side : Cutout Tree 2     4 3x3   5981601.8 2104810 37.7583401244926 -122.506699867993 (37.7583401244926, -122.506699867993) 1 8 3 56 35
121385 119124 4 45 601 46th Ave 3 Sidewalk: Property side : Yard Tree 2       Width 5ft   5981605.53063 2111566.74083 37.7768923962204 -122.507188220302 (37.7768923962204, -122.507188220302) 11 6 2 55 26
24658 106897 4 62 2768 GREAT HWY 1 Sidewalk: Curb side : Cutout Tree 2           5981642.5 2096616.3 37.735844912626 -122.505951630112 (37.735844912626, -122.505951630112) 1 8 3 29491 35
145950 105192 4 62 699X 46TH AVE 3 Sidewalk: Curb side : Cutout Tree 2     12 3   5981653 2111144 37.7757344699637 -122.506992646039 (37.7757344699637, -122.506992646039) 11 6 2 55 26
463 116745 4 62 2998x SLOAT BLVD 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5981657 2096559 37.7356884360348 -122.505897251941 (37.7356884360348, -122.505897251941) 1 8 3 29491 35
168573 107862 4 62 2788 GREAT HWY 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5981657.8 2096559 37.7356884831234 -122.50589448608 (37.7356884831234, -122.50589448608) 1 8 3 29491 35
78834 107860 4 62 3667 Wawona St 1 Sidewalk: Curb side : Cutout Tree 2       3x3 Permit Number 777933 5981683.9506 2096685.2741 37.7360367363779 -122.505813433386 (37.7360367363779, -122.505813433386) 1 8 3 29491 35
150270 118550 4 45 8140 Geary Blvd 3 Side Yard : Yard Tree 2           5981686.0706 2112397.37669 37.7791778206923 -122.506971243035 (37.7791778206923, -122.506971243035) 11 6 2 55 26
13988 106896 4 62 2958 SLOAT BLVD   Sidewalk: Curb side : Cutout Tree 2           5981703.3 2096579.8 37.7357482722765 -122.505738719186 (37.7357482722765, -122.505738719186) 1 8 3 29491 35
31741 118699 4 156 4445 Balboa St 3 Sidewalk: Curb side : Cutout Tree 2       Width 3ft   5981706.97988 2110951.27348 37.7752084783718 -122.506791621288 (37.7752084783718, -122.506791621288) 11 6 2 55 26
4623 106966 4 17 2391 47TH AVE   Sidewalk: Curb side : Cutout Tree 2           5981720.8 2098834.4 37.7419398125124 -122.505845312535 (37.7419398125124, -122.505845312535) 1 8 3 29491 35
21446 107856 4 62 2938 SLOAT BLVD   Sidewalk: Curb side : Cutout Tree 2       3x3   5981725.3 2096580 37.7357501162313 -122.505662672753 (37.7357501162313, -122.505662672753) 1 8 3 29491 35
49031 107855 4 62 2938 SLOAT BLVD   Sidewalk: Curb side : Cutout Tree 2       3x3   5981725.3 2096580 37.7357501162313 -122.505662672753 (37.7357501162313, -122.505662672753) 1 8 3 29491 35
186051 107857 4 17 2938 SLOAT BLVD   Sidewalk: Curb side : Cutout Tree 2       3x3 Permit Number 774528 5981725.3 2096580 37.7357501162313 -122.505662672753 (37.7357501162313, -122.505662672753) 1 8 3 29491 35
21073 118697 4 16 4445 Balboa St 1 Sidewalk: Curb side : Cutout Tree 2       Width 3ft   5981741.45625 2110952.76376 37.7752146003791 -122.506672472372 (37.7752146003791, -122.506672472372) 11 6 2 55 26
3419 259044 4 72 3649 Taraval St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5981832 2098708 37.7415992976029 -122.505451458513 (37.7415992976029, -122.505451458513) 1 8 3 29491 35
180663 106366 4 16 9 SEAL ROCK DR   Sidewalk: Curb side : Cutout Tree 2           5981833.1 2112945.4 37.7806911884837 -122.506503269885 (37.7806911884837, -122.506503269885) 11 6 2 55 26
910 259043 4 72 3639 Taraval St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5981868 2098709 37.7416041617746 -122.505327058934 (37.7416041617746, -122.505327058934) 1 8 3 29491 35
19136 102260 4 17 1350 46th Ave 1 Sidewalk: Property side : Cutout Tree 2     24 4x6   5981875.8 2105892.8 37.7613293147111 -122.505832545781 (37.7613293147111, -122.505832545781) 1 8 3 56 35
12436 259039 4 72 3627 Taraval St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5981920 2098711 37.7416127129705 -122.505147411787 (37.7416127129705, -122.505147411787) 1 8 3 29491 35
19150 259041 4 72 3614 Taraval St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5981967 2098808 37.7418818134636 -122.504992090975 (37.7418818134636, -122.504992090975) 1 8 3 29491 35
18670 259040 4 72 3615 Taraval St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5981969 2098712 37.7416183416682 -122.504978063323 (37.7416183416682, -122.504978063323) 1 8 3 29491 35
6440 259042 4 72 3612 Taraval St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5981996 2098820 37.7419164682935 -122.504892709134 (37.7419164682935, -122.504892709134) 1 8 3 29491 35
194143 118792 4 22 746 45th Ave 1 Sidewalk: Curb side : Cutout Tree 2       Width 4ft   5982002.3368 2110652.98782 37.7744068613492 -122.505747814892 (37.7744068613492, -122.505747814892) 11 6 2 55 26
192660 112981 4 16 3880 NORIEGA ST 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5982016 2102928 37.7531970663373 -122.505127932021 (37.7531970663373, -122.505127932021) 1 8 3 56 35
125661 115911 4 16 3698x QUINTARA ST 1 Sidewalk: Curb side : Cutout Tree 2     15 3x3   5982047 2100859 37.7475179963819 -122.504867427241 (37.7475179963819, -122.504867427241) 1 8 3 29491 35
17612 262236 4 113 3540 Rivera St 1 Sidewalk: Property side : Cutout Landscaping 2       3x3   5982153 2100195 37.7457010726591 -122.504451707081 (37.7457010726591, -122.504451707081) 1 8 3 29491 35
16399 262491 4 16 3940 Judah St 3 Sidewalk: Curb side : Cutout Tree 2       3x3   5982210 2105632 37.760632897171 -122.504657384045 (37.760632897171, -122.504657384045) 1 8 3 56 35
17238 262489 4 14 3940 Judah St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5982210 2105632 37.760632897171 -122.504657384045 (37.760632897171, -122.504657384045) 1 8 3 56 35
17827 262490 4 16 3940 Judah St 2 Sidewalk: Curb side : Cutout Tree 2       3x3   5982210 2105632 37.760632897171 -122.504657384045 (37.760632897171, -122.504657384045) 1 8 3 56 35
159537 255244 4 15 4300 Clement St 1 Front Yard : Yard Tree 2           5982359 2113083 37.7810999474526 -122.504694157984 (37.7810999474526, -122.504694157984) 11 6 2 55 26
127596 183654 4 45 4000 Kirkham St 2 Sidewalk: Curb side : Cutout Tree 2     0 Width 0ft   5982417.4167 2104930.2746 37.7587183575205 -122.503888061559 (37.7587183575205, -122.503888061559) 1 8 3 56 35
35142 102666 4 95 3399X Wawona St 7 Sidewalk: Property side : Cutout Tree 2       3x3   5982463.4 2096719.2 37.7361757338901 -122.503121118731 (37.7361757338901, -122.503121118731) 1 8 3 29491 35
70170 102663 4 95 3399X Wawona St 4 Sidewalk: Property side : Cutout Tree 2       3x3   5982463.4 2096719.2 37.7361757338901 -122.503121118731 (37.7361757338901, -122.503121118731) 1 8 3 29491 35
137333 102662 4 95 3399X Wawona St 3 Sidewalk: Property side : Cutout Tree 2       3x3   5982463.4 2096719.2 37.7361757338901 -122.503121118731 (37.7361757338901, -122.503121118731) 1 8 3 29491 35
138638 102661 4 16 3399X Wawona St 2 Sidewalk: Property side : Cutout Tree 2       3x3   5982463.4 2096719.2 37.7361757338901 -122.503121118731 (37.7361757338901, -122.503121118731) 1 8 3 29491 35
158204 102664 4 95 3399X Wawona St 5 Sidewalk: Property side : Cutout Tree 2       3x3   5982463.4 2096719.2 37.7361757338901 -122.503121118731 (37.7361757338901, -122.503121118731) 1 8 3 29491 35
178921 102660 4 95 3399X Wawona St 1 Sidewalk: Property side : Cutout Tree 2       3x3   5982463.4 2096719.2 37.7361757338901 -122.503121118731 (37.7361757338901, -122.503121118731) 1 8 3 29491 35
191350 102665 4 95 3399X Wawona St 6 Sidewalk: Property side : Cutout Tree 2       3x3   5982463.4 2096719.2 37.7361757338901 -122.503121118731 (37.7361757338901, -122.503121118731) 1 8 3 29491 35
180223 100354 4 17 1242 44th Ave 1 Sidewalk: Curb side : Cutout Tree 2           5982470.7 2106644.2 37.7634274417273 -122.503830723516 (37.7634274417273, -122.503830723516) 1 8 3 56 35
23118 104735 4 16 1499X 44th Ave 1 Sidewalk: Curb side : Cutout Tree 2       2x2   5982473.05016 2105245.16297 37.7595862228156 -122.503718978789 (37.7595862228156, -122.503718978789) 1 8 3 56 35
43484 115963 4 45 847 43RD AVE 2 Sidewalk: Curb side : Cutout Tree 2   03/07/2016 12:00:00 AM 3 3x3   5982585 2109998 37.7726427311472 -122.503683790346 (37.7726427311472, -122.503683790346) 11 6 2 55 26
88587 115931 4 45 847 43RD AVE 1 Sidewalk: Curb side : Cutout Tree 2   03/07/2016 12:00:00 AM 3 3x3   5982585 2109998 37.7726427311472 -122.503683790346 (37.7726427311472, -122.503683790346) 11 6 2 55 26
194044 115634 4 17 844 43RD AVE 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5982626 2109989 37.7726204302856 -122.503541302768 (37.7726204302856, -122.503541302768) 11 6 2 55 26
153097 114554 4 28 1200x 43RD AVE 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5982778 2106905 37.7641615885028 -122.502787196132 (37.7641615885028, -122.502787196132) 1 8 3 56 35
9568 261150 4 65 3220x Santiago St 3 Sidewalk: Curb side : Cutout Tree 2       3x3   5982825 2099474 37.7437609086011 -122.502074725774 (37.7437609086011, -122.502074725774) 1 8 3 29491 35
16950 261148 4 65 3220x Santiago St 2 Sidewalk: Curb side : Cutout Tree 2       3x3   5982825 2099474 37.7437609086011 -122.502074725774 (37.7437609086011, -122.502074725774) 1 8 3 29491 35
12191 113350 4 17 7802x GEARY BLVD 2 Sidewalk: Curb side : Cutout Tree 2     6 4x8   5982855 2112422 37.7793142001238 -122.502929326548 (37.7793142001238, -122.502929326548) 11 6 2 55 26
70657 113352 4 16 7802x GEARY BLVD 4 Sidewalk: Curb side : Cutout Tree 2     12 5x9   5982855 2112422 37.7793142001238 -122.502929326548 (37.7793142001238, -122.502929326548) 11 6 2 55 26
76536 113351 4 17 7802x GEARY BLVD 3 Sidewalk: Curb side : Cutout Tree 2       3x3   5982855 2112422 37.7793142001238 -122.502929326548 (37.7793142001238, -122.502929326548) 11 6 2 55 26
107154 113354 4 62 7802x GEARY BLVD 6 Sidewalk: Curb side : Cutout Tree 2     12 3x3   5982855 2112422 37.7793142001238 -122.502929326548 (37.7793142001238, -122.502929326548) 11 6 2 55 26
164768 113353 4 16 7802x GEARY BLVD 5 Sidewalk: Curb side : Cutout Tree 2     12 3x3   5982855 2112422 37.7793142001238 -122.502929326548 (37.7793142001238, -122.502929326548) 11 6 2 55 26
9014 261225 4 1 2111 43rd Ave 1 Sidewalk: Curb side : Cutout Tree 2   10/06/2020 12:00:00 AM 3 4x6   5982897 2100735 37.7472274959484 -122.501919055433 (37.7472274959484, -122.501919055433) 1 8 3 29491 35
122036 255425 4 15 2451 43rd Ave 1 Sidewalk: Property side : Cutout Tree 2       6x10   5982976 2098446 37.740947172682 -122.501476581088 (37.740947172682, -122.501476581088) 1 8 3 29491 35
62025 183697 4 9 1341 42nd Ave 11 Sidewalk: Curb side : Cutout Tree 2     3 Width 0ft   5983052.2798 2105821.6343 37.7612030896009 -122.501758397661 (37.7612030896009, -122.501758397661) 1 8 3 56 35
4317 261373 4 14 1701x 42nd Ave 1 Sidewalk: Curb side : Cutout Tree 2   01/07/2020 12:00:00 AM 3 3x3   5983095 2103514 37.7548694854578 -122.501439939014 (37.7548694854578, -122.501439939014) 1 8 3 56 35
11446 111248 4 16 3101x VICENTE ST 2 Sidewalk: Curb side : Cutout Tree 2     10 3x3   5983195 2097379 37.7380303412956 -122.50064049243 (37.7380303412956, -122.50064049243) 1 8 3 29491 35
59320 111254 4 16 2601x 42ND AVE 2 Sidewalk: Curb side : Cutout Tree 2       3x3   5983195 2097379 37.7380303412956 -122.50064049243 (37.7380303412956, -122.50064049243) 1 8 3 29491 35
83458 111255 4 16 2601x 42ND AVE 3 Sidewalk: Curb side : Cutout Tree 2       3x3   5983195 2097379 37.7380303412956 -122.50064049243 (37.7380303412956, -122.50064049243) 1 8 3 29491 35
104395 111256 4 16 2601x 42ND AVE 4 Sidewalk: Curb side : Cutout Tree 2       3x3   5983195 2097379 37.7380303412956 -122.50064049243 (37.7380303412956, -122.50064049243) 1 8 3 29491 35