Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▲ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 63348 | 63348 | 188891 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 998 Rhode Island St | 3 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6011866.5048400005 | 2103811.61512 | 37.7573344190536 | -122.401960361001 | (37.7573344190536, -122.401960361001) | |||
| 150688 | 150688 | 188890 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 998 Rhode Island St | 2 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6011864.92725 | 2103833.36661 | 37.7573940557998 | -122.401967346013 | (37.7573940557998, -122.401967346013) | |||
| 161117 | 161117 | 222211 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 998 Chenery St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6001126.04303 | 2096135.59352 | 37.7356525981802 | -122.43855505386999 | (37.7356525981802, -122.43855505387) | |||
| 103306 | 103306 | 118310 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 990 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/2016 12:00:00 AM | 3 | 3x3 | 6011874.0 | 2103773.0 | 37.7572288087602 | -122.40193172517901 | (37.7572288087602, -122.401931725179) | ||
| 140216 | 140216 | 118311 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 990 Rhode Island St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011874.0 | 2103773.0 | 37.7572288087602 | -122.40193172517901 | (37.7572288087602, -122.401931725179) | ||||
| 186795 | 186795 | 204500 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 99 Rosewood Dr | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5994814.30919 | 2095289.8817599998 | 37.73296941779 | -122.460315739002 | (37.73296941779, -122.460315739002) | |||
| 180328 | 180328 | 220926 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 99 Esmeralda Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | 6007313.3532 | 2098768.19788 | 37.743231169794605 | -122.417349591335 | (37.7432311697946, -122.417349591335) | ||||
| 74658 | 74658 | 222250 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 99 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008155.58362 | 2098186.1288400004 | 37.7416802871034 | -122.414396193456 | (37.7416802871034, -122.414396193456) | |||
| 54188 | 54188 | 204491 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 99 Castenada Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5994455.7902 | 2101236.32274 | 37.7492762327102 | -122.461986284554 | (37.7492762327102, -122.461986284554) | |||
| 16916 | 16916 | 4369 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 989 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6001020.80227 | 2096135.40108 | 37.7356460826069 | -122.438918897095 | (37.7356460826069, -122.438918897095) | |||
| 59562 | 59562 | 220940 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 989 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6009176.73244 | 2103397.56801 | 37.756047053048896 | -122.41123344146601 | (37.7560470530489, -122.411233441466) | |||
| 62820 | 62820 | 220942 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 989 Alabama St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6009174.43339 | 2103437.6718200003 | 37.756157040127604 | -122.411244225234 | (37.7561570401276, -122.411244225234) | |||
| 131955 | 131955 | 220939 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 989 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6009179.8123 | 2103380.42673 | 37.7560001596871 | -122.411221579429 | (37.7560001596871, -122.411221579429) | |||
| 168014 | 168014 | 220941 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 989 Alabama St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6009176.43878 | 2103413.72088 | 37.75609138871761 | -122.41123559804599 | (37.7560913887176, -122.411235598046) | |||
| 187378 | 187378 | 220943 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 989 Alabama St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6009173.019619999 | 2103460.05786 | 37.7562184278541 | -122.41125069586201 | (37.7562184278541, -122.411250695862) | |||
| 145849 | 145849 | 116847 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 987 ALABAMA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6009201.0 | 2103425.0 | 37.756123736079296 | -122.41115145346201 | (37.7561237360793, -122.411151453462) | |||
| 68895 | 68895 | 139890 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 983 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6004849.4324 | 2112263.6366 | 37.780147507260295 | -122.426830084895 | (37.7801475072603, -122.426830084895) | |||
| 51830 | 51830 | 139891 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 981 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6004864.9708 | 2112266.0271 | 37.780154949521105 | -122.426776500746 | (37.7801549495211, -122.426776500746) | |||
| 50054 | 50054 | 188989 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 98 Topeka Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6012384.419509999 | 2095296.8499099999 | 37.7339835868704 | -122.399571392929 | (37.7339835868704, -122.399571392929) | |||
| 152313 | 152313 | 188988 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 98 Topeka Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6012367.176419999 | 2095308.0499599997 | 37.7340133787081 | -122.399631794081 | (37.7340133787081, -122.399631794081) | |||
| 56552 | 56552 | 220799 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 98 Rosemont Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005109.9286400005 | 2107867.40022 | 37.7680912352555 | -122.425615931155 | (37.7680912352555, -122.425615931155) | |||
| 78733 | 78733 | 40684 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 98 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/1999 12:00:00 AM | Permit Number 41667 | 6004026.21190005 | 2093997.85413123 | 37.7299473965939 | -122.428375735336 | (37.7299473965939, -122.428375735336) | ||
| 105829 | 105829 | 94064 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 98 Ney St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Tree 4 on Craut | 6004036.0 | 2094004.0 | 37.7299648256421 | -122.42834233456199 | (37.7299648256421, -122.428342334562) | ||||
| 121161 | 121161 | 94061 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 98 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Tree 1 on Craut. | 6004036.0 | 2094004.0 | 37.7299648256421 | -122.42834233456199 | (37.7299648256421, -122.428342334562) | ||||
| 128840 | 128840 | 94065 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 98 Ney St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Tree 5 on Craut | 6004036.0 | 2094004.0 | 37.7299648256421 | -122.42834233456199 | (37.7299648256421, -122.428342334562) | ||||
| 142740 | 142740 | 94062 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 98 Ney St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Tree 2 on Craut | 6004036.0 | 2094004.0 | 37.7299648256421 | -122.42834233456199 | (37.7299648256421, -122.428342334562) | ||||
| 145528 | 145528 | 94063 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 98 Ney St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Tree 3 on Craut | 6004036.0 | 2094004.0 | 37.7299648256421 | -122.42834233456199 | (37.7299648256421, -122.428342334562) | ||||
| 48238 | 48238 | 188985 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 98 Maddux Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6012675.20565 | 2095233.0388900002 | 37.7338245795424 | -122.39856157297599 | (37.7338245795424, -122.398561572976) | |||
| 70902 | 70902 | 188983 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 98 Maddux Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6012689.1535 | 2095267.6369 | 37.733920355539496 | -122.398515777692 | (37.7339203555395, -122.398515777692) | |||
| 168952 | 168952 | 188986 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 98 Maddux Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6012667.64033 | 2095215.60548 | 37.7337762895405 | -122.398586505788 | (37.7337762895405, -122.398586505788) | |||
| 176157 | 176157 | 188984 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 98 Maddux Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6012682.9211 | 2095250.61598 | 37.733873272417995 | -122.39853613116301 | (37.733873272418, -122.398536131163) | |||
| 81480 | 81480 | 12316 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 977X Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6004927.25201 | 2112274.40172 | 37.7801814652814 | -122.42656163800899 | (37.7801814652814, -122.426561638009) | |||
| 91507 | 91507 | 12317 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 977X Golden Gate Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6004927.25201 | 2112274.40172 | 37.7801814652814 | -122.42656163800899 | (37.7801814652814, -122.426561638009) | |||
| 93646 | 93646 | 12314 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 977X Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6004927.25201 | 2112274.40172 | 37.7801814652814 | -122.42656163800899 | (37.7801814652814, -122.426561638009) | |||
| 96510 | 96510 | 12313 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 977X Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6004927.25201 | 2112274.40172 | 37.7801814652814 | -122.42656163800899 | (37.7801814652814, -122.426561638009) | |||
| 60080 | 60080 | 139893 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 977 Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6004903.219 | 2112271.4058 | 37.7801718805445 | -122.426644565829 | (37.7801718805445, -122.426644565829) | |||
| 76783 | 76783 | 222163 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 976 Elizabeth St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 4ft | 6000221.60157 | 2101988.12675 | 37.7516707693994 | -122.442102016907 | (37.7516707693994, -122.442102016907) | |||
| 166351 | 166351 | 222164 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 976 Elizabeth St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 23 | Width 4ft | 6000208.07575 | 2101987.18481 | 37.75166741222971 | -122.442148723208 | (37.7516674122297, -122.442148723208) | |||
| 58855 | 58855 | 220976 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 976 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5999674.18821 | 2101792.42886 | 37.7511022189001 | -122.443980977643 | (37.7511022189001, -122.443980977643) | |||
| 135852 | 135852 | 139894 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 975 Golden Gate Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6004921.7454 | 2112273.7963 | 37.7801794916425 | -122.42658064478 | (37.7801794916425, -122.42658064478) | |||
| 111382 | 111382 | 42188 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 975 Bryant St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42468 | 6010750.56133351 | 2109544.8068813 | 37.7730141185867 | -122.40622367699301 | (37.7730141185867, -122.406223676993) | ||
| 119454 | 119454 | 42187 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 975 Bryant St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42468 | 6010750.56133351 | 2109544.8068813 | 37.7730141185867 | -122.40622367699301 | (37.7730141185867, -122.406223676993) | ||
| 23720 | 23720 | 188872 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 969 De Haro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6012202.49655 | 2103904.7568 | 37.757608911948104 | -122.40080490573798 | (37.7576089119481, -122.400804905738) | |||
| 154816 | 154816 | 31902 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 965 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2003 12:00:00 AM | 14 | Permit Number 35327 | 6008027.66279 | 2109898.08591 | 37.7738314549808 | -122.415667565898 | (37.7738314549808, -122.415667565898) | |
| 21998 | 21998 | 22832 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 96 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 5999484.67049 | 2098974.10299 | 37.743352964077395 | -122.44443382318 | (37.7433529640774, -122.44443382318) | |||
| 118677 | 118677 | 36024 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 96 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39171 | 6007289.27861972 | 2098814.18555513 | 37.7433560871509 | -122.417436093563 | (37.7433560871509, -122.417436093563) | ||
| 21017 | 21017 | 1925 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 96 Berkeley Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6001058.612819999 | 2097389.17311 | 37.7390907990037 | -122.43887799141899 | (37.7390907990037, -122.438877991419) | |||
| 156777 | 156777 | 188903 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 959 Kansas St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 2ft | 6011647.627069999 | 2103912.94015 | 37.7576004169513 | -122.402724456485 | (37.7576004169513, -122.402724456485) | |||
| 58365 | 58365 | 189021 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 955 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6010755.67796 | 2109540.7071599998 | 37.77300314789979 | -122.406205688962 | (37.7730031478998, -122.406205688962) | |||
| 60099 | 60099 | 189025 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 955 Bryant St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6010814.25369 | 2109596.96764 | 37.773160902494794 | -122.406007031421 | (37.7731609024948, -122.406007031421) | |||
| 66129 | 66129 | 189026 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 955 Bryant St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6010848.733440001 | 2109624.73915 | 37.7732390850389 | -122.405889717541 | (37.7732390850389, -122.405889717541) | |||
| 133234 | 133234 | 189023 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 955 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6010789.051969999 | 2109573.65252 | 37.7730954749965 | -122.406092565024 | (37.7730954749965, -122.406092565024) | |||
| 162765 | 162765 | 189022 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 955 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010767.853130001 | 2109551.0498200003 | 37.7730322274755 | -122.406164302148 | (37.7730322274755, -122.406164302148) | |||
| 171185 | 171185 | 189024 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 955 Bryant St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010801.221969999 | 2109583.7303299997 | 37.7731238270259 | -122.40605117733601 | (37.7731238270259, -122.406051177336) | |||
| 17970 | 17970 | 10345 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 954 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6001545.3048 | 2109077.8189 | 37.7712126807777 | -122.43803227825 | (37.7712126807777, -122.43803227825) | |||
| 25836 | 25836 | 222165 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 953 Elizabeth St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 6000303.115259999 | 2101951.8939 | 37.7515759277946 | -122.441817532557 | (37.7515759277946, -122.441817532557) | |||
| 148825 | 148825 | 188249 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 950 Key Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6013627.87026 | 2089584.4738900003 | 37.718367790327 | -122.394872433433 | (37.718367790327, -122.394872433433) | |||
| 157546 | 157546 | 222234 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 95 Woodland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5997092.80086 | 2105979.68631 | 37.76245178543871 | -122.453209887936 | (37.7624517854387, -122.453209887936) | |||
| 115809 | 115809 | 1898 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 95 Beatrice Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6017638.107152401 | 2094354.0127633999 | 37.73168618881321 | -122.38134205350401 | (37.7316861888132, -122.381342053504) | |||
| 141879 | 141879 | 1899 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 95 Beatrice Ln | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X4 | 6017638.107152401 | 2094354.0127633999 | 37.73168618881321 | -122.38134205350401 | (37.7316861888132, -122.381342053504) | |||
| 161907 | 161907 | 66267 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 948 Key Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/1990 12:00:00 AM | 4 | Permit Number 29374 | 6013650.54179 | 2089569.78312 | 37.718328712978895 | -122.394793038594 | (37.7183287129789, -122.394793038594) | ||
| 20092 | 20092 | 24477 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 94 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/23/2011 12:00:00 AM | 3 | 3x3 | 6002318.918930001 | 2096714.27726 | 37.7373093148834 | -122.43447219024401 | (37.7373093148834, -122.434472190244) | ||
| 32137 | 32137 | 220826 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 932 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6010184.0504 | 2103797.47444 | 37.7572015487229 | -122.40777798088101 | (37.7572015487229, -122.407777980881) | |||
| 174474 | 174474 | 220891 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 93 Carl St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5998136.73707 | 2107165.08525 | 37.7657663690514 | -122.449684738853 | (37.7657663690514, -122.449684738853) | |||
| 175814 | 175814 | 220890 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 93 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5998113.20124 | 2107162.18766 | 37.7657570664623 | -122.449765935051 | (37.7657570664623, -122.449765935051) | |||
| 149996 | 149996 | 175708 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 926 Felton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008171.245180001 | 2093074.3122599998 | 37.72764522983879 | -122.413980505196 | (37.7276452298388, -122.413980505196) | |||
| 7607 | 7607 | 5218 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 923 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 2X3 | 6001447.2358 | 2111647.0619 | 37.778261599821896 | -122.43855561900499 | (37.7782615998219, -122.438555619005) | |||
| 18988 | 18988 | 16343 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 922X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/19/2013 12:00:00 AM | 3 | 5 | 5996035.52811 | 2094660.72414 | 37.7313120760949 | -122.456048222959 | (37.7313120760949, -122.456048222959) | ||
| 19627 | 19627 | 16344 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 922X Monterey Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/19/2013 12:00:00 AM | 3 | 5 | 5996005.09349 | 2094651.8098799998 | 37.7312858527477 | -122.45615279610901 | (37.7312858527477, -122.456152796109) | ||
| 19703 | 19703 | 16350 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 922X Monterey Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/23/1998 12:00:00 AM | 3 | 5 | 5995968.77487 | 2094643.75333 | 37.731261646602995 | -122.45627777310601 | (37.731261646603, -122.456277773106) | ||
| 60168 | 60168 | 93570 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 920 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 6001322.49897 | 2088870.0232799998 | 37.715714168855904 | -122.437355737785 | (37.7157141688559, -122.437355737785) | ||||
| 115122 | 115122 | 93571 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 920 Madrid St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6001349.0 | 2088904.0 | 37.7158089679017 | -122.43726656966801 | (37.7158089679017, -122.437266569668) | |||||
| 114929 | 114929 | 49972 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 919@ HOFFMAN Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/2003 12:00:00 AM | Permit Number 46723 | 6000510.08423821 | 2101956.9058674 | 37.7516014804748 | -122.44110216926701 | (37.7516014804748, -122.441102169267) | |||
| 44395 | 44395 | 175707 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 918 Felton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008280.68495 | 2093106.8787 | 37.7277407962862 | -122.41360447166599 | (37.7277407962862, -122.413604471666) | |||
| 3450 | 3450 | 12305 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 916 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004841.0657 | 2112154.2707 | 37.779846742390106 | -122.426851238143 | (37.7798467423901, -122.426851238143) | |||
| 8524 | 8524 | 12306 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 916 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004837.4799 | 2112172.7972 | 37.7798974088486 | -122.42686496280899 | (37.7798974088486, -122.426864962809) | |||
| 44788 | 44788 | 222158 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 91 Fountain St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6000382.39845 | 2101161.30106 | 37.749409667828104 | -122.44148663601801 | (37.7494096678281, -122.441486636018) | |||
| 131463 | 131463 | 222159 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 91 Fountain St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6000381.77611 | 2101180.15259 | 37.749461394136794 | -122.441490140664 | (37.7494613941368, -122.441490140664) | |||
| 172275 | 172275 | 222157 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 91 Fountain St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6000384.27386 | 2101137.71396 | 37.7493450101715 | -122.441478458473 | (37.7493450101715, -122.441478458473) | |||
| 47163 | 47163 | 125873 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 909 Montgomery St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6011640.68248 | 2118420.88773 | 37.7974355002954 | -122.403769300527 | (37.7974355002954, -122.403769300527) | |||
| 69897 | 69897 | 125872 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 909 Montgomery St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6011632.89499 | 2118465.5383599997 | 37.7975576651089 | -122.403799390925 | (37.7975576651089, -122.403799390925) | |||
| 150606 | 150606 | 125871 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 909 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6011628.14364 | 2118497.2870099996 | 37.797644573804604 | -122.403818067153 | (37.7976445738046, -122.403818067153) | |||
| 50420 | 50420 | 220944 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 907 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6009418.4217300005 | 2103772.57355 | 37.757090285516895 | -122.410424074105 | (37.7570902855169, -122.410424074105) | |||
| 140045 | 140045 | 113694 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 907 FLORIDA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6009441.0 | 2103786.0 | 37.7571284172194 | -122.41034693748101 | (37.7571284172194, -122.410346937481) | |||
| 189109 | 189109 | 222339 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 902 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003088.6063 | 2102957.06813 | 37.7544942233475 | -122.432256740954 | (37.7544942233475, -122.432256740954) | |||
| 157515 | 157515 | 43699 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 901 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | 4 | Permit Number 43342 | 5992748.80796 | 2111348.45458 | 37.7769430589995 | -122.46862468511699 | (37.7769430589995, -122.468624685117) | |
| 178839 | 178839 | 43698 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 901 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | 4 | Permit Number 43342 | 5992720.92787 | 2111349.5655900002 | 37.7769444989499 | -122.46872121090799 | (37.7769444989499, -122.468721210908) | |
| 150115 | 150115 | 188865 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 900x Carolina St | 41 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6012505.22674 | 2103087.46941 | 37.7553817004262 | -122.39970055083401 | (37.7553817004262, -122.399700550834) | ||||
| 162994 | 162994 | 188866 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 900x Carolina St | 42 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | 6012505.62203 | 2103079.77232 | 37.7553605879327 | -122.39969864337499 | (37.7553605879327, -122.399698643375) | ||||
| 40952 | 40952 | 204391 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 900 Junipero Serra Blvd | 97 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991142.0541199995 | 2090528.37768 | 37.7196835902046 | -122.472664513466 | (37.7196835902046, -122.472664513466) | |||
| 147633 | 147633 | 204392 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 900 Junipero Serra Blvd | 111 | : 4 | Tree 1 | Private 1 | 2 | Width 0ft | 5991121.6593 | 2090321.7694700002 | 37.7191151143447 | -122.47271995398 | (37.7191151143447, -122.47271995398) | |||
| 185997 | 185997 | 204390 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 900 Junipero Serra Blvd | 94 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5991146.571880001 | 2090545.43725 | 37.719730693094796 | -122.47265014049499 | (37.7197306930948, -122.472650140495) | |||
| 57113 | 57113 | 220874 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 900 Cole St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5998089.60587 | 2107124.4402 | 37.7656520715013 | -122.449844825399 | (37.7656520715013, -122.449844825399) | |||
| 63567 | 63567 | 220873 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 900 Cole St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5998092.16867 | 2107104.06929 | 37.7655962847777 | -122.449834493076 | (37.7655962847777, -122.449834493076) | |||
| 132261 | 132261 | 220872 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 900 Cole St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5998095.72246 | 2107084.6878299997 | 37.76554327153129 | -122.449820804483 | (37.7655432715313, -122.449820804483) | |||
| 100999 | 100999 | 18812 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 90 Rosie Lee Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X4 | 6017743.9455674 | 2094518.0196352 | 37.732142361857704 | -122.380987543086 | (37.7321423618577, -122.380987543086) | |||
| 33532 | 33532 | 204583 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 90 Melrose Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5999525.43351 | 2095520.39174 | 37.7338722184278 | -122.444044768346 | (37.7338722184278, -122.444044768346) | |||
| 81747 | 81747 | 122384 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 90 Melrose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | 5999501.0 | 2095545.0 | 37.7339383930574 | -122.444131009745 | (37.7339383930574, -122.444131009745) | ||||
| 96218 | 96218 | 122383 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 90 Melrose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x2 | 5999501.0 | 2095545.0 | 37.7339383930574 | -122.444131009745 | (37.7339383930574, -122.444131009745) | |||
| 176477 | 176477 | 204582 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 90 Melrose Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 8ft | 5999570.33408 | 2095534.33569 | 37.7339130665349 | -122.443890535522 | (37.7339130665349, -122.443890535522) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");