Data source: data.sfgov.org
This data as json, CSV (advanced)
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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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) |
JSON shape: default, array, newline-delimited
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");