Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||
| 420 | 420 | 54426 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 770 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/1973 12:00:00 AM | 15 | 3x3 | Permit Number 12242 | 6012397.0815 | 2104349.75534 | 37.758841631549394 | -122.400163199892 | (37.7588416315494, -122.400163199892) | |
| 1380 | 1380 | 251512 | Property Tree 7 | Callistemon viminalis :: Weeping Bottlebrush 20 | 4116x 18th St | 1 | Back Yard : Yard 13 | Tree 1 | MTA 6 | 3x3 | 6002190.0 | 2105341.0 | 37.760988934022706 | -122.43553488468001 | (37.7609889340227, -122.43553488468) | ||||
| 4201 | 4201 | 252891 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 300x Howth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 04:13:00 PM | 3 | 3x3 | 5997131.0 | 2090234.0 | 37.7192201544045 | -122.451941749186 | (37.7192201544045, -122.451941749186) | ||
| 4203 | 4203 | 252894 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 300x Howth St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 04:10:00 PM | 3 | 3x3 | 5997131.0 | 2090234.0 | 37.7192201544045 | -122.451941749186 | (37.7192201544045, -122.451941749186) | ||
| 4213 | 4213 | 252892 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 300x Howth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 04:08:00 PM | 3 | 3x3 | 5997131.0 | 2090234.0 | 37.7192201544045 | -122.451941749186 | (37.7192201544045, -122.451941749186) | ||
| 4246 | 4246 | 252893 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 300x Howth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 04:25:00 PM | 3 | 3x3 | 5997131.0 | 2090234.0 | 37.7192201544045 | -122.451941749186 | (37.7192201544045, -122.451941749186) | ||
| 4291 | 4291 | 252895 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 790x Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 03:29:00 PM | 3 | 3x3 | 5997282.0 | 2090432.0 | 37.719772464034904 | -122.45143407539 | (37.7197724640349, -122.45143407539) | ||
| 4849 | 4849 | 253684 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 767 Burrows St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009074.0 | 2092682.0 | 37.7266186845557 | -122.410831962563 | (37.7266186845557, -122.410831962563) | ||||
| 5538 | 5538 | 27609 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2695 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2000 12:00:00 AM | 3 | 3x3 | 6001941.56922 | 2115683.47507 | 37.7893726707572 | -122.437134613375 | (37.7893726707572, -122.437134613375) | ||
| 5700 | 5700 | 107235 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 786 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6008834.66692 | 2115296.44284 | 37.788699385205796 | -122.413257820814 | (37.7886993852058, -122.413257820814) | |||
| 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) |
| 7399 | 7399 | 45765 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 99 Blake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/2002 12:00:00 AM | 5 | 3x3 | Permit Number 44690 | 5997815.0796 | 2113173.4382 | 37.782245347199996 | -122.451230630986 | (37.7822453472, -122.451230630986) | |
| 7463 | 7463 | 52815 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2760 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773616 | 6000112.35725 | 2118047.78661 | 37.7957603016641 | -122.44363337348999 | (37.7957603016641, -122.44363337349) | |
| 9115 | 9115 | 90912 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 545 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5993886.17439 | 2110710.21085 | 37.775256248873895 | -122.464643860229 | (37.7752562488739, -122.464643860229) | ||
| 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) | |
| 10145 | 10145 | 173881 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1245 Willard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996703.0 | 2107106.0 | 37.7655220059747 | -122.45463943175601 | (37.7655220059747, -122.454639431756) | ||||
| 10673 | 10673 | 121353 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1221 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/2016 12:00:00 AM | 3 | 3x3 | 5984567.3281 | 2106871.8527 | 37.76417557031971 | -122.496596073864 | (37.7641755703197, -122.496596073864) | ||
| 11500 | 11500 | 66889 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 562 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/1991 12:00:00 AM | 8 | 3x3 | Permit Number 30203 | 6003132.96801 | 2090225.04515 | 37.7195375196183 | -122.43119459394899 | (37.7195375196183, -122.431194593949) | |
| 12081 | 12081 | 27218 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 393 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/10/1999 12:00:00 AM | 6 | 3x3 | 6004009.64112 | 2093507.9183200002 | 37.728601204683706 | -122.42839811609699 | (37.7286012046837, -122.428398116097) | ||
| 12561 | 12561 | 27049 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 910 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/1999 12:00:00 AM | 6 | 3x3 | 6007348.52678 | 2093482.2197099999 | 37.7287190140661 | -122.41685354777701 | (37.7287190140661, -122.416853547777) | ||
| 13092 | 13092 | 27221 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 385 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1999 12:00:00 AM | 10 | 3x3 | 6003913.32371 | 2093508.9041799998 | 37.7285984608493 | -122.428731161129 | (37.7285984608493, -122.428731161129) | ||
| 13269 | 13269 | 187626 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 298x Molimo Dr | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5997428.0 | 2096652.0 | 37.7368594694916 | -122.451377782024 | (37.7368594694916, -122.451377782024) | ||||
| 13750 | 13750 | 96932 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 901 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6011002.04218 | 2094782.5630700001 | 37.732494311353506 | -122.404314536086 | (37.7324943113535, -122.404314536086) | |||
| 13770 | 13770 | 96936 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 901 Bay Shore Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010967.89306 | 2094873.35668 | 37.732741703157394 | -122.404438986978 | (37.7327417031574, -122.404438986978) | |||
| 14213 | 14213 | 25940 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2018 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/2000 12:00:00 AM | 3 | 3x3 | 6012740.13667 | 2097232.43261 | 37.739318114344 | -122.398477333477 | (37.739318114344, -122.398477333477) | ||
| 14841 | 14841 | 96934 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 901 Bay Shore Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010990.76512 | 2094811.6628299998 | 37.7325735829947 | -122.404355571269 | (37.7325735829947, -122.404355571269) | |||
| 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) | |||
| 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) | |||
| 15147 | 15147 | 96937 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 901 Bay Shore Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010960.45235 | 2094890.17175 | 37.732787457976706 | -122.40446589470699 | (37.7327874579767, -122.404465894707) | |||
| 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) | |||
| 16389 | 16389 | 96935 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 901 Bay Shore Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010973.7505 | 2094855.21788 | 37.7326922251695 | -122.404417459925 | (37.7326922251695, -122.404417459925) | |||
| 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) | ||
| 16570 | 16570 | 96933 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 901 Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010997.56747 | 2094792.1485099997 | 37.7325203809043 | -122.40433068074101 | (37.7325203809043, -122.404330680741) | |||
| 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) |
| 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) | |
| 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) |
| 36944 | 36944 | 88065 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2055 Silver Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51066 | 6012481.79699 | 2096085.11316 | 37.7361534207291 | -122.399290043599 | (37.7361534207291, -122.399290043599) | |
| 45600 | 45600 | 57691 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 120 Conrad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/13/1976 12:00:00 AM | 8 | 3x3 | Permit Number 16595 | 6001759.0 | 2096663.0 | 37.7371367196384 | -122.436404416578 | (37.7371367196384, -122.436404416578) | |
| 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) |
| 50384 | 50384 | 43896 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 716 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51474 | 6009227.05246 | 2110468.55015 | 37.7754651643179 | -122.411558979885 | (37.7754651643179, -122.411558979885) | |
| 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) |
| 55954 | 55954 | 49814 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 824 Carolina St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2003 12:00:00 AM | 3 | 3x3 | Permit Number 46606 | 6012411.85736 | 2104145.59448 | 37.758281874620295 | -122.400097759826 | (37.7582818746203, -122.400097759826) | |
| 72565 | 72565 | 116874 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 824 Carolina St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6012413.67241 | 2104134.33813 | 37.7582510683591 | -122.400090692038 | (37.7582510683591, -122.400090692038) | |||
| 74849 | 74849 | 49815 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 824 Carolina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2003 12:00:00 AM | 11 | 3x3 | Permit Number 46737 | 6012411.853019999 | 2104156.1373900003 | 37.7583108228906 | -122.40009851524599 | (37.7583108228906, -122.400098515246) | |
| 79995 | 79995 | 109185 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 198x JUDSON AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998796.0 | 2093546.0 | 37.7284093651166 | -122.446424638984 | (37.7284093651166, -122.446424638984) | ||||
| 80689 | 80689 | 106706 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 199X BRIGHTON AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5996224.0 | 2090880.0 | 37.7209419254054 | -122.455123542447 | (37.7209419254054, -122.455123542447) | |||
| 81603 | 81603 | 96837 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 190 Bradford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6009513.0 | 2097465.0 | 37.7397763850106 | -122.40965179524099 | (37.7397763850106, -122.409651795241) | |||
| 81716 | 81716 | 116348 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 4051X 24TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 6002850.0 | 2101803.0 | 37.7513118941202 | -122.432999456035 | (37.7513118941202, -122.432999456035) | ||||
| 83690 | 83690 | 57741 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 112 Conrad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1976 12:00:00 AM | 10 | 3x3 | Permit Number 16659 | 6001762.0 | 2096689.0 | 37.7372082800729 | -122.436395904515 | (37.7372082800729, -122.436395904515) | |
| 84733 | 84733 | 116949 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 123 WEST PORTAL AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5992936.0 | 2097647.0 | 37.7393332491746 | -122.46698079132099 | (37.7393332491746, -122.466980791321) | ||||
| 84820 | 84820 | 103510 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 100X Leroy Pl | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6008356.0 | 2116660.0 | 37.7924164947138 | -122.41501049488501 | (37.7924164947138, -122.415010494885) | |||
| 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) | |||
| 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) |
| 87473 | 87473 | 121683 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1645 07th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993978.0 | 2104308.0 | 37.757682752419896 | -122.46386140871401 | (37.7576827524199, -122.463861408714) | ||||
| 87700 | 87700 | 100152 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 500X Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6002933.4 | 2105264.1 | 37.760819979332105 | -122.432958296422 | (37.7608199793321, -122.432958296422) | |||
| 87901 | 87901 | 94146 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1715 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53554 | 5992756.7 | 2103771.7 | 37.7561397565087 | -122.468046118338 | (37.7561397565087, -122.468046118338) | ||
| 88418 | 88418 | 109186 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 198x JUDSON AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998796.0 | 2093546.0 | 37.7284093651166 | -122.446424638984 | (37.7284093651166, -122.446424638984) | ||||
| 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) |
| 90156 | 90156 | 104503 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 157 ALBION ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 6005993.0 | 2106325.0 | 37.7639060282426 | -122.422451867395 | (37.7639060282426, -122.422451867395) | ||||
| 90638 | 90638 | 111230 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1113 SCOTT ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001842.0 | 2112262.0 | 37.779972512780105 | -122.4372340286 | (37.7799725127801, -122.4372340286) | ||||
| 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) | |
| 91508 | 91508 | 82031 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 471 Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49837 | 5998319.05661716 | 2095227.73962292 | 37.7329997723608 | -122.448194494208 | (37.7329997723608, -122.448194494208) | ||
| 92027 | 92027 | 103511 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 100X Leroy Pl | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6008356.0 | 2116660.0 | 37.7924164947138 | -122.41501049488501 | (37.7924164947138, -122.415010494885) | |||
| 92630 | 92630 | 112551 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 26 HIDALGO TER | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6004993.0 | 2107524.0 | 37.7671417328885 | -122.425995926974 | (37.7671417328885, -122.425995926974) | |||
| 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) | |||
| 93238 | 93238 | 96931 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 901 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010934.9 | 2094931.8 | 37.7329003323541 | -122.404557165415 | (37.7329003323541, -122.404557165415) | |||
| 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) |
| 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) | |||
| 93939 | 93939 | 116353 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 4051X 24TH ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 6002850.0 | 2101803.0 | 37.7513118941202 | -122.432999456035 | (37.7513118941202, -122.432999456035) | ||||
| 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) | ||||
| 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) | |
| 96727 | 96727 | 96840 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 180 Bradford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6009512.0 | 2097540.0 | 37.739982262694 | -122.409660545137 | (37.739982262694, -122.409660545137) | |||
| 96902 | 96902 | 98541 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 4016 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002873.0 | 2105350.0 | 37.76105241392221 | -122.433173330823 | (37.7610524139222, -122.433173330823) | ||||
| 97484 | 97484 | 104505 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 157163 ALBION ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6005993.0 | 2106325.0 | 37.7639060282426 | -122.422451867395 | (37.7639060282426, -122.422451867395) | |||
| 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) | |
| 98722 | 98722 | 48359 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1400X Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | 7 | 3x3 | Permit Number 45770 | 6005451.0 | 2114476.0 | 37.78625610570921 | -122.424906431455 | (37.7862561057092, -122.424906431455) | |
| 98882 | 98882 | 116352 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 4051X 24TH ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 6002850.0 | 2101803.0 | 37.7513118941202 | -122.432999456035 | (37.7513118941202, -122.432999456035) | ||||
| 98916 | 98916 | 100147 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 3955 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6003272.0 | 2105332.0 | 37.761025616168396 | -122.431792078279 | (37.7610256161684, -122.431792078279) | |||
| 100229 | 100229 | 104766 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1111 CASTRO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6002562.6 | 2102271.3 | 37.7525814287469 | -122.434026788658 | (37.7525814287469, -122.434026788658) | |||
| 100719 | 100719 | 114307 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 595 ELLIS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008020.0 | 2113749.0 | 37.7844047125189 | -122.415966831143 | (37.7844047125189, -122.415966831143) | ||||
| 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) | |
| 102340 | 102340 | 56923 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 3917 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/1974 12:00:00 AM | 18 | 3x3 | Permit Number 14165 | 6003709.0 | 2101851.0 | 37.751492377455705 | -122.430032361 | (37.7514923774557, -122.430032361) | |
| 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) | |
| 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) | |
| 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) | |||
| 110994 | 110994 | 111670 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 99x CARL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998115.0 | 2107097.0 | 37.7655781805803 | -122.44975501544201 | (37.7655781805803, -122.449755015442) | ||||
| 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) | |||
| 111092 | 111092 | 103509 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 100X Leroy Pl | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6008356.0 | 2116660.0 | 37.7924164947138 | -122.41501049488501 | (37.7924164947138, -122.415010494885) | |||
| 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) |
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");