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)
525 33087 7 27   6 Sidewalk: Curb side : Cutout Tree 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
637 35060 7 27 5545 03rd St 3 Sidewalk: Curb side : Cutout Tree 2   04/01/1999 12:00:00 AM     Permit Number 41350 6014167.69706675 2092844.73590691 37.7273498207281 -122.393234476852 (37.7273498207281, -122.393234476852) 10 3 8 58 1
886 73449 1 27 238 Vienna St 1 Sidewalk: Curb side : Cutout Tree 2 FUF   5     6004263.46084 2092033.98232 37.7245684629353 -122.427415688595 (37.7245684629353, -122.427415688595) 9 7 6 28861 5
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                    
1501 27903 7 27 280 The Embarcadero 33 Sidewalk: Curb side : Cutout Tree 6   01/31/2001 12:00:00 AM 12     6015937.152 2112771.705 37.7821632154212 -122.388507741674 (37.7821632154212, -122.388507741674) 6 2 9 28856 6
1524 28207 1 27 300X King St 13 Sidewalk: Curb side : Cutout Tree 1     12     6014268.5967781 2110706.0699128 37.7763988431969 -122.394135578218 (37.7763988431969, -122.394135578218) 6 2 9 28856 20
1534 28217 1 27 300X King St 23 Sidewalk: Curb side : Cutout Tree 1     12     6014268.5967781 2110706.0699128 37.7763988431969 -122.394135578218 (37.7763988431969, -122.394135578218) 6 2 9 28856 20
1605 35819 7 27 980 Houston St 4 Sidewalk: Curb side : Cutout Tree 2   04/22/1998 12:00:00 AM     Permit Number 39055                    
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
1792 195241 1 27 1400x Evans Ave 17 Median : Yard Tree 1     5     6016370.1217 2098002.92096 37.7416352733631 -122.385980035973 (37.7416352733631, -122.385980035973) 10 3 8 58 1
2271 37958 1 27 701 Minnesota St 2 Sidewalk: Curb side : Cutout Tree 2 FUF 09/17/1998 12:00:00 AM 7   Permit Number 40528 6015227.36686 2105129.80279 37.7611408796801 -122.390429180864 (37.7611408796801, -122.390429180864) 10 3 8 28856 29
2454 46118 7 27 2 Folsom St 11 Sidewalk: Curb side : Cutout Tree 2   12/27/2001 12:00:00 AM     Permit Number 44476 6015543.8 2115940.8 37.7908430231508 -122.390090033136 (37.7908430231508, -122.390090033136) 6 2 9 28855 6
2497 134970 1 27 2100 The Embarcadero 4 Sidewalk: Curb side : Yard Tree 2     10     6009821.57971 2122377.99729 37.8081989525817 -122.41034344359 (37.8081989525817, -122.41034344359) 3 1 10 308 23
2807 195472 1 27 450x The Embarcadero 8 Median : Yard Tree 1     7     6014582.56054 2117381.49578 37.7947454787808 -122.393516774681 (37.7947454787808, -122.393516774681) 12 2 10 28860 6
2869 260926 1 27 1726 Grove St 1 Sidewalk: Curb side : Cutout Tree 2           5999531 2110546 37.7751291750369 -122.445105382083 (37.7751291750369, -122.445105382083) 15 5 11 29492 16
2988 35689 7 27   12 Sidewalk: Curb side : Cutout Tree 2   04/10/1998 12:00:00 AM     Permit Number 38993                    
3031 68691 7 27 4639 California St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 11/02/1993 12:00:00 AM     Permit Number 32601 5993244.83438124 2114136.0623562 37.7846257148972 -122.467111515337 (37.7846257148972, -122.467111515337) 11 6 2 54 11
3043 50727 1 27 3101 Washington St 2 Sidewalk: Curb side : Cutout Tree 2   06/22/2020 12:00:00 AM 3   Permit Number 47278 5999820.18681 2116042.56859 37.7902378338637 -122.444500147275 (37.7902378338637, -122.444500147275) 13 6 1 29490 27
3147 59705 1 27 3135 Washington St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 05/08/1981 12:00:00 AM 12   Permit Number 19135 5999682.98481 2116022.48652 37.7901748642281 -122.444973410102 (37.7901748642281, -122.444973410102) 13 6 1 29490 27
3253 33090 7 27   3 Sidewalk: Curb side : Cutout Tree 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
3407 261413 1 27 784 Broadway 1 Sidewalk: Curb side : Cutout Tree 2           6009845.04505 2118484.93763 37.7975108909305 -122.409987225009 (37.7975108909305, -122.409987225009) 3 1 10 308 4
3443 33088 7 27   5 Sidewalk: Curb side : Cutout Tree 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
3499 30983 1 27 2351 Laguna St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 03/13/1995 12:00:00 AM 6   Permit Number 34770 6004127.32192 2116907.85743 37.7928585158547 -122.429659520472 (37.7928585158547, -122.429659520472) 13 9 1 29490 27
3709 33773 1 27 2640 Baker St 1 Sidewalk: Curb side : Cutout Tree 1 Private 12/23/1996 12:00:00 AM 12   Permit Number 37820 5999639.77056 2117940.89784 37.7954398489265 -122.44526091526 (37.7954398489265, -122.44526091526) 13 9 1 57 17
3870 53578 1 27 123 06th Ave 1 Sidewalk: Curb side : Cutout Tree 2   01/08/1970 12:00:00 AM 9   Permit Number 6502 5993941.76178 2114693.00762 37.7861951385831 -122.464740857622 (37.7861951385831, -122.464740857622) 11 6 2 54 11
3914 195226 1 27 551 Barneveld Ave 3 Sidewalk: Property side : Yard Tree 2     17     6011058.60969 2097355.10944 37.739561139028 -122.404299969763 (37.739561139028, -122.404299969763) 10 3 8 58 1
3932 36559 7 27   8 Sidewalk: Curb side : Cutout Tree 2   05/19/1998 12:00:00 AM     Permit Number 39428                    
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
4095 49027 7 27 199 01st St 6 Sidewalk: Curb side : Cutout Tree 2   01/06/2003 12:00:00 AM     Permit Number 46205 6013823.58160426 2115158.37921296 37.7885991200294 -122.395987099577 (37.7885991200294, -122.395987099577) 6 2 9 28855 6
4190 71445 1 27 60 Broadway 1 Sidewalk: Curb side : Cutout Tree 2 FUF   14     6013056.35208 2118942.99059 37.798948052957 -122.398907344312 (37.798948052957, -122.398907344312) 3 1 10 28860 6
4477 57232 7 27 91 Henry St 1 Sidewalk: Curb side : Cutout Tree 2   01/09/1975 12:00:00 AM     Permit Number 14519 6002939.30874382 2107370.92325937 37.7666051407068 -122.433088392926 (37.7666051407068, -122.433088392926) 15 5 5 28862 3
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                    
4725 35344 1 27 822 Arkansas St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 04/23/1998 12:00:00 AM 12   Permit Number 39079 6013033.1221 2103220.47445 37.7557763166346 -122.397884245859 (37.7557763166346, -122.397884245859) 10 3 8 28856 29
4781 254118 2 27 1 Newhall St 5 Sidewalk: Property side : Yard Tree 2   01/02/2018 12:00:00 AM 3   Permit Number 781123 6018720.08887 2097065.44422 37.739190920851 -122.377789500691 (37.739190920851, -122.377789500691) 10 3 8 58 1
4966 37957 1 27 701 Minnesota St 3 Sidewalk: Curb side : Cutout Tree 2 FUF 07/08/1998 12:00:00 AM 6   Permit Number 40192 6015227.61132 2105153.87314 37.7612069852338 -122.390430017258 (37.7612069852338, -122.390430017258) 10 3 8 28856 29
5044 261415 1 27 787 Broadway 1 Sidewalk: Curb side : Cutout Tree 2           6009827.54432 2118442.11593 37.7973923321705 -122.410044757791 (37.7973923321705, -122.410044757791) 3 1 10 308 4
5049 39250 7 27 3168 Cesar Chavez St 11 Sidewalk: Curb side : Cutout Tree 2   12/14/1998 12:00:00 AM     Permit Number 40877 6008614.08848489 2100618.91579037 37.7483859278404 -122.412982801874 (37.7483859278404, -122.412982801874) 2 4 7 28859 19
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                    
5113 60229 1 27 6242 California St 2 Sidewalk: Curb side : Cutout Tree 2   07/26/1982 12:00:00 AM 13   Permit Number 19780 5988145.31285 2114007.56926 37.783977233395 -122.484744500147 (37.783977233395, -122.484744500147) 11 6 2 55 26
5399 42533 1 27 616 Minna St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 06/26/2000 12:00:00 AM 10   Permit Number 42640 6009446.62137 2111558.04307 37.7784689692185 -122.410876400723 (37.7784689692185, -122.410876400723) 8 2 9 28853 34
5488 46196 7 27   3 Sidewalk: Curb side : Cutout Tree 2   12/31/2001 12:00:00 AM     Permit Number 44518                    
5697 100042 1 27 1925 Gough St 5 Sidewalk: Curb side : Cutout Tree 2     8     6005174.91003 2116356.5458 37.7914040153291 -122.425995549348 (37.7914040153291, -122.425995549348) 13 9 1 28858 27
6353 50331 1 27 800 Howard St 8 Sidewalk: Curb side : Cutout Tree 2   12/17/2009 12:00:00 AM 6   Permit Number 53108 6011486.90457 2112973.18308 37.7824688065362 -122.403917861314 (37.7824688065362, -122.403917861314) 12 2 9 28853 34
6495 37955 1 27 701 Minnesota St 6 Sidewalk: Curb side : Cutout Tree 2 FUF 07/08/1998 12:00:00 AM 6   Permit Number 40192 6015222.37613 2105229.81644 37.761415218749 -122.390453430208 (37.761415218749, -122.390453430208) 10 3 8 28856 29
6507 106422 1 27 900 North Point St 22 Sidewalk: Curb side : Cutout Tree 2     6     6006057.80404 2121440.5977 37.8054133915718 -122.423302314572 (37.8054133915718, -122.423302314572) 5 1 1 28858 32
6511 46719 7 27   3 Sidewalk: Curb side : Cutout Tree 2   04/24/2002 12:00:00 AM     Permit Number 44843                    
6607 28204 1 27 300X King St 10 Sidewalk: Curb side : Cutout Tree 1     12     6014268.5967781 2110706.0699128 37.7763988431969 -122.394135578218 (37.7763988431969, -122.394135578218) 6 2 9 28856 20
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
6956 34828 7 27 1627 18th Ave 1 Sidewalk: Curb side : Cutout Tree 2   07/29/1997 12:00:00 AM     Permit Number 38458 5990549.21563661 2104310.17201234 37.7574905284103 -122.4757195858 (37.7574905284103, -122.4757195858) 1 8 4 56 12
6996 261387 1 27 600 Broadway 1 Sidewalk: Curb side : Cutout Tree 2                              
7248 264745 1 27 1083 Market St 2 Sidewalk: Curb side : Cutout Tree 2           6009159.2602 2112391.6718 37.7807417986999 -122.411929420062 (37.7807417986999, -122.411929420062) 14 2 9 28853 34
7463 211983 1 27 694 Hearst Ave 1 Sidewalk: Property side : Yard Tree 2     15     5996957.73544 2094438.14779 37.7307538246289 -122.452843941191 (37.7307538246289, -122.452843941191) 9 7 4 59 40
7549 34002 7 27   1 Sidewalk: Curb side : Cutout Tree 2         Permit Number 37940                    
7585 78599 1 27 1721 20th St 1 Sidewalk: Curb side : Cutout Tree 2 FUF   6     6012838.14816 2104697.96448 37.7598223206635 -122.398662212485 (37.7598223206635, -122.398662212485) 10 3 8 28856 29
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                              
8867 34881 1 27 211 Main St 4 Sidewalk: Curb side : Cutout Tree 2   09/09/1997 12:00:00 AM 12   Permit Number 38492 6014682.09423 2115822.57014 37.7904705613091 -122.393063242988 (37.7904705613091, -122.393063242988) 6 2 9 28855 6
8960 39903 7 27   1 Sidewalk: Curb side : Cutout Tree 2   01/03/2002 12:00:00 AM     Permit Number 41185                    
9015 30418 1 27 2509 Filbert St 1 Sidewalk: Curb side : Cutout Tree 2   03/26/1956 12:00:00 AM 12   Permit Number 73 6000919.61601 2118590.12909 37.7972954389769 -122.440879042342 (37.7972954389769, -122.440879042342) 13 9 1 57 17
9077 261414 1 27 784 Broadway 2 Sidewalk: Curb side : Cutout Tree 2           6009845.04505 2118484.93763 37.7975108909305 -122.409987225009 (37.7975108909305, -122.409987225009) 3 1 10 308 4
9222 195471 1 27 450x The Embarcadero 7 Median : Yard Tree 1     7     6014542.5915 2117352.94839 37.7946648734448 -122.393653075045 (37.7946648734448, -122.393653075045) 12 2 10 28855 6
9237 261402 1 27 777 Broadway 2 Sidewalk: Curb side : Cutout Tree 2           6009873.57516 2118448.52327 37.7974125049795 -122.409885931014 (37.7974125049795, -122.409885931014) 3 1 10 308 4
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                    
9547 32801 1 27 1640 Hayes St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 10/29/1996 12:00:00 AM 7   Permit Number 37163 5999986.448 2110250.0303 37.7743425023806 -122.443508626239 (37.7743425023806, -122.443508626239) 15 5 11 29492 16
9675 49505 7 27 702@ INNES Phelps St 1 Sidewalk: Curb side : Cutout Tree 2   04/22/2003 12:00:00 AM     Permit Number 46416 6015133.81699265 2097838.73838627 37.7411159643244 -122.39024332946 (37.7411159643244, -122.39024332946) 10 3 8 58 1
9880 42534 1 27 616 Minna St 2 Sidewalk: Curb side : Cutout Tree 2   06/26/2000 12:00:00 AM 9   Permit Number 42640 6009431.80804 2111539.80243 37.7784180540966 -122.410926357172 (37.7784180540966, -122.410926357172) 8 2 9 28853 34
9957 78350 1 27 764 35th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF   5     5985108.45002 2110660.38164 37.7746094864044 -122.495003887719 (37.7746094864044, -122.495003887719) 11 6 2 55 26
10135 46240 7 27 160 King St 5 Sidewalk: Curb side : Cutout Tree 2   01/11/2002 12:00:00 AM     Permit Number 44534 6015164.29463736 2111614.90461458 37.7789440431462 -122.39110062089 (37.7789440431462, -122.39110062089) 6 2 9 28856 20
10346 41480 7 27 2390 Hyde St 1 Sidewalk: Curb side : Cutout Tree 2         Permit Number 42055 6007082.30805796 2120481.73008774 37.8028383512958 -122.41968879786 (37.8028383512958, -122.41968879786) 5 1 1 28858 32
10386 34217 7 27 110 Frederick St 2 Sidewalk: Curb side : Cutout Tree 2   06/17/1997 12:00:00 AM     Permit Number 38032 5999469.36873216 2107750.31436605 37.7674494126495 -122.445117544708 (37.7674494126495, -122.445117544708) 15 5 11 29492 9
10848 70116 1 27 1659 Jackson St 1 Sidewalk: Curb side : Cutout Tree 2 FUF   14     6006256.51205 2117265.43085 37.7939606548043 -122.422317826729 (37.7939606548043, -122.422317826729) 13 9 10 28858 32
10919 68353 1 27 573 14th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 08/09/1993 12:00:00 AM 9   Permit Number 32173 5991577.36858 2111540.92265 37.777403783844 -122.472691050295 (37.777403783844, -122.472691050295) 11 6 2 54 26
10942 36562 7 27   3 Sidewalk: Curb side : Cutout Tree 2   05/19/1998 12:00:00 AM     Permit Number 39428                    
11053 116828 4 27 111 BAY ST 15 Front Yard : Yard Tree 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
11260 28200 1 27 300X King St 6 Sidewalk: Curb side : Cutout Tree 1   09/30/2014 01:37:00 PM 3     6014268.5967781 2110706.0699128 37.7763988431969 -122.394135578218 (37.7763988431969, -122.394135578218) 6 2 9 28856 20
11363 78048 1 27 783 35th Ave 2 Sidewalk: Curb side : Cutout Tree 2 FUF   8     5985063.43296 2110545.25732 37.7742907524801 -122.495151117096 (37.7742907524801, -122.495151117096) 11 6 2 55 26
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                    
11949 34004 7 27   3 Sidewalk: Curb side : Cutout Tree 2         Permit Number 37940                    
12187 261401 1 27 777 Broadway 1 Sidewalk: Curb side : Cutout Tree 2           6009873.57516 2118448.52327 37.7974125049795 -122.409885931014 (37.7974125049795, -122.409885931014) 3 1 10 308 4
12503 33089 7 27   4 Sidewalk: Curb side : Cutout Tree 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
12540 33092 7 27   8 Sidewalk: Curb side : Cutout Tree 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
12629 84556 1 27 851 31st Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF   5     5986323.51581 2110116.60697 37.7731874908554 -122.490760773642 (37.7731874908554, -122.490760773642) 11 6 2 55 26
12644 261416 1 27 787 Broadway 2 Sidewalk: Curb side : Cutout Tree 2           6009827.54432 2118442.11593 37.7973923321705 -122.410044757791 (37.7973923321705, -122.410044757791) 3 1 10 308 4
12675 35820 7 27 980 Houston St 1 Sidewalk: Curb side : Cutout Tree 2   04/22/1998 12:00:00 AM     Permit Number 39055                    
12780 33093 7 27   9 Sidewalk: Curb side : Cutout Tree 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
12870 61071 1 27 2611 Sutter St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 09/01/1983 12:00:00 AM 10   Permit Number 20905 5999981.3394 2114011.0881 37.7846691114124 -122.44379656236 (37.7846691114124, -122.44379656236) 15 6 11 29490 31
13042 39902 7 27   2 Sidewalk: Curb side : Cutout Tree 2   01/03/2002 12:00:00 AM     Permit Number 41185                    
13339 49905 7 27 1686 15th St 4 Sidewalk: Curb side : Cutout Tree 2 FUF 07/02/2003 12:00:00 AM     Permit Number 46673 6006217.29915575 2107312.14837083 37.7666291551697 -122.421746203485 (37.7666291551697, -122.421746203485) 8 4 7 28853 19
13591 60096 1 27 3369 Jackson St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 03/19/1982 12:00:00 AM 14   Permit Number 19597 5998144.72497 2116139.23824 37.790407520633 -122.450304065089 (37.790407520633, -122.450304065089) 13 6 1 54 31
13714 116827 4 27 111 BAY ST 14 Front Yard : Yard Tree 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
13717 76301 1 27 2 Townsend St 6 Sidewalk: Curb side : Cutout Tree 2 FUF   13     6015739.49733 2112628.79912 37.7817598727711 -122.389181562198 (37.7817598727711, -122.389181562198) 6 2 9 28856 6
13823 81822 1 27 953 Indiana St 1 Sidewalk: Curb side : Cutout Tree 2 FUF   2     6014995.08745 2104204.61069 37.7585876135316 -122.391167870527 (37.7585876135316, -122.391167870527) 10 3 8 28856 29
13996 33267 7 27 1000 California St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 11/13/1996 12:00:00 AM     Permit Number 37441 6009551.65503934 2116448.08509162 37.7919017434497 -122.410858505631 (37.7919017434497, -122.410858505631) 5 1 10 28857 21
14289 113566 1 27 300X King St 28 Sidewalk: Curb side : Cutout Tree 1           6014268.5967781 2110706.0699128 37.7763988431969 -122.394135578218 (37.7763988431969, -122.394135578218) 6 2 9 28856 20
14315 27902 7 27 280 The Embarcadero 32 Sidewalk: Curb side : Cutout Tree 6   01/31/2001 12:00:00 AM 12     6015941.319 2112799.309 37.782239240724 -122.388495252967 (37.782239240724, -122.388495252967) 6 2 9 28856 6
14516 135161 1 27 1413 The Embarcadero 8 Sidewalk: Property side : Yard Tree 2     12     6009360.26763 2122546.84411 37.8086366930891 -122.411951881091 (37.8086366930891, -122.411951881091) 3 1 10 308 23