3,247 rows where qSpecies_id = 22 sorted by rowid descending

View and edit SQL

rowid ▲ TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
188363 123758 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 201 Cabrillo St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 5ft   5994989.32477 2110751.87532 37.7754341833406 -122.46083085861 (37.7754341833406, -122.46083085861) 11 6 2 54 11
188292 120948 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 1637 Oak St 4 Sidewalk: Curb side : Cutout Tree Private 2   08/30/2016 12:00:00 AM 3 3X4   5999143 2109364 37.7718615511814 -122.446362505197 (37.7718615511814, -122.446362505197) 15 5 11 29492 9
188229 30830 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 76 Mangels Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/06/1995 12:00:00 AM 2   Permit Number 34682 6000883.26953 2095219.22157 37.7331226406966 -122.439328749644 (37.7331226406966, -122.439328749644) 9 7 5 63 40
188145 219083 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1261 05th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5994524.07411 2106892.34706 37.7648101540841 -122.462160294371 (37.7648101540841, -122.462160294371) 11 5 11 56 12
188051 226163 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 53 Carmel St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   5998645.21714 2105367.01627 37.7608584008193 -122.44779656456 (37.7608584008193, -122.44779656456) 15 5 11 29492 12
188025 190567 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 550 South St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6016343.36637 2107984.47117 37.7690410290422 -122.386768461707 (37.7690410290422, -122.386768461707) 14 3 9 310 20
187965 35521 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 90 Alvarado St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/13/1999 12:00:00 AM     Permit Number 41442 6005793.71652674 2102887.49607432 37.7544562030797 -122.422896805421 (37.7544562030797, -122.422896805421) 2 4 5 28859 19
187838 91403 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1275 Indiana St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/04/2007 12:00:00 AM 1 3x3 Permit Number 49180 6015088.57959 2102608.00108 37.7542088522599 -122.390732954759 (37.7542088522599, -122.390732954759) 10 3 8 28856 29
187796 27495 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 401X Masonic Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1   03/28/2005 12:00:00 AM 6 8   5999043.2471 2111289.3703 37.7771424276553 -122.446846123038 (37.7771424276553, -122.446846123038) 15 5 2 29492 16
187770 192468 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1000 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6014906.49786 2103925.69197 37.7578168459985 -122.391454756925 (37.7578168459985, -122.391454756925) 10 3 8 28856 29
187734 192447 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2019 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6011308.81351 2106478.52293 37.7646260106971 -122.404076769723 (37.7646260106971, -122.404076769723) 8 3 8 28856 29
187706 98797 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 950@Washington Clay St 8 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   03/16/2012 12:00:00 AM 1 3x3 Permit Number 768771 6010116.35805 2117191.91562 37.7939757697248 -122.408957127878 (37.7939757697248, -122.408957127878) 3 1 10 28857 4
187550 35376 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 724 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/23/1998 12:00:00 AM 3   Permit Number 38833 6010962.01124 2104944.83832 37.7603954747858 -122.40516826792 (37.7603954747858, -122.40516826792) 10 3 8 28856 29
187538 138736 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2418 Sutter St 5 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6000983.5157 2114203.7411 37.78525519844 -122.440343196371 (37.78525519844, -122.440343196371) 15 6 1 29490 27
187518 247441 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 401 Pierce St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 0ft   6002616 2109935 37.7736271195826 -122.434390000575 (37.7736271195826, -122.434390000575) 15 5 11 29492 10
187478 128903 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 341 Spruce St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5997136.99207 2115139.1761 37.7876038940487 -122.453718489626 (37.7876038940487, -122.453718489626) 11 6 1 54 31
187437 226215 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1305 Alabama St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6009284.91465 2101528.45112 37.750920943448 -122.410727314736 (37.750920943448, -122.410727314736) 2 4 7 28859 19
187417 190413 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2323 Cesar Chavez St 15 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6012337.1891 2100920.23068 37.7494215649704 -122.400129481597 (37.7494215649704, -122.400129481597) 10 3 8 58 1
187311 7380 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1000X Folsom St 4 Sidewalk: Curb side : Cutout Tree Rec/Park 5     45 3X3   6010853.2469 2111475.4662 37.7783210049209 -122.406004508334 (37.7783210049209, -122.406004508334) 14 2 9 28853 34
187239 192492 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 301 Kansas St 5 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6011484.77933 2106676.49722 37.76517943372 -122.403482076842 (37.76517943372, -122.403482076842) 8 3 8 28853 20
187194 139207 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2071 Post St 13 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6002142.068 2113965.1028 37.7846658547261 -122.436317881839 (37.7846658547261, -122.436317881839) 13 6 11 29490 13
187053 37325 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 465 Liberty St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/15/1998 12:00:00 AM     Permit Number 39836 6003319.75877795 2103865.74575839 37.7570023398617 -122.431522222437 (37.7570023398617, -122.431522222437) 2 4 5 28862 3
187019 63400 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 229 Eureka St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/11/1987 12:00:00 AM 12   Permit Number 23982 6001466.35447253 2104493.12773322 37.7586197563696 -122.437976920317 (37.7586197563696, -122.437976920317) 2 4 5 28862 3
186892 51668 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2618 Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/13/2005 12:00:00 AM 3   Permit Number 48074 6003607.03534 2117490.12899 37.7944278103538 -122.431501323032 (37.7944278103538, -122.431501323032) 13 9 1 29490 27
186877 190424 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1300 Evans Ave 22 : Tree Private 2     1 Width 3ft   6017710.59589 2097057.73864 37.7391140860314 -122.381279373169 (37.7391140860314, -122.381279373169) 10 3 8 58 1
186830 143214 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 209 FRANCISCO ST 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6010288.2363 2121289.8221 37.805237242499 -122.408651632361 (37.805237242499, -122.408651632361) 3 1 10 308 23
186710 192490 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 301 Kansas St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6011488.18955 2106621.2113 37.765027821512 -122.403466391771 (37.765027821512, -122.403466391771) 8 3 8 28853 20
186662 190511 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 649 Delancey St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6015813.14404 2113067.73193 37.7829691659357 -122.388957431354 (37.7829691659357, -122.388957431354) 6 2 9 28856 6
186637 141049 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 15 MASONIC AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 0ft   5998797.2643 2113074.7036 37.7820304350803 -122.447825614108 (37.7820304350803, -122.447825614108) 15 5 2 54 16
186635 68700 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 168 Funston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/1993 12:00:00 AM 4   Permit Number 32612 5991833.50014 2114340.31773 37.7851049771354 -122.472009104115 (37.7851049771354, -122.472009104115) 11 6 2 54 11
186514 4043 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2323 Cesar Chavez St 8 Sidewalk: Curb side : Cutout Tree DPW 1   02/10/2005 12:00:00 AM 3 2X3   6012152.10777 2100910.47094 37.7493844454379 -122.400768815931 (37.7493844454379, -122.400768815931) 10 3 8 58 1
186354 91452 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 680x WASHINGTON ST 1 Sidewalk: Curb side : Cutout Tree Private 2   04/10/2009 12:00:00 AM   3x3 Permit Number 52103 6011317 2117738 37.7955423680345 -122.404841229346 (37.7955423680345, -122.404841229346) 3 1 10 28857 4
186223 51627 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 3100ON LYON ST Pacific Ave 6 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2010 12:00:00 AM     Permit Number 53623 5999297.18368594 2116674.7385641 37.7919437500329 -122.446355188809 (37.7919437500329, -122.446355188809) 11 6 1 29490 30
186117 86913 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 2300 28th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/06/2007 12:00:00 AM   3x3 Permit Number 49878 5987679.6 2099585.6 37.7443513377426 -122.485297072409 (37.7443513377426, -122.485297072409) 1 8 3 29491 35
186088 41380 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 117 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/15/2000 12:00:00 AM 2   Permit Number 42016 5992703.03888 2114672.23898 37.7860666199714 -122.469024963631 (37.7860666199714, -122.469024963631) 11 6 2 54 11
185969 228254 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 470 Liberty St 1 Sidewalk: Property side : Yard Tree Private 2     3 Width 3ft   6003313.06662 2103916.08492 37.7571401799037 -122.431548960114 (37.7571401799037, -122.431548960114) 2 4 5 28862 3
185816 192474 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 654 Minnesota St 6 Sidewalk: Property side : Yard Tree Private 2     9 Width 10ft   6015149.97171 2105400.79096 37.7618806610754 -122.390715797509 (37.7618806610754, -122.390715797509) 10 3 8 28856 29
185663 225716 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 45 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6004870.68489 2096216.32114 37.7360865606506 -122.425614119915 (37.7360865606506, -122.425614119915) 2 7 5 28859 2
185585 190448 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1498 Evans Ave 1 : Tree Private 2     1 Width 3ft   6016474.94651 2097978.89323 37.7415750988015 -122.385615909472 (37.7415750988015, -122.385615909472) 10 3 8 58 1
185425 24352 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 183 Duboce Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/24/1995 12:00:00 AM 3 3X3   6005552.77434 2108427.90971 37.7696552731946 -122.424124039488 (37.7696552731946, -122.424124039488) 8 4 5 28853 19
185409 190532 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 21 Clarence Pl 10 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6014670.88352 2111945.1803 37.7798235127783 -122.392830653125 (37.7798235127783, -122.392830653125) 6 2 9 28856 6
185405 6592 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 1375 Evans Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   03/29/2004 12:00:00 AM 6 3X3   6016853.0670442 2097574.0145522 37.7404842987312 -122.384280293448 (37.7404842987312, -122.384280293448) 10 3 8 58 1
185331 228262 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 460 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6002296.57244 2105544.02101 37.7615524328214 -122.435180819147 (37.7615524328214, -122.435180819147) 15 4 5 28862 3
185248 256596 Undocumented 4 Ginkgo biloba :: Maidenhair Tree 22 2x Stillman St 23 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
185008 4039 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2323 Cesar Chavez St 4 Sidewalk: Curb side : Cutout Tree DPW 1   03/07/2014 12:00:00 AM 5 2X3   6011942.20762 2100900.73993 37.7493460165275 -122.401493976188 (37.7493460165275, -122.401493976188) 10 3 8 58 1
184906 192439 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 8 McLea Ct 1 : Tree Private 2     3 Width 3ft   6010092.24423 2109274.67228 37.772235545969 -122.408481828984 (37.772235545969, -122.408481828984) 14 2 9 28853 34
184682 190535 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 143 Townsend St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6014843.30618 2111698.81025 37.7791566115278 -122.392216926969 (37.7791566115278, -122.392216926969) 6 2 9 28856 20
184629 192440 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 10 McLea Ct 3 : Tree Private 2     2 Width 3ft   6010071.61086 2109254.18785 37.7721781449322 -122.408551756678 (37.7721781449322, -122.408551756678) 14 2 9 28853 34
184515 190426 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1300 Evans Ave 24 : Tree Private 2     2 Width 3ft   6017676.69292 2097082.96184 37.7391814722423 -122.381398348955 (37.7391814722423, -122.381398348955) 10 3 8 58 1
184473 6506 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1200X Evans Ave 48 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2004 12:00:00 AM 3 3x3   6016870.73401 2097688.74101 37.7408002912118 -122.384227195218 (37.7408002912118, -122.384227195218) 10 3 8 58 1
184457 190370 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2125 19th St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6011391.26276 2105082.59531 37.7607977127635 -122.403693370779 (37.7607977127635, -122.403693370779) 10 3 8 28856 29
184339 128996 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1189 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6007875.74827 2118524.15827 37.7975080126282 -122.416804311666 (37.7975080126282, -122.416804311666) 5 1 10 28858 21
184314 6433 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1100X Evans Ave 15 Sidewalk: Curb side : Cutout Tree DPW 1   07/10/2014 12:00:00 AM 3 3x3   6018339.9760743 2096552.8140758 37.7377623877793 -122.379068180173 (37.7377623877793, -122.379068180173) 10 3 8 58 1
184281 120736 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 718 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5989459.46048 2110420.19517 37.7742037514814 -122.479935471669 (37.7742037514814, -122.479935471669) 11 6 2 55 26
184270 51315 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 1255 Harrison St 4 Sidewalk: Curb side : Cutout Tree Private 2   09/29/2004 12:00:00 AM     Permit Number 47679 6009865.2769481 2109575.56803781 37.773049022534 -122.409288169615 (37.773049022534, -122.409288169615) 14 2 9 28853 34
184190 44197 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 Harrison St 4 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2000 12:00:00 AM 4   Permit Number 43651 6015604.12637 2115150.5006 37.7886763877505 -122.389826079337 (37.7886763877505, -122.389826079337) 6 2 9 28855 6
184074 128997 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1189 Vallejo St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6007893.47286 2118525.78201 37.7975134679385 -122.416743094821 (37.7975134679385, -122.416743094821) 5 1 10 28858 21
184037 55930 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 1680 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/22/2009 12:00:00 AM   3x3 Permit Number 53115 5992813.78045219 2104035.719351 37.7568679811889 -122.467867918822 (37.7568679811889, -122.467867918822) 1 8 4 56 12
183893 190536 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 143 Townsend St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6014859.83951 2111716.56504 37.7792062801806 -122.392160972975 (37.7792062801806, -122.392160972975) 6 2 9 28856 20
183852 192441 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 10 McLea Ct 5 : Tree Private 2     2 Width 3ft   6010051.80213 2109236.00979 37.7721271227961 -122.408618994484 (37.7721271227961, -122.408618994484) 14 2 9 28853 34
183738 190587 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1245 03rd St 2 Sidewalk: Curb side : Yard Tree Private 2     3 Width 5ft   6015583.31199 2109308.81865 37.7726352865222 -122.389489966697 (37.7726352865222, -122.389489966697) 14 3 9 310 20
183682 141543 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2000 FULTON ST 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5998090.9824 2110680.0015 37.7754148117901 -122.450096360144 (37.7754148117901, -122.450096360144) 15 5 2 29492 16
183675 122698 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 98 Woolsey St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/16/2016 12:00:00 AM 3 3x3   6011441.99272 2092150.08828 37.725290657742 -122.402608459524 (37.725290657742, -122.402608459524) 10 3 7 309 28
183485 63008 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 104 ANDOVER ST 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/23/1986 12:00:00 AM 12 3x3 Permit Number 23421 6007561.3 2098161.3 37.741578710179 -122.41644927465 (37.741578710179, -122.41644927465) 2 7 7 28859 2
183337 59996 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 332 Spruce St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/13/1982 12:00:00 AM 8   Permit Number 19482 5997170.21604 2115201.86261 37.7877779191499 -122.453608069965 (37.7877779191499, -122.453608069965) 11 6 1 54 31
183284 228292 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 72 Belcher St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6003784.39845 2107904.86068 37.7681191043335 -122.43020347183 (37.7681191043335, -122.43020347183) 7 9 5 28862 3
183115 26812 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1701 Divisadero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 3X3   6001060.3249 2114356.0469 37.7856777639804 -122.440088385928 (37.7856777639804, -122.440088385928) 15 6 1 29490 27
183103 82380 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 409 Eureka St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51346 6001525.14685133 2103443.3076872 37.7557405478415 -122.437698403881 (37.7557405478415, -122.437698403881) 2 4 5 28862 22
183095 225623 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 615 Buena Vista Ave West 2 Sidewalk: Curb side : Yard Tree Private 2     4 Width 3ft   5999830.8005 2107620.03218 37.7671123132949 -122.443858043933 (37.7671123132949, -122.443858043933) 15 5 5 29492 9
183085 190588 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1245 03rd St 3 Sidewalk: Curb side : Yard Tree Private 2     4 Width 5ft   6015580.36907 2109321.80204 37.7726707728775 -122.389501053548 (37.7726707728775, -122.389501053548) 14 3 9 310 20
183078 33013 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 3625 24th St 4 Sidewalk: Curb side : Cutout Tree Private 2   11/05/1996 12:00:00 AM     Permit Number 37305 6005620.98142938 2101949.23575785 37.7518702093111 -122.423427471135 (37.7518702093111, -122.423427471135) 2 4 5 28859 19
182760 120715 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 126 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5989312.46235 2114493.28759 37.7853787843152 -122.480742207337 (37.7853787843152, -122.480742207337) 11 6 2 55 26
182679 55033 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 429 Liberty St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/04/1997 12:00:00 AM     Permit Number 10912 6003483.19958391 2103874.81150572 37.7570364944574 -122.430957629546 (37.7570364944574, -122.430957629546) 2 4 5 28862 3
182651 201865 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1026 Folsom St 3 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6010728.1722 2111355.3833 37.7779842891269 -122.406428726657 (37.7779842891269, -122.406428726657) 14 2 9 28853 34
182462 201606 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 598 Innes Ave 1 Sidewalk: Curb side : Yard Tree Private 2   07/12/2017 12:00:00 AM 1 Width 3ft   6020954.32481 2093200.46357 37.7287012794353 -122.369797385941 (37.7287012794353, -122.369797385941) 10 3 8 58 1
182443 107581 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 100 Panama St 3 Sidewalk: Curb side : Yard Tree Private 2   11/12/2014 12:00:00 AM 3   Permit Number 774090 5992393.94682 2086830.99569 37.7096038591978 -122.468068397753 (37.7096038591978, -122.468068397753) 9 8 4 64 24
182441 139200 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2179 Post St 6 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6001873.4582 2113930.4197 37.7845553580196 -122.437244696212 (37.7845553580196, -122.437244696212) 13 6 11 29490 13
182433 219054 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1020 Ulloa St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5992916.05504 2098440.23001 37.7415101074999 -122.467107408302 (37.7415101074999, -122.467107408302) 1 8 4 59 40
182395 219135 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 13 Melrose Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6000020.79486 2095469.62875 37.733761081096 -122.442328516573 (37.733761081096, -122.442328516573) 9 7 4 63 40
182302 120446 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 55 22nd Ave 2 Sidewalk: Curb side : Yard Tree Private 2     2 Width 6ft   5988945.57573 2114940.19348 37.7865845302304 -122.482044260519 (37.7865845302304, -122.482044260519) 11 6 1 55 33
182248 129012 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 150 Francisco St 6 Sidewalk: Property side : Yard Tree Private 2     17     6010624.52904 2121364.46761 37.8054610295673 -122.407493109815 (37.8054610295673, -122.407493109815) 3 1 10 308 23
182184 109118 Section 143 10 Ginkgo biloba :: Maidenhair Tree 22 2036x 15TH ST 4 Sidewalk: Curb side : Cutout Tree Private 2       12x6   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
182150 219140 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 10 Monterey Blvd 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6002002.66106 2094856.00835 37.732188978917 -122.43543274625 (37.732188978917, -122.43543274625) 9 7 4 63 40
182112 46478 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 195 Erie St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/10/2017 12:00:00 AM 3   Permit Number 779295 6006760.77877473 2108157.52189336 37.7689809837181 -122.419926393368 (37.7689809837181, -122.419926393368) 8 4 7 28853 19
182036 128914 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2305 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6001287.18154 2116377.26813 37.7912404277657 -122.439448468282 (37.7912404277657, -122.439448468282) 13 6 1 29490 27
182031 5198 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 635 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/17/2001 12:00:00 AM 3 3x3   6001582.4984 2110645.9942 37.775520613317 -122.43801597154 (37.775520613317, -122.43801597154) 15 5 11 29492 10
181958 31840 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1175 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/06/2015 12:00:00 AM 3 3x3 Permit Number 774358 6009887.2147 2110463.0079 37.7754869546364 -122.40927492061 (37.7754869546364, -122.40927492061) 8 2 9 28853 34
181951 48930 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 797 Hampshire St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/25/2002 12:00:00 AM     Permit Number 46118 6010177.49860621 2104588.91884778 37.7593743105767 -122.407856447489 (37.7593743105767, -122.407856447489) 10 4 8 28859 19
181906 119900 Undocumented 4 Ginkgo biloba :: Maidenhair Tree 22 300X 29th St 6 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   6004302 2098976 37.7436318598049 -122.427776865938 (37.7436318598049, -122.427776865938) 2 7 5 63 22
181897 225770 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 469 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6002361.00507 2105510.35987 37.7614636661325 -122.434955565955 (37.7614636661325, -122.434955565955) 15 4 5 28862 3
181883 226020 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 56 Julian Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6006380.28665 2107563.88675 37.7673295589316 -122.421200334536 (37.7673295589316, -122.421200334536) 8 4 7 28853 19
181881 52195 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1209 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2005 12:00:00 AM 3   Permit Number 48386 6007084.31165 2119457.46133 37.8000260811036 -122.419609149648 (37.8000260811036, -122.419609149648) 5 1 1 28858 32
181796 256590 Undocumented 4 Ginkgo biloba :: Maidenhair Tree 22 2x Stillman St 17 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
181792 228231 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 4143 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6002123.33 2104678.99261 37.7591674352478 -122.435718102016 (37.7591674352478, -122.435718102016) 2 4 5 28862 3
181771 110480 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 573 Scott St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     6002112.3456 2110445.7265 37.7750008457371 -122.436168770849 (37.7750008457371, -122.436168770849) 15 5 11 29492 10
181770 51317 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 1255 Harrison St 5 Sidewalk: Curb side : Cutout Tree Private 2   09/29/2004 12:00:00 AM     Permit Number 47679 6009865.2769481 2109575.56803781 37.773049022534 -122.409288169615 (37.773049022534, -122.409288169615) 14 2 9 28853 34
181565 109621 Undocumented 4 Ginkgo biloba :: Maidenhair Tree 22 300x DAVIS ST 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013341 2117458 37.794886478256 -122.39781814115 (37.794886478256, -122.39781814115) 3 1 10 28860 6
181536 22838 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 112 Turquoise Way 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/01/2000 12:00:00 AM 3 2X2   5999650.54183 2098943.83579 37.7432793203754 -122.443858110463 (37.7432793203754, -122.443858110463) 2 7 5 63 7
181444 226193 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 21 Elsie St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6007585.67898 2099286.71688 37.7446702253682 -122.416444678176 (37.7446702253682, -122.416444678176) 2 7 7 28859 2
181415 190479 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 260 Steuart St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6015266.16724 2116198.30541 37.7915346715264 -122.391068643817 (37.7915346715264, -122.391068643817) 6 2 9 28855 6

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);