trees
1,121 rows where qSpecies_id = 6 sorted by PlotSize 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
83192 | 227092 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Alemany Blvd | 30 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 9ft | 6009197.49082 | 2095788.04823 | 37.7351541534232 | -122.410624304588 | (37.7351541534232, -122.410624304588) | 10 | 7 | 7 | 28859 | 2 | |||
148726 | 227093 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Alemany Blvd | 31 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 9ft | 6009184.48132 | 2095791.05398 | 37.7351616771725 | -122.410669495512 | (37.7351616771725, -122.410669495512) | 10 | 7 | 7 | 28859 | 2 | |||
13391 | 119240 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 50 Sutro Heights Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 5981455.34518 | 2111336.83463 | 37.776252294734 | -122.507690683983 | (37.776252294734, -122.507690683983) | 11 | 6 | 2 | 55 | 26 | |||
83413 | 119242 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 50 Sutro Heights Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 5981417.66127 | 2111333.86508 | 37.7762419210818 | -122.507820820241 | (37.7762419210818, -122.507820820241) | 11 | 6 | 2 | 55 | 26 | |||
104812 | 117687 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 50 Point Lobos Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 8ft | 5982599.26265 | 2112595.13886 | 37.7797745547632 | -122.503826840405 | (37.7797745547632, -122.503826840405) | 11 | 6 | 2 | 55 | 26 | |||
154132 | 119243 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 50 Sutro Heights Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 5981398.37029 | 2111333.42566 | 37.7762395779827 | -122.507887519226 | (37.7762395779827, -122.507887519226) | 11 | 6 | 2 | 55 | 26 | |||
184601 | 119241 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 50 Sutro Heights Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 5981435.03386 | 2111334.77238 | 37.776245435782 | -122.5077607921 | (37.776245435782, -122.5077607921) | 11 | 6 | 2 | 55 | 26 | |||
40165 | 191226 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2350 20th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 7ft | 6011107.06002 | 2104648.42845 | 37.7595897074225 | -122.404645742032 | (37.7595897074225, -122.404645742032) | 10 | 3 | 8 | 28856 | 29 | |||
62739 | 227079 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 7ft | 6006194.41732 | 2099504.07308 | 37.7451886989034 | -122.421270828796 | (37.7451886989034, -122.421270828796) | 2 | 7 | 5 | 28859 | 2 | |||
10101 | 180653 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 245 Chicago Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/11/2017 07:56:00 AM | 3 | Width 6ft | 6002847.75966 | 2086772.69306 | 37.7100419513527 | -122.431934068713 | (37.7100419513527, -122.431934068713) | 9 | 7 | 6 | 28861 | 5 | ||
12985 | 229829 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1472 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2020 12:00:00 AM | 3 | Width 6ft | 6010097.10021 | 2100699.13339 | 37.7486893243481 | -122.407860213076 | (37.7486893243481, -122.407860213076) | 2 | 4 | 7 | 28859 | 19 | ||
21462 | 201816 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 Friedell St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 6ft | 6021143.08428 | 2093327.21502 | 37.7290596700622 | -122.369153577473 | (37.7290596700622, -122.369153577473) | 10 | 3 | 8 | 58 | 1 | ||
31921 | 191247 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1453 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 6ft | 6016461.47366 | 2096825.22247 | 37.7384066073881 | -122.385582111127 | (37.7384066073881, -122.385582111127) | 10 | 3 | 8 | 58 | 1 | |||
46503 | 201810 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 Friedell St | 1 | : | Tree | Private 2 | 1 | Width 6ft | 6021035.70856 | 2093179.80399 | 37.7286490171175 | -122.369514606714 | (37.7286490171175, -122.369514606714) | 10 | 3 | 8 | 58 | 1 | |||
54445 | 201812 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 Friedell St | 3 | : | Tree | Private 2 | 1 | Width 6ft | 6021065.67541 | 2093224.76894 | 37.7287741263267 | -122.369414113788 | (37.7287741263267, -122.369414113788) | 10 | 3 | 8 | 58 | 1 | |||
63555 | 201813 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 Friedell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 6ft | 6021086.18405 | 2093254.37787 | 37.7288565518864 | -122.369345258092 | (37.7288565518864, -122.369345258092) | 10 | 3 | 8 | 58 | 1 | ||
80797 | 201815 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 Friedell St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 6ft | 6021129.2467 | 2093308.19399 | 37.7290066829092 | -122.369200102111 | (37.7290066829092, -122.369200102111) | 10 | 3 | 8 | 58 | 1 | ||
112005 | 227095 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3651 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 6ft | 6005946.52179 | 2104309.35666 | 37.7583689226977 | -122.422469389447 | (37.7583689226977, -122.422469389447) | 2 | 4 | 5 | 28859 | 19 | |||
125237 | 201811 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 Friedell St | 2 | : | Tree | Private 2 | 1 | Width 6ft | 6021050.71889 | 2093203.62599 | 37.7287152512926 | -122.369464359799 | (37.7287152512926, -122.369464359799) | 10 | 3 | 8 | 58 | 1 | |||
135455 | 201808 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 247 Friedell St | 1 | : | Tree | Private 2 | 1 | Width 6ft | 6020927.8472 | 2093035.08257 | 37.7282457215548 | -122.369877496672 | (37.7282457215548, -122.369877496672) | 10 | 3 | 8 | 58 | 1 | |||
136658 | 227102 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1451 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 6ft | 6003961.99133 | 2099782.46881 | 37.7458269972341 | -122.4290100202 | (37.7458269972341, -122.4290100202) | 2 | 7 | 5 | 63 | 22 | |||
156146 | 201814 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 Friedell St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 6ft | 6021112.10587 | 2093285.4865 | 37.728943392223 | -122.369257791817 | (37.728943392223, -122.369257791817) | 10 | 3 | 8 | 58 | 1 | ||
175919 | 201807 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 273 Friedell St | 1 | : | Tree | Private 2 | 2 | Width 6ft | 6020893.11722 | 2092989.08595 | 37.7281175177998 | -122.369994383343 | (37.7281175177998, -122.369994383343) | 10 | 3 | 8 | 58 | 1 | |||
193987 | 201809 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 237 Friedell St | 1 | : | Tree | Private 2 | 1 | Width 6ft | 6020945.51773 | 2093059.30039 | 37.7283131886973 | -122.369818081152 | (37.7283131886973, -122.369818081152) | 10 | 3 | 8 | 58 | 1 | |||
31518 | 201833 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 350 Friedell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020733.63229 | 2092847.87799 | 37.7277210345753 | -122.370535976659 | (37.7277210345753, -122.370535976659) | 10 | 3 | 8 | 58 | 1 | |
44304 | 227096 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3639 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6006022.63157 | 2104312.28056 | 37.7583812443163 | -122.422206375532 | (37.7583812443163, -122.422206375532) | 2 | 4 | 5 | 28859 | 19 | |||
52248 | 201838 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 350 Friedell St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020663.4716 | 2092744.71005 | 37.7274339035298 | -122.370771395785 | (37.7274339035298, -122.370771395785) | 10 | 3 | 8 | 58 | 1 | |
53926 | 201827 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 258 Friedell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020879.65439 | 2093047.83852 | 37.7282781025329 | -122.370044984594 | (37.7282781025329, -122.370044984594) | 10 | 3 | 8 | 58 | 1 | |
57077 | 201825 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 232 Friedell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020928.29141 | 2093111.19247 | 37.7284547293849 | -122.369881218949 | (37.7284547293849, -122.369881218949) | 10 | 3 | 8 | 58 | 1 | |
59846 | 201831 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 350 Friedell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020768.36275 | 2092897.88429 | 37.7278602487283 | -122.370419366967 | (37.7278602487283, -122.370419366967) | 10 | 3 | 8 | 58 | 1 | |
63426 | 117686 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 34 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 5982669.57188 | 2112585.47797 | 37.7797521626965 | -122.503582898398 | (37.7797521626965, -122.503582898398) | 11 | 6 | 2 | 55 | 26 | |||
72608 | 201817 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Friedell St | 1 | : | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | 6021101.98762 | 2093338.62944 | 37.7290887577236 | -122.369296441991 | (37.7290887577236, -122.369296441991) | 10 | 3 | 8 | 58 | 1 | ||
72800 | 121883 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 50 18th Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 5ft | 5990230.48175 | 2114847.31405 | 37.786404156248 | -122.477592056385 | (37.786404156248, -122.477592056385) | 11 | 6 | 1 | 55 | 33 | |||
76682 | 201818 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Friedell St | 2 | : | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | 6021088.08179 | 2093322.41734 | 37.7290434795636 | -122.369343396492 | (37.7290434795636, -122.369343396492) | 10 | 3 | 8 | 58 | 1 | ||
81876 | 227086 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Alemany Blvd | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 5ft | 6009619.77164 | 2096165.81934 | 37.7362150980513 | -122.409190969587 | (37.7362150980513, -122.409190969587) | 10 | 7 | 7 | 28859 | 2 | |||
82053 | 121884 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 50 18th Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 5ft | 5990230.57834 | 2114834.81932 | 37.7863698548312 | -122.477590808601 | (37.7863698548312, -122.477590808601) | 11 | 6 | 1 | 55 | 33 | |||
82173 | 201824 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Friedell St | 8 | : | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | 6021004.60368 | 2093212.58809 | 37.7287373296405 | -122.369624404053 | (37.7287373296405, -122.369624404053) | 10 | 3 | 8 | 58 | 1 | ||
83985 | 227091 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Alemany Blvd | 29 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 5ft | 6009293.03444 | 2095834.73547 | 37.735287702767 | -122.410297269721 | (37.735287702767, -122.410297269721) | 10 | 7 | 7 | 28859 | 2 | |||
98535 | 227088 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Alemany Blvd | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 5ft | 6009533.30641 | 2096029.17809 | 37.7358350661275 | -122.409480276115 | (37.7358350661275, -122.409480276115) | 10 | 7 | 7 | 28859 | 2 | |||
102075 | 201832 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 350 Friedell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020752.62591 | 2092874.74971 | 37.7277958617862 | -122.370472171548 | (37.7277958617862, -122.370472171548) | 10 | 3 | 8 | 58 | 1 | |
108420 | 201836 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 350 Friedell St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020688.4191 | 2092782.87071 | 37.7275400550072 | -122.370687788509 | (37.7275400550072, -122.370687788509) | 10 | 3 | 8 | 58 | 1 | |
109623 | 227566 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 91 Clover Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6000468.02748 | 2104951.63177 | 37.7598218728073 | -122.441462479323 | (37.7598218728073, -122.441462479323) | 2 | 4 | 5 | 28862 | 3 | |||
121234 | 201829 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 284 Friedell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020846.41585 | 2093000.79454 | 37.7281471046068 | -122.370156642634 | (37.7281471046068, -122.370156642634) | 10 | 3 | 8 | 58 | 1 | |
129793 | 201837 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 350 Friedell St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020676.58787 | 2092764.09442 | 37.7274878493838 | -122.370727391967 | (37.7274878493838, -122.370727391967) | 10 | 3 | 8 | 58 | 1 | |
142719 | 124805 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2798 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2018 12:00:00 AM | 3 | Width 5ft | Permit Number 781937 | 5999607.72686 | 2118800.07594 | 37.7977970943207 | -122.445433600384 | (37.7977970943207, -122.445433600384) | 13 | 9 | 1 | 57 | 17 | |
146566 | 201835 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 350 Friedell St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020706.7385 | 2092807.85492 | 37.7276096625463 | -122.370626184075 | (37.7276096625463, -122.370626184075) | 10 | 3 | 8 | 58 | 1 | |
154340 | 176919 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 140 Seville St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6001505.61042 | 2087336.29034 | 37.7115132862848 | -122.436613103724 | (37.7115132862848, -122.436613103724) | 9 | 7 | 6 | 28861 | 5 | |||
156156 | 201828 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 268 Friedell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020862.97624 | 2093021.36948 | 37.728204508308 | -122.3701008136 | (37.728204508308, -122.3701008136) | 10 | 3 | 8 | 58 | 1 | |
168920 | 201823 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Friedell St | 7 | : | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | 6021023.85438 | 2093233.10906 | 37.7287947324852 | -122.369559269737 | (37.7287947324852, -122.369559269737) | 10 | 3 | 8 | 58 | 1 | ||
169734 | 201826 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 250 Friedell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020898.42083 | 2093071.04954 | 37.7283428654122 | -122.369981710984 | (37.7283428654122, -122.369981710984) | 10 | 3 | 8 | 58 | 1 | |
169785 | 201830 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 292 Friedell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020827.60649 | 2092975.44043 | 37.7280764547545 | -122.370219916224 | (37.7280764547545, -122.370219916224) | 10 | 3 | 8 | 58 | 1 | |
174485 | 201834 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 350 Friedell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020718.56969 | 2092826.63123 | 37.7276618681873 | -122.37058658062 | (37.7276618681873, -122.37058658062) | 10 | 3 | 8 | 58 | 1 | |
189609 | 227083 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 770 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6008514.34527 | 2104071.33726 | 37.7578598992273 | -122.41357185686 | (37.7578598992273, -122.41357185686) | 2 | 4 | 7 | 28859 | 19 | |||
1269 | 262440 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 99 San Gabriel Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 4ft | 6001119 | 2093653 | 37.728835569179 | -122.438401596107 | (37.728835569179, -122.438401596107) | 9 | 7 | 6 | 28861 | 25 | ||
1777 | 260927 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 354 Point Lobos Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | Width 4ft | 5981645 | 2112753 | 37.7801518383055 | -122.507139709579 | (37.7801518383055, -122.507139709579) | 11 | 6 | 2 | 55 | 26 | ||||
2939 | 262442 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 99 San Gabriel Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 4ft | 6001119 | 2093653 | 37.728835569179 | -122.438401596107 | (37.728835569179, -122.438401596107) | 9 | 7 | 6 | 28861 | 25 | ||
9404 | 176900 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 167 Madison St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6005606.72127 | 2092829.97134 | 37.7268299557374 | -122.422828750447 | (37.7268299557374, -122.422828750447) | 9 | 7 | 7 | 309 | 5 | |||
12204 | 164659 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 150 Granville Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 12:00:00 AM | 3 | Width 4ft | Permit Number 785596 | 5994533.58351 | 2098539.8464 | 37.7418768645301 | -122.461521809887 | (37.7418768645301, -122.461521809887) | 1 | 8 | 4 | 59 | 40 | |
15133 | 129382 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 91 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6008704.56308 | 2112447.63135 | 37.7808699297471 | -122.413506401504 | (37.7808699297471, -122.413506401504) | 7 | 10 | 9 | 28852 | 36 | |||
15310 | 262443 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 99 San Gabriel Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 4ft | 6001119 | 2093653 | 37.728835569179 | -122.438401596107 | (37.728835569179, -122.438401596107) | 9 | 7 | 6 | 28861 | 25 | ||
15599 | 262439 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 99 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 4ft | 6001119 | 2093653 | 37.728835569179 | -122.438401596107 | (37.728835569179, -122.438401596107) | 9 | 7 | 6 | 28861 | 25 | ||
16685 | 251006 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 348 Point Lobos Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2 | Width 4ft | 5981660.38525 | 2112713.01394 | 37.7800429545487 | -122.507083518802 | (37.7800429545487, -122.507083518802) | 11 | 6 | 2 | 55 | 26 | |||
20503 | 129384 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 91 McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6008749.2926 | 2112454.62361 | 37.7808916402666 | -122.413352154294 | (37.7808916402666, -122.413352154294) | 7 | 10 | 9 | 28852 | 36 | |||
21404 | 129375 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 454 Walnut St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5998637.858 | 2115126.26996 | 37.7876543864995 | -122.448524881439 | (37.7876543864995, -122.448524881439) | 13 | 6 | 1 | 54 | 31 | |||
21599 | 129376 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2500 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6002240.59165 | 2116825.10443 | 37.7925242837291 | -122.436181762774 | (37.7925242837291, -122.436181762774) | 13 | 9 | 1 | 29490 | 27 | |||
25424 | 176901 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 167 Madison St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6005600.43917 | 2092849.05844 | 37.7268820102711 | -122.422851823466 | (37.7268820102711, -122.422851823466) | 9 | 7 | 7 | 309 | 5 | |||
27719 | 250553 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 130 El Camino Del Mar | 1 | : | Tree | Private 2 | 8 | Width 4ft | 5988175.48547 | 2115367.76095 | 37.7877136895948 | -122.484739928202 | (37.7877136895948, -122.484739928202) | 11 | 6 | 1 | 55 | 33 | |||
30385 | 181018 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 197 Rolph St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/10/2017 11:31:00 AM | 3 | Width 4ft | 6001005.57228 | 2088396.04691 | 37.7143947132291 | -122.43841724089 | (37.7143947132291, -122.43841724089) | 9 | 7 | 6 | 28861 | 5 | ||
31769 | 227126 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1689 Noe St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 4ft | 6003395.21055 | 2098417.4445 | 37.742046857971 | -122.430872467617 | (37.742046857971, -122.430872467617) | 2 | 7 | 5 | 63 | 22 | |||
39381 | 181028 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 95 Rolph St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/05/2017 04:38:00 PM | 3 | Width 4ft | 6000533.08885 | 2088674.46766 | 37.7151323074928 | -122.440070279342 | (37.7151323074928, -122.440070279342) | 9 | 7 | 6 | 28861 | 5 | ||
41709 | 129378 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2500 Steiner St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6002236.43678 | 2116865.63553 | 37.7926353355998 | -122.436199040575 | (37.7926353355998, -122.436199040575) | 13 | 9 | 1 | 29490 | 27 | |||
50352 | 227104 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 35 Carmel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5998773.50017 | 2105374.28879 | 37.7608857006352 | -122.447353415547 | (37.7608857006352, -122.447353415547) | 15 | 5 | 11 | 29492 | 12 | |||
55754 | 176898 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 167 Madison St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6005619.38027 | 2092788.13013 | 37.7267157831975 | -122.422782016296 | (37.7267157831975, -122.422782016296) | 9 | 7 | 7 | 309 | 5 | |||
72338 | 227121 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 791 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6001433.87774 | 2099966.59062 | 37.7461891245209 | -122.437765046244 | (37.7461891245209, -122.437765046244) | 2 | 7 | 5 | 63 | 22 | |||
81750 | 129385 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 722 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6009662.68842 | 2115877.38276 | 37.7903409582254 | -122.41043401253 | (37.7903409582254, -122.41043401253) | 5 | 1 | 10 | 28857 | 21 | |||
82485 | 118666 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 465 43rd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5982506.22463 | 2112651.75572 | 37.7799245369815 | -122.504152889313 | (37.7799245369815, -122.504152889313) | 11 | 6 | 2 | 55 | 26 | |||
85415 | 207038 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 270 Magellan Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 5994641.46146 | 2100307.89339 | 37.7467376875983 | -122.461276941602 | (37.7467376875983, -122.461276941602) | 1 | 8 | 4 | 29491 | 40 | |||
85418 | 227105 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 436 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 5998543.73083 | 2106633.91182 | 37.7643311769734 | -122.448238788212 | (37.7643311769734, -122.448238788212) | 15 | 5 | 11 | 29492 | 9 | |||
92442 | 129379 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1765 Jackson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6005697.11148 | 2117184.40611 | 37.793706610722 | -122.424247645012 | (37.793706610722, -122.424247645012) | 13 | 9 | 1 | 28858 | 27 | |||
95828 | 129377 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2500 Steiner St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6002239.2844 | 2116842.37021 | 37.7925716168296 | -122.436187522037 | (37.7925716168296, -122.436187522037) | 13 | 9 | 1 | 29490 | 27 | |||
102876 | 119072 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 635 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2016 12:00:00 AM | 3 | Width 4ft | Permit Number 778557 | 5981931.09212 | 2111414.85236 | 37.7764945246953 | -122.506050759134 | (37.7764945246953, -122.506050759134) | 11 | 6 | 2 | 55 | 26 | |
102966 | 206997 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1290 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5992719.48539 | 2106665.14578 | 37.7640822509305 | -122.46838531524 | (37.7640822509305, -122.46838531524) | 11 | 8 | 11 | 56 | 12 | |||
106437 | 250555 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 130 El Camino Del Mar | 3 | : | Tree | Private 2 | 5 | Width 4ft | 5988156.37986 | 2115366.75845 | 37.7877098242971 | -122.484805955556 | (37.7877098242971, -122.484805955556) | 11 | 6 | 1 | 55 | 33 | |||
107699 | 129383 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 91 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6008721.10925 | 2112450.33412 | 37.7808782799549 | -122.413449351208 | (37.7808782799549, -122.413449351208) | 7 | 10 | 9 | 28852 | 36 | |||
108454 | 227082 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4021 Mission St | 1 | : | Tree | Private 2 | 4 | Width 4ft | 6004538.86235 | 2095169.33967 | 37.7331930297319 | -122.426686831253 | (37.7331930297319, -122.426686831253) | 2 | 7 | 7 | 28861 | 2 | |||
109143 | 181019 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 191 Rolph St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/10/2017 12:36:00 PM | 3 | Width 4ft | 6000981.45407 | 2088409.26942 | 37.7144296473919 | -122.438501549606 | (37.7144296473919, -122.438501549606) | 9 | 7 | 6 | 28861 | 5 | ||
112736 | 227106 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 436 Belvedere St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 5998542.97606 | 2106650.29925 | 37.7643761295797 | -122.448242578852 | (37.7643761295797, -122.448242578852) | 15 | 5 | 11 | 29492 | 9 | |||
117385 | 181020 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 183 Rolph St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/10/2017 12:41:00 PM | 3 | Width 4ft | 6000952.49174 | 2088426.93011 | 37.7144764921819 | -122.438602919392 | (37.7144764921819, -122.438602919392) | 9 | 7 | 6 | 28861 | 5 | ||
119325 | 129374 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 454 Walnut St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5998634.47077 | 2115144.95556 | 37.7877054985629 | -122.448537946784 | (37.7877054985629, -122.448537946784) | 13 | 6 | 1 | 54 | 31 | |||
125716 | 119982 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 250 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 5987459.3505 | 2114288.69945 | 37.7847091625278 | -122.487138302864 | (37.7847091625278, -122.487138302864) | 11 | 6 | 1 | 55 | 26 | |||
133452 | 181027 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 95 Rolph St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/05/2017 04:23:00 PM | 3 | Width 4ft | 6000546.58685 | 2088667.24811 | 37.7151132526545 | -122.440023107188 | (37.7151132526545, -122.440023107188) | 9 | 7 | 6 | 28861 | 5 | ||
134071 | 227103 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 138 Rivoli St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5998021.55452 | 2105968.74453 | 37.7624749295086 | -122.449996897152 | (37.7624749295086, -122.449996897152) | 15 | 5 | 11 | 29492 | 9 | |||
137770 | 206987 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1248 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5992091.43933 | 2106913.61789 | 37.7647281934706 | -122.470575621288 | (37.7647281934706, -122.470575621288) | 11 | 8 | 11 | 56 | 12 | |||
138303 | 191219 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 318 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6010580.39617 | 2106780.39752 | 37.7654141639451 | -122.406617457953 | (37.7654141639451, -122.406617457953) | 8 | 4 | 8 | 28853 | 19 | |||
142268 | 129380 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 730 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6008321.92773 | 2115014.63424 | 37.7878968077251 | -122.415011874722 | (37.7878968077251, -122.415011874722) | 5 | 1 | 10 | 28858 | 21 | |||
145000 | 227089 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Alemany Blvd | 17 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 6009456.29094 | 2095946.49023 | 37.7356037074354 | -122.409740715285 | (37.7356037074354, -122.409740715285) | 10 | 7 | 7 | 28859 | 2 | |||
147718 | 201819 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Friedell St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | 6021071.50009 | 2093300.77069 | 37.7289831323462 | -122.369399226393 | (37.7289831323462, -122.369399226393) | 10 | 3 | 8 | 58 | 1 | ||
148373 | 129381 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 555 O'Farrell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6008630.87446 | 2114175.52263 | 37.7856101663154 | -122.413883591577 | (37.7856101663154, -122.413883591577) | 7 | 10 | 9 | 28852 | 36 | |||
149415 | 201820 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Friedell St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | 6021056.53291 | 2093279.09213 | 37.7289227860515 | -122.369449472416 | (37.7289227860515, -122.369449472416) | 10 | 3 | 8 | 58 | 1 | ||
150091 | 129390 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 902 Vallejo St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 4ft | 6009192.86484 | 2118752.75452 | 37.798209676283 | -122.412262888224 | (37.798209676283, -122.412262888224) | 3 | 1 | 10 | 308 | 21 |
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) );