trees

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
525 33087 7 27   6 Sidewalk: Curb side : Cutout Tree 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
582 20409 1 27 451X Sunset Blvd 1 Sidewalk: Curb side : Cutout Tree 1     18 10                      
1191 34003 7 27   2 Sidewalk: Curb side : Cutout Tree 2         Permit Number 37940                    
1227 46197 7 27   2 Sidewalk: Curb side : Cutout Tree 2   12/31/2001 12:00:00 AM     Permit Number 44518                    
1605 35819 7 27 980 Houston St 4 Sidewalk: Curb side : Cutout Tree 2   04/22/1998 12:00:00 AM     Permit Number 39055                    
2564 20333 1 27 101X Sunset Blvd 21 Sidewalk: Curb side : Cutout Tree 1     24 60                      
2988 35689 7 27   12 Sidewalk: Curb side : Cutout Tree 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
3253 33090 7 27   3 Sidewalk: Curb side : Cutout Tree 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
3352 20327 1 27 101X Sunset Blvd 15 Sidewalk: Curb side : Cutout Tree 1     18 60                      
3443 33088 7 27   5 Sidewalk: Curb side : Cutout Tree 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
3932 36559 7 27   8 Sidewalk: Curb side : Cutout Tree 2   05/19/1998 12:00:00 AM     Permit Number 39428                    
4354 20459 1 27 495X Sunset Blvd 24 Sidewalk: Curb side : Cutout Tree 1     18 60                      
4642 254121 2 27 150 Jennings St 3 Sidewalk: Property side : Yard Tree 2   01/02/2018 12:00:00 AM 3   Permit Number 781123                    
4666 36564 7 27   1 Sidewalk: Curb side : Cutout Tree 2   05/19/1998 12:00:00 AM     Permit Number 39428                    
4952 20349 1 27 103X Sunset Blvd 3 Sidewalk: Curb side : Cutout Tree 1     12 8                      
5071 254119 2 27 150 Jennings St 1 Sidewalk: Property side : Yard Tree 2   01/02/2018 12:00:00 AM 3   Permit Number 781123                    
5256 20347 1 27 103X Sunset Blvd 1 Sidewalk: Curb side : Cutout Tree 1     18 8                      
5488 46196 7 27   3 Sidewalk: Curb side : Cutout Tree 2   12/31/2001 12:00:00 AM     Permit Number 44518                    
6511 46719 7 27   3 Sidewalk: Curb side : Cutout Tree 2   04/24/2002 12:00:00 AM     Permit Number 44843                    
6996 261387 1 27 600 Broadway 1 Sidewalk: Curb side : Cutout Tree 2                              
7549 34002 7 27   1 Sidewalk: Curb side : Cutout Tree 2         Permit Number 37940                    
7997 46198 7 27   1 Sidewalk: Curb side : Cutout Tree 2   12/31/2001 12:00:00 AM     Permit Number 44518                    
8327 33086 7 27   1 Sidewalk: Curb side : Cutout Tree 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
8443 36563 7 27   2 Sidewalk: Curb side : Cutout Tree 2   05/19/1998 12:00:00 AM     Permit Number 39428                    
8748 261394 1 27 690 Broadway 1 Sidewalk: Curb side : Cutout Tree 2                              
8960 39903 7 27   1 Sidewalk: Curb side : Cutout Tree 2   01/03/2002 12:00:00 AM     Permit Number 41185                    
9263 254120 2 27 150 Jennings St 2 Sidewalk: Property side : Yard Tree 2   01/02/2018 12:00:00 AM 3   Permit Number 781123                    
10801 20411 1 27 451X Sunset Blvd 3 Sidewalk: Curb side : Cutout Tree 1     18 10                      
10942 36562 7 27   3 Sidewalk: Curb side : Cutout Tree 2   05/19/1998 12:00:00 AM     Permit Number 39428                    
11082 20348 1 27 103X Sunset Blvd 2 Sidewalk: Curb side : Cutout Tree 1     12 8                      
11484 20350 1 27 103X Sunset Blvd 4 Sidewalk: Curb side : Cutout Tree 1     12 8                      
11566 46721 7 27   1 Sidewalk: Curb side : Cutout Tree 2   04/24/2002 12:00:00 AM     Permit Number 44843                    
11814 39901 7 27   3 Sidewalk: Curb side : Cutout Tree 2   01/03/2002 12:00:00 AM     Permit Number 41185                    
11924 20331 1 27 101X Sunset Blvd 19 Sidewalk: Curb side : Cutout Tree 1     24 60                      
11949 34004 7 27   3 Sidewalk: Curb side : Cutout Tree 2         Permit Number 37940                    
12503 33089 7 27   4 Sidewalk: Curb side : Cutout Tree 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
12533 251650 1 27 101X Vicente St 1 Sidewalk: Curb side : Cutout Tree 1       3x3                      
12540 33092 7 27   8 Sidewalk: Curb side : Cutout Tree 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
12675 35820 7 27 980 Houston St 1 Sidewalk: Curb side : Cutout Tree 2   04/22/1998 12:00:00 AM     Permit Number 39055                    
12691 120130 1 27 799x Shotwell St 1 Sidewalk: Curb side : Cutout Tree 2       3x3                      
12780 33093 7 27   9 Sidewalk: Curb side : Cutout Tree 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
13042 39902 7 27   2 Sidewalk: Curb side : Cutout Tree 2   01/03/2002 12:00:00 AM     Permit Number 41185                    
14174 120131 1 27 799x Shotwell St 2 Sidewalk: Curb side : Cutout Tree 2       3x3                      
14606 36560 7 27   7 Sidewalk: Curb side : Cutout Tree 2   05/19/1998 12:00:00 AM     Permit Number 39428                    
15431 36565 7 27   6 Sidewalk: Curb side : Cutout Tree 2   05/19/1998 12:00:00 AM     Permit Number 39428                    
15824 20410 1 27 451X Sunset Blvd 2 Sidewalk: Curb side : Cutout Tree 1     18 10                      
16113 33085 7 27   10 Sidewalk: Curb side : Cutout Tree 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
16329 35818 7 27 980 Houston St 3 Sidewalk: Curb side : Cutout Tree 2   04/22/1998 12:00:00 AM     Permit Number 39055                    
17106 33091 7 27   2 Sidewalk: Curb side : Cutout Tree 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
17326 33082 7 27   7 Sidewalk: Curb side : Cutout Tree 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
17709 46720 7 27   2 Sidewalk: Curb side : Cutout Tree 2   04/24/2002 12:00:00 AM     Permit Number 44843                    
18507 254122 2 27 150 Jennings St 4 Sidewalk: Property side : Yard Tree 2   01/02/2018 12:00:00 AM 3   Permit Number 781123                    
18524 35817 7 27 980 Houston St 2 Sidewalk: Curb side : Cutout Tree 2   04/22/1998 12:00:00 AM     Permit Number 39055                    
18937 20328 1 27 101X Sunset Blvd 16 Sidewalk: Curb side : Cutout Tree 1     18 60                      
19426 35691 7 27   1 Sidewalk: Curb side : Cutout Tree 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
87271 27884 1 27 280 The Embarcadero 14 Sidewalk: Curb side : Cutout Tree 6   01/31/2001 12:00:00 AM 12     6015985.589 2013289.413 37.5090039879895 -122.381420145897 (37.5090039879895, -122.381420145897)       28590  
1101 245920 1 27 1828 Market St 2 Sidewalk: Curb side : Cutout Tree 2     10 Width 0ft   6005542.6546 2109064.0833 37.7714014816775 -122.424204294394 (37.7714014816775, -122.424204294394) 7 2 5 28852 10
1302 14133 1 27 1642X Market St 2 Sidewalk: Curb side : Cutout Tree 1     18 4x4   6006458.8907635 2109942.5653128 37.773865274364 -122.421097370447 (37.773865274364, -122.421097370447) 7 2 11 28852 10
1765 73918 1 27 740 Buchanan St 2 Sidewalk: Curb side : Cutout Tree 2 FUF   7     6004497.3871 2111109.5855 37.776958856214 -122.42796571067 (37.776958856214, -122.42796571067) 7 9 11 28852 10
2016 134492 1 27 199 Fulton St 15 Sidewalk: Property side : Yard Tree 2     10 Width 4ft   6008187.17961 2111997.187 37.7796040530222 -122.415264393538 (37.7796040530222, -122.415264393538) 7 10 9 28852 36
2558 134571 1 27 30 Larkin St 3 Sidewalk: Curb side : Cutout Tree 2     16 Width 4ft   6007831.94374 2111562.01758 37.7783892110202 -122.416462477559 (37.7783892110202, -122.416462477559) 7 9 9 28852 36
2672 134477 1 27 100 Larkin St 3 Sidewalk: Curb side : Yard Tree 2     14 Width 3ft   6007817.15292 2111847.04957 37.7791710087729 -122.416533840565 (37.7791710087729, -122.416533840565) 7 9 9 28852 36
2841 9956 1 27 155 Grove St 1 Sidewalk: Curb side : Cutout Tree 11     12 4X4   6007076.05273 2111529.8614 37.7782583803491 -122.419075111548 (37.7782583803491, -122.419075111548) 7 9 9 28852 36
3484 134344 1 27 1028 Market St 3 Sidewalk: Curb side : Cutout Tree 2     7 Width 4ft   6009395.71575 2112755.03795 37.7817527789197 -122.411137077326 (37.7817527789197, -122.411137077326) 14 2 9 28852 36
3538 249405 1 27 430 Turk St 1 : Tree 2     8 Width 4ft   6007893.39158 2113084.10787 37.7825719605735 -122.416357743418 (37.7825719605735, -122.416357743418) 7 10 9 28852 36
3735 134467 1 27 599 Van Ness Ave 7 Sidewalk: Curb side : Cutout Tree 2     4 Width 4ft   6006763.32454 2112440.01421 37.780739823924 -122.420221568169 (37.780739823924, -122.420221568169) 7 9 9 28852 36
3777 109546 1 27 300x Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree 2     4 3x3   6006868.4272 2111721.79621 37.778773692788 -122.419806988803 (37.778773692788, -122.419806988803) 7 9 9 28852 36
3956 48783 1 27 201 Turk St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 10/30/2002 12:00:00 AM 6   Permit Number 46038 6008763.21846 2113151.61883 37.7828062042714 -122.413353282927 (37.7828062042714, -122.413353282927) 7 10 9 28852 36
3979 13887 1 27 1028 Market St 1 Sidewalk: Curb side : Cutout Tree 1     12 4x4   6009423.70824 2112763.96692 37.7817788655291 -122.411040866943 (37.7817788655291, -122.411040866943) 14 2 9 28852 36
4164 260061 6 27 100 Larkin St 8 Sidewalk: Property side : Yard Tree 2       Width 3ft   6007818.52804 2111871.98583 37.7792395550969 -122.416530850318 (37.7792395550969, -122.416530850318) 7 9 9 28852 36
4544 143321 1 27 1150 MARKET ST 14 Sidewalk: Curb side : Cutout Tree 2     10 Width 0ft   6008853.5011 2112237.2541 37.7803006456525 -122.412976271095 (37.7803006456525, -122.412976271095) 7 2 9 28852 36
5061 250274 1 27 43 United Nations Plz 15 Sidewalk: Curb side : Yard Tree 2     13 Width 0ft   6008410.26158 2112128.0464 37.779975896618 -122.414501916828 (37.779975896618, -122.414501916828) 7 10 9 28852 36
5111 134476 1 27 100 Larkin St 2 Sidewalk: Curb side : Yard Tree 2     13 Width 3ft   6007839.62129 2111720.04477 37.7788235475933 -122.416447114449 (37.7788235475933, -122.416447114449) 7 9 9 28852 36
5189 134478 1 27 100 Larkin St 4 Sidewalk: Curb side : Yard Tree 2     13 Width 3ft   6007818.52804 2111871.98583 37.7792395550969 -122.416530850318 (37.7792395550969, -122.416530850318) 7 9 9 28852 36
5191 13827 1 27 964 Market St 4 Sidewalk: Curb side : Cutout Tree 1     40 4X4   6009845.6649 2113195.3529 37.7829870022194 -122.409611544992 (37.7829870022194, -122.409611544992) 14 2 9 28852 36
6007 261051 4 27 770 Van Ness Ave 4 Sidewalk: Curb side : Cutout Tree 2       3x3   6006693 2113137 37.7826496144307 -122.420514344125 (37.7826496144307, -122.420514344125) 7 9 9 28852 36
6120 134430 1 27 600 McAllister St 10 Sidewalk: Curb side : Cutout Tree 2     10 Width 4ft   6005993.13992 2112128.40319 37.7798407887477 -122.422863859998 (37.7798407887477, -122.422863859998) 7 9 11 28852 41
6503 250273 1 27 43 United Nations Plz 14 Sidewalk: Curb side : Yard Tree 2     14 Width 0ft   6008481.10598 2112153.65237 37.7800501841947 -122.414258645714 (37.7800501841947, -122.414258645714) 7 10 9 28852 36
6609 134440 1 27 600 Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree 2     9 Width 4ft   6006735.90509 2112663.11167 37.7813508503011 -122.420332264839 (37.7813508503011, -122.420332264839) 7 9 9 28852 36
6688 119707 7 27 47 Octavia St 6 Sidewalk: Curb side : Cutout Tree 2           6005657.12364045 2109394.65582136 37.772315616937 -122.423831849588 (37.772315616937, -122.423831849588) 7 9 11 28852 10
7181 14058 1 27 1390 Market St 1 Sidewalk: Curb side : Cutout Tree 1     18 4X4   6007799.3288 2111218.6717 37.7774446311696 -122.416550977219 (37.7774446311696, -122.416550977219) 7 2 9 28852 36
7530 27369 7 27 251 Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree 17     12 3X3   6006819.3487219 2111354.6736121 37.7777628978385 -122.419950711926 (37.7777628978385, -122.419950711926) 7 9 11 28852 10
7898 143411 1 27 1244 MARKET ST 1 Sidewalk: Curb side : Cutout Tree 2     4 Width 0ft   6008077.8348 2111482.5707 37.7781848938095 -122.415606219442 (37.7781848938095, -122.415606219442) 7 2 9 28852 36
8078 260059 6 27 100 Larkin St 6 Sidewalk: Property side : Yard Tree 2       Width 3ft   6007818.52804 2111871.98583 37.7792395550969 -122.416530850318 (37.7792395550969, -122.416530850318) 7 9 9 28852 36
8178 13824 1 27 964 Market St 1 Sidewalk: Curb side : Cutout Tree 1     40 4x4   6009889.5706 2113199.7435 37.7830015179357 -122.409459958667 (37.7830015179357, -122.409459958667) 14 2 9 28852 36
8249 109550 1 27 300x Van Ness Ave 6 Sidewalk: Curb side : Cutout Tree 2     4 3x3   6006859.56746 2111778.81942 37.7789297656303 -122.41984168554 (37.7789297656303, -122.41984168554) 7 9 9 28852 36
8276 134481 1 27 199 Fulton St 3 Sidewalk: Property side : Yard Tree 2     8 Width 4ft   6007895.36182 2111951.33143 37.7794617397969 -122.416270671059 (37.7794617397969, -122.416270671059) 7 10 9 28852 36
8431 14116 1 27 1564 Market St 2 Sidewalk: Curb side : Cutout Tree 1     18 4x4   6006761.0540098 2110225.9136176 37.7746603099629 -122.420072248795 (37.7746603099629, -122.420072248795) 7 2 11 28852 10
8607 23185 1 27 560X McAllister St 1 Sidewalk: Curb side : Cutout Tree 1     30 3X3   6006458.921066 2112191.041059 37.7800390474075 -122.421256963785 (37.7800390474075, -122.421256963785) 7 9 11 28852 41
9215 260060 6 27 100 Larkin St 7 Sidewalk: Property side : Yard Tree 2       Width 3ft   6007818.52804 2111871.98583 37.7792395550969 -122.416530850318 (37.7792395550969, -122.416530850318) 7 9 9 28852 36
9558 13935 1 27 1140X Market St 3 Sidewalk: Curb side : Cutout Tree 1     25 4x4   6008690.2869843 2112068.9420038 37.7798293375501 -122.413528998881 (37.7798293375501, -122.413528998881) 7 2 9 28852 36
9608 143298 1 27 1024 MARKET ST 1 Sidewalk: Curb side : Cutout Tree 2     2 Width 0ft   6009502.2089 2112829.3107 37.7819626858057 -122.410773906539 (37.7819626858057, -122.410773906539) 14 2 9 28852 36
10568 14122 1 27 1600X Market St 3 Sidewalk: Curb side : Cutout Tree 1   07/07/2011 03:22:00 PM 2 4x4   6006469.71168 2109964.77137 37.7739268568633 -122.42106151609 (37.7739268568633, -122.42106151609) 7 2 11 28852 10
10626 117236 4 27 635 GROVE ST 8 Sidewalk: Curb side : Cutout Tree 2       3x3   6004711 2111132 37.7770324835269 -122.427228354699 (37.7770324835269, -122.427228354699) 7 9 11 28852 10
11317 13705 1 27 750 Market St 2 Sidewalk: Curb side : Cutout Tree 1     12 4x4   6011215.54657 2114485.16599 37.7866051915093 -122.404963137048 (37.7866051915093, -122.404963137048) 5 2 10 28852 6
11559 261050 4 27 770 Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6006693 2113137 37.7826496144307 -122.420514344125 (37.7826496144307, -122.420514344125) 7 9 9 28852 36
12000 261047 4 27 750 Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6006673 2113065 37.7824507928685 -122.420578423098 (37.7824507928685, -122.420578423098) 7 9 9 28852 36
12408 33687 7 27 610 Ivy St 1 Sidewalk: Curb side : Cutout Tree 2   12/03/1996 12:00:00 AM   2x3 Permit Number 37763 6004420.66783798 2111040.26799248 37.7767641867681 -122.428226164884 (37.7767641867681, -122.428226164884) 7 9 11 28852 10
12935 200972 1 27 1408 Market St 2 Sidewalk: Curb side : Cutout Tree 2     12 Width 0ft   6007378.6483 2110811.6244 37.776303309184 -122.417977390819 (37.776303309184, -122.417977390819) 7 2 9 28852 36
12944 138948 1 27 738 HAYES ST 1 Sidewalk: Curb side : Cutout Tree 2   08/07/2008 12:00:00 AM 4 Width 0ft Permit Number 51651 6004303.429 2110848.9359 37.7762322016228 -122.428618087069 (37.7762322016228, -122.428618087069) 7 9 11 28852 10
13007 23212 1 27 595X Van Ness Ave 8 Sidewalk: Curb side : Cutout Tree 1     10 3X3   6006669.9178 2112533.82047 37.7809921295165 -122.420551368612 (37.7809921295165, -122.420551368612) 7 9 11 28852 41