trees
953 rows where qSpecies_id = 60 sorted by PermitNotes descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▲ | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
186216 | 45706 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 184 Graystone Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/27/2001 12:00:00 AM | Permit Number 44380 | 5999327.0354809 | 2103995.03426473 | 37.7571302242183 | -122.445339815815 | (37.7571302242183, -122.445339815815) | 2 | 5 | 5 | 28862 | 3 | |||
153583 | 45279 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 615 Ellsworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2001 12:00:00 AM | Permit Number 44121 | 6008007.34922264 | 2096035.79545566 | 37.7357676155782 | -122.414756594978 | (37.7357676155782, -122.414756594978) | 2 | 7 | 7 | 28859 | 2 | ||
37894 | 45238 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 871 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2001 12:00:00 AM | Permit Number 44088 | 6008421.36689101 | 2115188.65226849 | 37.7883802062735 | -122.414680152021 | (37.7883802062735, -122.414680152021) | 5 | 1 | 10 | 28858 | 21 | |||
19095 | 182316 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2700X Kirkham St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/2001 12:00:00 AM | 3 | Width 0ft | Permit Number 43905 | 5986474 | 2105095 | 37.7594083467555 | -122.489870843925 | (37.7594083467555, -122.489870843925) | 1 | 8 | 3 | 56 | 35 | |
103004 | 44808 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1371 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2001 12:00:00 AM | 4 | Permit Number 43903 | 5986465.0991 | 2105937.0115 | 37.7617197583894 | -122.489963557407 | (37.7617197583894, -122.489963557407) | 1 | 8 | 3 | 56 | 35 | |
192423 | 44809 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1371 31st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2001 12:00:00 AM | 3 | Permit Number 43903 | 5986466.0604 | 2105911.3769 | 37.7616494289947 | -122.489958347215 | (37.7616494289947, -122.489958347215) | 1 | 8 | 3 | 56 | 35 | |
2627 | 44717 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1991 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/2001 12:00:00 AM | Permit Number 43839 | 5989704.86545465 | 2101822.42727681 | 37.7506108546658 | -122.478457743126 | (37.7506108546658, -122.478457743126) | 1 | 8 | 3 | 29491 | 35 | ||
23509 | 44343 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 233 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/14/2001 12:00:00 AM | Permit Number 43727 | 5991164.04904901 | 2113857.0036857 | 37.7837391697575 | -122.474289891692 | (37.7837391697575, -122.474289891692) | 11 | 6 | 2 | 54 | 26 | |||
5884 | 44280 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1588 Newhall St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2001 12:00:00 AM | 7 | Permit Number 43704 | 6014158.82633 | 2095418.03078 | 37.734415072582 | -122.393445153596 | (37.734415072582, -122.393445153596) | 10 | 3 | 8 | 58 | 1 | ||
161055 | 44281 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1588 Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2001 12:00:00 AM | 7 | Permit Number 43704 | 6014169.38647 | 2095432.395 | 37.734455100518 | -122.393409648353 | (37.734455100518, -122.393409648353) | 10 | 3 | 8 | 58 | 1 | ||
90113 | 43897 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 714 Tehama St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2000 12:00:00 AM | Permit Number 43499 | 6009277.55531704 | 2110532.12490079 | 37.7756425583487 | -122.411388770124 | (37.7756425583487, -122.411388770124) | 8 | 2 | 9 | 28853 | 34 | |||
126759 | 43894 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 716 Tehama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2000 12:00:00 AM | 6 | Permit Number 43499 | 6009202.88564 | 2110443.77487 | 37.7753957816152 | -122.411640828084 | (37.7753957816152, -122.411640828084) | 8 | 2 | 9 | 28853 | 34 | ||
186653 | 43895 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 714 Tehama St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2000 12:00:00 AM | Permit Number 43499 | 6009277.55531704 | 2110532.12490079 | 37.7756425583487 | -122.411388770124 | (37.7756425583487, -122.411388770124) | 8 | 2 | 9 | 28853 | 34 | |||
39368 | 43890 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1233 Howard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2000 12:00:00 AM | 5 | Permit Number 43498 | 6009124.11279 | 2110606.98987 | 37.7758395125283 | -122.41192485917 | (37.7758395125283, -122.41192485917) | 8 | 2 | 9 | 28853 | 34 | ||
88999 | 43891 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1233 Howard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2000 12:00:00 AM | 5 | Permit Number 43498 | 6009112.33188 | 2110593.08814 | 37.7758006806963 | -122.411964629875 | (37.7758006806963, -122.411964629875) | 8 | 2 | 9 | 28853 | 34 | ||
95823 | 43889 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1233 Howard St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2000 12:00:00 AM | 4 | Permit Number 43498 | 6009135.81805 | 2110617.1891 | 37.775868173909 | -122.411885088422 | (37.775868173909, -122.411885088422) | 8 | 2 | 9 | 28853 | 34 | ||
103654 | 43892 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1233 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2000 12:00:00 AM | 6 | Permit Number 43498 | 6009086.19652 | 2110571.73494 | 37.7757405834934 | -122.412053529658 | (37.7757405834934, -122.412053529658) | 8 | 2 | 9 | 28853 | 34 | ||
129887 | 43893 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1233 Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2000 12:00:00 AM | 5 | Permit Number 43498 | 6009099.28139 | 2110583.25278 | 37.7757729429148 | -122.412009079782 | (37.7757729429148, -122.412009079782) | 8 | 2 | 9 | 28853 | 34 | ||
56273 | 43665 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 241 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | 3 | Permit Number 43308 | 5992118.30424 | 2113674.27096 | 37.7832926725519 | -122.47097524296 | (37.7832926725519, -122.47097524296) | 11 | 6 | 2 | 54 | 11 | |
117264 | 43591 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2278 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | 4 | Permit Number 43252 | 5987031.7486 | 2099759.5703 | 37.744791251078 | -122.487549954339 | (37.744791251078, -122.487549954339) | 1 | 8 | 3 | 29491 | 35 | |
130817 | 43213 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 361 Sweeny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2000 12:00:00 AM | 3 | Permit Number 43004 | 6008709.78977 | 2094511.79844 | 37.7316224914874 | -122.41222029725 | (37.7316224914874, -122.41222029725) | 9 | 3 | 7 | 309 | 28 | |
177520 | 43212 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 357 Sweeny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2000 12:00:00 AM | 6 | Permit Number 43003 | 6008732.26973 | 2094519.16075 | 37.7316439681866 | -122.412143099436 | (37.7316439681866, -122.412143099436) | 9 | 3 | 7 | 309 | 28 | |
175317 | 39767 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 476 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/2000 12:00:00 AM | 3 | 2x2 | Permit Number 42916 | 6008173.90648 | 2113469.9166 | 37.7836470686025 | -122.415414601899 | (37.7836470686025, -122.415414601899) | 7 | 10 | 9 | 28858 | 36 |
136087 | 30737 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 490X Page St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/05/2000 12:00:00 AM | 4 | 3x3 | Permit Number 42884 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.429051358355 | (37.7740034947051, -122.429051358355) | 7 | 9 | 11 | 28852 | 10 |
91299 | 42943 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2517 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42837 | 6008896.6043096 | 2103802.00203994 | 37.7571418228984 | -122.412230804785 | (37.7571418228984, -122.412230804785) | 2 | 4 | 7 | 28859 | 19 | ||
152916 | 42713 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1740 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | 8 | Permit Number 42726 | 6014522.39227 | 2095210.25322 | 37.7338647513416 | -122.392173650716 | (37.7338647513416, -122.392173650716) | 10 | 3 | 8 | 58 | 1 | |
124650 | 41895 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 373 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42260 | 6003498.09000552 | 2108603.98384634 | 37.7700225055727 | -122.431243691901 | (37.7700225055727, -122.431243691901) | 15 | 9 | 5 | 29492 | 10 | ||
189901 | 41633 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 100 Jordan Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/2000 12:00:00 AM | Permit Number 42113 | 5996241.92564567 | 2113793.75965037 | 37.7838583861175 | -122.456717884501 | (37.7838583861175, -122.456717884501) | 11 | 6 | 1 | 54 | 31 | |||
121977 | 41599 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 11 Haight St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/2000 12:00:00 AM | Permit Number 42106 | 6006168.11250893 | 2109650.54781373 | 37.7730470683498 | -122.422082471983 | (37.7730470683498, -122.422082471983) | 7 | 2 | 11 | 28852 | 10 | |||
141493 | 41345 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 733 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/03/2000 12:00:00 AM | Permit Number 41999 | 5995888.07123287 | 2089420.5370121 | 37.7169153059378 | -122.4561792734 | (37.7169153059378, -122.4561792734) | 9 | 8 | 6 | 28861 | 24 | |||
99347 | 41261 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 136 Mateo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/1999 12:00:00 AM | Permit Number 41948 | 6003783.84120513 | 2096452.6287084 | 37.73667393521 | -122.429388624637 | (37.73667393521, -122.429388624637) | 2 | 7 | 5 | 63 | 7 | |||
42114 | 40737 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 163 Putnam St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/12/1999 12:00:00 AM | Permit Number 41716 | 6009144.8463962 | 2096601.1649491 | 37.737383844528 | -122.410863725513 | (37.737383844528, -122.410863725513) | 10 | 7 | 7 | 28859 | 2 | ||
165430 | 40030 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1637 Newcomb Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | 3 | Permit Number 41272 | 6014878.68368 | 2095916.71611 | 37.735824330914 | -122.390991193288 | (37.735824330914, -122.390991193288) | 10 | 3 | 8 | 58 | 1 | |
62828 | 39705 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 85 El Verano Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41089 | 5994595.05199927 | 2094752.76443113 | 37.7314820102104 | -122.461034845634 | (37.7314820102104, -122.461034845634) | 9 | 8 | 4 | 59 | 40 | ||
89668 | 39704 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 85 El Verano Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41089 | 5994595.05199927 | 2094752.76443113 | 37.7314820102104 | -122.461034845634 | (37.7314820102104, -122.461034845634) | 9 | 8 | 4 | 59 | 40 | ||
41380 | 39674 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 510 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41060 | 5994056.62807806 | 2090013.39911729 | 37.7184378644924 | -122.462552614145 | (37.7184378644924, -122.462552614145) | 9 | 8 | 6 | 28861 | 24 | ||
26513 | 39670 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 500 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41059 | 5994056.18580091 | 2089950.78311256 | 37.7182659104704 | -122.462549603412 | (37.7182659104704, -122.462549603412) | 9 | 8 | 6 | 28861 | 24 | ||
80877 | 39671 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 500 Orizaba Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41059 | 5994056.18580091 | 2089950.78311256 | 37.7182659104704 | -122.462549603412 | (37.7182659104704, -122.462549603412) | 9 | 8 | 6 | 28861 | 24 | ||
108083 | 39673 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 500 Orizaba Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41059 | 5994056.18580091 | 2089950.78311256 | 37.7182659104704 | -122.462549603412 | (37.7182659104704, -122.462549603412) | 9 | 8 | 6 | 28861 | 24 | ||
134510 | 39672 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 500 Orizaba Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41059 | 5994056.18580091 | 2089950.78311256 | 37.7182659104704 | -122.462549603412 | (37.7182659104704, -122.462549603412) | 9 | 8 | 6 | 28861 | 24 | ||
58561 | 39663 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 901 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41054 | 5994040.07409456 | 2090558.08173508 | 37.7199324789318 | -122.462649323963 | (37.7199324789318, -122.462649323963) | 9 | 8 | 6 | 28861 | 24 | ||
72542 | 39664 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 901 Grafton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41054 | 5994040.07409456 | 2090558.08173508 | 37.7199324789318 | -122.462649323963 | (37.7199324789318, -122.462649323963) | 9 | 8 | 6 | 28861 | 24 | ||
125006 | 39654 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 326 Ashton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41047 | 5994205.8673586 | 2092067.47591786 | 37.7240864587641 | -122.462185647149 | (37.7240864587641, -122.462185647149) | 9 | 8 | 4 | 28861 | 24 | ||
178238 | 39653 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 150 Ashton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41046 | 5994186.17432148 | 2090915.05015887 | 37.7209210416097 | -122.462170184545 | (37.7209210416097, -122.462170184545) | 9 | 8 | 6 | 28861 | 24 | ||
131995 | 39652 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 141 Ashton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41045 | 5994132.92951736 | 2090837.78725757 | 37.7207058303918 | -122.462348633516 | (37.7207058303918, -122.462348633516) | 9 | 8 | 6 | 28861 | 24 | ||
106990 | 39650 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 114 Ashton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41043 | 5994182.55528924 | 2090689.21166175 | 37.7203007349832 | -122.462166324336 | (37.7203007349832, -122.462166324336) | 9 | 8 | 6 | 28861 | 24 | ||
118674 | 39648 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 111 Ashton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/25/2002 12:00:00 AM | Permit Number 41042 | 5994130.09830184 | 2090661.11089351 | 37.7202205565242 | -122.462345612464 | (37.7202205565242, -122.462345612464) | 9 | 8 | 6 | 28861 | 24 | ||
192200 | 39649 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 111 Ashton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1998 12:00:00 AM | 5 | 3x20 | Permit Number 41042 | 5994130.09830184 | 2090661.11089351 | 37.7202205565242 | -122.462345612464 | (37.7202205565242, -122.462345612464) | 9 | 8 | 6 | 28861 | 24 | |
105529 | 39521 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1330 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | 1 | 3x3 | Permit Number 40968 | 6012480.371 | 2107070.1033 | 37.7663157471753 | -122.400066187848 | (37.7663157471753, -122.400066187848) | 14 | 3 | 8 | 28856 | 20 |
40880 | 39219 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 347 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/1998 12:00:00 AM | Permit Number 40862 | 5993215.94072133 | 2089494.769314 | 37.7169653816902 | -122.465420843024 | (37.7169653816902, -122.465420843024) | 9 | 8 | 6 | 64 | 24 | |||
128985 | 38681 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1725 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1998 12:00:00 AM | 3x3 | Permit Number 40598 | 5999507.78485898 | 2110823.62249875 | 37.7758901304473 | -122.445205652379 | (37.7758901304473, -122.445205652379) | 15 | 5 | 11 | 29492 | 16 | |
147989 | 38652 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1276 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/28/1998 12:00:00 AM | Permit Number 40574 | 5982148.09911045 | 2106418.94720672 | 37.762789987906 | -122.504929783979 | (37.762789987906, -122.504929783979) | 1 | 8 | 3 | 56 | 35 | |||
110273 | 38557 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1511 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 12 | Permit Number 40522 | 6015824.3664 | 2095556.8722 | 37.7348887022439 | -122.3876964685 | (37.7348887022439, -122.3876964685) | 10 | 3 | 8 | 58 | 1 | |
160804 | 35218 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 896 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/1998 12:00:00 AM | 5 | Permit Number 40401 | 6011658.1335 | 2112244.4696 | 37.7804774939022 | -122.403274202035 | (37.7804774939022, -122.403274202035) | 6 | 2 | 9 | 28853 | 34 | ||
42933 | 38322 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1303 Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40379 | 6006986.09982569 | 2107885.23558278 | 37.7682460414156 | -122.419127704144 | (37.7682460414156, -122.419127704144) | 8 | 4 | 7 | 28853 | 19 | ||
114468 | 38323 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1303 Minna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40379 | 6006986.09982569 | 2107885.23558278 | 37.7682460414156 | -122.419127704144 | (37.7682460414156, -122.419127704144) | 8 | 4 | 7 | 28853 | 19 | ||
88465 | 38107 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1295 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/1998 12:00:00 AM | Permit Number 40275 | 5987371.29466581 | 2106479.28053316 | 37.7632615539614 | -122.486869255203 | (37.7632615539614, -122.486869255203) | 1 | 8 | 3 | 56 | 35 | ||
103073 | 38105 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1295 28th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/1998 12:00:00 AM | Permit Number 40275 | 5987371.29466581 | 2106479.28053316 | 37.7632615539614 | -122.486869255203 | (37.7632615539614, -122.486869255203) | 1 | 8 | 3 | 56 | 35 | ||
156716 | 38104 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1295 28th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/1998 12:00:00 AM | Permit Number 40275 | 5987371.29466581 | 2106479.28053316 | 37.7632615539614 | -122.486869255203 | (37.7632615539614, -122.486869255203) | 1 | 8 | 3 | 56 | 35 | ||
192625 | 38106 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1295 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/1998 12:00:00 AM | Permit Number 40275 | 5987371.29466581 | 2106479.28053316 | 37.7632615539614 | -122.486869255203 | (37.7632615539614, -122.486869255203) | 1 | 8 | 3 | 56 | 35 | ||
128701 | 38103 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1339 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/1998 12:00:00 AM | 6 | Permit Number 40274 | 5987697.8486 | 2106168.016 | 37.7624259403231 | -122.485716981396 | (37.7624259403231, -122.485716981396) | 1 | 8 | 3 | 56 | 35 | |
77330 | 37234 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2200X Moraga St | 12 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/12/1998 12:00:00 AM | Permit Number 39797 | 5987459.55498562 | 2104367.82715752 | 37.7574692259463 | -122.486408967056 | (37.7574692259463, -122.486408967056) | 1 | 8 | 3 | 56 | 35 | |||
143420 | 37239 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2200X Moraga St | 11 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/12/1998 12:00:00 AM | Permit Number 39797 | 5987459.55498562 | 2104367.82715752 | 37.7574692259463 | -122.486408967056 | (37.7574692259463, -122.486408967056) | 1 | 8 | 3 | 56 | 35 | |||
188906 | 37235 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2200X Moraga St | 9 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/12/1998 12:00:00 AM | Permit Number 39797 | 5987459.55498562 | 2104367.82715752 | 37.7574692259463 | -122.486408967056 | (37.7574692259463, -122.486408967056) | 1 | 8 | 3 | 56 | 35 | |||
46708 | 37017 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1050 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | Permit Number 39630 | 6008600.86286293 | 2102426.42877225 | 37.7533482108195 | -122.413156329636 | (37.7533482108195, -122.413156329636) | 2 | 4 | 7 | 28859 | 19 | ||
63122 | 36807 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1450 Donner Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | 8 | Permit Number 39531 | 6014713.4944 | 2091220.9181 | 37.7229214477716 | -122.391234181927 | (37.7229214477716, -122.391234181927) | 10 | 3 | 8 | 58 | 1 | |
144523 | 36805 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1450 Donner Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | 10 | Permit Number 39531 | 6014737.8573 | 2091203.2549 | 37.7228743001584 | -122.39114872971 | (37.7228743001584, -122.39114872971) | 10 | 3 | 8 | 58 | 1 | |
190026 | 36806 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1450 Donner Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | 4 | Permit Number 39531 | 6014725.6758 | 2091211.782 | 37.7228970378734 | -122.391191434704 | (37.7228970378734, -122.391191434704) | 10 | 3 | 8 | 58 | 1 | |
48513 | 36468 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1469 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39366 | 5995883.06149021 | 2093810.4895036 | 37.7289687842477 | -122.456513863949 | (37.7289687842477, -122.456513863949) | 9 | 7 | 4 | 28861 | 40 | ||
27376 | 35610 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 325 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1998 12:00:00 AM | Permit Number 38967 | 5992638.71984217 | 2094691.8038829 | 37.7312018573426 | -122.467793768821 | (37.7312018573426, -122.467793768821) | 9 | 8 | 4 | 59 | 40 | |||
19123 | 30366 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 764 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 1 | Permit Number 38805 | 6013019.81503 | 2103473.1005 | 37.756469231694 | -122.397947987108 | (37.756469231694, -122.397947987108) | 10 | 3 | 8 | 28856 | 29 | |
120697 | 35219 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 896 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/1998 12:00:00 AM | 7 | Permit Number 38722 | 6011641.6488 | 2112229.3585 | 37.7804350816614 | -122.403330167353 | (37.7804350816614, -122.403330167353) | 6 | 2 | 9 | 28853 | 34 | ||
134808 | 35090 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 122 Hugo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2003 12:00:00 AM | Permit Number 38632 | 5995399.98940883 | 2107075.75682232 | 37.7653641436682 | -122.459144031764 | (37.7653641436682, -122.459144031764) | 15 | 5 | 11 | 56 | 12 | ||
61548 | 34932 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2770 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/1997 12:00:00 AM | 5 | Permit Number 38524 | 6000272.2691 | 2114453.3621 | 37.7859000712136 | -122.442821815392 | (37.7859000712136, -122.442821815392) | 13 | 6 | 1 | 29490 | 27 | ||
115356 | 34434 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 62 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38178 | 6002507.14171464 | 2096534.38214196 | 37.7368260470236 | -122.433808563627 | (37.7368260470236, -122.433808563627) | 2 | 7 | 5 | 63 | 7 | ||
33218 | 34342 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 12661268 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38099 | 6010039 | 2101826 | 37.7517801982502 | -122.408140586549 | (37.7517801982502, -122.408140586549) | 2 | 4 | 7 | 28859 | 19 | ||
39187 | 33577 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 190 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/1996 12:00:00 AM | Permit Number 37685 | 6007025.08907683 | 2097945.62097714 | 37.7409563345382 | -122.418288026055 | (37.7409563345382, -122.418288026055) | 2 | 7 | 7 | 28859 | 2 | |||
98450 | 33575 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 166 Bonview St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/1996 12:00:00 AM | Permit Number 37683 | 6007091.70402672 | 2098068.82881396 | 37.7412983853712 | -122.418066427995 | (37.7412983853712, -122.418066427995) | 2 | 7 | 7 | 28859 | 2 | |||
158959 | 53743 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 166 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/1996 12:00:00 AM | Permit Number 37683 | 6007091.70402672 | 2098068.82881396 | 37.7412983853712 | -122.418066427995 | (37.7412983853712, -122.418066427995) | 2 | 7 | 7 | 28859 | 2 | |||
141960 | 33543 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 225 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | Permit Number 37651 | 6007131.02167651 | 2097668.57746319 | 37.7402015970519 | -122.417902115277 | (37.7402015970519, -122.417902115277) | 2 | 7 | 7 | 28859 | 2 | |||
97204 | 33534 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 199 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | Permit Number 37644 | 6007201.13991539 | 2097799.25218884 | 37.7405643467581 | -122.417668933754 | (37.7405643467581, -122.417668933754) | 2 | 7 | 7 | 28859 | 2 | |||
167727 | 33527 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 191 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | 16 | Permit Number 37637 | 6007243.54484492 | 2097878.27946769 | 37.740783724234 | -122.41752791305 | (37.740783724234, -122.41752791305) | 2 | 7 | 7 | 28859 | 2 | ||
154108 | 33526 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 196 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1996 12:00:00 AM | Permit Number 37636 | 6007164.07712738 | 2097840.15957198 | 37.7406745836679 | -122.417799981783 | (37.7406745836679, -122.417799981783) | 2 | 7 | 7 | 28859 | 2 | ||
137352 | 33525 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 188 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | Permit Number 37635 | 6007199.10727987 | 2097905.4429638 | 37.7408558086436 | -122.417683486647 | (37.7408558086436, -122.417683486647) | 2 | 7 | 7 | 28859 | 2 | |||
109383 | 33524 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 184 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | Permit Number 37634 | 6007216.6223638 | 2097938.08467402 | 37.740946421126 | -122.417625238841 | (37.740946421126, -122.417625238841) | 2 | 7 | 7 | 28859 | 2 | |||
104793 | 33501 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 121 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1996 12:00:00 AM | Permit Number 37595 | 6006663.30728315 | 2098959.97627538 | 37.7437211553943 | -122.41961088786 | (37.7437211553943, -122.41961088786) | 2 | 7 | 7 | 28859 | 2 | ||
108523 | 33374 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1901 Monterey Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/14/1996 12:00:00 AM | Permit Number 37501 | 5992405.97715527 | 2095379.41663179 | 37.7330764284901 | -122.468648408098 | (37.7330764284901, -122.468648408098) | 9 | 8 | 4 | 59 | 40 | |||
111782 | 33375 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1901 Monterey Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/14/1996 12:00:00 AM | Permit Number 37501 | 5992405.97715527 | 2095379.41663179 | 37.7330764284901 | -122.468648408098 | (37.7330764284901, -122.468648408098) | 9 | 8 | 4 | 59 | 40 | |||
56301 | 33288 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1242 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/13/1996 12:00:00 AM | 7 | Permit Number 37449 | 6008832.98278 | 2116682.76958 | 37.7925058062477 | -122.413361726687 | (37.7925058062477, -122.413361726687) | 5 | 1 | 10 | 28857 | 21 | |
75223 | 33248 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2591 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/13/1996 12:00:00 AM | 3 | 3x3 | Permit Number 37429 | 5987367.1404 | 2097667.8262 | 37.7390674308693 | -122.486236717873 | (37.7390674308693, -122.486236717873) | 1 | 8 | 3 | 29491 | 35 |
104905 | 32867 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 593 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1996 12:00:00 AM | Permit Number 37213 | 6001338.28217306 | 2101417.26764603 | 37.7501669020767 | -122.438199507309 | (37.7501669020767, -122.438199507309) | 2 | 4 | 5 | 28862 | 22 | ||
24194 | 32579 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1247 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/1996 12:00:00 AM | 5 | Permit Number 37053 | 5985814.1748 | 2106726.0184 | 37.7638481208517 | -122.492272911774 | (37.7638481208517, -122.492272911774) | 1 | 8 | 3 | 56 | 35 | |
181007 | 32519 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 845 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/15/1996 12:00:00 AM | Permit Number 37021 | 6007591.14794748 | 2095436.54835454 | 37.734098820334 | -122.41615314248 | (37.734098820334, -122.41615314248) | 2 | 7 | 7 | 28859 | 2 | ||
17506 | 32483 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 76 States St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/10/1996 12:00:00 AM | 10 | Permit Number 36991 | 6001817.38914 | 2106232.68155 | 37.763416104203 | -122.436887416735 | (37.763416104203, -122.436887416735) | 15 | 5 | 5 | 28862 | 3 | |
85373 | 32334 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 150 Grand View Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/1996 12:00:00 AM | Permit Number 36897 | 6000779.60429895 | 2103438.99609434 | 37.7556862897816 | -122.440276412657 | (37.7556862897816, -122.440276412657) | 2 | 4 | 5 | 63 | 38 | |||
153816 | 31678 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 568 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35184 | 5984441.54106734 | 2111980.46046246 | 37.7781949786835 | -122.497408297818 | (37.7781949786835, -122.497408297818) | 11 | 6 | 2 | 55 | 26 | |||
166131 | 31624 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 437 Burnett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1995 12:00:00 AM | Permit Number 35141 | 5999729.14661554 | 2103006.40603622 | 37.7544386392977 | -122.443878137556 | (37.7544386392977, -122.443878137556) | 2 | 5 | 5 | 63 | 38 | |||
37830 | 31102 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 215 Congo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | 6 | Permit Number 34832 | 6000072.59523 | 2094462.74015 | 37.7309993521219 | -122.442077177628 | (37.7309993521219, -122.442077177628) | 9 | 7 | 4 | 63 | 40 | |
177903 | 30798 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 142 Acadia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1995 12:00:00 AM | Permit Number 34664 | 6001440.7282053 | 2094773.69226545 | 37.7319310278176 | -122.437369578033 | (37.7319310278176, -122.437369578033) | 9 | 7 | 4 | 63 | 40 | ||
22092 | 30745 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 486X Page St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34630 | 6004274.8073 | 2109806.6859 | 37.773368818647 | -122.42864278458 | (37.773368818647, -122.42864278458) | 7 | 9 | 11 | 28852 | 10 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );