trees
493 rows where qSpecies_id = 133 sorted by SiteOrder descending
This data as json, CSV (advanced)
These facets timed out: PlotSize
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6774 | 249677 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2400 Baker St | 9 | Front Yard : Yard | Tree | Private 2 | 9 | 5999741.70445 | 2117184.69909 | 37.7933693451834 | -122.444853823654 | (37.7933693451834, -122.444853823654) | 13 | 9 | 1 | 57 | 27 | ||||
101700 | 247588 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 800 Tompkins Ave | 9 | Front Yard : Yard | Tree | Private 2 | 6 | 6008943.01163 | 2096440.06729 | 37.7369301858647 | -122.411550186315 | (37.7369301858647, -122.411550186315) | 10 | 7 | 7 | 28859 | 2 | ||||
133368 | 247587 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 800 Tompkins Ave | 8 | Front Yard : Yard | Tree | Private 2 | 6 | 6008949.04431 | 2096428.80776 | 37.7368996080238 | -122.411528533315 | (37.7368996080238, -122.411528533315) | 10 | 7 | 7 | 28859 | 2 | ||||
70530 | 206606 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 160 Magellan Ave | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5995035.92285 | 2100721.97488 | 37.747897345392 | -122.459942934033 | (37.747897345392, -122.459942934033) | 1 | 8 | 4 | 29491 | 40 | |||
78140 | 53145 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1498@ KEITH Underwood Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/2006 12:00:00 AM | Permit Number 49074 | 6015150.01654287 | 2093336.52012549 | 37.7287546860169 | -122.389872907792 | (37.7287546860169, -122.389872907792) | 10 | 3 | 8 | 58 | 1 | ||
155534 | 206514 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1023 Lawton St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5991006.3222 | 2104484.4348 | 37.7579954981234 | -122.474151458838 | (37.7579954981234, -122.474151458838) | 1 | 8 | 4 | 56 | 12 | |||
160622 | 206650 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 180 Castenada Ave | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5994518.14401 | 2100922.4103 | 37.748417898169 | -122.461747907542 | (37.748417898169, -122.461747907542) | 1 | 8 | 4 | 29491 | 40 | |||
8606 | 190946 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 40 Bluxome St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6013405.51497 | 2110852.0091 | 37.7767515500726 | -122.397131477343 | (37.7767515500726, -122.397131477343) | 6 | 2 | 9 | 28856 | 34 | |||
96906 | 206702 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 5998869.22619 | 2095565.73707 | 37.7339592701108 | -122.446316727449 | (37.7339592701108, -122.446316727449) | 9 | 7 | 4 | 59 | 40 | |||
117905 | 206513 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1023 Lawton St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5990992.34085 | 2104483.78156 | 37.757992894562 | -122.47419976413 | (37.757992894562, -122.47419976413) | 1 | 8 | 4 | 56 | 12 | |||
126897 | 45118 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 201 Buena Vista Ave East | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2001 12:00:00 AM | Permit Number 43980 | 6001449.9 | 2108254.9 | 37.7689477239633 | -122.438303322299 | (37.7689477239633, -122.438303322299) | 15 | 5 | 5 | 29492 | 3 | |||
131143 | 199671 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1903 Keith St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6015210.0019 | 2093419.3228 | 37.7289853719934 | -122.389671313679 | (37.7289853719934, -122.389671313679) | 10 | 3 | 8 | 58 | 1 | |||
160913 | 206649 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 180 Castenada Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5994518.46873 | 2100904.00828 | 37.7483673895631 | -122.461745450587 | (37.7483673895631, -122.461745450587) | 1 | 8 | 4 | 29491 | 40 | |||
164367 | 206605 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 160 Magellan Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5995038.86988 | 2100730.57279 | 37.7479211225827 | -122.459933366148 | (37.7479211225827, -122.459933366148) | 1 | 8 | 4 | 29491 | 40 | |||
28527 | 206648 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 180 Castenada Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5994513.85188 | 2100887.12446 | 37.748320765087 | -122.461760191398 | (37.748320765087, -122.461760191398) | 1 | 8 | 4 | 29491 | 40 | |||
40425 | 115540 | Planning Code 138.1 required 2 | Crataegus laevigata :: English Hawthorn 133 | 99X Lech Walesa St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | 3x5 | Permit Number 770842 | 6007116.50228 | 2111387.72892 | 37.7778703965252 | -122.418925098047 | (37.7778703965252, -122.418925098047) | 7 | 9 | 9 | 28852 | 36 | |
84636 | 82952 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 660X Clementina St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2005 12:00:00 AM | 3 | 3x3 | 6009636 | 2110586 | 37.7758105844997 | -122.410152621086 | (37.7758105844997, -122.410152621086) | 8 | 2 | 9 | 28853 | 34 | |
94644 | 45119 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 201 Buena Vista Ave East | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2001 12:00:00 AM | Permit Number 43980 | 6001449.9 | 2108254.9 | 37.7689477239633 | -122.438303322299 | (37.7689477239633, -122.438303322299) | 15 | 5 | 5 | 29492 | 3 | |||
108186 | 206701 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5998876.80466 | 2095558.49789 | 37.7339398258586 | -122.446290005877 | (37.7339398258586, -122.446290005877) | 9 | 7 | 4 | 59 | 40 | |||
114669 | 206502 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 245 Lawton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5993453.26762 | 2104570.92091 | 37.7583744121607 | -122.465695235269 | (37.7583744121607, -122.465695235269) | 1 | 8 | 4 | 56 | 12 | |||
129133 | 206670 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 15 Sotelo Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994011.71818 | 2100897.82655 | 37.7483212318599 | -122.463497320046 | (37.7483212318599, -122.463497320046) | 1 | 8 | 4 | 29491 | 40 | |||
130434 | 206512 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1023 Lawton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5990980.22345 | 2104481.19226 | 37.7579850830548 | -122.474241481884 | (37.7579850830548, -122.474241481884) | 1 | 8 | 4 | 56 | 12 | |||
137546 | 206604 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 160 Magellan Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5995043.01031 | 2100739.53906 | 37.747945979831 | -122.45991969824 | (37.747945979831, -122.45991969824) | 1 | 8 | 4 | 29491 | 40 | |||
159238 | 206571 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 51 Cortes Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5993219.18082 | 2099666.63445 | 37.7448949964991 | -122.466148413523 | (37.7448949964991, -122.466148413523) | 1 | 8 | 4 | 29491 | 40 | |||
162377 | 121664 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5998939 | 2095554 | 37.7339310276146 | -122.446074655004 | (37.7339310276146, -122.446074655004) | 9 | 7 | 4 | 59 | 40 | ||||
167985 | 206518 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1019 Lawton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5991072.98938 | 2104484.60902 | 37.7579998382313 | -122.473920910448 | (37.7579998382313, -122.473920910448) | 1 | 8 | 4 | 56 | 12 | |||
194061 | 206612 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 49 Sola Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 5994889.66342 | 2100721.49656 | 37.7478876192364 | -122.460448654307 | (37.7478876192364, -122.460448654307) | 1 | 8 | 4 | 29491 | 40 | |||
19807 | 200076 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1500 Van Dyke Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6014887.9102 | 2093187.7857 | 37.7283317520978 | -122.390768643797 | (37.7283317520978, -122.390768643797) | 10 | 3 | 8 | 58 | 1 | |||
28142 | 121663 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5998939 | 2095554 | 37.7339310276146 | -122.446074655004 | (37.7339310276146, -122.446074655004) | 9 | 7 | 4 | 59 | 40 | ||||
32357 | 126382 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1001 Vallejo St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 4ft | 6008670.39988 | 2118624.74661 | 37.7978288673746 | -122.414061717575 | (37.7978288673746, -122.414061717575) | 5 | 1 | 10 | 308 | 21 | |||
34205 | 45120 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 201 Buena Vista Ave East | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2001 12:00:00 AM | Permit Number 43980 | 6001449.9 | 2108254.9 | 37.7689477239633 | -122.438303322299 | (37.7689477239633, -122.438303322299) | 15 | 5 | 5 | 29492 | 3 | |||
44899 | 51539 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 4138 20th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/18/2005 12:00:00 AM | Permit Number 47837 | 6002788.00139397 | 2104180.95255656 | 37.7578376687282 | -122.433383762609 | (37.7578376687282, -122.433383762609) | 2 | 4 | 5 | 28862 | 3 | ||
45592 | 206647 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 180 Castenada Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5994503.49405 | 2100867.53113 | 37.748266370491 | -122.461794587759 | (37.748266370491, -122.461794587759) | 1 | 8 | 4 | 29491 | 40 | |||
48224 | 206660 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 41 Alton Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994227.71262 | 2101539.78712 | 37.7500963352778 | -122.462796987411 | (37.7500963352778, -122.462796987411) | 1 | 8 | 4 | 29491 | 40 | |||
52704 | 94078 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 629 Los Palmos Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2010 12:00:00 AM | 2x4 | Permit Number 53465 | 5996116 | 2095941 | 37.734832022473 | -122.455862534884 | (37.734832022473, -122.455862534884) | 9 | 7 | 4 | 59 | 40 | ||
52801 | 206552 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 308 Pacheco St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 5994313.1172 | 2100803.87721 | 37.7480806317257 | -122.462448284279 | (37.7480806317257, -122.462448284279) | 1 | 8 | 4 | 29491 | 40 | |||
55106 | 102412 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 55X Lyon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000310.8 | 2109142 | 37.7713186232103 | -122.442307075209 | (37.7713186232103, -122.442307075209) | 15 | 5 | 11 | 29492 | 9 | |||||
63353 | 206511 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1023 Lawton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5990966.24876 | 2104480.85465 | 37.7579833464788 | -122.474289787164 | (37.7579833464788, -122.474289787164) | 1 | 8 | 4 | 56 | 12 | |||
72234 | 43002 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 205X Rose St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | Permit Number 42873 | 6005609.30796774 | 2109736.9244771 | 37.7732527046739 | -122.424021592666 | (37.7732527046739, -122.424021592666) | 7 | 9 | 11 | 28852 | 10 | |||
73036 | 206517 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1019 Lawton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5991060.29058 | 2104484.56084 | 37.7579989703891 | -122.473964824336 | (37.7579989703891, -122.473964824336) | 1 | 8 | 4 | 56 | 12 | |||
74334 | 244873 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 49 Lyon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6000342.3248 | 2109115.5777 | 37.7712478709156 | -122.442196132801 | (37.7712478709156, -122.442196132801) | 15 | 5 | 11 | 29492 | 9 | |||
75364 | 115539 | Planning Code 138.1 required 2 | Crataegus laevigata :: English Hawthorn 133 | 99X Lech Walesa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | 3x10 | Permit Number 770842 | 6007116.50228 | 2111387.72892 | 37.7778703965252 | -122.418925098047 | (37.7778703965252, -122.418925098047) | 7 | 9 | 9 | 28852 | 36 | |
95037 | 206600 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 150 Magellan Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5995054.43703 | 2100813.29817 | 37.7481491609747 | -122.459885527604 | (37.7481491609747, -122.459885527604) | 1 | 8 | 4 | 29491 | 40 | |||
111783 | 206669 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 15 Sotelo Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994007.62455 | 2100906.4247 | 37.7483446043367 | -122.463512099503 | (37.7483446043367, -122.463512099503) | 1 | 8 | 4 | 29491 | 40 | |||
112891 | 82953 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 660X Clementina St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2005 12:00:00 AM | 3 | 3x3 | 6009636 | 2110586 | 37.7758105844997 | -122.410152621086 | (37.7758105844997, -122.410152621086) | 8 | 2 | 9 | 28853 | 34 | |
114209 | 206572 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 51 Cortes Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5993215.16949 | 2099646.04946 | 37.7448382439064 | -122.466160788211 | (37.7448382439064, -122.466160788211) | 1 | 8 | 4 | 29491 | 40 | |||
114457 | 206501 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 245 Lawton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5993462.44278 | 2104571.82213 | 37.7583774159051 | -122.465663569242 | (37.7583774159051, -122.465663569242) | 1 | 8 | 4 | 56 | 12 | |||
127586 | 206603 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 160 Magellan Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5995045.25769 | 2100752.48094 | 37.7479816442318 | -122.459912864313 | (37.7479816442318, -122.459912864313) | 1 | 8 | 4 | 29491 | 40 | |||
156321 | 206611 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 49 Sola Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5994869.30829 | 2100730.97603 | 37.7479124764813 | -122.460519727717 | (37.7479124764813, -122.460519727717) | 1 | 8 | 4 | 29491 | 40 | |||
165991 | 206681 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 657 Los Palmos Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995960.60425 | 2096012.63655 | 37.735019799206 | -122.456404966934 | (37.735019799206, -122.456404966934) | 9 | 7 | 4 | 59 | 40 | |||
180598 | 206700 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5998900.28229 | 2095547.61505 | 37.7339112849776 | -122.446208054284 | (37.7339112849776, -122.446208054284) | 9 | 7 | 4 | 59 | 40 | |||
1063 | 32734 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 808 Capitol Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37117 | 5995081.95862964 | 2089664.82981262 | 37.7175397705127 | -122.458983271916 | (37.7175397705127, -122.458983271916) | 9 | 8 | 6 | 28861 | 24 | ||
19680 | 206561 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 355 Yerba Buena Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5995302.34368 | 2095238.16689 | 37.732855482695 | -122.458624745542 | (37.732855482695, -122.458624745542) | 9 | 7 | 4 | 59 | 40 | |||
22339 | 206516 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1019 Lawton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5991047.26108 | 2104483.88717 | 37.7579963659448 | -122.474009836278 | (37.7579963659448, -122.474009836278) | 1 | 8 | 4 | 56 | 12 | |||
27348 | 206661 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 390 Pacheco St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994161.93741 | 2101486.33597 | 37.7499457833913 | -122.463020562465 | (37.7499457833913, -122.463020562465) | 1 | 8 | 4 | 29491 | 40 | |||
32203 | 206500 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 245 Lawton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5993474.54652 | 2104572.66216 | 37.7583804205467 | -122.465621770525 | (37.7583804205467, -122.465621770525) | 1 | 8 | 4 | 56 | 12 | |||
35026 | 206591 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 101 Montalvo Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5993709.62503 | 2099698.37793 | 37.7450104397813 | -122.464454865994 | (37.7450104397813, -122.464454865994) | 1 | 8 | 4 | 29491 | 40 | |||
37635 | 206573 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 51 Cortes Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993216.90415 | 2099626.41246 | 37.7447844257663 | -122.466153363383 | (37.7447844257663, -122.466153363383) | 1 | 8 | 4 | 29491 | 40 | |||
40920 | 206659 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 41 Alton Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5994198.61036 | 2101541.1054 | 37.750098278721 | -122.462897719553 | (37.750098278721, -122.462897719553) | 1 | 8 | 4 | 29491 | 40 | |||
42334 | 206608 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2 Sola Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5994960.81371 | 2100721.5804 | 37.7478919422595 | -122.460202627649 | (37.7478919422595, -122.460202627649) | 1 | 8 | 4 | 29491 | 40 | |||
43073 | 206510 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1023 Lawton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5990951.63934 | 2104480.53076 | 37.7579816107816 | -122.474340288587 | (37.7579816107816, -122.474340288587) | 1 | 8 | 4 | 56 | 12 | |||
47801 | 206671 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 370 Yerba Buena Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5995266.43425 | 2095204.88442 | 37.732762033223 | -122.458746484089 | (37.732762033223, -122.458746484089) | 9 | 7 | 4 | 59 | 40 | |||
48275 | 41698 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1 Mizpah St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42148 | 6001073.51924875 | 2096662.39464483 | 37.7370960833617 | -122.43877438618 | (37.7370960833617, -122.43877438618) | 2 | 7 | 5 | 63 | 7 | ||
49032 | 206680 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 657 Los Palmos Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995948.68471 | 2096013.62894 | 37.7350218397753 | -122.456446248507 | (37.7350218397753, -122.456446248507) | 9 | 7 | 4 | 59 | 40 | |||
52088 | 126383 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1116 Greenwich St | 3 | Front Yard : Yard | Tree | Private 2 | 4 | 6007504.98606 | 2119897.57415 | 37.801258207159 | -122.418184672095 | (37.801258207159, -122.418184672095) | 5 | 1 | 1 | 28858 | 32 | ||||
57243 | 206633 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 145 Castenada Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994552.30711 | 2100925.23177 | 37.7484276117632 | -122.461629977659 | (37.7484276117632, -122.461629977659) | 1 | 8 | 4 | 29491 | 40 | |||
70998 | 206529 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 13 Madrone Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992989.73242 | 2099015.25675 | 37.7430932380525 | -122.466894452432 | (37.7430932380525, -122.466894452432) | 1 | 8 | 4 | 59 | 40 | |||
71121 | 206526 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 35 Madrone Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5992953.91132 | 2098913.47299 | 37.7428116981042 | -122.467010912843 | (37.7428116981042, -122.467010912843) | 1 | 8 | 4 | 59 | 40 | |||
72984 | 206596 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 135 Magellan Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5995085.45283 | 2100859.88169 | 37.7482788513041 | -122.459781650511 | (37.7482788513041, -122.459781650511) | 1 | 8 | 4 | 29491 | 40 | |||
77345 | 206554 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 47 Sotelo Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5993895.61602 | 2101166.11299 | 37.7490511881613 | -122.463918266634 | (37.7490511881613, -122.463918266634) | 1 | 8 | 4 | 29491 | 40 | |||
81352 | 206602 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 160 Magellan Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5995047.85902 | 2100763.4476 | 37.7480119055303 | -122.459904663381 | (37.7480119055303, -122.459904663381) | 1 | 8 | 4 | 29491 | 40 | |||
83405 | 206668 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 15 Sotelo Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993998.36893 | 2100916.34697 | 37.7483713150869 | -122.463544824955 | (37.7483713150869, -122.463544824955) | 1 | 8 | 4 | 29491 | 40 | |||
85017 | 51537 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 4138 20th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/18/2005 12:00:00 AM | Permit Number 47837 | 6002788.00139397 | 2104180.95255656 | 37.7578376687282 | -122.433383762609 | (37.7578376687282, -122.433383762609) | 2 | 4 | 5 | 28862 | 3 | ||
86826 | 121662 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5998939 | 2095554 | 37.7339310276146 | -122.446074655004 | (37.7339310276146, -122.446074655004) | 9 | 7 | 4 | 59 | 40 | ||||
90233 | 108929 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 12x MacOndray Ln | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6008556.45633 | 2119171.57464 | 37.7993239210113 | -122.414494709684 | (37.7993239210113, -122.414494709684) | 5 | 1 | 10 | 308 | 32 | |||
101316 | 94077 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 629 Los Palmos Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2010 12:00:00 AM | 2x4 | Permit Number 53465 | 5996116 | 2095941 | 37.734832022473 | -122.455862534884 | (37.734832022473, -122.455862534884) | 9 | 7 | 4 | 59 | 40 | ||
103424 | 206620 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2105 09th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5993657.15968 | 2101227.85905 | 37.7492069822304 | -122.464747327347 | (37.7492069822304, -122.464747327347) | 1 | 8 | 4 | 29491 | 40 | |||
106812 | 206577 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 215 Dorantes Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5993636.26419 | 2099712.16168 | 37.7450440573323 | -122.464709533316 | (37.7450440573323, -122.464709533316) | 1 | 8 | 4 | 29491 | 40 | |||
109919 | 206599 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 150 Magellan Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 5995053.98462 | 2100829.4455 | 37.7481934714657 | -122.459888261529 | (37.7481934714657, -122.459888261529) | 1 | 8 | 4 | 29491 | 40 | |||
114722 | 218122 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 45 Lopez Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5994032.10421 | 2100668.86964 | 37.7476937487685 | -122.463410213512 | (37.7476937487685, -122.463410213512) | 1 | 8 | 4 | 29491 | 40 | |||
122610 | 176075 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 100 Capistrano Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6001444.80034 | 2093622.381 | 37.7287700227166 | -122.4372730928 | (37.7287700227166, -122.4372730928) | 9 | 7 | 6 | 28861 | 25 | |||
123072 | 206530 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 175 Garcia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5994631.6545 | 2099433.40276 | 37.7443359914089 | -122.461247472601 | (37.7443359914089, -122.461247472601) | 1 | 8 | 4 | 59 | 40 | |||
123636 | 182596 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 945 Rivera St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 0ft | 5990197.9307 | 2100380.5725 | 37.7466805119975 | -122.47664737489 | (37.7466805119975, -122.47664737489) | 1 | 8 | 3 | 29491 | 35 | |||
128619 | 206610 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 49 Sola Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5994851.29052 | 2100738.8321 | 37.7479330107067 | -122.46058260112 | (37.7479330107067, -122.46058260112) | 1 | 8 | 4 | 29491 | 40 | |||
132029 | 121560 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 400X Alvarado St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6003675 | 2102779 | 37.7540385213778 | -122.430216135756 | (37.7540385213778, -122.430216135756) | 2 | 4 | 5 | 28862 | 22 | |||
133547 | 206684 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 647 Los Palmos Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5996011.49185 | 2096001.54035 | 37.7349922529962 | -122.456228229446 | (37.7349922529962, -122.456228229446) | 9 | 7 | 4 | 59 | 40 | |||
136667 | 206535 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 665 Miramar Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5995362.41808 | 2093767.65006 | 37.7288212525964 | -122.458310655534 | (37.7288212525964, -122.458310655534) | 9 | 7 | 4 | 28861 | 40 | |||
137361 | 206699 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5998907.63682 | 2095545.72944 | 37.7339065275492 | -122.446182491946 | (37.7339065275492, -122.446182491946) | 9 | 7 | 4 | 59 | 40 | |||
140979 | 206548 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 160 Dorantes Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5993741.10567 | 2099827.07051 | 37.7453656117262 | -122.464355354239 | (37.7453656117262, -122.464355354239) | 1 | 8 | 4 | 29491 | 40 | |||
144577 | 206643 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 196 Castenada Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994392.21173 | 2100761.61427 | 37.7479691427812 | -122.462171715751 | (37.7479691427812, -122.462171715751) | 1 | 8 | 4 | 29491 | 40 | |||
155431 | 206656 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 45 Alton Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994277.82387 | 2101540.85875 | 37.7501021637853 | -122.46262377888 | (37.7501021637853, -122.46262377888) | 1 | 8 | 4 | 29491 | 40 | |||
164255 | 126380 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1136 Havens St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 7ft | 6007510.81799 | 2119357.46903 | 37.7997755425663 | -122.418126178374 | (37.7997755425663, -122.418126178374) | 5 | 1 | 1 | 28858 | 32 | |||
164265 | 115538 | Planning Code 138.1 required 2 | Crataegus laevigata :: English Hawthorn 133 | 99X Lech Walesa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | 3x10 | Permit Number 770842 | 6007116.50228 | 2111387.72892 | 37.7778703965252 | -122.418925098047 | (37.7778703965252, -122.418925098047) | 7 | 9 | 9 | 28852 | 36 | |
167164 | 82954 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 660X Clementina St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2005 12:00:00 AM | 3 | 3x3 | 6009636 | 2110586 | 37.7758105844997 | -122.410152621086 | (37.7758105844997, -122.410152621086) | 8 | 2 | 9 | 28853 | 34 | |
170391 | 200075 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1500 Van Dyke Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6014900.2728 | 2093175.985 | 37.7283000356482 | -122.390725081061 | (37.7283000356482, -122.390725081061) | 10 | 3 | 8 | 58 | 1 | |||
172217 | 45117 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 201 Buena Vista Ave East | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2001 12:00:00 AM | Permit Number 43980 | 6001449.9 | 2108254.9 | 37.7689477239633 | -122.438303322299 | (37.7689477239633, -122.438303322299) | 15 | 5 | 5 | 29492 | 3 | |||
176132 | 206578 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 275 Dorantes Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993312.03833 | 2099686.0969 | 37.7449537923783 | -122.465828745912 | (37.7449537923783, -122.465828745912) | 1 | 8 | 4 | 29491 | 40 | |||
178097 | 206551 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 308 Pacheco St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5994320.14066 | 2100781.15308 | 37.7480186414603 | -122.462422349606 | (37.7480186414603, -122.462422349606) | 1 | 8 | 4 | 29491 | 40 | |||
181962 | 206688 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 629 Los Palmos Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5996101.05251 | 2095948.39142 | 37.7348514596286 | -122.455914747394 | (37.7348514596286, -122.455914747394) | 9 | 7 | 4 | 59 | 40 | |||
192879 | 206646 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 180 Castenada Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994489.71886 | 2100854.37735 | 37.7482294605322 | -122.461841267977 | (37.7482294605322, -122.461841267977) | 1 | 8 | 4 | 29491 | 40 |
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) );