trees
3,267 rows where qSpecies_id = 67 sorted by Fire Prevention Districts 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
184 | 204541 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 400x Marietta Dr | 4 | Median : Cutout | Tree | DPW 1 | 16 | Width 3ft | 5999538.51913 | 2097033.8732 | 37.7380286277303 | -122.444108242518 | (37.7380286277303, -122.444108242518) | 9 | 7 | 4 | 59 | 40 | |||
2387 | 204545 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300x Marietta Dr | 73 | Median : Cutout | Tree | DPW 1 | 15 | Width 3ft | 5999723.14356 | 2097244.03838 | 37.7386162222515 | -122.44348499884 | (37.7386162222515, -122.44348499884) | 9 | 7 | 4 | 59 | 40 | |||
2414 | 204512 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 38 Cresta Vista Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5995329.78004 | 2096137.76725 | 37.7353271425384 | -122.458594991475 | (37.7353271425384, -122.458594991475) | 9 | 7 | 4 | 59 | 40 | |||
4183 | 204530 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 400x Marietta Dr | 28 | Median : Cutout | Tree | DPW 1 | 9 | Width 3ft | 5999185.819 | 2097019.37186 | 37.7379686834 | -122.445326654823 | (37.7379686834, -122.445326654823) | 9 | 7 | 4 | 59 | 40 | |||
4199 | 78379 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 35 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6001615.3363 | 2090906.3588 | 37.7213221342777 | -122.436489223015 | (37.7213221342777, -122.436489223015) | 9 | 7 | 6 | 28861 | 5 | |||
4343 | 65663 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 35 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/1991 12:00:00 AM | Permit Number 28583 | 5998824.47448758 | 2095859.96140736 | 37.7347645844735 | -122.446492607567 | (37.7347645844735, -122.446492607567) | 9 | 7 | 4 | 59 | 40 | ||
5308 | 30814 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 145 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1995 12:00:00 AM | 8 | Permit Number 34676 | 6001106.90976 | 2094917.71442 | 37.7323074960919 | -122.438533971982 | (37.7323074960919, -122.438533971982) | 9 | 7 | 4 | 63 | 40 | |
6227 | 77210 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 499X Hearst Ave | 17 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/15/1999 12:00:00 AM | 5 | 3x3 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 | |
6663 | 205779 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 451 Hearst Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5998302.15103 | 2094370.64521 | 37.7306454275301 | -122.448191246446 | (37.7306454275301, -122.448191246446) | 9 | 7 | 4 | 28861 | 40 | |||
6979 | 42994 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 500 Yale St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42870 | 6007553.67502493 | 2091408.33369541 | 37.7230361052022 | -122.415997529963 | (37.7230361052022, -122.415997529963) | 9 | 3 | 7 | 309 | 28 | ||
7079 | 120113 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 266 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999649 | 2094406 | 37.7308194078275 | -122.443537538611 | (37.7308194078275, -122.443537538611) | 9 | 7 | 4 | 63 | 40 | ||||
8344 | 205728 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 395 San Leandro Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5992226.12034 | 2094297.28733 | 37.7300947798476 | -122.469191482823 | (37.7300947798476, -122.469191482823) | 9 | 8 | 4 | 59 | 40 | |||
9444 | 205868 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 312 Lakeview Ave | 1 | : | Tree | Private 2 | 11/04/1969 12:00:00 AM | 13 | Width 3ft | Permit Number 6398 | 5996845.79725 | 2089640.92362 | 37.7175753652817 | -122.452884796511 | (37.7175753652817, -122.452884796511) | 9 | 8 | 6 | 28861 | 24 | |
9837 | 175669 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 218 Craut St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6004027.59383 | 2093929.81211 | 37.729760646628 | -122.428366110135 | (37.729760646628, -122.428366110135) | 9 | 7 | 6 | 28861 | 5 | |||
9967 | 15752 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4650 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4x4 | 6001829 | 2091729 | 37.7235930609595 | -122.435809477936 | (37.7235930609595, -122.435809477936) | 9 | 7 | 6 | 28861 | 25 | |||
10012 | 175625 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 700x Mansell St | 22 | Median : Cutout | Tree | DPW 1 | 10 | Width 0ft | 6009376.03196 | 2090018.08104 | 37.7193210519043 | -122.409599906627 | (37.7193210519043, -122.409599906627) | 9 | 3 | 8 | 309 | 18 | |||
10199 | 15747 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4596 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6002118.4331 | 2092158.7505 | 37.7247894959296 | -122.434839677987 | (37.7247894959296, -122.434839677987) | 9 | 7 | 6 | 28861 | 25 | |||
10219 | 78797 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 85 Morse St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6001030.80147 | 2087976.50512 | 37.7132441799408 | -122.438300000759 | (37.7132441799408, -122.438300000759) | 9 | 7 | 6 | 28861 | 5 | |||
10401 | 205781 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 451 Hearst Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5998357.35987 | 2094370.04016 | 37.7306469222149 | -122.448000338355 | (37.7306469222149, -122.448000338355) | 9 | 7 | 4 | 28861 | 40 | |||
10724 | 175667 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 218 Craut St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6004027.33391 | 2093958.94333 | 37.7298406197321 | -122.42836908418 | (37.7298406197321, -122.42836908418) | 9 | 7 | 6 | 28861 | 5 | |||
11996 | 204552 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300x Marietta Dr | 60 | Median : Cutout | Tree | DPW 1 | 11 | Width 5ft | 5999641.44525 | 2097441.40723 | 37.7391534907361 | -122.443781647414 | (37.7391534907361, -122.443781647414) | 9 | 7 | 4 | 59 | 40 | |||
12114 | 78378 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 35 Russia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6001605.25452 | 2090913.72299 | 37.7213417817901 | -122.436524599656 | (37.7213417817901, -122.436524599656) | 9 | 7 | 6 | 28861 | 5 | |||
12140 | 260108 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 921 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008890 | 2090823 | 37.7215039438499 | -122.411336776053 | (37.7215039438499, -122.411336776053) | 9 | 3 | 7 | 309 | 28 | ||||
12374 | 65607 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 182 Maynard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/09/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767458 | 6004579.16944 | 2093759.75788 | 37.7293249116129 | -122.426447147525 | (37.7293249116129, -122.426447147525) | 9 | 7 | 6 | 28861 | 5 |
12837 | 47215 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 106 Cambridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 6 | Permit Number 45166 | 6006633.47627 | 2094299.61445 | 37.7309231552671 | -122.419383490876 | (37.7309231552671, -122.419383490876) | 9 | 7 | 7 | 309 | 5 | |
13520 | 175634 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 29 Tucker Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6010973.25986 | 2088486.32565 | 37.7152045356343 | -122.403971122781 | (37.7152045356343, -122.403971122781) | 9 | 7 | 8 | 309 | 39 | |||
14974 | 71651 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 177 Wilson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5994505.19973 | 2086471.6739 | 37.7087389470079 | -122.460745569971 | (37.7087389470079, -122.460745569971) | 9 | 8 | 6 | 28861 | 25 | |||
15203 | 70396 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 309 Madison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6005777.21829 | 2092245.96314 | 37.7252360153268 | -122.422197872442 | (37.7252360153268, -122.422197872442) | 9 | 7 | 7 | 309 | 5 | |||
15502 | 78224 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1214 Bowdoin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6009704.84764 | 2090538.93921 | 37.7207696402774 | -122.408500030351 | (37.7207696402774, -122.408500030351) | 9 | 3 | 7 | 309 | 28 | |||
15793 | 42348 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 380X Flood Ave | 7 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/23/2000 12:00:00 AM | 3 | 8x45 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 |
18532 | 205861 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 78 Montana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 1ft | 5996047.17386 | 2089324.02533 | 37.7166594390586 | -122.455622364282 | (37.7166594390586, -122.455622364282) | 9 | 8 | 6 | 28861 | 24 | |||
19793 | 204525 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 400x Marietta Dr | 35 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 5999144.59173 | 2097002.17091 | 37.7379191001944 | -122.44546796079 | (37.7379191001944, -122.44546796079) | 9 | 7 | 4 | 59 | 40 | |||
19859 | 204521 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 400x Marietta Dr | 41 | Median : Cutout | Tree | DPW 1 | 15 | Width 3ft | 5999107.98616 | 2096985.95215 | 37.7378724775396 | -122.445593357764 | (37.7378724775396, -122.445593357764) | 9 | 7 | 4 | 59 | 40 | |||
20386 | 49124 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 235 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/14/2003 12:00:00 AM | Permit Number 46255 | 5992667.25802575 | 2095222.38841823 | 37.7326603583325 | -122.467733682241 | (37.7326603583325, -122.467733682241) | 9 | 8 | 4 | 59 | 40 | ||
20579 | 175642 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 275 De Long St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 10ft | 5993719.3869 | 2086798.38844 | 37.709590783961 | -122.463485117168 | (37.709590783961, -122.463485117168) | 9 | 8 | 6 | 28861 | 25 | |||
22105 | 175678 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 147 Trumbull St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6004344.1962 | 2094346.31946 | 37.7309221929871 | -122.42730123817 | (37.7309221929871, -122.42730123817) | 9 | 7 | 6 | 28861 | 5 | |||
22495 | 204586 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 231 Edna St | 2 | Side Yard : Yard | Tree | Private 2 | 14 | 5998760.41171 | 2095319.00684 | 37.7332755919857 | -122.446675184631 | (37.7332755919857, -122.446675184631) | 9 | 7 | 4 | 59 | 40 | ||||
22792 | 175701 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 150 Yale St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 3ft | 6007087.6481 | 2092939.47489 | 37.7272140768676 | -122.417716969765 | (37.7272140768676, -122.417716969765) | 9 | 3 | 7 | 309 | 5 | |||
23237 | 114665 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 480 Myra Way | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5997245.35324946 | 2096954.8836892 | 37.737680654694 | -122.452031115145 | (37.737680654694, -122.452031115145) | 9 | 7 | 4 | 59 | 40 | ||||
23518 | 175745 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 52 Baltimore Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 6ft | 6003007.00361 | 2086627.02122 | 37.7096509944604 | -122.431373299139 | (37.7096509944604, -122.431373299139) | 9 | 7 | 6 | 28861 | 5 | |||
23669 | 42343 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 380X Flood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/23/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 |
23892 | 57845 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 153 Trumbull St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/1977 12:00:00 AM | 10 | Permit Number 16786 | 6004375.10165 | 2094347.97988 | 37.7309284999329 | -122.427194511121 | (37.7309284999329, -122.427194511121) | 9 | 7 | 6 | 28861 | 5 | ||
24046 | 42102 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 324 Gennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42408 | 5997476.85720986 | 2094482.06690448 | 37.7309041502726 | -122.451052430403 | (37.7309041502726, -122.451052430403) | 9 | 7 | 4 | 59 | 40 | ||
25231 | 116687 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 45 Santa Rosa Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 777961 | 6002117.845 | 2092646.43529 | 37.7261285348836 | -122.434876571303 | (37.7261285348836, -122.434876571303) | 9 | 7 | 6 | 28861 | 25 | ||
26052 | 94065 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 98 Ney St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Tree 5 on Craut | 6004036 | 2094004 | 37.7299648256421 | -122.428342334562 | (37.7299648256421, -122.428342334562) | 9 | 7 | 6 | 28861 | 5 | ||||
26172 | 205731 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 391 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5992455.63344 | 2094179.85071 | 37.7297855875292 | -122.468389493495 | (37.7297855875292, -122.468389493495) | 9 | 8 | 4 | 59 | 40 | |||
27126 | 205835 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 815 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5994339.81958 | 2090564.44928 | 37.7199672210772 | -122.46161367654 | (37.7199672210772, -122.46161367654) | 9 | 8 | 6 | 28861 | 24 | |||
27850 | 204603 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 178 Judson Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5998810.44602 | 2093518.01163 | 37.7283333406902 | -122.446372685966 | (37.7283333406902, -122.446372685966) | 9 | 7 | 4 | 28861 | 40 | |||
28211 | 175688 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1849 Felton St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 5ft | 6005530.78221 | 2092211.86243 | 37.7251284788867 | -122.423047355852 | (37.7251284788867, -122.423047355852) | 9 | 7 | 7 | 309 | 5 | |||
28220 | 67519 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 343 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/22/1992 12:00:00 AM | Permit Number 31055 | 5997813.90677575 | 2093780.36383283 | 37.7289967307539 | -122.449836649621 | (37.7289967307539, -122.449836649621) | 9 | 7 | 4 | 28861 | 40 | ||
28702 | 204518 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 400x Marietta Dr | 47 | Median : Cutout | Tree | DPW 1 | 17 | Width 3ft | 5999003.37096 | 2096940.15214 | 37.7377407484277 | -122.445951769058 | (37.7377407484277, -122.445951769058) | 9 | 7 | 4 | 59 | 40 | |||
28957 | 204576 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 589 Congo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6000101.14547 | 2095674.82006 | 37.734329067735 | -122.442065445065 | (37.734329067735, -122.442065445065) | 9 | 7 | 4 | 63 | 40 | |||
29150 | 175710 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300 Gaven St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 4ft | 6008896.74795 | 2094854.28773 | 37.7325733824383 | -122.411598132751 | (37.7325733824383, -122.411598132751) | 9 | 3 | 7 | 309 | 28 | |||
30555 | 175665 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 218 Craut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6004025.70156 | 2093994.52733 | 37.7299382330641 | -122.428377262621 | (37.7299382330641, -122.428377262621) | 9 | 7 | 6 | 28861 | 5 | |||
30696 | 175647 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 199 Shakespeare St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 5993520.37631 | 2086668.28967 | 37.7092220951912 | -122.464163488366 | (37.7092220951912, -122.464163488366) | 9 | 8 | 6 | 28861 | 25 | |||
31448 | 205797 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 250 Foerster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5998120.49312 | 2094141.78617 | 37.7300066480673 | -122.448802784526 | (37.7300066480673, -122.448802784526) | 9 | 7 | 4 | 28861 | 40 | |||
31465 | 175679 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 141 Trumbull St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6004312.06369 | 2094345.39116 | 37.7309178267824 | -122.427412259486 | (37.7309178267824, -122.427412259486) | 9 | 7 | 6 | 28861 | 5 | |||
31511 | 31182 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 538 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34880 | 5992624.59921054 | 2089874.97031305 | 37.7179751991794 | -122.467492439169 | (37.7179751991794, -122.467492439169) | 9 | 8 | 6 | 64 | 24 | ||
31782 | 205865 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 565 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5994014.3343 | 2090276.58042 | 37.7191580614818 | -122.462717886617 | (37.7191580614818, -122.462717886617) | 9 | 8 | 6 | 64 | 24 | |||
31886 | 175628 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 700x Mansell St | 43 | Median : Cutout | Tree | DPW 1 | 9 | Width 0ft | 6009091.54392 | 2089913.69924 | 37.7190184956734 | -122.410575912047 | (37.7190184956734, -122.410575912047) | 9 | 3 | 8 | 309 | 18 | |||
32059 | 62223 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 101 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/19/2010 12:00:00 AM | 3 | Permit Number 53519 | 6001462.98995 | 2093679.24123 | 37.7289271819206 | -122.437214279825 | (37.7289271819206, -122.437214279825) | 9 | 7 | 6 | 28861 | 25 | |
32660 | 204524 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 400x Marietta Dr | 36 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 5999142.13445 | 2097001.14376 | 37.7379161396038 | -122.445476382943 | (37.7379161396038, -122.445476382943) | 9 | 7 | 4 | 59 | 40 | |||
32962 | 175676 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 183 Trumbull St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6004509.17603 | 2094353.87576 | 37.7309522699232 | -122.426731413329 | (37.7309522699232, -122.426731413329) | 9 | 7 | 6 | 28861 | 5 | |||
33420 | 175639 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 28 De Long St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 5995095.5192 | 2086815.41001 | 37.7097167133235 | -122.458730228841 | (37.7097167133235, -122.458730228841) | 9 | 8 | 6 | 28861 | 25 | |||
33470 | 205832 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 179 Brighton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5996204.59549 | 2091059.7455 | 37.7214343508049 | -122.455203600366 | (37.7214343508049, -122.455203600366) | 9 | 8 | 6 | 28861 | 24 | |||
33993 | 175658 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 401 Cayuga Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6002179.18447 | 2093938.15694 | 37.729678792135 | -122.434756854447 | (37.729678792135, -122.434756854447) | 9 | 7 | 6 | 28861 | 25 | |||
34196 | 204497 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 85 El Verano Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5994608.21745 | 2094783.39604 | 37.7315668747125 | -122.460991549817 | (37.7315668747125, -122.460991549817) | 9 | 8 | 4 | 59 | 40 | |||
35092 | 66605 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 246 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/1991 12:00:00 AM | Permit Number 29800 | 6004471.01014592 | 2091844.94810518 | 37.7240611530605 | -122.426684762239 | (37.7240611530605, -122.426684762239) | 9 | 7 | 6 | 28861 | 5 | ||
35378 | 175685 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 212 Madison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6005595.71584 | 2092701.63331 | 37.7264769466425 | -122.422857678951 | (37.7264769466425, -122.422857678951) | 9 | 7 | 7 | 309 | 5 | |||
35484 | 205807 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 360 Flood Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5998283.57616 | 2094110.59852 | 37.7299303388027 | -122.448236744044 | (37.7299303388027, -122.448236744044) | 9 | 7 | 4 | 28861 | 40 | |||
35607 | 205859 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 70 Montana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5996096.42731 | 2089323.76634 | 37.7166615542625 | -122.455452101947 | (37.7166615542625, -122.455452101947) | 9 | 8 | 6 | 28861 | 24 | |||
35656 | 205826 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 116 Jules Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5994471.11499 | 2090695.81427 | 37.7203354745885 | -122.461169353905 | (37.7203354745885, -122.461169353905) | 9 | 8 | 6 | 28861 | 24 | |||
35768 | 175732 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 680 Sweeny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6007353.31502 | 2094046.83333 | 37.7302695900593 | -122.416876980503 | (37.7302695900593, -122.416876980503) | 9 | 3 | 7 | 309 | 28 | |||
35778 | 205864 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 714 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5995928.91835 | 2089403.79858 | 37.7168716907653 | -122.456036876198 | (37.7168716907653, -122.456036876198) | 9 | 8 | 6 | 28861 | 24 | |||
35782 | 205854 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 293 Montana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5994120.5161 | 2089316.03837 | 37.7165267575898 | -122.462281231613 | (37.7165267575898, -122.462281231613) | 9 | 8 | 6 | 28861 | 24 | |||
35968 | 204573 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 403 Baden St | 1 | Side Yard : Yard | Tree | Private 2 | 6 | Width 10ft | 6000740.47882 | 2095257.81142 | 37.7332204725414 | -122.439825179911 | (37.7332204725414, -122.439825179911) | 9 | 7 | 5 | 63 | 40 | |||
36269 | 47348 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 46 Jules Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/2002 12:00:00 AM | Permit Number 45274 | 5994469.1469604 | 2090229.4816179 | 37.7190549234375 | -122.461142372223 | (37.7190549234375, -122.461142372223) | 9 | 8 | 6 | 28861 | 24 | ||
36466 | 25316 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 15X Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6001811.27411 | 2091808.97426 | 37.7238116453109 | -122.435876472647 | (37.7238116453109, -122.435876472647) | 9 | 7 | 6 | 28861 | 25 | |||
36494 | 38922 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 758 Lakeview Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/02/1998 12:00:00 AM | Permit Number 40732 | 5994446.73850644 | 2089956.09273845 | 37.7183029732854 | -122.461200022537 | (37.7183029732854, -122.461200022537) | 9 | 8 | 6 | 28861 | 24 | |||
36690 | 42398 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 600 Gennessee St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42555 | 5997487.92419847 | 2095274.73436784 | 37.7330812596511 | -122.451071309951 | (37.7330812596511, -122.451071309951) | 9 | 7 | 4 | 59 | 40 | ||
36928 | 205763 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300x Marietta Dr | 12 | Median : Cutout | Tree | DPW 1 | 3 | Width 5ft | 5999213.2528 | 2097587.01076 | 37.739528850671 | -122.445272603768 | (37.739528850671, -122.445272603768) | 9 | 7 | 4 | 59 | 40 | |||
37151 | 77198 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 499X Hearst Ave | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/15/1999 12:00:00 AM | 3 | 3x3 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 | |
37241 | 204602 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 200 Judson Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 8ft | 5998668.22296 | 2093529.87364 | 37.7283577869805 | -122.446865208659 | (37.7283577869805, -122.446865208659) | 9 | 7 | 4 | 28861 | 40 | |||
37261 | 204581 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 111 Melrose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5999358.22229 | 2095479.77537 | 37.7337511552818 | -122.444619947753 | (37.7337511552818, -122.444619947753) | 9 | 7 | 4 | 59 | 40 | |||
38467 | 204378 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 150 Ramsell St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5992980.7825 | 2088221.20971 | 37.7134549279767 | -122.466141167706 | (37.7134549279767, -122.466141167706) | 9 | 8 | 6 | 64 | 24 | |||
39294 | 205788 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 201 Hearst Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6000020.87413 | 2094345.53232 | 37.7306745790527 | -122.442247574877 | (37.7306745790527, -122.442247574877) | 9 | 7 | 4 | 63 | 40 | |||
39774 | 204585 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 132 Melrose Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5999120.349 | 2095540.31074 | 37.7339037945118 | -122.445446694533 | (37.7339037945118, -122.445446694533) | 9 | 7 | 4 | 59 | 40 | |||
40121 | 204523 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 400x Marietta Dr | 39 | Median : Cutout | Tree | DPW 1 | 5 | Width 3ft | 5999123.85141 | 2096993.97726 | 37.7378954183401 | -122.445539080959 | (37.7378954183401, -122.445539080959) | 9 | 7 | 4 | 59 | 40 | |||
40242 | 67987 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 201 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31711 | 5995615.55852093 | 2091245.53486568 | 37.7219106715002 | -122.457253158986 | (37.7219106715002, -122.457253158986) | 9 | 8 | 4 | 28861 | 24 | ||
40261 | 205848 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 438 Orizaba Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5994034.73412 | 2089295.68258 | 37.7164659256424 | -122.462576258696 | (37.7164659256424, -122.462576258696) | 9 | 8 | 6 | 28861 | 24 | |||
40323 | 204470 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 246 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5992624.09671 | 2095127.97284 | 37.7323986243995 | -122.467876035462 | (37.7323986243995, -122.467876035462) | 9 | 8 | 4 | 59 | 40 | |||
40740 | 175739 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 275 Chicago Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 6ft | 6002794.41849 | 2086722.13696 | 37.7099001111816 | -122.432114818072 | (37.7099001111816, -122.432114818072) | 9 | 7 | 6 | 28861 | 5 | |||
41099 | 204587 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 231 Edna St | 3 | Side Yard : Yard | Tree | Private 2 | 15 | 5998761.63986 | 2095307.99591 | 37.733245428731 | -122.446670146634 | (37.733245428731, -122.446670146634) | 9 | 7 | 4 | 59 | 40 | ||||
41535 | 204536 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 400x Marietta Dr | 12 | Median : Cutout | Tree | DPW 1 | 13 | Width 3ft | 5999467.93009 | 2097036.4178 | 37.7380315873918 | -122.444352485783 | (37.7380315873918, -122.444352485783) | 9 | 7 | 4 | 59 | 40 | |||
41536 | 204380 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 64 Ralston St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5992207.49196 | 2088316.25633 | 37.713671258107 | -122.468820820922 | (37.713671258107, -122.468820820922) | 9 | 8 | 6 | 64 | 24 | |||
41896 | 204368 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 504 Head St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5993515.00932 | 2089252.8539 | 37.7163183837543 | -122.464369561706 | (37.7163183837543, -122.464369561706) | 9 | 8 | 6 | 64 | 24 | |||
41910 | 205764 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300x Marietta Dr | 13 | Median : Cutout | Tree | DPW 1 | 5 | Width 5ft | 5999220.24224 | 2097585.41843 | 37.7395248774812 | -122.445248322956 | (37.7395248774812, -122.445248322956) | 9 | 7 | 4 | 59 | 40 | |||
42058 | 31004 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 285 Chicago Way | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34778 | 6002766.74364375 | 2086692.10708835 | 37.7098160865806 | -122.432208324272 | (37.7098160865806, -122.432208324272) | 9 | 7 | 6 | 28861 | 5 | ||
42529 | 205847 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 67 Brighton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5996192.14222 | 2090321.7289 | 37.7194072168392 | -122.455193341813 | (37.7194072168392, -122.455193341813) | 9 | 8 | 6 | 28861 | 24 | |||
43029 | 204357 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 380 Byxbee St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 5991985.99504 | 2091008.33716 | 37.7210502575511 | -122.469782262745 | (37.7210502575511, -122.469782262745) | 9 | 8 | 6 | 64 | 24 |
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) );