trees
3,267 rows where qSpecies_id = 67 sorted by qAddress 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
132952 | 188890 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 998 Rhode Island St | 2 | : | Tree | Private 2 | 16 | Width 3ft | 6011864.92725 | 2103833.36661 | 37.7573940557998 | -122.401967346013 | (37.7573940557998, -122.401967346013) | 10 | 3 | 8 | 28856 | 29 | |||
174475 | 188891 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 998 Rhode Island St | 3 | : | Tree | Private 2 | 11 | Width 3ft | 6011866.50484 | 2103811.61512 | 37.7573344190536 | -122.401960361001 | (37.7573344190536, -122.401960361001) | 10 | 3 | 8 | 28856 | 29 | |||
21490 | 222211 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 998 Chenery St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001126.04303 | 2096135.59352 | 37.7356525981802 | -122.43855505387 | (37.7356525981802, -122.43855505387) | 2 | 7 | 5 | 63 | 7 | |||
95460 | 118310 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 990 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/12/2016 12:00:00 AM | 3 | 3x3 | 6011874 | 2103773 | 37.7572288087602 | -122.401931725179 | (37.7572288087602, -122.401931725179) | 10 | 3 | 8 | 28856 | 29 | ||
186957 | 118311 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 990 Rhode Island St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011874 | 2103773 | 37.7572288087602 | -122.401931725179 | (37.7572288087602, -122.401931725179) | 10 | 3 | 8 | 28856 | 29 | ||||
95892 | 204500 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 99 Rosewood Dr | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5994814.30919 | 2095289.88176 | 37.73296941779 | -122.460315739002 | (37.73296941779, -122.460315739002) | 9 | 8 | 4 | 59 | 40 | |||
43858 | 220926 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 99 Esmeralda Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | 6007313.3532 | 2098768.19788 | 37.7432311697946 | -122.417349591335 | (37.7432311697946, -122.417349591335) | 2 | 7 | 7 | 28859 | 2 | ||||
91850 | 222250 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 99 Ellsworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008155.58362 | 2098186.12884 | 37.7416802871034 | -122.414396193456 | (37.7416802871034, -122.414396193456) | 2 | 7 | 7 | 28859 | 2 | |||
179779 | 204491 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 99 Castenada Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5994455.7902 | 2101236.32274 | 37.7492762327102 | -122.461986284554 | (37.7492762327102, -122.461986284554) | 1 | 8 | 4 | 29491 | 40 | |||
155010 | 4369 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 989 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6001020.80227 | 2096135.40108 | 37.7356460826069 | -122.438918897095 | (37.7356460826069, -122.438918897095) | 2 | 7 | 5 | 63 | 7 | |||
98370 | 220940 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 989 Alabama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6009176.73244 | 2103397.56801 | 37.7560470530489 | -122.411233441466 | (37.7560470530489, -122.411233441466) | 2 | 4 | 7 | 28859 | 19 | |||
120315 | 220943 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 989 Alabama St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6009173.01962 | 2103460.05786 | 37.7562184278541 | -122.411250695862 | (37.7562184278541, -122.411250695862) | 2 | 4 | 7 | 28859 | 19 | |||
132796 | 220942 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 989 Alabama St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6009174.43339 | 2103437.67182 | 37.7561570401276 | -122.411244225234 | (37.7561570401276, -122.411244225234) | 2 | 4 | 7 | 28859 | 19 | |||
177124 | 220941 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 989 Alabama St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6009176.43878 | 2103413.72088 | 37.7560913887176 | -122.411235598046 | (37.7560913887176, -122.411235598046) | 2 | 4 | 7 | 28859 | 19 | |||
184617 | 220939 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 989 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6009179.8123 | 2103380.42673 | 37.7560001596871 | -122.411221579429 | (37.7560001596871, -122.411221579429) | 2 | 4 | 7 | 28859 | 19 | |||
191570 | 116847 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 987 ALABAMA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6009201 | 2103425 | 37.7561237360793 | -122.411151453462 | (37.7561237360793, -122.411151453462) | 2 | 4 | 7 | 28859 | 19 | |||
43279 | 139890 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 983 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6004849.4324 | 2112263.6366 | 37.7801475072603 | -122.426830084895 | (37.7801475072603, -122.426830084895) | 7 | 9 | 11 | 28852 | 41 | |||
99956 | 139891 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 981 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6004864.9708 | 2112266.0271 | 37.7801549495211 | -122.426776500746 | (37.7801549495211, -122.426776500746) | 7 | 9 | 11 | 28852 | 41 | |||
91875 | 188989 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 98 Topeka Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6012384.41951 | 2095296.84991 | 37.7339835868704 | -122.399571392929 | (37.7339835868704, -122.399571392929) | 10 | 3 | 8 | 58 | 1 | |||
92599 | 188988 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 98 Topeka Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6012367.17642 | 2095308.04996 | 37.7340133787081 | -122.399631794081 | (37.7340133787081, -122.399631794081) | 10 | 3 | 8 | 58 | 1 | |||
73060 | 220799 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 98 Rosemont Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6005109.92864 | 2107867.40022 | 37.7680912352555 | -122.425615931155 | (37.7680912352555, -122.425615931155) | 8 | 4 | 5 | 28853 | 19 | |||
26052 | 94065 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 98 Ney St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Tree 5 on Craut | 6004036 | 2094004 | 37.7299648256421 | -122.428342334562 | (37.7299648256421, -122.428342334562) | 9 | 7 | 6 | 28861 | 5 | ||||
54526 | 40684 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 98 Ney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/10/1999 12:00:00 AM | Permit Number 41667 | 6004026.21190005 | 2093997.85413123 | 37.7299473965939 | -122.428375735336 | (37.7299473965939, -122.428375735336) | 9 | 7 | 6 | 28861 | 5 | ||
114729 | 94064 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 98 Ney St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Tree 4 on Craut | 6004036 | 2094004 | 37.7299648256421 | -122.428342334562 | (37.7299648256421, -122.428342334562) | 9 | 7 | 6 | 28861 | 5 | ||||
166934 | 94061 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 98 Ney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Tree 1 on Craut. | 6004036 | 2094004 | 37.7299648256421 | -122.428342334562 | (37.7299648256421, -122.428342334562) | 9 | 7 | 6 | 28861 | 5 | ||||
173743 | 94062 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 98 Ney St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Tree 2 on Craut | 6004036 | 2094004 | 37.7299648256421 | -122.428342334562 | (37.7299648256421, -122.428342334562) | 9 | 7 | 6 | 28861 | 5 | ||||
192464 | 94063 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 98 Ney St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Tree 3 on Craut | 6004036 | 2094004 | 37.7299648256421 | -122.428342334562 | (37.7299648256421, -122.428342334562) | 9 | 7 | 6 | 28861 | 5 | ||||
19003 | 188986 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 98 Maddux Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6012667.64033 | 2095215.60548 | 37.7337762895405 | -122.398586505788 | (37.7337762895405, -122.398586505788) | 10 | 3 | 8 | 58 | 1 | |||
118039 | 188985 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 98 Maddux Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6012675.20565 | 2095233.03889 | 37.7338245795424 | -122.398561572976 | (37.7338245795424, -122.398561572976) | 10 | 3 | 8 | 58 | 1 | |||
152103 | 188983 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 98 Maddux Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6012689.1535 | 2095267.6369 | 37.7339203555395 | -122.398515777692 | (37.7339203555395, -122.398515777692) | 10 | 3 | 8 | 58 | 1 | |||
181511 | 188984 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 98 Maddux Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6012682.9211 | 2095250.61598 | 37.733873272418 | -122.398536131163 | (37.733873272418, -122.398536131163) | 10 | 3 | 8 | 58 | 1 | |||
50177 | 12316 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 977X Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6004927.25201 | 2112274.40172 | 37.7801814652814 | -122.426561638009 | (37.7801814652814, -122.426561638009) | 7 | 9 | 11 | 28852 | 41 | |||
81628 | 12317 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 977X Golden Gate Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6004927.25201 | 2112274.40172 | 37.7801814652814 | -122.426561638009 | (37.7801814652814, -122.426561638009) | 7 | 9 | 11 | 28852 | 41 | |||
91527 | 12314 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 977X Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6004927.25201 | 2112274.40172 | 37.7801814652814 | -122.426561638009 | (37.7801814652814, -122.426561638009) | 7 | 9 | 11 | 28852 | 41 | |||
94246 | 12313 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 977X Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6004927.25201 | 2112274.40172 | 37.7801814652814 | -122.426561638009 | (37.7801814652814, -122.426561638009) | 7 | 9 | 11 | 28852 | 41 | |||
99025 | 139893 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 977 Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004903.219 | 2112271.4058 | 37.7801718805445 | -122.426644565829 | (37.7801718805445, -122.426644565829) | 7 | 9 | 11 | 28852 | 41 | |||
70625 | 222164 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 976 Elizabeth St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | Width 4ft | 6000208.07575 | 2101987.18481 | 37.7516674122297 | -122.442148723208 | (37.7516674122297, -122.442148723208) | 2 | 4 | 5 | 28862 | 22 | |||
86710 | 222163 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 976 Elizabeth St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 4ft | 6000221.60157 | 2101988.12675 | 37.7516707693994 | -122.442102016907 | (37.7516707693994, -122.442102016907) | 2 | 4 | 5 | 28862 | 22 | |||
29349 | 220976 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 976 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5999674.18821 | 2101792.42886 | 37.7511022189001 | -122.443980977643 | (37.7511022189001, -122.443980977643) | 2 | 5 | 5 | 63 | 38 | |||
112304 | 139894 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 975 Golden Gate Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6004921.7454 | 2112273.7963 | 37.7801794916425 | -122.42658064478 | (37.7801794916425, -122.42658064478) | 7 | 9 | 11 | 28852 | 41 | |||
135264 | 42188 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 975 Bryant St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42468 | 6010750.56133351 | 2109544.8068813 | 37.7730141185867 | -122.406223676993 | (37.7730141185867, -122.406223676993) | 14 | 2 | 9 | 28853 | 34 | ||
169368 | 42187 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 975 Bryant St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42468 | 6010750.56133351 | 2109544.8068813 | 37.7730141185867 | -122.406223676993 | (37.7730141185867, -122.406223676993) | 14 | 2 | 9 | 28853 | 34 | ||
121084 | 188872 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 969 De Haro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6012202.49655 | 2103904.7568 | 37.7576089119481 | -122.400804905738 | (37.7576089119481, -122.400804905738) | 10 | 3 | 8 | 28856 | 29 | |||
10999 | 31902 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 965 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | 14 | Permit Number 35327 | 6008027.66279 | 2109898.08591 | 37.7738314549808 | -122.415667565898 | (37.7738314549808, -122.415667565898) | 8 | 2 | 9 | 28853 | 34 | |
59698 | 22832 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 96 Turquoise Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 5999484.67049 | 2098974.10299 | 37.7433529640774 | -122.44443382318 | (37.7433529640774, -122.44443382318) | 2 | 7 | 5 | 63 | 7 | |||
159688 | 36024 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 96 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39171 | 6007289.27861972 | 2098814.18555513 | 37.7433560871509 | -122.417436093563 | (37.7433560871509, -122.417436093563) | 2 | 7 | 7 | 28859 | 2 | ||
38427 | 1925 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 96 Berkeley Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6001058.61282 | 2097389.17311 | 37.7390907990037 | -122.438877991419 | (37.7390907990037, -122.438877991419) | 2 | 7 | 5 | 63 | 7 | |||
179787 | 188903 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 959 Kansas St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 15 | Width 2ft | 6011647.62707 | 2103912.94015 | 37.7576004169513 | -122.402724456485 | (37.7576004169513, -122.402724456485) | 10 | 3 | 8 | 28856 | 29 | |||
6660 | 189023 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 955 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2018 12:00:00 AM | 3 | Width 3ft | 6010789.05197 | 2109573.65252 | 37.7730954749965 | -122.406092565024 | (37.7730954749965, -122.406092565024) | 14 | 2 | 9 | 28853 | 34 | ||
41108 | 189025 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 955 Bryant St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2018 12:00:00 AM | 3 | Width 3ft | 6010814.25369 | 2109596.96764 | 37.7731609024948 | -122.406007031421 | (37.7731609024948, -122.406007031421) | 14 | 2 | 9 | 28853 | 34 | ||
45547 | 189024 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 955 Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2018 12:00:00 AM | 3 | Width 3ft | 6010801.22197 | 2109583.73033 | 37.7731238270259 | -122.406051177336 | (37.7731238270259, -122.406051177336) | 14 | 2 | 9 | 28853 | 34 | ||
47135 | 189026 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 955 Bryant St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2018 12:00:00 AM | 3 | Width 3ft | 6010848.73344 | 2109624.73915 | 37.7732390850389 | -122.405889717541 | (37.7732390850389, -122.405889717541) | 14 | 2 | 9 | 28853 | 34 | ||
170526 | 189022 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 955 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2018 12:00:00 AM | 3 | Width 3ft | 6010767.85313 | 2109551.04982 | 37.7730322274755 | -122.406164302148 | (37.7730322274755, -122.406164302148) | 14 | 2 | 9 | 28853 | 34 | ||
181438 | 189021 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 955 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2018 12:00:00 AM | 3 | Width 3ft | 6010755.67796 | 2109540.70716 | 37.7730031478998 | -122.406205688962 | (37.7730031478998, -122.406205688962) | 14 | 2 | 9 | 28853 | 34 | ||
176399 | 10345 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 954 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6001545.3048 | 2109077.8189 | 37.7712126807777 | -122.43803227825 | (37.7712126807777, -122.43803227825) | 15 | 5 | 11 | 29492 | 9 | |||
156 | 222165 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 953 Elizabeth St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 6000303.11526 | 2101951.8939 | 37.7515759277946 | -122.441817532557 | (37.7515759277946, -122.441817532557) | 2 | 4 | 5 | 28862 | 22 | |||
24776 | 188249 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 950 Key Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6013627.87026 | 2089584.47389 | 37.718367790327 | -122.394872433433 | (37.718367790327, -122.394872433433) | 10 | 3 | 8 | 58 | 1 | |||
161847 | 222234 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 95 Woodland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5997092.80086 | 2105979.68631 | 37.7624517854387 | -122.453209887936 | (37.7624517854387, -122.453209887936) | 15 | 5 | 11 | 29492 | 12 | |||
138213 | 1898 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 95 Beatrice Ln | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6017638.1071524 | 2094354.0127634 | 37.7316861888132 | -122.381342053504 | (37.7316861888132, -122.381342053504) | 10 | 3 | 8 | 58 | 1 | |||
180107 | 1899 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 95 Beatrice Ln | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X4 | 6017638.1071524 | 2094354.0127634 | 37.7316861888132 | -122.381342053504 | (37.7316861888132, -122.381342053504) | 10 | 3 | 8 | 58 | 1 | |||
125991 | 66267 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 948 Key Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/1990 12:00:00 AM | 4 | Permit Number 29374 | 6013650.54179 | 2089569.78312 | 37.7183287129789 | -122.394793038594 | (37.7183287129789, -122.394793038594) | 10 | 3 | 8 | 58 | 1 | ||
118886 | 24477 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 94 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/23/2011 12:00:00 AM | 3 | 3x3 | 6002318.91893 | 2096714.27726 | 37.7373093148834 | -122.434472190244 | (37.7373093148834, -122.434472190244) | 2 | 7 | 5 | 63 | 7 | ||
61097 | 220826 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 932 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6010184.0504 | 2103797.47444 | 37.7572015487229 | -122.407777980881 | (37.7572015487229, -122.407777980881) | 2 | 4 | 7 | 28859 | 19 | |||
119380 | 220891 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 93 Carl St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5998136.73707 | 2107165.08525 | 37.7657663690514 | -122.449684738853 | (37.7657663690514, -122.449684738853) | 15 | 5 | 11 | 29492 | 9 | |||
155588 | 220890 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 93 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5998113.20124 | 2107162.18766 | 37.7657570664623 | -122.449765935051 | (37.7657570664623, -122.449765935051) | 15 | 5 | 11 | 29492 | 9 | |||
146421 | 175708 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 926 Felton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008171.24518 | 2093074.31226 | 37.7276452298388 | -122.413980505196 | (37.7276452298388, -122.413980505196) | 9 | 3 | 7 | 309 | 28 | |||
4453 | 5218 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 923 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 2X3 | 6001447.2358 | 2111647.0619 | 37.7782615998219 | -122.438555619005 | (37.7782615998219, -122.438555619005) | 15 | 5 | 11 | 29490 | 41 | |||
86146 | 16343 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 922X Monterey Blvd | 1 | Median : Cutout | Tree | DPW 1 | 01/19/2013 12:00:00 AM | 3 | 5 | 5996035.52811 | 2094660.72414 | 37.7313120760949 | -122.456048222959 | (37.7313120760949, -122.456048222959) | 9 | 7 | 4 | 59 | 40 | ||
101458 | 16350 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 922X Monterey Blvd | 3 | Median : Cutout | Tree | DPW 1 | 04/23/1998 12:00:00 AM | 3 | 5 | 5995968.77487 | 2094643.75333 | 37.731261646603 | -122.456277773106 | (37.731261646603, -122.456277773106) | 9 | 7 | 4 | 59 | 40 | ||
112054 | 16344 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 922X Monterey Blvd | 2 | Median : Cutout | Tree | DPW 1 | 01/19/2013 12:00:00 AM | 3 | 5 | 5996005.09349 | 2094651.80988 | 37.7312858527477 | -122.456152796109 | (37.7312858527477, -122.456152796109) | 9 | 7 | 4 | 59 | 40 | ||
12140 | 260108 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 921 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008890 | 2090823 | 37.7215039438499 | -122.411336776053 | (37.7215039438499, -122.411336776053) | 9 | 3 | 7 | 309 | 28 | ||||
136306 | 93570 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 920 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 6001322.49897 | 2088870.02328 | 37.7157141688559 | -122.437355737785 | (37.7157141688559, -122.437355737785) | 9 | 7 | 6 | 28861 | 5 | ||||
142050 | 93571 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 920 Madrid St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6001349 | 2088904 | 37.7158089679017 | -122.437266569668 | (37.7158089679017, -122.437266569668) | 9 | 7 | 6 | 28861 | 5 | |||||
137560 | 49972 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 919@ HOFFMAN Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/2003 12:00:00 AM | Permit Number 46723 | 6000510.08423821 | 2101956.9058674 | 37.7516014804748 | -122.441102169267 | (37.7516014804748, -122.441102169267) | 2 | 4 | 5 | 28862 | 22 | |||
82415 | 175707 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 918 Felton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008280.68495 | 2093106.8787 | 37.7277407962862 | -122.413604471666 | (37.7277407962862, -122.413604471666) | 9 | 3 | 7 | 309 | 28 | |||
91480 | 12305 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 916 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6004841.0657 | 2112154.2707 | 37.7798467423901 | -122.426851238143 | (37.7798467423901, -122.426851238143) | 7 | 9 | 11 | 28852 | 41 | |||
116230 | 12306 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 916 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6004837.4799 | 2112172.7972 | 37.7798974088486 | -122.426864962809 | (37.7798974088486, -122.426864962809) | 7 | 9 | 11 | 28852 | 41 | |||
107931 | 222158 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 91 Fountain St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6000382.39845 | 2101161.30106 | 37.7494096678281 | -122.441486636018 | (37.7494096678281, -122.441486636018) | 2 | 4 | 5 | 28862 | 22 | |||
150130 | 222157 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 91 Fountain St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6000384.27386 | 2101137.71396 | 37.7493450101715 | -122.441478458473 | (37.7493450101715, -122.441478458473) | 2 | 4 | 5 | 28862 | 22 | |||
177834 | 222159 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 91 Fountain St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6000381.77611 | 2101180.15259 | 37.7494613941368 | -122.441490140664 | (37.7494613941368, -122.441490140664) | 2 | 4 | 5 | 28862 | 22 | |||
75829 | 125871 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 909 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6011628.14364 | 2118497.28701 | 37.7976445738046 | -122.403818067153 | (37.7976445738046, -122.403818067153) | 3 | 1 | 10 | 308 | 23 | |||
76408 | 125873 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 909 Montgomery St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6011640.68248 | 2118420.88773 | 37.7974355002954 | -122.403769300527 | (37.7974355002954, -122.403769300527) | 3 | 1 | 10 | 308 | 23 | |||
88291 | 125872 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 909 Montgomery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6011632.89499 | 2118465.53836 | 37.7975576651089 | -122.403799390925 | (37.7975576651089, -122.403799390925) | 3 | 1 | 10 | 308 | 23 | |||
145869 | 220944 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 907 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6009418.42173 | 2103772.57355 | 37.7570902855169 | -122.410424074105 | (37.7570902855169, -122.410424074105) | 2 | 4 | 7 | 28859 | 19 | |||
184646 | 113694 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 907 FLORIDA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6009441 | 2103786 | 37.7571284172194 | -122.410346937481 | (37.7571284172194, -122.410346937481) | 2 | 4 | 7 | 28859 | 19 | |||
15047 | 222339 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 902 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003088.6063 | 2102957.06813 | 37.7544942233475 | -122.432256740954 | (37.7544942233475, -122.432256740954) | 2 | 4 | 5 | 28862 | 22 | |||
37915 | 43699 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 901 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | 4 | Permit Number 43342 | 5992748.80796 | 2111348.45458 | 37.7769430589995 | -122.468624685117 | (37.7769430589995, -122.468624685117) | 11 | 6 | 2 | 54 | 11 | |
131960 | 43698 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 901 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | 4 | Permit Number 43342 | 5992720.92787 | 2111349.56559 | 37.7769444989499 | -122.468721210908 | (37.7769444989499, -122.468721210908) | 11 | 6 | 2 | 54 | 11 | |
131864 | 188865 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 900x Carolina St | 41 | Median : Yard | Tree | DPW 1 | 12 | 6012505.22674 | 2103087.46941 | 37.7553817004262 | -122.399700550834 | (37.7553817004262, -122.399700550834) | 10 | 3 | 8 | 28856 | 29 | ||||
144826 | 188866 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 900x Carolina St | 42 | Median : Yard | Tree | DPW 1 | 9 | 6012505.62203 | 2103079.77232 | 37.7553605879327 | -122.399698643375 | (37.7553605879327, -122.399698643375) | 10 | 3 | 8 | 28856 | 29 | ||||
86570 | 204390 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 900 Junipero Serra Blvd | 94 | : | Tree | Private 2 | 5 | Width 0ft | 5991146.57188 | 2090545.43725 | 37.7197306930948 | -122.472650140495 | (37.7197306930948, -122.472650140495) | 9 | 8 | 4 | 64 | 40 | |||
131022 | 204391 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 900 Junipero Serra Blvd | 97 | : | Tree | Private 2 | 4 | Width 0ft | 5991142.05412 | 2090528.37768 | 37.7196835902046 | -122.472664513466 | (37.7196835902046, -122.472664513466) | 9 | 8 | 4 | 64 | 40 | |||
189301 | 204392 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 900 Junipero Serra Blvd | 111 | : | Tree | Private 2 | 2 | Width 0ft | 5991121.6593 | 2090321.76947 | 37.7191151143447 | -122.47271995398 | (37.7191151143447, -122.47271995398) | 9 | 8 | 4 | 64 | 40 | |||
36717 | 220874 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 900 Cole St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5998089.60587 | 2107124.4402 | 37.7656520715013 | -122.449844825399 | (37.7656520715013, -122.449844825399) | 15 | 5 | 11 | 29492 | 9 | |||
64465 | 220873 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 900 Cole St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5998092.16867 | 2107104.06929 | 37.7655962847777 | -122.449834493076 | (37.7655962847777, -122.449834493076) | 15 | 5 | 11 | 29492 | 9 | |||
88592 | 220872 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 900 Cole St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5998095.72246 | 2107084.68783 | 37.7655432715313 | -122.449820804483 | (37.7655432715313, -122.449820804483) | 15 | 5 | 11 | 29492 | 9 | |||
10766 | 189037 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 90 Russ St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6010129.26407 | 2111748.29533 | 37.7790296110535 | -122.408528295169 | (37.7790296110535, -122.408528295169) | 14 | 2 | 9 | 28853 | 34 | |||
10778 | 189038 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 90 Russ St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6010137.33918 | 2111739.58339 | 37.7790061423445 | -122.408499745276 | (37.7790061423445, -122.408499745276) | 14 | 2 | 9 | 28853 | 34 | |||
12936 | 189036 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 90 Russ St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6010111.83402 | 2111767.71706 | 37.7790819623998 | -122.408589963453 | (37.7790819623998, -122.408589963453) | 14 | 2 | 9 | 28853 | 34 | |||
17297 | 189039 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 90 Russ St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010144.76793 | 2111731.54232 | 37.7789844794824 | -122.408473478765 | (37.7789844794824, -122.408473478765) | 14 | 2 | 9 | 28853 | 34 |
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) );