953 rows where qSpecies_id = 60 sorted by PermitNotes descending

View and edit SQL

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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);