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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 125272 | 125272 | 110420 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 419X 18TH AVE | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | MTA 10 | 3x3 | 5990240.0 | 2112557.0 | 37.7801161452828 | -122.477391675869 | (37.7801161452828, -122.477391675869) | |||
| 101889 | 101889 | 95411 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2815 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 1 | 3x3 | Planted by Glen Park Library; will become DPW maintained. | 6002467.0 | 2095594.0 | 37.734241695714005 | -122.43388015504499 | (37.734241695714, -122.433880155045) | |
| 111008 | 111008 | 116626 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 5732X GEARY BLVD | 7 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
| 120383 | 120383 | 95412 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2815 Diamond St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 1 | 3x3 | Planted by Glen Park Public Library; will become DPW maintained after it is established. | 6002467.0 | 2095594.0 | 37.734241695714005 | -122.43388015504499 | (37.734241695714, -122.433880155045) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 10007 | 10007 | 99273 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2825 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | DPW for City Agency 2 | 02/01/2013 12:00:00 AM | 3 | 3x3 | 6002499.0 | 2095479.8 | 37.733929944538204 | -122.43376136145201 | (37.7339299445382, -122.433761361452) | |
| 17300 | 17300 | 30745 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 486X Page St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 01/31/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34630 | 6004274.8073 | 2109806.6859 | 37.773368818647 | -122.42864278458 | (37.773368818647, -122.42864278458) |
| 17361 | 17361 | 30744 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 380 Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 01/31/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34630 | 6004178.56485 | 2109886.0183099997 | 37.7735811988523 | -122.428981357915 | (37.7735811988523, -122.428981357915) |
| 18822 | 18822 | 30746 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 490X Page St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 01/31/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34630 | 6004256.1031 | 2109802.2559 | 37.7733555963905 | -122.42870716917601 | (37.7733555963905, -122.428707169176) |
| 20531 | 20531 | 30747 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 496X Page St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 01/31/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34630 | 6004231.9845 | 2109799.7949 | 37.77334747404829 | -122.42879042330799 | (37.7733474740483, -122.428790423308) |
| 21303 | 21303 | 30742 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 380 Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 01/31/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34630 | 6004180.58298 | 2109863.27384 | 37.7735188623338 | -122.428972754992 | (37.7735188623338, -122.428972754992) |
| 86916 | 86916 | 30739 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 490X Page St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 01/31/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34630 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.42905135835501 | (37.7740034947051, -122.429051358355) |
| 89141 | 89141 | 30743 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 490X Page St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 01/31/1995 12:00:00 AM | 3 | 3x3 | Permit Number 34630 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.42905135835501 | (37.7740034947051, -122.429051358355) |
| 98059 | 98059 | 96209 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 201X Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/28/2012 12:00:00 AM | 3 | 4x4 | 6001762.6 | 2104666.8 | 37.759113460692 | -122.43696480408701 | (37.759113460692, -122.436964804087) | |
| 112231 | 112231 | 30737 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 490X Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/05/2000 12:00:00 AM | 4 | 3x3 | Permit Number 42884 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.42905135835501 | (37.7740034947051, -122.429051358355) |
| 113735 | 113735 | 30736 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 490X Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 01/31/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34630 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.42905135835501 | (37.7740034947051, -122.429051358355) |
| 129289 | 129289 | 30741 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 490X Page St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 01/31/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34630 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.42905135835501 | (37.7740034947051, -122.429051358355) |
| 7114 | 7114 | 45767 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 99 Blake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/02/2002 12:00:00 AM | 5 | 3x3 | Permit Number 44690 | 5997811.6954 | 2113198.143 | 37.782312986330794 | -122.45124412099399 | (37.7823129863308, -122.451244120994) |
| 19179 | 19179 | 96019 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 810 Jones St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767661 | 6008769.0 | 2115301.0 | 37.7887082111555 | -122.413485341988 | (37.7887082111555, -122.413485341988) | |
| 27384 | 27384 | 39767 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 476 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/2000 12:00:00 AM | 3 | 2x2 | Permit Number 42916 | 6008173.90648 | 2113469.9166 | 37.7836470686025 | -122.41541460189899 | (37.7836470686025, -122.415414601899) |
| 29332 | 29332 | 61172 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 346 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | 11 | Permit Number 27084 | 5989366.0565 | 2113024.18126 | 37.781348145965296 | -122.480449215491 | (37.7813481459653, -122.480449215491) | |
| 32793 | 32793 | 67326 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 714 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1992 12:00:00 AM | 12 | Permit Number 30809 | 5993329.61616 | 2111427.9815700003 | 37.7771949529998 | -122.466621290245 | (37.7771949529998, -122.466621290245) | |
| 34144 | 34144 | 71268 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1733 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1989 12:00:00 AM | 13 | 5999451.8492 | 2110818.1122 | 37.775871807627 | -122.445398751236 | (37.775871807627, -122.445398751236) | ||
| 39548 | 39548 | 72980 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1730 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1999 12:00:00 AM | 7 | 5987835.4413 | 2103488.2738 | 37.7550761133303 | -122.48504448823499 | (37.7550761133303, -122.485044488235) | ||
| 40165 | 40165 | 32579 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1247 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/1996 12:00:00 AM | 5 | Permit Number 37053 | 5985814.1748 | 2106726.0184 | 37.763848120851705 | -122.49227291177401 | (37.7638481208517, -122.492272911774) | |
| 41975 | 41975 | 65113 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 363 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | 10 | Permit Number 27082 | 5989323.435380001 | 2112903.08855 | 37.781013182321104 | -122.480587794991 | (37.7810131823211, -122.480587794991) | |
| 42881 | 42881 | 78349 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 741 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2000 12:00:00 AM | 4 | 5986607.90066 | 2110854.65361 | 37.7752305672016 | -122.489831352395 | (37.7752305672016, -122.489831352395) | ||
| 45681 | 45681 | 49816 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 824 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2003 12:00:00 AM | 12 | 3x3 | Permit Number 46737 | 6012410.64537 | 2104168.1082 | 37.758343624767605 | -122.400103532548 | (37.7583436247676, -122.400103532548) |
| 45847 | 45847 | 43213 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 361 Sweeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 3 | Permit Number 43004 | 6008709.78977 | 2094511.79844 | 37.7316224914874 | -122.41222029725 | (37.7316224914874, -122.41222029725) | |
| 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) | |
| 47820 | 47820 | 70445 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2471 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1994 12:00:00 AM | 5 | 5982997.1409 | 2098317.8833 | 37.740596640895795 | -122.501394010052 | (37.7405966408958, -122.501394010052) | ||
| 50558 | 50558 | 70268 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 656 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 11 | 6002561.31186 | 2089826.6998700001 | 37.71841134000321 | -122.43314215230801 | (37.7184113400032, -122.433142152308) | ||
| 50710 | 50710 | 72270 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 619 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 5 | 6002965.14713 | 2089877.08907 | 37.7185725974338 | -122.431749858784 | (37.7185725974338, -122.431749858784) | ||
| 51501 | 51501 | 44809 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1371 31st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2001 12:00:00 AM | 3 | Permit Number 43903 | 5986466.0604 | 2105911.3769 | 37.7616494289947 | -122.48995834721501 | (37.7616494289947, -122.489958347215) | |
| 54695 | 54695 | 52371 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 970JONES Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | 6 | 3x3 | Permit Number 48503 | 6008855.4568 | 2115649.67517 | 37.78967044259821 | -122.41321087889901 | (37.7896704425982, -122.413210878899) |
| 64059 | 64059 | 52490 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 380 Tompkins Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48600 | 6008167.536314401 | 2096496.40585448 | 37.7370413503065 | -122.414235342537 | (37.7370413503065, -122.414235342537) | ||
| 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) | |
| 67038 | 67038 | 69446 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 443 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/1994 12:00:00 AM | 10 | Permit Number 33556 | 5985911.814680001 | 2112907.20872 | 37.7808256288006 | -122.492390419974 | (37.7808256288006, -122.492390419974) | |
| 67302 | 67302 | 32207 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1760 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1995 12:00:00 AM | 9 | Permit Number 35529 | 6009303.23325 | 2099186.73635 | 37.7444921398121 | -122.41049862882 | (37.7444921398121, -122.41049862882) | |
| 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) | |
| 70052 | 70052 | 47793 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2578 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2002 12:00:00 AM | 3 | Permit Number 45565 | 5987410.8144 | 2097738.044 | 37.7392627758453 | -122.48609086811899 | (37.7392627758453, -122.486090868119) | |
| 72162 | 72162 | 38103 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1339 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | 6 | Permit Number 40274 | 5987697.8486 | 2106168.016 | 37.7624259403231 | -122.48571698139601 | (37.7624259403231, -122.485716981396) | |
| 72258 | 72258 | 47216 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 102 Colby St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 4 | Permit Number 45167 | 6008173.05313 | 2093488.0369799999 | 37.728781330768896 | -122.41400351077299 | (37.7287813307689, -122.414003510773) | |
| 74603 | 74603 | 66582 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 425 Peru Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/15/1991 12:00:00 AM | 16 | Permit Number 29772 | 6004685.90241 | 2092879.2867599998 | 37.7269133660376 | -122.426015508917 | (37.7269133660376, -122.426015508917) | |
| 75181 | 75181 | 66828 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 154 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/1992 12:00:00 AM | 5 | Permit Number 30314 | 5996849.4776 | 2111929.315 | 37.7787739785332 | -122.454481262068 | (37.7787739785332, -122.454481262068) | |
| 75941 | 75941 | 73418 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2483 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1994 12:00:00 AM | 3 | 5983001.5767 | 2098246.6338 | 37.740401269768796 | -122.50137340388001 | (37.7404012697688, -122.50137340388) | ||
| 76460 | 76460 | 65960 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2514 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/1990 12:00:00 AM | 11 | Permit Number 28982 | 5988016.2527 | 2098169.589 | 37.740482951266706 | -122.48402919603399 | (37.7404829512667, -122.484029196034) | |
| 76976 | 76976 | 43212 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 357 Sweeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 6 | Permit Number 43003 | 6008732.269730001 | 2094519.16075 | 37.7316439681866 | -122.412143099436 | (37.7316439681866, -122.412143099436) | |
| 78132 | 78132 | 34342 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 12661268 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38099 | 6010039.0 | 2101826.0 | 37.7517801982502 | -122.408140586549 | (37.7517801982502, -122.408140586549) | ||
| 78376 | 78376 | 36468 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1469 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39366 | 5995883.06149021 | 2093810.4895036 | 37.728968784247705 | -122.456513863949 | (37.7289687842477, -122.456513863949) | ||
| 79262 | 79262 | 37017 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1050 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | Permit Number 39630 | 6008600.86286293 | 2102426.42877225 | 37.7533482108195 | -122.413156329636 | (37.7533482108195, -122.413156329636) | ||
| 79362 | 79362 | 47227 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 600 Girard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | Permit Number 45171 | 6011131.84499471 | 2092020.43251585 | 37.7249173292839 | -122.403671497463 | (37.7249173292839, -122.403671497463) | ||
| 80441 | 80441 | 38322 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1303 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1998 12:00:00 AM | Permit Number 40379 | 6006986.09982569 | 2107885.23558278 | 37.7682460414156 | -122.419127704144 | (37.7682460414156, -122.419127704144) | ||
| 82171 | 82171 | 46798 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 151 Maywood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | Permit Number 44888 | 5994310.21524684 | 2095607.50798883 | 37.7338125312017 | -122.46208153607701 | (37.7338125312017, -122.462081536077) | ||
| 82360 | 82360 | 39674 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 510 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41060 | 5994056.62807806 | 2090013.39911729 | 37.718437864492394 | -122.462552614145 | (37.7184378644924, -122.462552614145) | ||
| 82749 | 82749 | 46346 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 384 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/14/2002 12:00:00 AM | Permit Number 44592 | 6005461.4442402 | 2101476.38644964 | 37.7505628685682 | -122.423945552398 | (37.7505628685682, -122.423945552398) | ||
| 83355 | 83355 | 40737 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 163 Putnam St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/1999 12:00:00 AM | Permit Number 41716 | 6009144.8463962 | 2096601.1649491 | 37.737383844528 | -122.410863725513 | (37.737383844528, -122.410863725513) | ||
| 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) | ||
| 86680 | 86680 | 39663 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 901 Grafton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41054 | 5994040.07409456 | 2090558.08173508 | 37.719932478931796 | -122.46264932396299 | (37.7199324789318, -122.462649323963) | ||
| 89747 | 89747 | 39705 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 85 El Verano Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | Permit Number 41089 | 5994595.05199927 | 2094752.76443113 | 37.7314820102104 | -122.461034845634 | (37.7314820102104, -122.461034845634) | ||
| 90504 | 90504 | 39664 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 901 Grafton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41054 | 5994040.07409456 | 2090558.08173508 | 37.719932478931796 | -122.46264932396299 | (37.7199324789318, -122.462649323963) | ||
| 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) | ||
| 90810 | 90810 | 49467 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 3624 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/2003 12:00:00 AM | 4 | 3x3 | Permit Number 46393 | 6006125.2277224995 | 2104366.11259234 | 37.7585348409416 | -122.421855375902 | (37.7585348409416, -122.421855375902) |
| 91224 | 91224 | 96020 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 810 Jones St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767661 | 6008769.0 | 2115301.0 | 37.7887082111555 | -122.413485341988 | (37.7887082111555, -122.413485341988) | |
| 91549 | 91549 | 42943 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2517 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2000 12:00:00 AM | Permit Number 42837 | 6008896.604309599 | 2103802.00203994 | 37.7571418228984 | -122.412230804785 | (37.7571418228984, -122.412230804785) | ||
| 91837 | 91837 | 38107 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1295 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | Permit Number 40275 | 5987371.29466581 | 2106479.28053316 | 37.7632615539614 | -122.486869255203 | (37.7632615539614, -122.486869255203) | ||
| 92664 | 92664 | 39671 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 500 Orizaba Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41059 | 5994056.18580091 | 2089950.78311256 | 37.7182659104704 | -122.462549603412 | (37.7182659104704, -122.462549603412) | ||
| 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) |
| 93761 | 93761 | 47226 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 600 Girard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | Permit Number 45171 | 6011131.84499471 | 2092020.43251585 | 37.7249173292839 | -122.403671497463 | (37.7249173292839, -122.403671497463) | ||
| 95766 | 95766 | 39704 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 85 El Verano Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | Permit Number 41089 | 5994595.05199927 | 2094752.76443113 | 37.7314820102104 | -122.461034845634 | (37.7314820102104, -122.461034845634) | ||
| 95994 | 95994 | 95534 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 3725 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767323 | 6004904.0 | 2102501.0 | 37.7533447323081 | -122.425946167651 | (37.7533447323081, -122.425946167651) | |
| 97541 | 97541 | 30674 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1040 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2005 12:00:00 AM | Permit Number 34599 | 6007565.37727332 | 2109755.15641274 | 37.77341300719829 | -122.417256559972 | (37.7734130071983, -122.417256559972) | ||
| 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) | |
| 98121 | 98121 | 47220 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 102 Colby St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | Permit Number 45167 | 6008165.27144692 | 2093507.30784615 | 37.7288338073717 | -122.414031775389 | (37.7288338073717, -122.414031775389) | ||
| 98635 | 98635 | 32867 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 593 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | Permit Number 37213 | 6001338.28217306 | 2101417.26764603 | 37.7501669020767 | -122.438199507309 | (37.7501669020767, -122.438199507309) | ||
| 99326 | 99326 | 39673 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 500 Orizaba Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41059 | 5994056.18580091 | 2089950.78311256 | 37.7182659104704 | -122.462549603412 | (37.7182659104704, -122.462549603412) | ||
| 100533 | 100533 | 63555 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2979 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/10/2012 12:00:00 AM | Permit Number 768997 | 6008364.95764339 | 2103853.79348965 | 37.7572541841117 | -122.414073113457 | (37.7572541841117, -122.414073113457) | ||
| 102452 | 102452 | 38105 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1295 28th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | Permit Number 40275 | 5987371.29466581 | 2106479.28053316 | 37.7632615539614 | -122.486869255203 | (37.7632615539614, -122.486869255203) | ||
| 103622 | 103622 | 48643 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1481 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2002 12:00:00 AM | Permit Number 45936 | 5993334.71771315 | 2105415.01360696 | 37.7606852319988 | -122.466166570005 | (37.7606852319988, -122.466166570005) | ||
| 103711 | 103711 | 39650 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 114 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41043 | 5994182.55528924 | 2090689.21166175 | 37.7203007349832 | -122.462166324336 | (37.7203007349832, -122.462166324336) | ||
| 103715 | 103715 | 33501 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 121 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1996 12:00:00 AM | Permit Number 37595 | 6006663.30728315 | 2098959.97627538 | 37.7437211553943 | -122.41961088786002 | (37.7437211553943, -122.41961088786) | ||
| 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) | |||||
| 104860 | 104860 | 95797 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 907 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767539 | 6008624.3 | 2103231.6 | 37.7555603448561 | -122.413132208673 | (37.7555603448561, -122.413132208673) | |
| 106138 | 106138 | 38323 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1303 Minna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1998 12:00:00 AM | Permit Number 40379 | 6006986.09982569 | 2107885.23558278 | 37.7682460414156 | -122.419127704144 | (37.7682460414156, -122.419127704144) | ||
| 106167 | 106167 | 34434 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 62 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38178 | 6002507.14171464 | 2096534.38214196 | 37.7368260470236 | -122.433808563627 | (37.7368260470236, -122.433808563627) | ||
| 106583 | 106583 | 46402 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 324 Howth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/2002 12:00:00 AM | Permit Number 44632 | 5997151.20329152 | 2090327.07955038 | 37.7194768863059 | -122.451878625824 | (37.7194768863059, -122.451878625824) | ||
| 107205 | 107205 | 41895 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 373 Hermann St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42260 | 6003498.09000552 | 2108603.98384634 | 37.770022505572705 | -122.431243691901 | (37.7700225055727, -122.431243691901) | ||
| 107272 | 107272 | 39648 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 111 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/25/2002 12:00:00 AM | Permit Number 41042 | 5994130.09830184 | 2090661.11089351 | 37.720220556524204 | -122.462345612464 | (37.7202205565242, -122.462345612464) | ||
| 107537 | 107537 | 39654 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 326 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41047 | 5994205.8673586 | 2092067.47591786 | 37.7240864587641 | -122.46218564714898 | (37.7240864587641, -122.462185647149) | ||
| 107581 | 107581 | 39652 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 141 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41045 | 5994132.92951736 | 2090837.78725757 | 37.7207058303918 | -122.462348633516 | (37.7207058303918, -122.462348633516) | ||
| 108607 | 108607 | 38681 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1725 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/1998 12:00:00 AM | 3x3 | Permit Number 40598 | 5999507.78485898 | 2110823.62249875 | 37.775890130447294 | -122.445205652379 | (37.7758901304473, -122.445205652379) | |
| 110263 | 110263 | 52957 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 227 Ramsell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | Permit Number 48944 | 5992946.65383726 | 2088708.6513983002 | 37.714791356792 | -122.46629453065701 | (37.714791356792, -122.466294530657) | ||
| 110629 | 110629 | 120154 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 187 Hartford St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6002716.18242301 | 2104822.03495589 | 37.759593852181894 | -122.433677959685 | (37.7595938521819, -122.433677959685) | ||||
| 112900 | 112900 | 39672 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 500 Orizaba Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41059 | 5994056.18580091 | 2089950.78311256 | 37.7182659104704 | -122.462549603412 | (37.7182659104704, -122.462549603412) |
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");