trees
8,659 rows where qSpecies_id = 11 sorted by qSiteInfo 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 127023 | 251811 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2 Hangah St | 4 | Unaccepted Street : Cutout | Tree | DPW for City Agency 14 | Rec/Park | 3x3 | 6010544 | 2117119 | 37.7937995065594 | -122.407472293877 | (37.7937995065594, -122.407472293877) | 3 | 1 | 10 | 28857 | 4 | |||
| 144228 | 251810 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2 Hangah St | 3 | Unaccepted Street : Cutout | Tree | DPW for City Agency 14 | Rec/Park | 3x3 | 6010544 | 2117119 | 37.7937995065594 | -122.407472293877 | (37.7937995065594, -122.407472293877) | 3 | 1 | 10 | 28857 | 4 | |||
| 168582 | 251809 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2 Hangah St | 2 | Unaccepted Street : Cutout | Tree | DPW for City Agency 14 | Rec/Park | 3x3 | 6010544 | 2117119 | 37.7937995065594 | -122.407472293877 | (37.7937995065594, -122.407472293877) | 3 | 1 | 10 | 28857 | 4 | |||
| 1393 | 255136 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 401X Brotherhood Way | 14 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
| 1893 | 202466 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 299 Bryant St | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 3ft | 6015364.08596 | 2113980.86874 | 37.7854515313193 | -122.390574827864 | (37.7854515313193, -122.390574827864) | 6 | 2 | 9 | 28856 | 6 | |||
| 3403 | 228171 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 401x Powhattan Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 3ft | 6008190.97242 | 2098122.00574 | 37.7415062071578 | -122.414269294615 | (37.7415062071578, -122.414269294615) | 2 | 7 | 7 | 28859 | 2 | |||
| 3644 | 123178 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 755 10th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 9ft | 5992851.1981 | 2110319.16368 | 37.7741228178256 | -122.46819559495 | (37.7741228178256, -122.46819559495) | 11 | 6 | 2 | 54 | 11 | |||
| 4997 | 255137 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 401X Brotherhood Way | 15 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
| 7086 | 255139 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 401X Brotherhood Way | 17 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
| 7311 | 255140 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 401X Brotherhood Way | 18 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
| 10648 | 255138 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 401X Brotherhood Way | 16 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
| 11423 | 250609 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2201 Golden Gate Ave | 34 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 5998802.7301 | 2111413.83913 | 37.7774704438335 | -122.447687106294 | (37.7774704438335, -122.447687106294) | 15 | 6 | 2 | 29492 | 16 | ||||
| 12774 | 255134 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 401X Brotherhood Way | 12 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
| 15221 | 255135 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 401X Brotherhood Way | 13 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
| 19840 | 228754 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 38 States St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6002024.93343 | 2106247.25047 | 37.7634679006536 | -122.436170631885 | (37.7634679006536, -122.436170631885) | 15 | 5 | 5 | 28862 | 3 | |||
| 22528 | 228914 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 902 Duboce Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6002566.20611 | 2108263.73827 | 37.7690354208689 | -122.434442729365 | (37.7690354208689, -122.434442729365) | 15 | 5 | 5 | 28862 | 3 | ||||
| 25190 | 208460 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 545 Teresita Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 3ft | 5998994.59253 | 2097295.1297 | 37.7387149309567 | -122.446007644855 | (37.7387149309567, -122.446007644855) | 9 | 7 | 4 | 59 | 40 | |||
| 28599 | 202485 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 299 Bryant St | 41 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 6ft | 6015591.97779 | 2114203.68942 | 37.7860759863606 | -122.389801952302 | (37.7860759863606, -122.389801952302) | 6 | 2 | 9 | 28855 | 6 | |||
| 31481 | 187531 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 205 Lauren Ct | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 1ft | 6012419.71049 | 2088072.38871 | 37.7141486551063 | -122.398942493396 | (37.7141486551063, -122.398942493396) | 10 | 3 | 8 | 309 | 1 | |||
| 36353 | 201083 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1206 Connecticut St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6013397.04192 | 2101508.8855 | 37.7510969228067 | -122.396505714667 | (37.7510969228067, -122.396505714667) | 10 | 3 | 8 | 28856 | 1 | ||||
| 36370 | 228755 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 40 States St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6002016.60182 | 2106247.42286 | 37.7634679006327 | -122.436199460544 | (37.7634679006327, -122.436199460544) | 15 | 5 | 5 | 28862 | 3 | |||
| 37727 | 228757 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 44 States St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6001993.07516 | 2106245.64579 | 37.7634616845236 | -122.436280704398 | (37.7634616845236, -122.436280704398) | 15 | 5 | 5 | 28862 | 3 | |||
| 38734 | 175106 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 654 Brotherhood Way | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 5990415.51721 | 2088495.51708 | 37.71405977332 | -122.475027549593 | (37.71405977332, -122.475027549593) | 1 | 8 | 4 | 64 | 14 | |||
| 41016 | 208397 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 8 Locksley Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 3ft | 5994179.14452 | 2104724.61437 | 37.7588382572923 | -122.463196003099 | (37.7588382572923, -122.463196003099) | 1 | 5 | 4 | 56 | 12 | |||
| 41794 | 202457 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 299 Bryant St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 6015279.90066 | 2113895.71742 | 37.7852130544834 | -122.390860133284 | (37.7852130544834, -122.390860133284) | 6 | 2 | 9 | 28856 | 6 | |||
| 42040 | 201086 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1206 Connecticut St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6013398.63652 | 2101437.25716 | 37.7509003354797 | -122.396495180026 | (37.7509003354797, -122.396495180026) | 10 | 3 | 8 | 28856 | 1 | ||||
| 43238 | 130213 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 24 Priest St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 10ft | 6008335.34786 | 2117068.60071 | 37.7935372512871 | -122.415110887372 | (37.7935372512871, -122.415110887372) | 5 | 1 | 10 | 28858 | 21 | |||
| 46521 | 122247 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 47 Lake St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 4ft | 5990771.99578 | 2114778.57066 | 37.7862468151678 | -122.475713552448 | (37.7862468151678, -122.475713552448) | 11 | 6 | 1 | 54 | 33 | |||
| 46870 | 250607 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2201 Golden Gate Ave | 32 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 5998769.74892 | 2111409.24483 | 37.7774559440593 | -122.447800867812 | (37.7774559440593, -122.447800867812) | 15 | 6 | 2 | 29492 | 16 | ||||
| 47346 | 228983 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1300 San Jose Ave | 39 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6003399.16662 | 2095595.26226 | 37.7342980159353 | -122.430657448703 | (37.7342980159353, -122.430657448703) | 2 | 7 | 5 | 63 | 7 | ||||
| 48106 | 208185 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1250 14th Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 5ft | 5991789.84585 | 2106909.67891 | 37.7646999340806 | -122.471618457129 | (37.7646999340806, -122.471618457129) | 11 | 8 | 11 | 56 | 12 | |||
| 50539 | 130332 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 150 Lombard St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 3ft | 6011713.56739 | 2120837.28367 | 37.8040744080582 | -122.403687207699 | (37.8040744080582, -122.403687207699) | 3 | 1 | 10 | 28860 | 6 | |||
| 50809 | 250611 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2201 Golden Gate Ave | 36 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 5998832.75116 | 2111418.50425 | 37.7774849687826 | -122.447583589827 | (37.7774849687826, -122.447583589827) | 15 | 6 | 2 | 29492 | 16 | ||||
| 51067 | 202464 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 299 Bryant St | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 3ft | 6015349.35153 | 2113969.09697 | 37.7854183912871 | -122.390624982151 | (37.7854183912871, -122.390624982151) | 6 | 2 | 9 | 28856 | 6 | |||
| 54831 | 201047 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 953 Indiana St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 8ft | 6014994.68358 | 2104372.25303 | 37.759047900964 | -122.391180985336 | (37.759047900964, -122.391180985336) | 10 | 3 | 8 | 28856 | 29 | |||
| 56603 | 202468 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 299 Bryant St | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 6015375.7803 | 2113995.06833 | 37.7854911689213 | -122.390535361139 | (37.7854911689213, -122.390535361139) | 6 | 2 | 9 | 28856 | 6 | |||
| 58019 | 130363 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1500 Sansome St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 4ft | 6011809.34098 | 2121067.49936 | 37.804711873607 | -122.40337198005 | (37.804711873607, -122.40337198005) | 3 | 1 | 10 | 28860 | 6 | |||
| 60499 | 175107 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 654 Brotherhood Way | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 5990408.51338 | 2088499.51505 | 37.7140703448535 | -122.475052048918 | (37.7140703448535, -122.475052048918) | 1 | 8 | 4 | 64 | 14 | |||
| 65866 | 228913 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 902 Duboce Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 6002535.15841 | 2108262.61475 | 37.7690305735192 | -122.434550040972 | (37.7690305735192, -122.434550040972) | 15 | 5 | 5 | 28862 | 3 | ||||
| 66494 | 228917 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 902 Duboce Ave | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 9ft | 6002641.22231 | 2108269.24913 | 37.7690548102697 | -122.434183647259 | (37.7690548102697, -122.434183647259) | 15 | 5 | 5 | 28862 | 3 | |||
| 69811 | 208182 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1250 14th Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 5ft | 5991791.47216 | 2106815.91316 | 37.764442572392 | -122.471605998827 | (37.764442572392, -122.471605998827) | 11 | 8 | 11 | 56 | 12 | |||
| 73382 | 228753 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 36 States St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6002041.28039 | 2106249.93043 | 37.7634761879043 | -122.436114284872 | (37.7634761879043, -122.436114284872) | 15 | 5 | 5 | 28862 | 3 | |||
| 76540 | 250605 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2201 Golden Gate Ave | 30 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 5998735.90805 | 2111405.0281 | 37.777442431746 | -122.447917630414 | (37.777442431746, -122.447917630414) | 15 | 6 | 2 | 29492 | 16 | ||||
| 77848 | 202450 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 299 Bryant St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 6015215.71695 | 2113812.52853 | 37.7849810752709 | -122.391076374397 | (37.7849810752709, -122.391076374397) | 6 | 2 | 9 | 28856 | 6 | |||
| 83613 | 187529 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 201 Lauren Ct | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 1ft | 6012398.67488 | 2088039.02734 | 37.7140558792414 | -122.399012860852 | (37.7140558792414, -122.399012860852) | 10 | 3 | 8 | 309 | 1 | |||
| 87392 | 228756 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 42 States St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6002002.55063 | 2106245.82703 | 37.7634627205367 | -122.436247944813 | (37.7634627205367, -122.436247944813) | 15 | 5 | 5 | 28862 | 3 | |||
| 92384 | 201084 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1206 Connecticut St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6013398.48807 | 2101490.04723 | 37.7510452774357 | -122.39649939335 | (37.7510452774357, -122.39649939335) | 10 | 3 | 8 | 28856 | 1 | ||||
| 98127 | 177239 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 700 Barneveld Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6009929.8098 | 2095382.7765 | 37.7340823944827 | -122.408063829483 | (37.7340823944827, -122.408063829483) | 10 | 3 | 7 | 309 | 28 | ||||
| 103787 | 202486 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 299 Bryant St | 42 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 6ft | 6015605.55295 | 2114216.90424 | 37.7861130240416 | -122.389755908832 | (37.7861130240416, -122.389755908832) | 6 | 2 | 9 | 28855 | 6 | |||
| 104647 | 129892 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 97 Parker Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5996812.70207 | 2113910.24255 | 37.7842109731914 | -122.454751639797 | (37.7842109731914, -122.454751639797) | 11 | 6 | 1 | 54 | 31 | |||
| 104808 | 250602 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2201 Golden Gate Ave | 27 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 5998679.25957 | 2111396.77415 | 37.7774165303825 | -122.448113000908 | (37.7774165303825, -122.448113000908) | 15 | 6 | 2 | 29492 | 16 | ||||
| 105734 | 228915 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 902 Duboce Ave | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 9ft | 6002590.64519 | 2108266.76384 | 37.76904511557 | -122.434358412533 | (37.76904511557, -122.434358412533) | 15 | 5 | 5 | 28862 | 3 | |||
| 108673 | 228909 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 902 Duboce Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6002414.42906 | 2108254.07715 | 37.7690002771719 | -122.434967025116 | (37.7690002771719, -122.434967025116) | 15 | 5 | 5 | 28862 | 3 | ||||
| 114659 | 250606 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2201 Golden Gate Ave | 31 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 5998755.1093 | 2111407.10323 | 37.7774492270278 | -122.447851356665 | (37.7774492270278, -122.447851356665) | 15 | 6 | 2 | 29492 | 16 | ||||
| 117318 | 202483 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 299 Bryant St | 39 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 6ft | 6015577.75199 | 2114193.56391 | 37.786047395123 | -122.389850462652 | (37.786047395123, -122.389850462652) | 6 | 2 | 9 | 28855 | 6 | |||
| 117698 | 104345 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 953 Indiana St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6014995.86461 | 2104338.49081 | 37.7589552627061 | -122.391174540789 | (37.7589552627061, -122.391174540789) | 10 | 3 | 8 | 28856 | 29 | ||||
| 120066 | 208184 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1250 14th Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 5ft | 5991790.26152 | 2106888.46165 | 37.7646417011847 | -122.47161547319 | (37.7646417011847, -122.47161547319) | 11 | 8 | 11 | 56 | 12 | |||
| 121626 | 250604 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2201 Golden Gate Ave | 29 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 5998717.29269 | 2111402.63651 | 37.7774348009994 | -122.447981854581 | (37.7774348009994, -122.447981854581) | 15 | 6 | 2 | 29492 | 16 | ||||
| 122180 | 201087 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1206 Connecticut St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6013399.886 | 2101408.71462 | 37.7508220333155 | -122.396488858689 | (37.7508220333155, -122.396488858689) | 10 | 3 | 8 | 28856 | 1 | ||||
| 122642 | 202453 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 299 Bryant St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6015244.83694 | 2113854.06461 | 37.7850967397668 | -122.390978531735 | (37.7850967397668, -122.390978531735) | 6 | 2 | 9 | 28856 | 6 | |||
| 126624 | 254469 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1601 Evans Ave | 62 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6015397 | 2098706 | 37.7435118805521 | -122.389393878977 | (37.7435118805521, -122.389393878977) | 10 | 3 | 8 | 58 | 1 | ||||
| 132963 | 228981 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1300 San Jose Ave | 37 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6003423.97246 | 2095615.4048 | 37.7343547280757 | -122.430573123757 | (37.7343547280757, -122.430573123757) | 2 | 7 | 5 | 63 | 7 | ||||
| 133477 | 202470 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 299 Bryant St | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6015391.5844 | 2114012.735 | 37.7855405543088 | -122.390481918033 | (37.7855405543088, -122.390481918033) | 6 | 2 | 9 | 28856 | 6 | |||
| 133577 | 254467 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1601 Evans Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6015397 | 2098706 | 37.7435118805521 | -122.389393878977 | (37.7435118805521, -122.389393878977) | 10 | 3 | 8 | 58 | 1 | ||||
| 134701 | 228912 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 902 Duboce Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 9ft | 6002507.65455 | 2108261.418 | 37.7690257261844 | -122.43464508942 | (37.7690257261844, -122.43464508942) | 15 | 5 | 5 | 28862 | 3 | |||
| 139733 | 228982 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1300 San Jose Ave | 38 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6003411.177 | 2095606.28442 | 37.7343289607029 | -122.430616711213 | (37.7343289607029, -122.430616711213) | 2 | 7 | 5 | 63 | 7 | ||||
| 140918 | 228758 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 46 States St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6001976.01738 | 2106245.24414 | 37.7634596124877 | -122.43633967294 | (37.7634596124877, -122.43633967294) | 15 | 5 | 5 | 28862 | 3 | |||
| 141523 | 228630 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 415 Noe St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 6002990.59235 | 2105867.59638 | 37.7624802786679 | -122.432803607018 | (37.7624802786679, -122.432803607018) | 15 | 4 | 5 | 28862 | 3 | |||
| 143959 | 208459 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 124 Los Palmos Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 5998457.9684 | 2096177.68112 | 37.7356160263437 | -122.447782605293 | (37.7356160263437, -122.447782605293) | 9 | 7 | 4 | 59 | 40 | |||
| 145220 | 250610 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2201 Golden Gate Ave | 35 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 5998818.59622 | 2111415.77935 | 37.7774766779527 | -122.447632360059 | (37.7774766779527, -122.447632360059) | 15 | 6 | 2 | 29492 | 16 | ||||
| 146396 | 130366 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1500 Sansome St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 4ft | 6011802.47859 | 2121110.74803 | 37.8048302405876 | -122.403398772629 | (37.8048302405876, -122.403398772629) | 3 | 1 | 10 | 28860 | 6 | |||
| 146481 | 201085 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1206 Connecticut St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 6013398.00576 | 2101451.22494 | 37.7509386529078 | -122.396498340247 | (37.7509386529078, -122.396498340247) | 10 | 3 | 8 | 28856 | 1 | ||||
| 148255 | 228910 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 902 Duboce Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6002455.70272 | 2108256.75448 | 37.7690099718673 | -122.434824453805 | (37.7690099718673, -122.434824453805) | 15 | 5 | 5 | 28862 | 3 | ||||
| 150397 | 250601 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2201 Golden Gate Ave | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 5998661.06901 | 2111393.5225 | 37.7774065623113 | -122.448175693572 | (37.7774065623113, -122.448175693572) | 15 | 6 | 2 | 29492 | 16 | ||||
| 151680 | 228908 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 902 Duboce Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6002385.59637 | 2108252.908 | 37.7689954298298 | -122.435066671805 | (37.7689954298298, -122.435066671805) | 15 | 5 | 5 | 28862 | 3 | ||||
| 152928 | 250603 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2201 Golden Gate Ave | 28 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 5998697.83635 | 2111399.4102 | 37.7774248302192 | -122.448048927835 | (37.7774248302192, -122.448048927835) | 15 | 6 | 2 | 29492 | 16 | ||||
| 154181 | 223790 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 190x Storrie St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/10/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782422 | 6000695.90206 | 2105313.46128 | 37.7608283472609 | -122.440700329057 | (37.7608283472609, -122.440700329057) | 15 | 4 | 5 | 28862 | 3 | |
| 156767 | 175105 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 654 Brotherhood Way | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 3x6 | 5990422.48043 | 2088489.59506 | 37.7140439164585 | -122.475003050272 | (37.7140439164585, -122.475003050272) | 1 | 8 | 4 | 64 | 14 | |||
| 158477 | 130214 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 24 Priest St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 6008331.4163 | 2117110.67994 | 37.7936525695546 | -122.41512747086 | (37.7936525695546, -122.41512747086) | 5 | 1 | 10 | 28858 | 21 | |||
| 159773 | 192724 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 900 Kirkwood Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 8ft | 6019533.42418 | 2093575.80573 | 37.729653833243 | -122.37473558218 | (37.729653833243, -122.37473558218) | 10 | 3 | 8 | 58 | 1 | |||
| 160969 | 255701 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 654 Brotherhood Way | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x12 | 5990422.48043 | 2088489.59506 | 37.7140439164585 | -122.475003050272 | (37.7140439164585, -122.475003050272) | 1 | 8 | 4 | 64 | 14 | ||||
| 164259 | 130331 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 150 Lombard St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6011736.68392 | 2120841.79777 | 37.8040880939644 | -122.403607528667 | (37.8040880939644, -122.403607528667) | 3 | 1 | 10 | 28860 | 6 | |||
| 164775 | 254468 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1601 Evans Ave | 61 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6015397 | 2098706 | 37.7435118805521 | -122.389393878977 | (37.7435118805521, -122.389393878977) | 10 | 3 | 8 | 58 | 1 | ||||
| 169728 | 228916 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 902 Duboce Ave | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 9ft | 6002616.34038 | 2108266.23267 | 37.7690451155718 | -122.434269496565 | (37.7690451155718, -122.434269496565) | 15 | 5 | 5 | 28862 | 3 | |||
| 170227 | 208183 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1250 14th Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 5ft | 5991790.78706 | 2106869.23774 | 37.7645889478528 | -122.471612254517 | (37.7645889478528, -122.471612254517) | 11 | 8 | 11 | 56 | 12 | |||
| 170292 | 187530 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 201 Lauren Ct | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 1ft | 6012406.92343 | 2088056.05376 | 37.7141030900466 | -122.398985544863 | (37.7141030900466, -122.398985544863) | 10 | 3 | 8 | 309 | 1 | |||
| 172399 | 104344 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 953 Indiana St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6014997.70938 | 2104304.04046 | 37.7588607718232 | -122.391165752619 | (37.7588607718232, -122.391165752619) | 10 | 3 | 8 | 28856 | 29 | ||||
| 173194 | 129893 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 400 Cherry St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 9ft | 5996283.0892 | 2114624.04425 | 37.7861404893398 | -122.456635539617 | (37.7861404893398, -122.456635539617) | 11 | 6 | 1 | 54 | 31 | |||
| 173424 | 202461 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 299 Bryant St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 6015317.37791 | 2113939.21463 | 37.7853345672879 | -122.390733513247 | (37.7853345672879, -122.390733513247) | 6 | 2 | 9 | 28856 | 6 | |||
| 173629 | 130362 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1500 Sansome St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 4ft | 6011810.82515 | 2121055.17232 | 37.8046781094657 | -122.403365976165 | (37.8046781094657, -122.403365976165) | 3 | 1 | 10 | 28860 | 6 | |||
| 173734 | 228980 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1300 San Jose Ave | 36 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6003436.04165 | 2095624.2228 | 37.7343796240226 | -122.430532025653 | (37.7343796240226, -122.430532025653) | 2 | 7 | 5 | 63 | 7 | ||||
| 175324 | 228911 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 902 Duboce Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6002477.93592 | 2108260.26707 | 37.7690208788446 | -122.434747801875 | (37.7690208788446, -122.434747801875) | 15 | 5 | 5 | 28862 | 3 | ||||
| 176389 | 130365 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1500 Sansome St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 4ft | 6011804.31754 | 2121095.94582 | 37.8047897000529 | -122.403391366725 | (37.8047897000529, -122.403391366725) | 3 | 1 | 10 | 28860 | 6 | |||
| 177923 | 202481 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 299 Bryant St | 37 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6015568.22944 | 2114180.97701 | 37.7860123062744 | -122.389882528859 | (37.7860123062744, -122.389882528859) | 6 | 2 | 9 | 28855 | 6 | |||
| 179336 | 250608 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2201 Golden Gate Ave | 33 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 5998787.15443 | 2111411.51458 | 37.7774631710182 | -122.447740820088 | (37.7774631710182, -122.447740820088) | 15 | 6 | 2 | 29492 | 16 | ||||
| 184852 | 177240 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 700 Barneveld Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6009907.41655 | 2095376.53945 | 37.7340640150435 | -122.408140810556 | (37.7340640150435, -122.408140810556) | 10 | 3 | 7 | 309 | 28 | ||||
| 188425 | 208196 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 177 Lomita Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 6ft | 5991318.16001 | 2104277.79248 | 37.7574461724167 | -122.473057932675 | (37.7574461724167, -122.473057932675) | 1 | 8 | 4 | 56 | 12 | |||
| 192987 | 130364 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1500 Sansome St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 4ft | 6011804.63165 | 2121081.32693 | 37.8047495777032 | -122.403389250627 | (37.8047495777032, -122.403389250627) | 3 | 1 | 10 | 28860 | 6 | |||
| 194272 | 177230 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 65 Ocean Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Permit Number 785586 | 6001004.64572 | 2091720.9184 | 37.7235240092161 | -122.438658540667 | (37.7235240092161, -122.438658540667) | 9 | 7 | 6 | 28861 | 25 | |||
| 194276 | 262536 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 65 Ocean Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 785586 | 6001004.64572 | 2091720.9184 | 37.7235240092161 | -122.438658540667 | (37.7235240092161, -122.438658540667) | 9 | 7 | 6 | 28861 | 25 |
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) );