Street_Tree_List

Data source: data.sfgov.org

674 rows where qSpecies = 135

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
1137 223094 Permitted Site 1 Crataegus phaenopyrum :: Washington Hawthorn 135 1625 Alabama St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/22/2001 12:00:00 AM 5 Width 3ft Permit Number 44006 6009321.48111 2099968.9048200003 37.7466408252167 -122.41049075166 (37.7466408252167, -122.41049075166)
1184 59673 Permitted Site 1 Crataegus phaenopyrum :: Washington Hawthorn 135 531 Grove St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/31/1994 12:00:00 AM 3 3x3 Permit Number 33280 6005241.131 2111282.5171 37.777475732552205 -122.425405179356 (37.7774757325522, -122.425405179356)
3354 223144 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 603X Elizabeth St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 2ft   6002466.57399 2102069.11902 37.7520208377029 -122.43434440919201 (37.7520208377029, -122.434344409192)
4742 161277 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 582 Naples St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/25/2017 12:23:00 PM 3 Width 0ft   6002834.75222 2090259.2052900002 37.7196144116499 -122.432227854755 (37.7196144116499, -122.432227854755)
4748 161275 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 574 Naples St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/25/2017 12:26:00 PM 3 Width 0ft   6002859.417719999 2090297.5513900002 37.7197211000357 -122.432145332055 (37.7197211000357, -122.432145332055)
4825 161272 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 562 Naples St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/25/2017 03:33:00 PM 3 Width 0ft   6002894.24566 2090355.62698 37.719882537321 -122.43202908927499 (37.719882537321, -122.432029089275)
9743 173674 Significant Tree 6 Crataegus phaenopyrum :: Washington Hawthorn 135 299x Beale St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6014575.0 2115523.0 37.789642061391 -122.39341281176901 (37.789642061391, -122.393412811769)
9744 173673 Significant Tree 6 Crataegus phaenopyrum :: Washington Hawthorn 135 299x Beale St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6014575.0 2115523.0 37.789642061391 -122.39341281176901 (37.789642061391, -122.393412811769)
9750 173672 Significant Tree 6 Crataegus phaenopyrum :: Washington Hawthorn 135 299x Beale St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6014575.0 2115523.0 37.789642061391 -122.39341281176901 (37.789642061391, -122.393412811769)
11854 27094 DPW Maintained 3 Crataegus phaenopyrum :: Washington Hawthorn 135 711 Silver Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 2X3   6006079.32482 2093593.7371200002 37.728953744301 -122.421249181231 (37.728953744301, -122.421249181231)
12879 108784 Permitted Site 1 Crataegus phaenopyrum :: Washington Hawthorn 135 2055 Sunnydale Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 FUF 1 01/06/2015 12:00:00 AM 3 3x3 Permit Number 773821 6005634.22998 2088024.3237700001 37.7136362375916 -122.42239234634899 (37.7136362375916, -122.422392346349)
13106 108782 Permitted Site 1 Crataegus phaenopyrum :: Washington Hawthorn 135 2055 Sunnydale Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 FUF 1 01/06/2015 12:00:00 AM 3 3x3 Permit Number 773821 6005606.4158 2088034.4515 37.713662477117 -122.422489201534 (37.713662477117, -122.422489201534)
13428 51364 DPW Maintained 3 Crataegus phaenopyrum :: Washington Hawthorn 135 50 Pomona St 7 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014150.64944 2094610.63008 37.732197660973505 -122.393416939157 (37.7321976609735, -122.393416939157)
14765 51356 DPW Maintained 3 Crataegus phaenopyrum :: Washington Hawthorn 135 50 Pomona St 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 12/10/2005 12:00:00 AM 3 3x3 Permit Number 47704 6014174.8382 2094728.0237900002 37.732521344076204 -122.393341524701 (37.7325213440762, -122.393341524701)
15350 78329 DPW Maintained 3 Crataegus phaenopyrum :: Washington Hawthorn 135 50 Pomona St 18 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 07/15/2000 12:00:00 AM 3 3x3   6014093.60126 2094328.91133 37.731420948908294 -122.39359445903999 (37.7314209489083, -122.39359445904)
15526 78327 DPW Maintained 3 Crataegus phaenopyrum :: Washington Hawthorn 135 50 Pomona St 20 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 07/15/2000 12:00:00 AM 3 3x3   6014087.33436 2094297.79766 37.7313351688787 -122.39361394824199 (37.7313351688787, -122.393613948242)
15539 78321 DPW Maintained 3 Crataegus phaenopyrum :: Washington Hawthorn 135 50 Pomona St 26 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 07/15/2000 12:00:00 AM 3 3x3   6014066.05948 2094191.2042200002 37.73104130280179 -122.39368004209999 (37.7310413028018, -122.3936800421)
15702 51369 DPW Maintained 3 Crataegus phaenopyrum :: Washington Hawthorn 135 50 Pomona St 3 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 03/12/2005 12:00:00 AM 3 3x3 Permit Number 47704 6014169.21344 2094698.3618 37.7324395857978 -122.39335889598999 (37.7324395857978, -122.39335889599)
15731 78323 DPW Maintained 3 Crataegus phaenopyrum :: Washington Hawthorn 135 50 Pomona St 24 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 07/15/2000 12:00:00 AM 3 3x3   6014072.33534 2094216.7042200002 37.731111669349204 -122.393660129315 (37.7311116693492, -122.393660129315)
16338 51366 DPW Maintained 3 Crataegus phaenopyrum :: Washington Hawthorn 135 50 Pomona St 5 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 03/12/2005 12:00:00 AM 3 3x3 Permit Number 47704 6014162.991119999 2094669.4439299998 37.73235983751729 -122.39337838521601 (37.7323598375173, -122.393378385216)
16645 51363 DPW Maintained 3 Crataegus phaenopyrum :: Washington Hawthorn 135 50 Pomona St 9 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014143.519230001 2094573.1883599998 37.7320944574823 -122.393438970749 (37.7320944574823, -122.393438970749)
16703 49954 Permitted Site 1 Crataegus phaenopyrum :: Washington Hawthorn 135 1704@ ARKANSAS 20th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/25/2003 12:00:00 AM 2 3x3 Permit Number 46735 6012896.201830001 2104748.72577 37.759964934260395 -122.39846499386002 (37.7599649342604, -122.39846499386)
17423 32509 Permitted Site 1 Crataegus phaenopyrum :: Washington Hawthorn 135 718 Moultrie St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/15/1996 12:00:00 AM 6 2x3 Permit Number 37011 6007605.33765 2096031.84482 37.735734172092705 -122.41614623006399 (37.7357341720927, -122.416146230064)
17843 55366 Permitted Site 1 Crataegus phaenopyrum :: Washington Hawthorn 135 160 San Aleso Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/16/2003 12:00:00 AM     Permit Number 46504 5993337.43694089 2094535.94135118 37.7308142184714 -122.46536688133499 (37.7308142184714, -122.465366881335)
17979 48935 Permitted Site 1 Crataegus phaenopyrum :: Washington Hawthorn 135 2743 Harrison St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/25/2002 12:00:00 AM     Permit Number 46123 6008967.24880953 2102489.58925571 37.7535421972635 -122.411893748881 (37.7535421972635, -122.411893748881)
18439 24596 Permitted Site 1 Crataegus phaenopyrum :: Washington Hawthorn 135 453 Cortland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3X3   6007445.261530001 2097275.3983299998 37.739139694228705 -122.41678774975 (37.7391396942287, -122.41678774975)
19740 26870 Permitted Site 1 Crataegus phaenopyrum :: Washington Hawthorn 135 2822 Harrison St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 3x3   6008934.68396 2102005.53061 37.752211253858206 -122.411972160807 (37.7522112538582, -122.411972160807)
20289 49003 Permitted Site 1 Crataegus phaenopyrum :: Washington Hawthorn 135 428 Elizabeth St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/16/2002 12:00:00 AM 6   Permit Number 46190 6003609.57090194 2102180.87163122 37.7523924957508 -122.430399732377 (37.7523924957508, -122.430399732377)
20824 24558 Permitted Site 1 Crataegus phaenopyrum :: Washington Hawthorn 135 424 Cortland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 3X3   6007341.228080001 2097246.92859 37.7390556705772 -122.41714543443999 (37.7390556705772, -122.41714543444)
21176 32511 Permitted Site 1 Crataegus phaenopyrum :: Washington Hawthorn 135 730 Moultrie St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/15/1996 12:00:00 AM 6 2x3 Permit Number 37013 6007601.86918 2095982.1999400002 37.735597663102396 -122.416154707082 (37.7355976631024, -122.416154707082)
22409 249318 Permitted Site 1 Crataegus phaenopyrum :: Washington Hawthorn 135 198X Prospect Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1     3x3            
23622 39544 Permitted Site 1 Crataegus phaenopyrum :: Washington Hawthorn 135 1947 22nd St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/16/2009 12:00:00 AM 3 3x3 Permit Number 52628 6012257.26801 2103730.7313099997 37.7571341310464 -122.400603257944 (37.7571341310464, -122.400603257944)
23940 190941 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 1701 Newhall St 1 : 4 Tree 1 Private 1     4 Width 3ft   6013964.79274 2095080.10635 37.733476418703496 -122.39409234708599 (37.7334764187035, -122.394092347086)
24061 190934 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 1101 25th St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 9ft   6015168.60212 2102024.17667 37.752610233591206 -122.390415424833 (37.7526102335912, -122.390415424833)
24308 190929 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 1101 25th St 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 9ft   6015301.73602 2102030.54675 37.752635108841 -122.389955465678 (37.752635108841, -122.389955465678)
24444 52695 Permitted Site 1 Crataegus phaenopyrum :: Washington Hawthorn 135 2719@ SCOTT Pacific Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/31/2006 12:00:00 AM 8   Permit Number 48762 6001054.39961 2116869.28224 37.792578119835795 -122.440289185102 (37.7925781198358, -122.440289185102)
24555 223256 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 87 Deming St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5999118.73702 2105182.21845 37.7603780450418 -122.446145581955 (37.7603780450418, -122.446145581955)
24749 223177 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 357 Ellert St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6006824.211080001 2097044.2034599998 37.7384699331325 -122.41891867267701 (37.7384699331325, -122.418918672677)
25077 40184 Permitted Site 1 Crataegus phaenopyrum :: Washington Hawthorn 135 1402 18th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/27/1999 12:00:00 AM 3 9x6 Permit Number 41371 6013366.18337 2105703.90093 37.762613806409504 -122.396906512841 (37.7626138064095, -122.396906512841)
25189 206752 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 10 Beachmont Dr 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 10ft   5990858.798830001 2095874.41908 37.7343460811043 -122.474033463291 (37.7343460811043, -122.474033463291)
25328 223242 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 166 Alpine Ter 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6001694.88286 2107842.35275 37.76782890210671 -122.437426398431 (37.7678289021067, -122.437426398431)
25411 223238 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 3819 19th St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6004233.22031 2104799.55992 37.7596181035173 -122.428429683205 (37.7596181035173, -122.428429683205)
25474 206720 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 1734 08th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5993752.64886 2103670.2025099997 37.7559185363224 -122.464594447978 (37.7559185363224, -122.464594447978)
26439 190947 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 40 Bluxome St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 2ft   6013395.866090001 2110840.5938 37.7767196691005 -122.39716405528601 (37.7767196691005, -122.397164055286)
26755 223152 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 355 Sussex St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   6001098.68707 2096660.9942599998 37.7370936700316 -122.438687269517 (37.7370936700316, -122.438687269517)
26794 223122 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 148 Ellert St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 2ft   6007428.542880001 2096958.7422900002 37.738269286294106 -122.416823127285 (37.7382692862941, -122.416823127285)
27035 223254 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 12 Buena Vista Ter 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   6001416.1859800005 2108119.15554 37.7685730857195 -122.43841020995701 (37.7685730857195, -122.438410209957)
27393 223226 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 3704 23rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6003734.03519 2102475.93139 37.753209709985 -122.429990360391 (37.753209709985, -122.429990360391)
27396 32387 Permitted Site 1 Crataegus phaenopyrum :: Washington Hawthorn 135 135 Park St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/03/1996 12:00:00 AM 7   Permit Number 36930 6005715.56726 2096415.1361099998 37.736680166259 -122.422707139641 (37.736680166259, -122.422707139641)
27416 223259 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 280 Laussat St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6003359.42366 2109144.6321900003 37.7714991343099 -122.43176194386001 (37.7714991343099, -122.43176194386)
27461 223091 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 1257 Hampshire St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6010331.583740001 2101901.50724 37.7520039025724 -122.40713410947201 (37.7520039025724, -122.407134109472)
27478 223079 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 816 York St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6009889.07799 2104426.28197 37.7589115952211 -122.40884247690501 (37.7589115952211, -122.408842476905)
27557 223180 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 300 Ellert St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6006872.0649 2097073.1402900002 37.7385520817218 -122.418755268548 (37.7385520817218, -122.418755268548)
27749 223228 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 426 Elizabeth St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6003592.067969999 2102177.09415 37.7523811321982 -122.43045999085899 (37.7523811321982, -122.430459990859)
28164 250812 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 70 Sea View Ter 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   5986123.548719999 2114165.24712 37.78429221705 -122.49175057792601 (37.78429221705, -122.491750577926)
28188 223220 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 416 Alvarado St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6003639.2601 2102761.32258 37.7539879589785 -122.43033847174601 (37.7539879589785, -122.430338471746)
28546 46649 Permitted Site 1 Crataegus phaenopyrum :: Washington Hawthorn 135 126 17th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/19/2002 12:00:00 AM 2   Permit Number 44781 5990552.508640001 2114536.5883400002 37.785569672264295 -122.47645522938299 (37.7855696722643, -122.476455229383)
28627 113317 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 2497x 39th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 3x3   5984244.6688 2098225.7519 37.74041685963079 -122.497073806106 (37.7404168596308, -122.497073806106)
28665 84393 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 2101 Jerrold Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/29/2006 12:00:00 AM 2     6012494.05335 2099085.01558 37.744391202597704 -122.399458212338 (37.7443912025977, -122.399458212338)
29112 206747 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 316 Grafton Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5995834.85726 2090578.94523 37.720092967003495 -122.45644692569999 (37.7200929670035, -122.4564469257)
29218 176078 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 230 Tocoloma Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6012689.21584 2087374.22772 37.7122466573345 -122.39796202644301 (37.7122466573345, -122.397962026443)
29749 223126 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 951 Alabama St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   6009165.7822199995 2103624.7791 37.7566703092939 -122.411287361236 (37.7566703092939, -122.411287361236)
29849 223245 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 253 Buena Vista Ave East 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6001239.96378 2107994.4707400003 37.768220707038395 -122.43901080962699 (37.7682207070384, -122.439010809627)
29947 223093 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 2800 19th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 4ft   6009478.298169999 2105023.61747 37.7605287255414 -122.41030532674601 (37.7605287255414, -122.410305326746)
30045 223118 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 18 Stoneman St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6008319.16941 2099444.00252 37.7451433182199 -122.41391952755899 (37.7451433182199, -122.413919527559)
30360 223252 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 223 Buena Vista Ave East 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6001379.7968 2108143.42128 37.7686376435263 -122.438537815694 (37.7686376435263, -122.438537815694)
30571 206774 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 333 Ulloa St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 3ft   5995753.2455 2098512.7905 37.7418727024551 -122.45730268546998 (37.7418727024551, -122.45730268547)
30782 223240 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 64 Collingwood St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6001986.3293 2105505.11191 37.761427975634795 -122.436251036652 (37.7614279756348, -122.436251036652)
31412 206726 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 127 Lawton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   5993852.03575 2104584.23438 37.7584339607877 -122.464317096167 (37.7584339607877, -122.464317096167)
31554 223247 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 223 Buena Vista Ave East 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6001313.05295 2108032.14287 37.7683283037239 -122.43876070183799 (37.7683283037239, -122.438760701838)
32000 206745 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 201 Judson Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 3ft   5998694.48733 2093469.3475099998 37.7281930968236 -122.446770058609 (37.7281930968236, -122.446770058609)
32117 223134 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 58 Alvarado St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6005929.6240300005 2102889.79812 37.754470191658 -122.42242696485 (37.754470191658, -122.42242696485)
32124 223251 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 223 Buena Vista Ave East 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6001365.4819 2108117.26701 37.7685650160862 -122.438585455453 (37.7685650160862, -122.438585455453)
32589 223243 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 166 Alpine Ter 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6001694.0873300005 2107829.29676 37.7677930083548 -122.43742821504 (37.7677930083548, -122.43742821504)
32745 190945 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 40 Bluxome St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   6013445.03636 2110888.0497 37.7768527094247 -122.396997287698 (37.7768527094247, -122.396997287698)
33210 78274 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 1715 Yosemite Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/15/2000 12:00:00 AM 8     6013961.9126699995 2093099.05364 37.728036691237705 -122.393963673903 (37.7280366912377, -122.393963673903)
33817 206719 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 1624 11th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   5992799.45091 2104376.41203 37.757802607033 -122.467942255237 (37.757802607033, -122.467942255237)
33852 223090 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 1261 Hampshire St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6010331.77576 2101864.8151700003 37.7519031650082 -122.40713085929801 (37.7519031650082, -122.407130859298)
34121 223130 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 2859 22nd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6009046.46902 2103310.42171 37.7558004625361 -122.411677780329 (37.7558004625361, -122.411677780329)
34191 223197 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 810 Capp St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6007331.17621 2102503.10004 37.7534873711569 -122.417552615065 (37.7534873711569, -122.417552615065)
34584 223162 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 735 Banks St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6008468.3229 2095367.5887799999 37.7339587547775 -122.413115589431 (37.7339587547775, -122.413115589431)
34921 41958 Permitted Site 1 Crataegus phaenopyrum :: Washington Hawthorn 135 3520 Fulton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/20/2000 12:00:00 AM 4   Permit Number 42314 5992457.73238 2110034.76352 37.773319199454995 -122.469535942454 (37.773319199455, -122.469535942454)
34931 223085 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 1383 York St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6010105.406830001 2101175.2990599996 37.749997235391895 -122.407865061343 (37.7499972353919, -122.407865061343)
35500 73766 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 3834 Sacramento St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/13/1996 12:00:00 AM 5     5996504.18251 2114976.06965 37.787119748535794 -122.45589607746 (37.7871197485358, -122.45589607746)
35724 223119 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 136 Newman St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6007270.88561 2096752.20058 37.7376932993062 -122.41735359689699 (37.7376932993062, -122.417353596897)
36092 223108 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 3704 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6008436.99326 2097599.41483 37.7400851038481 -122.41338168713999 (37.7400851038481, -122.41338168714)
36848 223257 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 187 States St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6001119.248980001 2106275.06053 37.76349276240129 -122.43930509025499 (37.7634927624013, -122.439305090255)
37720 223075 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 585 York St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6009845.48817 2105596.5830900003 37.7621225355506 -122.409075808698 (37.7621225355506, -122.409075808698)
37746 52285 Permitted Site 1 Crataegus phaenopyrum :: Washington Hawthorn 135 49 Valley St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/29/2005 12:00:00 AM     Permit Number 48443 6005568.13669376 2099312.5052799 37.744627369144204 -122.423422786255 (37.7446273691442, -122.423422786255)
37754 38011 Permitted Site 1 Crataegus phaenopyrum :: Washington Hawthorn 135 2537 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/08/1998 12:00:00 AM     Permit Number 40222 5991707.38932153 2098162.62971781 37.7406780464622 -122.47126629995199 (37.7406780464622, -122.471266299952)
37848 223192 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 13 Stoneman St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   6008381.698469999 2099413.06751 37.745061889109394 -122.413701124524 (37.7450618891094, -122.413701124524)
38304 223262 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 214 Steiner St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6003313.48049 2109165.67905 37.7715543194136 -122.431922366729 (37.7715543194136, -122.431922366729)
39040 206755 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 2249 17th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5991006.69103 2100092.27446 37.7459357971944 -122.473829763244 (37.7459357971944, -122.473829763244)
39258 206751 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 770 Lakeview Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5994332.77202 2089945.7388 37.7182679844691 -122.46159320346399 (37.7182679844691, -122.461593203464)
39427 223155 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 43 Conrad St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6001836.39965 2096899.0019200002 37.7377891238618 -122.436153694935 (37.7377891238618, -122.436153694935)
39550 206763 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 1550 Plymouth Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5995815.46326 2094322.90602 37.7303718753392 -122.456784599525 (37.7303718753392, -122.456784599525)
39760 223120 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 144 Ellert St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6007356.10175 2096969.11843 37.7382937019981 -122.417074328634 (37.7382937019981, -122.417074328634)
39962 223170 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 44 Powers Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6006977.3899300005 2099699.22842 37.7457686626942 -122.418577273841 (37.7457686626942, -122.418577273841)
40039 223146 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 1543 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6003344.3364699995 2099293.67104 37.744449890566294 -122.43111090036301 (37.7444498905663, -122.431110900363)
40180 223112 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 299 Nevada St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   6008984.458269999 2096955.3258900002 37.7383472988825 -122.41144327759599 (37.7383472988825, -122.411443277596)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 413.473ms · Data source: data.sfgov.org