Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▲ | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 104783 | 104783 | 96999 | Property Tree 7 | Callistemon viminalis :: Weeping Bottlebrush 20 | 195A Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 125835 | 125835 | 97004 | Property Tree 7 | Callistemon viminalis :: Weeping Bottlebrush 20 | 195A Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 84720 | 84720 | 18799 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 36 Rosie Lee Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6017963.3534873 | 2094445.0871971 | 37.731954211667706 | -122.380223926679 | (37.7319542116677, -122.380223926679) | |||
| 119626 | 119626 | 12947 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 35 Lillian St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6017849.360696499 | 2094492.6056632 | 37.7320783980043 | -122.38062132992901 | (37.7320783980043, -122.380621329929) | |||
| 83301 | 83301 | 10882 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1175X Hudson Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X4 | 6017544.4990408 | 2094830.7506973 | 37.732990049052205 | -122.381698823278 | (37.7329900490522, -122.381698823278) | |||
| 85326 | 85326 | 106091 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1200 HUDSON AVE | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3x3 | 6017390.0 | 2095089.0 | 37.733690618402704 | -122.382250932174 | (37.7336906184027, -122.382250932174) | |||
| 392 | 392 | 251280 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1275x Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 03/11/2006 12:00:00 AM | 3x3 | 6017281.0 | 2095243.0 | 37.734107450868 | -122.38263849321599 | (37.734107450868, -122.382638493216) | ||
| 398 | 398 | 251281 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1275x Hudson Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 03/23/2006 12:00:00 AM | 3x3 | 6017281.0 | 2095243.0 | 37.734107450868 | -122.38263849321599 | (37.734107450868, -122.382638493216) | ||
| 9171 | 9171 | 26893 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1275X HUDSON AVE | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/1999 12:00:00 AM | 6 | 3X4 | 6017281.0 | 2095243.0 | 37.734107450868 | -122.38263849321599 | (37.734107450868, -122.382638493216) | ||
| 9226 | 9226 | 10863 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1275X HUDSON AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2016 12:00:00 AM | 6 | 3X4 | 6017281.0 | 2095243.0 | 37.734107450868 | -122.38263849321599 | (37.734107450868, -122.382638493216) | ||
| 9446 | 9446 | 10864 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1275X HUDSON AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/19/1993 12:00:00 AM | 6 | 3X4 | 6017281.0 | 2095243.0 | 37.734107450868 | -122.38263849321599 | (37.734107450868, -122.382638493216) | ||
| 94410 | 94410 | 10855 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1299X HUDSON AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/21/1996 12:00:00 AM | 6 | 3X4 | 6017281.0 | 2095243.0 | 37.734107450868 | -122.38263849321599 | (37.734107450868, -122.382638493216) | ||
| 115921 | 115921 | 10852 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1299X HUDSON AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2016 12:00:00 AM | 3 | 3X4 | 6017281.0 | 2095243.0 | 37.734107450868 | -122.38263849321599 | (37.734107450868, -122.382638493216) | ||
| 140514 | 140514 | 10856 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1299X HUDSON AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/21/1996 12:00:00 AM | 6 | 3X4 | 6017281.0 | 2095243.0 | 37.734107450868 | -122.38263849321599 | (37.734107450868, -122.382638493216) | ||
| 92439 | 92439 | 10887 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1270X Hudson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/1996 12:00:00 AM | 6 | 3X4 | 6017265.0162454005 | 2095327.7862917 | 37.734339374173004 | -122.382699652574 | (37.734339374173, -122.382699652574) | ||
| 124915 | 124915 | 10888 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1270X Hudson Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/1996 12:00:00 AM | 6 | 3X4 | 6017265.0162454005 | 2095327.7862917 | 37.734339374173004 | -122.382699652574 | (37.734339374173, -122.382699652574) | ||
| 39974 | 39974 | 188355 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1339 Hudson Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017230.94644 | 2095282.0098400002 | 37.7342117988404 | -122.38281425956998 | (37.7342117988404, -122.38281425957) | |||
| 358 | 358 | 251286 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1299x Hudson Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 02/09/1998 12:00:00 AM | 3x3 | 6017207.0 | 2095414.0 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | ||
| 375 | 375 | 251284 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1299x Hudson Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 06/21/1996 12:00:00 AM | 3x3 | 6017207.0 | 2095414.0 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | ||
| 385 | 385 | 251282 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1299x Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 04/07/2016 12:00:00 AM | 3x3 | 6017207.0 | 2095414.0 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | ||
| 402 | 402 | 251283 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1299x Hudson Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 06/06/1997 12:00:00 AM | 3x3 | 6017207.0 | 2095414.0 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | ||
| 410 | 410 | 251287 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1299x Hudson Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 02/09/1998 12:00:00 AM | 3x3 | 6017207.0 | 2095414.0 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | ||
| 26495 | 26495 | 188354 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1341 Hudson Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6017148.15295 | 2095467.55143 | 37.73471668451 | -122.383113415457 | (37.73471668451, -122.383113415457) | |||
| 156417 | 156417 | 188356 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1334 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6017138.822869999 | 2095616.15283 | 37.735124198807796 | -122.38315601274701 | (37.7351241988078, -122.383156012747) | |||
| 147704 | 147704 | 188357 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1334 Hudson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6017134.511390001 | 2095632.2409 | 37.7351681351926 | -122.38317203866 | (37.7351681351926, -122.38317203866) | |||
| 38282 | 38282 | 188358 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1334 Hudson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6017132.819619999 | 2095655.66164 | 37.7352323503922 | -122.383179517428 | (37.7352323503922, -122.383179517428) | |||
| 45351 | 45351 | 188353 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1341 Hudson Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6017129.66281 | 2095538.6901900002 | 37.7349109956364 | -122.38318229272899 | (37.7349109956364, -122.383182292729) | |||
| 73411 | 73411 | 188359 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1334 Hudson Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6017127.7114699995 | 2095678.22784 | 37.735294030402706 | -122.383198748549 | (37.7352940304027, -122.383198748549) | |||
| 172093 | 172093 | 188352 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1341 Hudson Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6017123.5169400005 | 2095558.35639 | 37.7349646554818 | -122.383204909781 | (37.7349646554818, -122.383204909781) | |||
| 162540 | 162540 | 188351 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1341 Hudson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6017067.0525 | 2095737.1486900002 | 37.7354524630578 | -122.383412571329 | (37.7354524630578, -122.383412571329) | |||
| 50086 | 50086 | 113271 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1321 Revere Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/16/2015 12:00:00 AM | Permit Number 774420 | 6016529.9 | 2093260.0 | 37.7286210040554 | -122.38509718743299 | (37.7286210040554, -122.385097187433) | ||||
| 114797 | 114797 | 5808 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 22 Dukes Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/02/2012 12:00:00 AM | 3 | 6016199.5009328 | 2096264.8663221002 | 37.736853484109794 | -122.38644883389 | (37.7368534841098, -122.38644883389) | |||
| 75566 | 75566 | 188350 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2 Dukes Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6016183.298880001 | 2096350.88685 | 37.7370887822104 | -122.386510848195 | (37.7370887822104, -122.386510848195) | |||
| 99616 | 99616 | 26698 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 89 Dukes Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X4 | 6016127.069051901 | 2096424.3370057999 | 37.73728734855921 | -122.386710382374 | (37.7372873485592, -122.386710382374) | |||
| 142456 | 142456 | 51756 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1350 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/2005 12:00:00 AM | Permit Number 48024 | 6016094.75384316 | 2092981.324561 | 37.727831736096796 | -122.386582102799 | (37.7278317360968, -122.386582102799) | |||
| 46438 | 46438 | 38557 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1511 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 12 | Permit Number 40522 | 6015824.3664 | 2095556.8722 | 37.7348887022439 | -122.38769646850001 | (37.7348887022439, -122.3876964685) | |
| 129775 | 129775 | 56716 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1522 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6015807.4304 | 2095648.0005 | 37.7351379840188 | -122.38776137892799 | (37.7351379840188, -122.387761378928) | ||||
| 134470 | 134470 | 56725 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1519 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 6015793.5491 | 2095580.2933 | 37.734951304754404 | -122.387804649295 | (37.7349513047544, -122.387804649295) | ||||
| 64789 | 64789 | 56717 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1526 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 6015787.6443 | 2095659.5423 | 37.735168579406704 | -122.387830592307 | (37.7351685794067, -122.387830592307) | ||||
| 156244 | 156244 | 56727 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1531 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 6015734.3799 | 2095622.8211 | 37.7350647995931 | -122.38801218661399 | (37.7350647995931, -122.388012186614) | ||||
| 160399 | 160399 | 200794 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1550 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6015667.8289 | 2095751.3276 | 37.735413965172796 | -122.388251244981 | (37.7354139651728, -122.388251244981) | |||
| 136620 | 136620 | 188304 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 601 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6015659.791809999 | 2105320.44232 | 37.7616883131784 | -122.38894690567801 | (37.7616883131784, -122.388946905678) | |||
| 174190 | 174190 | 56722 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1560 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/12/1974 12:00:00 AM | 9 | Permit Number 13995 | 6015605.7227 | 2095794.747 | 37.7355297446147 | -122.388469000899 | (37.7355297446147, -122.388469000899) | ||
| 160599 | 160599 | 200647 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1579 McKinnon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6015511.5711 | 2095791.0834 | 37.735514467209995 | -122.388794265849 | (37.73551446721, -122.388794265849) | |||
| 136027 | 136027 | 56732 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1579 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6015489.3827 | 2095804.6430000002 | 37.7355504693065 | -122.388871926567 | (37.7355504693065, -122.388871926567) | ||||
| 3320 | 3320 | 56733 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1583 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Permit Number 780681 | 6015469.0433 | 2095825.5988 | 37.7356068823061 | -122.388943710821 | (37.7356068823061, -122.388943710821) | |||
| 132822 | 132822 | 188306 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 635 Tennessee St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6015455.75158 | 2106081.00048 | 37.7637653298293 | -122.38970572753999 | (37.7637653298293, -122.38970572754) | |||
| 60373 | 60373 | 188307 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 635 Tennessee St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6015454.50593 | 2106102.86687 | 37.763825301131895 | -122.389711563256 | (37.7638253011319, -122.389711563256) | |||
| 41275 | 41275 | 188305 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 635 Tennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6015454.10981 | 2106058.18427 | 37.7637025904139 | -122.389709812266 | (37.7637025904139, -122.389709812266) | |||
| 90738 | 90738 | 48736 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1633 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/26/2002 12:00:00 AM | Permit Number 46017 | 6015017.13579754 | 2095815.21126112 | 37.7355533009373 | -122.39050541553001 | (37.7355533009373, -122.39050541553) | ||
| 120831 | 120831 | 106009 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1745 LANE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6014990.1 | 2094194.5 | 37.7311016564679 | -122.390485679987 | (37.7311016564679, -122.390485679987) | |||
| 92699 | 92699 | 97048 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1590X Shafter Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6014988.7 | 2094146.3 | 37.7309692313217 | -122.39048715342 | (37.7309692313217, -122.39048715342) | |||
| 109764 | 109764 | 97047 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1590X Shafter Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6014988.7 | 2094146.3 | 37.7309692313217 | -122.39048715342 | (37.7309692313217, -122.39048715342) | |||
| 93655 | 93655 | 97046 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1590X SHAFTER AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6014988.0 | 2094146.0 | 37.7309683687499 | -122.390489552503 | (37.7309683687499, -122.390489552503) | |||
| 169060 | 169060 | 40030 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1637 Newcomb Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 3 | Permit Number 41272 | 6014878.683680001 | 2095916.71611 | 37.735824330914 | -122.390991193288 | (37.735824330914, -122.390991193288) | |
| 187374 | 187374 | 36805 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1450 Donner Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | 10 | Permit Number 39531 | 6014737.8573 | 2091203.2549 | 37.7228743001584 | -122.39114872971001 | (37.7228743001584, -122.39114872971) | |
| 187540 | 187540 | 36806 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1450 Donner Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | 4 | Permit Number 39531 | 6014725.6758 | 2091211.782 | 37.722897037873395 | -122.391191434704 | (37.7228970378734, -122.391191434704) | |
| 65839 | 65839 | 36807 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1450 Donner Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | 8 | Permit Number 39531 | 6014713.4944 | 2091220.9181 | 37.722921447771604 | -122.39123418192699 | (37.7229214477716, -122.391234181927) | |
| 157003 | 157003 | 49416 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 17643RD/PHELPS La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/2003 12:00:00 AM | 9 | Permit Number 46362 | 6014695.16416 | 2096823.71289 | 37.7383045729921 | -122.39168909330401 | (37.7383045729921, -122.391689093304) | ||
| 180781 | 180781 | 188349 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1764 La Salle Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6014694.72418 | 2096821.3256 | 37.738297993561396 | -122.391690447682 | (37.7382979935614, -122.391690447682) | |||
| 67811 | 67811 | 42713 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1740 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 8 | Permit Number 42726 | 6014522.39227 | 2095210.25322 | 37.7338647513416 | -122.392173650716 | (37.7338647513416, -122.392173650716) | |
| 186252 | 186252 | 188346 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1716 Revere Ave | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6014499.65662 | 2094860.17735 | 37.7329022519179 | -122.39222777999399 | (37.7329022519179, -122.392227779994) | |||
| 146750 | 146750 | 188337 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1578 Newhall St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 6014186.2862599995 | 2095457.7275599998 | 37.7345255974821 | -122.393352991941 | (37.7345255974821, -122.393352991941) | |||
| 59966 | 59966 | 188338 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1580 Newhall St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 6014174.61235 | 2095442.29815 | 37.7344825828894 | -122.39339227343001 | (37.7344825828894, -122.39339227343) | |||
| 36392 | 36392 | 44281 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1588 Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/27/2001 12:00:00 AM | 7 | Permit Number 43704 | 6014169.386469999 | 2095432.395 | 37.734455100518 | -122.393409648353 | (37.734455100518, -122.393409648353) | ||
| 26719 | 26719 | 44280 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1588 Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/27/2001 12:00:00 AM | 7 | Permit Number 43704 | 6014158.826330001 | 2095418.03078 | 37.734415072582 | -122.393445153596 | (37.734415072582, -122.393445153596) | ||
| 46843 | 46843 | 54597 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 630 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/1972 12:00:00 AM | 19 | Permit Number 10420 | 6014092.76415 | 2104176.14538 | 37.7584593387525 | -122.394286543097 | (37.7584593387525, -122.394286543097) | ||
| 165755 | 165755 | 116373 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 366 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6014023.28278 | 2105408.18049 | 37.761838376751896 | -122.394613116617 | (37.7618383767519, -122.394613116617) | |||
| 95927 | 95927 | 114570 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 366 MISSISSIPPI ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014008.0 | 2105399.0 | 37.7618123194661 | -122.394665331171 | (37.7618123194661, -122.394665331171) | ||||
| 68293 | 68293 | 188331 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 612 Texas St | 1 | : 4 | Tree 1 | Private 1 | 18 | Width 4ft | 6013806.03622 | 2104232.11636 | 37.7585970807056 | -122.39528210428101 | (37.7585970807056, -122.395282104281) | |||
| 41982 | 41982 | 188330 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 214 Texas St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6013707.236830001 | 2106019.4851599997 | 37.763499309471506 | -122.395749036807 | (37.7634993094715, -122.395749036807) | |||
| 118043 | 118043 | 107041 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1301 18TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6013691.7 | 2105657.2 | 37.7625036896712 | -122.39577738754299 | (37.7625036896712, -122.395777387543) | ||||
| 110296 | 110296 | 84731 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 72 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/2007 12:00:00 AM | Permit No. 49232 | 6013473.0 | 2114579.0 | 37.7869887683946 | -122.397159425184 | (37.7869887683946, -122.397159425184) | |||
| 15602 | 15602 | 101156 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1490X 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6013453.7614400005 | 2105247.5910900002 | 37.7613657542352 | -122.39657162148501 | (37.7613657542352, -122.396571621485) | |||
| 60191 | 60191 | 188333 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 300 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6013450.6432300005 | 2105637.1609900002 | 37.7624352541126 | -122.396609715869 | (37.7624352541126, -122.396609715869) | |||
| 169960 | 169960 | 188332 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 288 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6013443.0879999995 | 2105758.2954 | 37.7627674420819 | -122.396644338879 | (37.7627674420819, -122.396644338879) | |||
| 15038 | 15038 | 101157 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1490X 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6x5 | 6013434.11839 | 2105245.8196900003 | 37.7613597971466 | -122.396639434871 | (37.7613597971466, -122.396639434871) | |||
| 16317 | 16317 | 101158 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1490X 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 6x5 | 6013408.6905 | 2105245.2503299997 | 37.7613568185891 | -122.396727339995 | (37.7613568185891, -122.396727339995) | |||
| 15120 | 15120 | 101159 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1490X 19th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6013387.24003 | 2105243.87751 | 37.7613518552239 | -122.39680143245701 | (37.7613518552239, -122.396801432457) | |||
| 161577 | 161577 | 188334 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1490 19th St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 6013355.939119999 | 2105240.17326 | 37.7613399419185 | -122.396909430223 | (37.7613399419185, -122.396909430223) | |||
| 38034 | 38034 | 188335 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1490 19th St | 2 | : 4 | Tree 1 | Private 1 | 12 | Width 5ft | 6013335.43042 | 2105239.42727 | 37.761336752 | -122.396980309397 | (37.761336752, -122.396980309397) | |||
| 73514 | 73514 | 188348 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 135 Bridgeview Dr | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 2ft | 6013321.68612 | 2095651.6396700002 | 37.7350099660289 | -122.396355810291 | (37.7350099660289, -122.396355810291) | |||
| 68710 | 68710 | 188336 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1490 19th St | 3 | : 4 | Tree 1 | Private 1 | 11 | Width 5ft | 6013315.97127 | 2105238.81397 | 37.7613339848017 | -122.39704756789101 | (37.7613339848017, -122.397047567891) | |||
| 152265 | 152265 | 188341 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2351 Silver Ave | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6013156.07372 | 2096444.5663599998 | 37.737177960788706 | -122.396983972339 | (37.7371779607887, -122.396983972339) | |||
| 15299 | 15299 | 27175 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2300X Silver Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/1999 12:00:00 AM | 6 | 2X3 | 6013102.951669999 | 2096377.5356599998 | 37.736990951255706 | -122.397162941913 | (37.7369909512557, -122.397162941913) | ||
| 82895 | 82895 | 27119 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2345X Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/1999 12:00:00 AM | 3 | 3X3 | 6013094.94494 | 2096422.2568700002 | 37.7371133006396 | -122.397193759945 | (37.7371133006396, -122.397193759945) | ||
| 182374 | 182374 | 188342 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2335 Silver Ave | 2 | : 4 | Tree 1 | Private 1 | 21 | Width 2ft | 6013082.28487 | 2096418.14951 | 37.7371013178729 | -122.397237243906 | (37.7371013178729, -122.397237243906) | |||
| 110016 | 110016 | 27122 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2335 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/2003 12:00:00 AM | 12 | 2x2 | 6013082.27872 | 2096428.43607 | 37.7371295622807 | -122.39723798628401 | (37.7371295622807, -122.397237986284) | ||
| 177360 | 177360 | 95997 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 56 Neptune St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767648 | 6013070.55126 | 2094035.71681 | 37.730558997287396 | -122.39711080912501 | (37.7305589972874, -122.397110809125) |
| 15119 | 15119 | 27174 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2300X Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/1999 12:00:00 AM | 6 | 2X3 | 6013069.06083 | 2096365.0106900001 | 37.7369546735192 | -122.397279240461 | (37.7369546735192, -122.397279240461) | ||
| 84601 | 84601 | 49808 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1546ARKANSAS 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2003 12:00:00 AM | Permit Number 46602 | 6013062.18652198 | 2105692.25425348 | 37.7625649012206 | -122.397957118424 | (37.7625649012206, -122.397957118424) | ||
| 171430 | 171430 | 30366 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 764 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2005 12:00:00 AM | 1 | Permit Number 38805 | 6013019.81503 | 2103473.1005 | 37.756469231694005 | -122.397947987108 | (37.756469231694, -122.397947987108) | |
| 97552 | 97552 | 108723 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 764 Arkansas St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773103 | 6013016.81056 | 2103494.00722 | 37.7565264696642 | -122.39795984425301 | (37.7565264696642, -122.397959844253) | |
| 93454 | 93454 | 108730 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1822-1898X 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773105 | 6013006.0 | 2102886.0 | 37.7548564119513 | -122.39795458116001 | (37.7548564119513, -122.39795458116) |
| 16407 | 16407 | 97995 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1450 Mariposa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/2016 12:00:00 AM | 3 | 3x3 | 6013004.40763 | 2106156.2643 | 37.7638357521307 | -122.398189511757 | (37.7638357521307, -122.398189511757) | ||
| 185934 | 185934 | 188326 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1810 23rd St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6012985.7528099995 | 2102888.64274 | 37.7548625406828 | -122.39802478743799 | (37.7548625406828, -122.398024787438) | |||
| 25360 | 25360 | 188327 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1810 23rd St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6012968.79067 | 2102886.92272 | 37.754856873149706 | -122.398083326981 | (37.7548568731497, -122.398083326981) | |||
| 14985 | 14985 | 97996 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1450 Mariposa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6012957.391559999 | 2106153.16264 | 37.7638246167349 | -122.398351909517 | (37.7638246167349, -122.398351909517) | |||
| 71804 | 71804 | 188313 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 299 Arkansas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6012940.76459 | 2105761.15041 | 37.7627473116745 | -122.39838191001199 | (37.7627473116745, -122.398381910012) | |||
| 166478 | 166478 | 188312 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 299 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6012939.88574 | 2105717.83125 | 37.762628317876896 | -122.398381909999 | (37.7626283178769, -122.398381909999) |
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");