trees
953 rows where qSpecies_id = 60 sorted by Longitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30618 | 97004 | Property Tree 8 | Callistemon viminalis :: Weeping Bottlebrush 60 | 195A Kiska Rd | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | 10 | 3 | 8 | 58 | 1 | |||||
125967 | 96999 | Property Tree 8 | Callistemon viminalis :: Weeping Bottlebrush 60 | 195A Kiska Rd | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | 10 | 3 | 8 | 58 | 1 | |||||
47354 | 18799 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 36 Rosie Lee Ln | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6017963.3534873 | 2094445.0871971 | 37.7319542116677 | -122.380223926679 | (37.7319542116677, -122.380223926679) | 10 | 3 | 8 | 58 | 1 | |||
155430 | 12947 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 35 Lillian St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6017849.3606965 | 2094492.6056632 | 37.7320783980043 | -122.380621329929 | (37.7320783980043, -122.380621329929) | 10 | 3 | 8 | 58 | 1 | |||
53975 | 10882 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1175X Hudson Ave | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X4 | 6017544.4990408 | 2094830.7506973 | 37.7329900490522 | -122.381698823278 | (37.7329900490522, -122.381698823278) | 10 | 3 | 8 | 58 | 1 | |||
65476 | 106091 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1200 HUDSON AVE | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3x3 | 6017390 | 2095089 | 37.7336906184027 | -122.382250932174 | (37.7336906184027, -122.382250932174) | 10 | 3 | 8 | 58 | 1 | |||
50927 | 26893 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1275X HUDSON AVE | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/09/1999 12:00:00 AM | 6 | 3X4 | 6017281 | 2095243 | 37.734107450868 | -122.382638493216 | (37.734107450868, -122.382638493216) | 10 | 3 | 8 | 58 | 1 | ||
82067 | 10863 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1275X HUDSON AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2016 12:00:00 AM | 6 | 3X4 | 6017281 | 2095243 | 37.734107450868 | -122.382638493216 | (37.734107450868, -122.382638493216) | 10 | 3 | 8 | 58 | 1 | ||
86372 | 10855 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1299X HUDSON AVE | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/21/1996 12:00:00 AM | 6 | 3X4 | 6017281 | 2095243 | 37.734107450868 | -122.382638493216 | (37.734107450868, -122.382638493216) | 10 | 3 | 8 | 58 | 1 | ||
113064 | 251280 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1275x Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 03/11/2006 12:00:00 AM | 3x3 | 6017281 | 2095243 | 37.734107450868 | -122.382638493216 | (37.734107450868, -122.382638493216) | 10 | 3 | 8 | 58 | 1 | ||
128759 | 251281 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1275x Hudson Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 03/23/2006 12:00:00 AM | 3x3 | 6017281 | 2095243 | 37.734107450868 | -122.382638493216 | (37.734107450868, -122.382638493216) | 10 | 3 | 8 | 58 | 1 | ||
144380 | 10852 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1299X HUDSON AVE | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2016 12:00:00 AM | 3 | 3X4 | 6017281 | 2095243 | 37.734107450868 | -122.382638493216 | (37.734107450868, -122.382638493216) | 10 | 3 | 8 | 58 | 1 | ||
185134 | 10864 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1275X HUDSON AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/1993 12:00:00 AM | 6 | 3X4 | 6017281 | 2095243 | 37.734107450868 | -122.382638493216 | (37.734107450868, -122.382638493216) | 10 | 3 | 8 | 58 | 1 | ||
189422 | 10856 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1299X HUDSON AVE | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/21/1996 12:00:00 AM | 6 | 3X4 | 6017281 | 2095243 | 37.734107450868 | -122.382638493216 | (37.734107450868, -122.382638493216) | 10 | 3 | 8 | 58 | 1 | ||
26959 | 10888 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1270X Hudson Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/1996 12:00:00 AM | 6 | 3X4 | 6017265.0162454 | 2095327.7862917 | 37.734339374173 | -122.382699652574 | (37.734339374173, -122.382699652574) | 10 | 3 | 8 | 58 | 1 | ||
87411 | 10887 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1270X Hudson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/1996 12:00:00 AM | 6 | 3X4 | 6017265.0162454 | 2095327.7862917 | 37.734339374173 | -122.382699652574 | (37.734339374173, -122.382699652574) | 10 | 3 | 8 | 58 | 1 | ||
91061 | 188355 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1339 Hudson Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017230.94644 | 2095282.00984 | 37.7342117988404 | -122.38281425957 | (37.7342117988404, -122.38281425957) | 10 | 3 | 8 | 58 | 1 | |||
34591 | 251286 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1299x Hudson Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 02/09/1998 12:00:00 AM | 3x3 | 6017207 | 2095414 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | 10 | 3 | 8 | 58 | 1 | ||
45337 | 251284 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1299x Hudson Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 06/21/1996 12:00:00 AM | 3x3 | 6017207 | 2095414 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | 10 | 3 | 8 | 58 | 1 | ||
83418 | 251282 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1299x Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 04/07/2016 12:00:00 AM | 3x3 | 6017207 | 2095414 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | 10 | 3 | 8 | 58 | 1 | ||
134399 | 251283 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1299x Hudson Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 06/06/1997 12:00:00 AM | 3x3 | 6017207 | 2095414 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | 10 | 3 | 8 | 58 | 1 | ||
167923 | 251287 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1299x Hudson Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 02/09/1998 12:00:00 AM | 3x3 | 6017207 | 2095414 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | 10 | 3 | 8 | 58 | 1 | ||
177377 | 188354 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1341 Hudson Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017148.15295 | 2095467.55143 | 37.73471668451 | -122.383113415457 | (37.73471668451, -122.383113415457) | 10 | 3 | 8 | 58 | 1 | |||
22794 | 188356 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1334 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6017138.82287 | 2095616.15283 | 37.7351241988078 | -122.383156012747 | (37.7351241988078, -122.383156012747) | 10 | 3 | 8 | 58 | 1 | |||
165759 | 188357 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1334 Hudson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6017134.51139 | 2095632.2409 | 37.7351681351926 | -122.38317203866 | (37.7351681351926, -122.38317203866) | 10 | 3 | 8 | 58 | 1 | |||
56097 | 188358 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1334 Hudson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017132.81962 | 2095655.66164 | 37.7352323503922 | -122.383179517428 | (37.7352323503922, -122.383179517428) | 10 | 3 | 8 | 58 | 1 | |||
178278 | 188353 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1341 Hudson Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6017129.66281 | 2095538.69019 | 37.7349109956364 | -122.383182292729 | (37.7349109956364, -122.383182292729) | 10 | 3 | 8 | 58 | 1 | |||
166124 | 188359 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1334 Hudson Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6017127.71147 | 2095678.22784 | 37.7352940304027 | -122.383198748549 | (37.7352940304027, -122.383198748549) | 10 | 3 | 8 | 58 | 1 | |||
164970 | 188352 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1341 Hudson Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6017123.51694 | 2095558.35639 | 37.7349646554818 | -122.383204909781 | (37.7349646554818, -122.383204909781) | 10 | 3 | 8 | 58 | 1 | |||
167176 | 188351 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1341 Hudson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6017067.0525 | 2095737.14869 | 37.7354524630578 | -122.383412571329 | (37.7354524630578, -122.383412571329) | 10 | 3 | 8 | 58 | 1 | |||
74586 | 113271 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1321 Revere Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/2015 12:00:00 AM | Permit Number 774420 | 6016529.9 | 2093260 | 37.7286210040554 | -122.385097187433 | (37.7286210040554, -122.385097187433) | 10 | 3 | 8 | 58 | 1 | ||||
150566 | 5808 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 22 Dukes Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/02/2012 12:00:00 AM | 3 | 6016199.5009328 | 2096264.8663221 | 37.7368534841098 | -122.38644883389 | (37.7368534841098, -122.38644883389) | 10 | 3 | 8 | 58 | 1 | |||
53393 | 188350 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2 Dukes Ct | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6016183.29888 | 2096350.88685 | 37.7370887822104 | -122.386510848195 | (37.7370887822104, -122.386510848195) | 10 | 3 | 8 | 58 | 1 | |||
188978 | 51756 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1350 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2005 12:00:00 AM | Permit Number 48024 | 6016094.75384316 | 2092981.324561 | 37.7278317360968 | -122.386582102799 | (37.7278317360968, -122.386582102799) | 10 | 3 | 8 | 58 | 1 | |||
110324 | 26698 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 89 Dukes Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X4 | 6016127.0690519 | 2096424.3370058 | 37.7372873485592 | -122.386710382374 | (37.7372873485592, -122.386710382374) | 10 | 3 | 8 | 58 | 1 | |||
110273 | 38557 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1511 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 12 | Permit Number 40522 | 6015824.3664 | 2095556.8722 | 37.7348887022439 | -122.3876964685 | (37.7348887022439, -122.3876964685) | 10 | 3 | 8 | 58 | 1 | |
25164 | 56716 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1522 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6015807.4304 | 2095648.0005 | 37.7351379840188 | -122.387761378928 | (37.7351379840188, -122.387761378928) | 10 | 3 | 8 | 58 | 1 | ||||
18161 | 56725 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1519 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 6015793.5491 | 2095580.2933 | 37.7349513047544 | -122.387804649295 | (37.7349513047544, -122.387804649295) | 10 | 3 | 8 | 58 | 1 | ||||
81632 | 56717 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1526 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 6015787.6443 | 2095659.5423 | 37.7351685794067 | -122.387830592307 | (37.7351685794067, -122.387830592307) | 10 | 3 | 8 | 58 | 1 | ||||
26892 | 56727 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1531 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 6015734.3799 | 2095622.8211 | 37.7350647995931 | -122.388012186614 | (37.7350647995931, -122.388012186614) | 10 | 3 | 8 | 58 | 1 | ||||
186107 | 200794 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1550 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6015667.8289 | 2095751.3276 | 37.7354139651728 | -122.388251244981 | (37.7354139651728, -122.388251244981) | 10 | 3 | 8 | 58 | 1 | |||
67658 | 56722 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1560 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/12/1974 12:00:00 AM | 9 | Permit Number 13995 | 6015605.7227 | 2095794.747 | 37.7355297446147 | -122.388469000899 | (37.7355297446147, -122.388469000899) | 10 | 3 | 8 | 58 | 1 | ||
80649 | 200647 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1579 McKinnon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6015511.5711 | 2095791.0834 | 37.73551446721 | -122.388794265849 | (37.73551446721, -122.388794265849) | 10 | 3 | 8 | 58 | 1 | |||
102422 | 56732 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1579 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6015489.3827 | 2095804.643 | 37.7355504693065 | -122.388871926567 | (37.7355504693065, -122.388871926567) | 10 | 3 | 8 | 58 | 1 | ||||
158962 | 56733 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1583 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Permit Number 780681 | 6015469.0433 | 2095825.5988 | 37.7356068823061 | -122.388943710821 | (37.7356068823061, -122.388943710821) | 10 | 3 | 8 | 58 | 1 | |||
135162 | 188304 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 601 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6015659.79181 | 2105320.44232 | 37.7616883131784 | -122.388946905678 | (37.7616883131784, -122.388946905678) | 10 | 3 | 8 | 28856 | 29 | |||
31303 | 188306 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 635 Tennessee St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6015455.75158 | 2106081.00048 | 37.7637653298293 | -122.38970572754 | (37.7637653298293, -122.38970572754) | 14 | 3 | 8 | 28856 | 29 | |||
65937 | 188305 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 635 Tennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6015454.10981 | 2106058.18427 | 37.7637025904139 | -122.389709812266 | (37.7637025904139, -122.389709812266) | 14 | 3 | 8 | 28856 | 29 | |||
141840 | 188307 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 635 Tennessee St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6015454.50593 | 2106102.86687 | 37.7638253011319 | -122.389711563256 | (37.7638253011319, -122.389711563256) | 14 | 3 | 8 | 28856 | 29 | |||
162844 | 106009 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1745 LANE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6014990.1 | 2094194.5 | 37.7311016564679 | -122.390485679987 | (37.7311016564679, -122.390485679987) | 10 | 3 | 8 | 58 | 1 | |||
88998 | 97048 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1590X Shafter Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6014988.7 | 2094146.3 | 37.7309692313217 | -122.39048715342 | (37.7309692313217, -122.39048715342) | 10 | 3 | 8 | 58 | 1 | |||
123503 | 97047 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1590X Shafter Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6014988.7 | 2094146.3 | 37.7309692313217 | -122.39048715342 | (37.7309692313217, -122.39048715342) | 10 | 3 | 8 | 58 | 1 | |||
87310 | 97046 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1590X SHAFTER AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6014988 | 2094146 | 37.7309683687499 | -122.390489552503 | (37.7309683687499, -122.390489552503) | 10 | 3 | 8 | 58 | 1 | |||
66804 | 48736 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1633 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/26/2002 12:00:00 AM | Permit Number 46017 | 6015017.13579754 | 2095815.21126112 | 37.7355533009373 | -122.39050541553 | (37.7355533009373, -122.39050541553) | 10 | 3 | 8 | 58 | 1 | ||
165430 | 40030 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1637 Newcomb Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | 3 | Permit Number 41272 | 6014878.68368 | 2095916.71611 | 37.735824330914 | -122.390991193288 | (37.735824330914, -122.390991193288) | 10 | 3 | 8 | 58 | 1 | |
144523 | 36805 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1450 Donner Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | 10 | Permit Number 39531 | 6014737.8573 | 2091203.2549 | 37.7228743001584 | -122.39114872971 | (37.7228743001584, -122.39114872971) | 10 | 3 | 8 | 58 | 1 | |
190026 | 36806 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1450 Donner Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | 4 | Permit Number 39531 | 6014725.6758 | 2091211.782 | 37.7228970378734 | -122.391191434704 | (37.7228970378734, -122.391191434704) | 10 | 3 | 8 | 58 | 1 | |
63122 | 36807 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1450 Donner Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | 8 | Permit Number 39531 | 6014713.4944 | 2091220.9181 | 37.7229214477716 | -122.391234181927 | (37.7229214477716, -122.391234181927) | 10 | 3 | 8 | 58 | 1 | |
80527 | 49416 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 17643RD/PHELPS La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2003 12:00:00 AM | 9 | Permit Number 46362 | 6014695.16416 | 2096823.71289 | 37.7383045729921 | -122.391689093304 | (37.7383045729921, -122.391689093304) | 10 | 3 | 8 | 58 | 1 | ||
194164 | 188349 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1764 La Salle Ave | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6014694.72418 | 2096821.3256 | 37.7382979935614 | -122.391690447682 | (37.7382979935614, -122.391690447682) | 10 | 3 | 8 | 58 | 1 | |||
152916 | 42713 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1740 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | 8 | Permit Number 42726 | 6014522.39227 | 2095210.25322 | 37.7338647513416 | -122.392173650716 | (37.7338647513416, -122.392173650716) | 10 | 3 | 8 | 58 | 1 | |
50057 | 188346 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1716 Revere Ave | 2 | : | Tree | Private 2 | 8 | Width 3ft | 6014499.65662 | 2094860.17735 | 37.7329022519179 | -122.392227779994 | (37.7329022519179, -122.392227779994) | 10 | 3 | 8 | 58 | 1 | |||
114027 | 188337 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1578 Newhall St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 6014186.28626 | 2095457.72756 | 37.7345255974821 | -122.393352991941 | (37.7345255974821, -122.393352991941) | 10 | 3 | 8 | 58 | 1 | |||
176596 | 188338 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1580 Newhall St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 6014174.61235 | 2095442.29815 | 37.7344825828894 | -122.39339227343 | (37.7344825828894, -122.39339227343) | 10 | 3 | 8 | 58 | 1 | |||
161055 | 44281 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1588 Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2001 12:00:00 AM | 7 | Permit Number 43704 | 6014169.38647 | 2095432.395 | 37.734455100518 | -122.393409648353 | (37.734455100518, -122.393409648353) | 10 | 3 | 8 | 58 | 1 | ||
5884 | 44280 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1588 Newhall St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2001 12:00:00 AM | 7 | Permit Number 43704 | 6014158.82633 | 2095418.03078 | 37.734415072582 | -122.393445153596 | (37.734415072582, -122.393445153596) | 10 | 3 | 8 | 58 | 1 | ||
109747 | 54597 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 630 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/1972 12:00:00 AM | 19 | Permit Number 10420 | 6014092.76415 | 2104176.14538 | 37.7584593387525 | -122.394286543097 | (37.7584593387525, -122.394286543097) | 10 | 3 | 8 | 28856 | 29 | ||
63443 | 116373 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 366 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6014023.28278 | 2105408.18049 | 37.7618383767519 | -122.394613116617 | (37.7618383767519, -122.394613116617) | 10 | 3 | 8 | 28856 | 29 | |||
77285 | 114570 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 366 MISSISSIPPI ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014008 | 2105399 | 37.7618123194661 | -122.394665331171 | (37.7618123194661, -122.394665331171) | 10 | 3 | 8 | 28856 | 29 | ||||
188055 | 188331 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 612 Texas St | 1 | : | Tree | Private 2 | 18 | Width 4ft | 6013806.03622 | 2104232.11636 | 37.7585970807056 | -122.395282104281 | (37.7585970807056, -122.395282104281) | 10 | 3 | 8 | 28856 | 29 | |||
103736 | 188330 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 214 Texas St | 1 | : | Tree | Private 2 | 13 | Width 3ft | 6013707.23683 | 2106019.48516 | 37.7634993094715 | -122.395749036807 | (37.7634993094715, -122.395749036807) | 14 | 3 | 8 | 28856 | 29 | |||
155842 | 107041 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1301 18TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6013691.7 | 2105657.2 | 37.7625036896712 | -122.395777387543 | (37.7625036896712, -122.395777387543) | 10 | 3 | 8 | 28856 | 29 | ||||
61208 | 188348 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 135 Bridgeview Dr | 1 | : | Tree | Private 2 | 11 | Width 2ft | 6013321.68612 | 2095651.63967 | 37.7350099660289 | -122.396355810291 | (37.7350099660289, -122.396355810291) | 10 | 3 | 8 | 58 | 1 | |||
65055 | 101156 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1490X 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6013453.76144 | 2105247.59109 | 37.7613657542352 | -122.396571621485 | (37.7613657542352, -122.396571621485) | 10 | 3 | 8 | 28856 | 29 | |||
84768 | 188333 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 300 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6013450.64323 | 2105637.16099 | 37.7624352541126 | -122.396609715869 | (37.7624352541126, -122.396609715869) | 10 | 3 | 8 | 28856 | 29 | |||
101359 | 101157 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1490X 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6x5 | 6013434.11839 | 2105245.81969 | 37.7613597971466 | -122.396639434871 | (37.7613597971466, -122.396639434871) | 10 | 3 | 8 | 28856 | 29 | |||
35110 | 188332 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 288 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6013443.088 | 2105758.2954 | 37.7627674420819 | -122.396644338879 | (37.7627674420819, -122.396644338879) | 14 | 3 | 8 | 28856 | 29 | |||
117544 | 101158 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1490X 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 6x5 | 6013408.6905 | 2105245.25033 | 37.7613568185891 | -122.396727339995 | (37.7613568185891, -122.396727339995) | 10 | 3 | 8 | 28856 | 29 | |||
37552 | 101159 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1490X 19th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6013387.24003 | 2105243.87751 | 37.7613518552239 | -122.396801432457 | (37.7613518552239, -122.396801432457) | 10 | 3 | 8 | 28856 | 29 | |||
58365 | 188334 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1490 19th St | 1 | : | Tree | Private 2 | 13 | Width 4ft | 6013355.93912 | 2105240.17326 | 37.7613399419185 | -122.396909430223 | (37.7613399419185, -122.396909430223) | 10 | 3 | 8 | 28856 | 29 | |||
84711 | 188335 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1490 19th St | 2 | : | Tree | Private 2 | 12 | Width 5ft | 6013335.43042 | 2105239.42727 | 37.761336752 | -122.396980309397 | (37.761336752, -122.396980309397) | 10 | 3 | 8 | 28856 | 29 | |||
66946 | 188341 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2351 Silver Ave | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6013156.07372 | 2096444.56636 | 37.7371779607887 | -122.396983972339 | (37.7371779607887, -122.396983972339) | 10 | 3 | 8 | 58 | 1 | |||
163055 | 188336 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1490 19th St | 3 | : | Tree | Private 2 | 11 | Width 5ft | 6013315.97127 | 2105238.81397 | 37.7613339848017 | -122.397047567891 | (37.7613339848017, -122.397047567891) | 10 | 3 | 8 | 28856 | 29 | |||
117356 | 95997 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 56 Neptune St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767648 | 6013070.55126 | 2094035.71681 | 37.7305589972874 | -122.397110809125 | (37.7305589972874, -122.397110809125) | 10 | 3 | 8 | 58 | 1 |
136875 | 84731 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 72 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/13/2007 12:00:00 AM | Permit No. 49232 | 6013473 | 2114579 | 37.7869887683946 | -122.397159425184 | (37.7869887683946, -122.397159425184) | 6 | 2 | 9 | 28855 | 6 | |||
128409 | 27175 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2300X Silver Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/1999 12:00:00 AM | 6 | 2X3 | 6013102.95167 | 2096377.53566 | 37.7369909512557 | -122.397162941913 | (37.7369909512557, -122.397162941913) | 10 | 3 | 8 | 58 | 1 | ||
52066 | 27119 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2345X Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/1999 12:00:00 AM | 3 | 3X3 | 6013094.94494 | 2096422.25687 | 37.7371133006396 | -122.397193759945 | (37.7371133006396, -122.397193759945) | 10 | 3 | 8 | 58 | 1 | ||
96245 | 188342 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2335 Silver Ave | 2 | : | Tree | Private 2 | 21 | Width 2ft | 6013082.28487 | 2096418.14951 | 37.7371013178729 | -122.397237243906 | (37.7371013178729, -122.397237243906) | 10 | 3 | 8 | 58 | 1 | |||
119657 | 27122 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2335 Silver Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/02/2003 12:00:00 AM | 12 | 2x2 | 6013082.27872 | 2096428.43607 | 37.7371295622807 | -122.397237986284 | (37.7371295622807, -122.397237986284) | 10 | 3 | 8 | 58 | 1 | ||
72437 | 27174 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2300X Silver Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/1999 12:00:00 AM | 6 | 2X3 | 6013069.06083 | 2096365.01069 | 37.7369546735192 | -122.397279240461 | (37.7369546735192, -122.397279240461) | 10 | 3 | 8 | 58 | 1 | ||
133982 | 175759 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 201 Tocoloma Ave | 7 | Front Yard : Yard | Tree | Private 2 | 5 | 6012872.74847 | 2087577.73375 | 37.7128156646891 | -122.397341941199 | (37.7128156646891, -122.397341941199) | 10 | 3 | 8 | 309 | 1 | ||||
186886 | 54766 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 192 Nueva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1972 12:00:00 AM | 7 | Permit Number 10615 | 6012860.29811 | 2087055.87455 | 37.7113820491125 | -122.397348400111 | (37.7113820491125, -122.397348400111) | 10 | 3 | 8 | 309 | 1 | ||
66695 | 175758 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 201 Tocoloma Ave | 5 | Front Yard : Yard | Tree | Private 2 | 4 | 6012839.87945 | 2087571.56346 | 37.7127968922232 | -122.397455115464 | (37.7127968922232, -122.397455115464) | 10 | 3 | 8 | 309 | 1 | ||||
19123 | 30366 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 764 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 1 | Permit Number 38805 | 6013019.81503 | 2103473.1005 | 37.756469231694 | -122.397947987108 | (37.756469231694, -122.397947987108) | 10 | 3 | 8 | 28856 | 29 | |
88423 | 108730 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1822-1898X 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773105 | 6013006 | 2102886 | 37.7548564119513 | -122.39795458116 | (37.7548564119513, -122.39795458116) | 10 | 3 | 8 | 28856 | 29 |
42932 | 49808 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1546ARKANSAS 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2003 12:00:00 AM | Permit Number 46602 | 6013062.18652198 | 2105692.25425348 | 37.7625649012206 | -122.397957118424 | (37.7625649012206, -122.397957118424) | 14 | 3 | 8 | 28856 | 29 | ||
111726 | 108723 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 764 Arkansas St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773103 | 6013016.81056 | 2103494.00722 | 37.7565264696642 | -122.397959844253 | (37.7565264696642, -122.397959844253) | 10 | 3 | 8 | 28856 | 29 | |
131846 | 188326 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1810 23rd St | 1 | : | Tree | Private 2 | 8 | Width 2ft | 6012985.75281 | 2102888.64274 | 37.7548625406828 | -122.398024787438 | (37.7548625406828, -122.398024787438) | 10 | 3 | 8 | 28856 | 29 | |||
127070 | 254844 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 475 Arkansas St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/29/2018 12:00:00 AM | 3 | 3x3 | 6013011 | 2104854 | 37.7602603887437 | -122.398075345371 | (37.7602603887437, -122.398075345371) | 10 | 3 | 8 | 28856 | 29 | ||
49530 | 188327 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1810 23rd St | 2 | : | Tree | Private 2 | 6 | Width 2ft | 6012968.79067 | 2102886.92272 | 37.7548568731497 | -122.398083326981 | (37.7548568731497, -122.398083326981) | 10 | 3 | 8 | 28856 | 29 |
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) );