trees
713 rows where qSpecies_id = 102 sorted by rowid descending
This data as json, CSV (advanced)
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
165358 | 223121 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 144 Ellert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6007371.50251 | 2096967.99456 | 37.7382914824521 | -122.417021000638 | (37.7382914824521, -122.417021000638) | 2 | 7 | 7 | 28859 | 2 | |||
165086 | 206780 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 527 Congo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6000096.27478 | 2095389.45869 | 37.7335452545959 | -122.442061808207 | (37.7335452545959, -122.442061808207) | 9 | 7 | 4 | 63 | 40 | |||
165081 | 223133 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2647 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008939.97503 | 2103025.29331 | 37.7550115898188 | -122.412025923166 | (37.7550115898188, -122.412025923166) | 2 | 4 | 7 | 28859 | 19 | |||
164119 | 223083 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1444 York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 6ft | 6010087.8553 | 2100823.29254 | 37.7490297204664 | -122.407900936194 | (37.7490297204664, -122.407900936194) | 2 | 4 | 7 | 28859 | 19 | |||
163741 | 223071 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2637 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6010290.16731 | 2103379.94771 | 37.7560610536772 | -122.407381551617 | (37.7560610536772, -122.407381551617) | 10 | 4 | 7 | 28859 | 19 | |||
163636 | 126395 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3024 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6000079.15965 | 2116130.17302 | 37.7904931459848 | -122.443610419206 | (37.7904931459848, -122.443610419206) | 13 | 6 | 1 | 29490 | 27 | |||
163619 | 42904 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3267 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42817 | 6007744.73028146 | 2104990.07889872 | 37.7603393072133 | -122.416298586055 | (37.7603393072133, -122.416298586055) | 2 | 4 | 7 | 28859 | 19 | ||
163598 | 206725 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1758 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5993757.65716 | 2103519.81492 | 37.7555058994863 | -122.464566208375 | (37.7555058994863, -122.464566208375) | 1 | 8 | 4 | 56 | 12 | |||
163386 | 223160 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 205 Ellsworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008106.57773 | 2097614.35525 | 37.7401075697958 | -122.414525189493 | (37.7401075697958, -122.414525189493) | 2 | 7 | 7 | 28859 | 2 | |||
163209 | 206723 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1754 08th Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | Width 2ft | 5993756.65127 | 2103543.92939 | 37.7555720536195 | -122.464571437933 | (37.7555720536195, -122.464571437933) | 1 | 8 | 4 | 56 | 12 | |||
163177 | 37430 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1229 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39904 | 6003244.98413008 | 2101088.21150407 | 37.7493716492712 | -122.431582531662 | (37.7493716492712, -122.431582531662) | 2 | 4 | 5 | 28862 | 22 | ||
163052 | 223140 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 512 Clipper St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6001850.84653 | 2100907.94099 | 37.7487975505677 | -122.436390583577 | (37.7487975505677, -122.436390583577) | 2 | 4 | 5 | 28862 | 22 | |||
163032 | 206737 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2110 09th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5993674.35078 | 2101279.72748 | 37.7493503908303 | -122.46469164671 | (37.7493503908303, -122.46469164671) | 1 | 8 | 4 | 29491 | 40 | |||
162960 | 250813 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 70 Sea View Ter | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5986113.64494 | 2114167.67929 | 37.7842983162539 | -122.491785020157 | (37.7842983162539, -122.491785020157) | 11 | 6 | 1 | 55 | 33 | |||
162872 | 254858 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 309 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/29/2018 12:00:00 AM | 3 | 3x3 | 6000181 | 2110050 | 37.7738043631957 | -122.442821270125 | (37.7738043631957, -122.442821270125) | 15 | 5 | 11 | 29492 | 16 | |
162372 | 37809 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 945 Woolsey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/06/1998 12:00:00 AM | 6 | Permit Number 40129 | 6008935.03699 | 2091336.11474 | 37.7229153750213 | -122.411217322939 | (37.7229153750213, -122.411217322939) | 9 | 3 | 7 | 309 | 28 | |
162293 | 84596 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 660-668 Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/18/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50124 | 6009623.56460334 | 2110595.7986646 | 37.7758367923088 | -122.410196330421 | (37.7758367923088, -122.410196330421) | 8 | 2 | 9 | 28853 | 34 |
162118 | 223257 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 187 States St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001119.24898 | 2106275.06053 | 37.7634927624013 | -122.439305090255 | (37.7634927624013, -122.439305090255) | 15 | 5 | 5 | 28862 | 3 | |||
161068 | 37429 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1229 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39904 | 6003244.98413008 | 2101088.21150407 | 37.7493716492712 | -122.431582531662 | (37.7493716492712, -122.431582531662) | 2 | 4 | 5 | 28862 | 22 | ||
161012 | 37899 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1525 Plymouth Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | Permit Number 40169 | 5995814.03079033 | 2094240.32165612 | 37.7301450363484 | -122.45678358123 | (37.7301450363484, -122.45678358123) | 9 | 7 | 4 | 28861 | 40 | ||
160819 | 223152 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 355 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6001098.68707 | 2096660.99426 | 37.7370936700316 | -122.438687269517 | (37.7370936700316, -122.438687269517) | 2 | 7 | 5 | 63 | 7 | |||
160543 | 30863 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 265 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/1995 12:00:00 AM | 8 | Permit Number 34702 | 6003432.86004 | 2100952.83028 | 37.7490105711958 | -122.430923192045 | (37.7490105711958, -122.430923192045) | 2 | 4 | 5 | 28862 | 22 | ||
160399 | 24555 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 410 Cortland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3X3 | 6007239.9582761 | 2097260.4210516 | 37.7390870202574 | -122.417496536021 | (37.7390870202574, -122.417496536021) | 2 | 7 | 7 | 28859 | 2 | |||
160389 | 223247 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 223 Buena Vista Ave East | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6001313.05295 | 2108032.14287 | 37.7683283037239 | -122.438760701838 | (37.7683283037239, -122.438760701838) | 15 | 5 | 5 | 29492 | 3 | |||
160235 | 126399 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2417 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6001345.88444 | 2117956.79701 | 37.7955807430055 | -122.439358627814 | (37.7955807430055, -122.439358627814) | 13 | 9 | 1 | 57 | 27 | |||
160194 | 38917 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 116 De Soto St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40728 | 5993276.12701887 | 2091907.60614304 | 37.7235939185401 | -122.465387983379 | (37.7235939185401, -122.465387983379) | 9 | 8 | 4 | 59 | 40 | ||
160032 | 103444 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50X Bluxome St | 21 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x2 | 6013250.8 | 2110869.1 | 37.7767898637251 | -122.397667885183 | (37.7767898637251, -122.397667885183) | 6 | 2 | 9 | 28856 | 34 | ||||
159817 | 52303 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 62 Collingwood St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/01/2005 12:00:00 AM | 3x3 | Permit Number 48463 | 6001983.15894282 | 2105499.92791468 | 37.7614135615131 | -122.436261630575 | (37.7614135615131, -122.436261630575) | 15 | 4 | 5 | 28862 | 3 | |
159432 | 206745 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 201 Judson Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5998694.48733 | 2093469.34751 | 37.7281930968236 | -122.446770058609 | (37.7281930968236, -122.446770058609) | 9 | 7 | 4 | 28861 | 40 | |||
159372 | 103433 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50X Bluxome St | 10 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x2 | 6013250.8 | 2110869.1 | 37.7767898637251 | -122.397667885183 | (37.7767898637251, -122.397667885183) | 6 | 2 | 9 | 28856 | 34 | ||||
158216 | 223209 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 939 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002511.22757 | 2102771.05412 | 37.7539507189667 | -122.434240167846 | (37.7539507189667, -122.434240167846) | 2 | 4 | 5 | 28862 | 22 | |||
158047 | 39547 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1945 22nd St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | Permit Number 40973 | 6012286.64815743 | 2103730.55141744 | 37.7571352756248 | -122.400501636831 | (37.7571352756248, -122.400501636831) | 10 | 3 | 8 | 28856 | 29 | ||
157850 | 223248 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 223 Buena Vista Ave East | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001320.7936 | 2108049.6165 | 37.7683767223465 | -122.43873517998 | (37.7683767223465, -122.43873517998) | 15 | 5 | 5 | 29492 | 3 | |||
157506 | 206785 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 639 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5997188.65099 | 2095255.93697 | 37.7330125079079 | -122.452104615736 | (37.7330125079079, -122.452104615736) | 9 | 7 | 4 | 59 | 40 | |||
157237 | 223205 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 928 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001890.89943 | 2101318.95016 | 37.7499283599176 | -122.4362814913 | (37.7499283599176, -122.4362814913) | 2 | 4 | 5 | 28862 | 22 | |||
156951 | 223156 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 266 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5996995.23335 | 2106707.65337 | 37.7644450050552 | -122.453599902314 | (37.7644450050552, -122.453599902314) | 15 | 5 | 11 | 29492 | 12 | |||
156833 | 39736 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3892 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41105 | 6003712.19802155 | 2104818.42047752 | 37.759640392907 | -122.430232983891 | (37.759640392907, -122.430232983891) | 2 | 4 | 5 | 28862 | 3 | ||
156772 | 206736 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 778 Faxon Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 10ft | 5994913.66935 | 2093209.24182 | 37.7272622013836 | -122.459821566928 | (37.7272622013836, -122.459821566928) | 9 | 7 | 4 | 28861 | 40 | |||
156444 | 68112 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 99 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767697 | 6008270.46985677 | 2099447.7930484 | 37.7451509909812 | -122.414088190825 | (37.7451509909812, -122.414088190825) | 2 | 7 | 7 | 28859 | 2 | |
156213 | 38599 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1334 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 1 | Permit Number 40550 | 6016508.9427 | 2093376.549 | 37.7289398652867 | -122.385177756249 | (37.7289398652867, -122.385177756249) | 10 | 3 | 8 | 58 | 1 | |
156002 | 223192 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 13 Stoneman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6008381.69847 | 2099413.06751 | 37.7450618891094 | -122.413701124524 | (37.7450618891094, -122.413701124524) | 2 | 7 | 7 | 28859 | 2 | |||
155745 | 206757 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 125 Montalvo Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5993771.47174 | 2099572.51825 | 37.7446684258232 | -122.464231877296 | (37.7446684258232, -122.464231877296) | 1 | 8 | 4 | 29491 | 40 | |||
155288 | 78634 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 90 Corona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52272 | 5992884.13871167 | 2091762.58426518 | 37.7231731092186 | -122.466732469761 | (37.7231731092186, -122.466732469761) | 9 | 8 | 4 | 59 | 40 | ||
154602 | 206735 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 251 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992283.73753 | 2097815.15281 | 37.7397572847581 | -122.469248240839 | (37.7397572847581, -122.469248240839) | 1 | 8 | 4 | 59 | 40 | |||
154425 | 223144 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 603X Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6002466.57399 | 2102069.11902 | 37.7520208377029 | -122.434344409192 | (37.7520208377029, -122.434344409192) | 2 | 4 | 5 | 28862 | 22 | |||
153975 | 255802 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 151 Urbano Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x3 | 5993243 | 2092509 | 37.7252432887469 | -122.465546165723 | (37.7252432887469, -122.465546165723) | 9 | 8 | 4 | 59 | 40 | ||||
153519 | 223260 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 280 Laussat St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003343.49773 | 2109142.82285 | 37.7714932635271 | -122.431816903254 | (37.7714932635271, -122.431816903254) | 15 | 9 | 11 | 29492 | 10 | |||
153415 | 41932 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 568 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 5 | Permit Number 42291 | 5994718.86088 | 2111682.35233 | 37.7779734598848 | -122.461833934507 | (37.7779734598848, -122.461833934507) | 11 | 6 | 2 | 54 | 11 | |
153009 | 88358 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 245 11th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51336 | 6008270 | 2109444 | 37.7725982617206 | -122.414797136624 | (37.7725982617206, -122.414797136624) | 8 | 2 | 9 | 28853 | 34 | ||
152687 | 223145 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 4428 23rd St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 6000417.49081 | 2102293.12791 | 37.7525193903635 | -122.441446492087 | (37.7525193903635, -122.441446492087) | 2 | 4 | 5 | 28862 | 22 | |||
152576 | 36414 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 665 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39335 | 5995348.52277962 | 2093755.44427738 | 37.7287869399676 | -122.458357809087 | (37.7287869399676, -122.458357809087) | 9 | 7 | 4 | 28861 | 40 | ||
152542 | 223082 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1438 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 6010087.31315 | 2100865.46474 | 37.7491454856861 | -122.407905784439 | (37.7491454856861, -122.407905784439) | 2 | 4 | 7 | 28859 | 19 | |||
152030 | 223202 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 53 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005597.47376 | 2099315.42645 | 37.7446370457794 | -122.423321551968 | (37.7446370457794, -122.423321551968) | 2 | 7 | 5 | 28859 | 22 | |||
151742 | 161277 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 582 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/25/2017 12:23:00 PM | 3 | Width 0ft | 6002834.75222 | 2090259.20529 | 37.7196144116499 | -122.432227854755 | (37.7196144116499, -122.432227854755) | 9 | 7 | 6 | 28861 | 5 | |
151695 | 40700 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 100 Oxford St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/10/1999 12:00:00 AM | Permit Number 41678 | 6006308.40202986 | 2093422.77537775 | 37.7284972327963 | -122.420445112942 | (37.7284972327963, -122.420445112942) | 9 | 7 | 7 | 309 | 5 | ||
151165 | 206747 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 316 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5995834.85726 | 2090578.94523 | 37.7200929670035 | -122.4564469257 | (37.7200929670035, -122.4564469257) | 9 | 8 | 6 | 28861 | 24 | |||
150183 | 87777 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 190 28th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50501 | 6004650.7 | 2099620.4 | 37.7454209537076 | -122.426617023323 | (37.7454209537076, -122.426617023323) | 2 | 7 | 5 | 63 | 22 | |||
149992 | 84591 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2800 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52651 | 6009557.23570783 | 2105031.47254004 | 37.760554718378 | -122.410032871336 | (37.760554718378, -122.410032871336) | 2 | 4 | 7 | 28859 | 19 | ||
149758 | 223091 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1257 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6010331.58374 | 2101901.50724 | 37.7520039025724 | -122.407134109472 | (37.7520039025724, -122.407134109472) | 10 | 4 | 7 | 28859 | 19 | |||
149265 | 223200 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2678 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008882.17295 | 2102957.50661 | 37.7548222195948 | -122.412221029305 | (37.7548222195948, -122.412221029305) | 2 | 4 | 7 | 28859 | 19 | |||
148959 | 108780 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2055 Sunnydale Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | FUF | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773821 | 6006878.58529 | 2087505.45215 | 37.7122816418905 | -122.418054633195 | (37.7122816418905, -122.418054633195) | 9 | 7 | 8 | 309 | 39 |
148631 | 223226 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3704 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003734.03519 | 2102475.93139 | 37.753209709985 | -122.429990360391 | (37.753209709985, -122.429990360391) | 2 | 4 | 5 | 28862 | 22 | |||
148278 | 98833 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 333 Pacheco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5994230.9 | 2100817.4 | 37.748113026994 | -122.462733567037 | (37.748113026994, -122.462733567037) | 1 | 8 | 4 | 29491 | 40 | |||||
147676 | 49042 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 935 Darien Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2003 12:00:00 AM | Permit Number 46217 | 5994602.24270835 | 2094017.7241855 | 37.729464182785 | -122.460956731648 | (37.729464182785, -122.460956731648) | 9 | 8 | 4 | 59 | 40 | ||
147392 | 47288 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 818 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/2002 12:00:00 AM | Permit Number 45230 | 6009079.93491226 | 2104385.57714062 | 37.7587544732757 | -122.411638006303 | (37.7587544732757, -122.411638006303) | 2 | 4 | 7 | 28859 | 19 | ||
147127 | 32848 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 605 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46786 | 6002477.19482321 | 2102065.63734158 | 37.7520118806872 | -122.434307431946 | (37.7520118806872, -122.434307431946) | 2 | 4 | 5 | 28862 | 22 | ||
146083 | 46649 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 126 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/19/2002 12:00:00 AM | 2 | Permit Number 44781 | 5990552.50864 | 2114536.58834 | 37.7855696722643 | -122.476455229383 | (37.7855696722643, -122.476455229383) | 11 | 6 | 2 | 54 | 26 | |
145498 | 46816 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 192 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/2003 12:00:00 AM | Permit Number 44895 | 5994691.45503575 | 2096154.19409478 | 37.7353355395411 | -122.460803091527 | (37.7353355395411, -122.460803091527) | 9 | 8 | 4 | 59 | 40 | ||
145457 | 31814 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 77 Park Hill Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | 4 | Permit Number 43298 | 6001174.33831 | 2107557.42667 | 37.7670169581965 | -122.439206472418 | (37.7670169581965, -122.439206472418) | 15 | 5 | 5 | 29492 | 3 | |
145281 | 39543 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1947 22nd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52628 | 6012246.93603 | 2103730.22749 | 37.7571321714345 | -122.400638954732 | (37.7571321714345, -122.400638954732) | 10 | 3 | 8 | 28856 | 29 | |
143673 | 199806 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1305 Carroll Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6015615.5318 | 2090822.5842 | 37.7218777199193 | -122.388088213537 | (37.7218777199193, -122.388088213537) | 10 | 3 | 8 | 58 | 1 | |||
143588 | 223173 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 26 Ellert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006909.08577 | 2097034.73139 | 37.7384487037558 | -122.418624544905 | (37.7384487037558, -122.418624544905) | 2 | 7 | 7 | 28859 | 2 | |||
143426 | 223179 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 300 Ellert St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006860.60609 | 2097074.04768 | 37.7385539280298 | -122.418794952033 | (37.7385539280298, -122.418794952033) | 2 | 7 | 7 | 28859 | 2 | |||
143360 | 36026 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3300 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39173 | 6008450.89308194 | 2099430.5216028 | 37.745113699604 | -122.413463095186 | (37.745113699604, -122.413463095186) | 2 | 7 | 7 | 28859 | 2 | ||
143081 | 48953 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1155 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/2002 12:00:00 AM | Permit Number 46139 | 6009500.74518539 | 2102451.82232494 | 37.7534684137838 | -122.410046128834 | (37.7534684137838, -122.410046128834) | 2 | 4 | 7 | 28859 | 19 | |||
142981 | 223137 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 115 Highland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6005502.70721 | 2096694.07923 | 37.7374340697101 | -122.423462914599 | (37.7374340697101, -122.423462914599) | 2 | 7 | 7 | 28859 | 2 | |||
142954 | 52302 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 62 Collingwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/01/2005 12:00:00 AM | 3x3 | Permit Number 48463 | 6001983.15894282 | 2105499.92791468 | 37.7614135615131 | -122.436261630575 | (37.7614135615131, -122.436261630575) | 15 | 4 | 5 | 28862 | 3 | |
142530 | 36656 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2820 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1998 12:00:00 AM | Permit Number 39464 | 6008939.95613786 | 2102026.58830635 | 37.7522693693655 | -122.41195541668 | (37.7522693693655, -122.41195541668) | 2 | 4 | 7 | 28859 | 19 | ||
142526 | 26870 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2822 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | 6008934.68396 | 2102005.53061 | 37.7522112538582 | -122.411972160807 | (37.7522112538582, -122.411972160807) | 2 | 4 | 7 | 28859 | 19 | |||
142488 | 223256 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 87 Deming St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5999118.73702 | 2105182.21845 | 37.7603780450418 | -122.446145581955 | (37.7603780450418, -122.446145581955) | 15 | 5 | 5 | 28862 | 3 | |||
142111 | 44792 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 585 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2001 12:00:00 AM | Permit Number 43885 | 6009841.4903569 | 2105563.40623193 | 37.7620312154749 | -122.409087294566 | (37.7620312154749, -122.409087294566) | 8 | 4 | 8 | 28859 | 19 | ||
142088 | 223129 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2859 22nd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009065.38321 | 2103312.46262 | 37.7558071274104 | -122.411612512907 | (37.7558071274104, -122.411612512907) | 2 | 4 | 7 | 28859 | 19 | |||
142016 | 223253 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 12 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6001414.63525 | 2108139.27095 | 37.7686282294424 | -122.438417015146 | (37.7686282294424, -122.438417015146) | 15 | 5 | 5 | 29492 | 3 | |||
141257 | 120050 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 178 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5987440.2158 | 2114793.01422 | 37.7860927508149 | -122.487241556125 | (37.7860927508149, -122.487241556125) | 11 | 6 | 1 | 55 | 33 | |||
141219 | 206748 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 316 Grafton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5995822.77858 | 2090577.54277 | 37.7200884227352 | -122.456488575987 | (37.7200884227352, -122.456488575987) | 9 | 8 | 6 | 28861 | 24 | |||
141147 | 223068 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 21 Bird St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6005913.20621 | 2105707.10819 | 37.762204941322 | -122.422683938016 | (37.762204941322, -122.422683938016) | 8 | 4 | 5 | 28859 | 19 | |||
140985 | 223208 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 912 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003092.37389 | 2102904.024 | 37.7543487903813 | -122.432239923642 | (37.7543487903813, -122.432239923642) | 2 | 4 | 5 | 28862 | 22 | |||
140560 | 223103 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 219 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004980.81211 | 2100162.14097 | 37.7469271073188 | -122.425514095497 | (37.7469271073188, -122.425514095497) | 2 | 7 | 5 | 63 | 22 | |||
140545 | 223158 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 603 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007818.38039 | 2096052.91627 | 37.7358040062425 | -122.415411147601 | (37.7358040062425, -122.415411147601) | 2 | 7 | 7 | 28859 | 2 | |||
140337 | 82182 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 301-311 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2008 12:00:00 AM | 3x3 | Permit Number 50624 | 5994571.67850182 | 2114861.96423825 | 37.786695343884 | -122.462573787528 | (37.786695343884, -122.462573787528) | 11 | 6 | 1 | 54 | 11 | ||
139900 | 36514 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 219 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39392 | 6006979.76664921 | 2097780.88573019 | 37.7405014569239 | -122.418433056711 | (37.7405014569239, -122.418433056711) | 2 | 7 | 7 | 28859 | 2 | ||
139716 | 45576 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3570 Sacramento St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2001 12:00:00 AM | Permit Number 44316 | 5997787.21690008 | 2115155.59999905 | 37.7876862452164 | -122.451470035928 | (37.7876862452164, -122.451470035928) | 11 | 6 | 1 | 54 | 31 | |||
139689 | 40447 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 205 Ellsworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/10/1999 12:00:00 AM | Permit Number 41533 | 6008125.1454753 | 2097661.9456045 | 37.7402392855519 | -122.414464356229 | (37.7402392855519, -122.414464356229) | 2 | 7 | 7 | 28859 | 2 | ||
139525 | 47105 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 124 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | Permit Number 45089 | 6007923.53662616 | 2098042.04046144 | 37.7412716140529 | -122.415188339569 | (37.7412716140529, -122.415188339569) | 2 | 7 | 7 | 28859 | 2 | ||
139297 | 223197 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 810 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007331.17621 | 2102503.10004 | 37.7534873711569 | -122.417552615065 | (37.7534873711569, -122.417552615065) | 2 | 4 | 7 | 28859 | 19 | |||
139163 | 206767 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1525 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995816.07198 | 2094254.87486 | 37.7301851131404 | -122.456777576749 | (37.7301851131404, -122.456777576749) | 9 | 7 | 4 | 28861 | 40 | |||
138883 | 88356 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 245 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51336 | 6008270 | 2109444 | 37.7725982617206 | -122.414797136624 | (37.7725982617206, -122.414797136624) | 8 | 2 | 9 | 28853 | 34 | ||
138721 | 250797 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 286 31st Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5986226.59241 | 2114006.99175 | 37.7838637152673 | -122.491382435973 | (37.7838637152673, -122.491382435973) | 11 | 6 | 1 | 55 | 33 | |||
138411 | 34525 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3704 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39403 | 6008431.51779874 | 2097641.44980503 | 37.7402002152374 | -122.413403591094 | (37.7402002152374, -122.413403591094) | 2 | 7 | 7 | 28859 | 2 | ||
138100 | 126388 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3751 Sacramento St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5996839.89046 | 2114975.9108 | 37.7871385740184 | -122.454734596729 | (37.7871385740184, -122.454734596729) | 11 | 6 | 1 | 54 | 31 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );