trees
953 rows where qSpecies_id = 60 sorted by SiteOrder 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 84102 | 27160 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1700X Silver Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3 | 3X3 | 6011020.5092245 | 2095004.7366116 | 37.7331053850338 | -122.40426632243 | (37.7331053850338, -122.40426632243) | 10 | 3 | 8 | 58 | 1 | |||
| 125660 | 188325 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 800 Wisconsin St | 9 | : | Tree | Private 2 | 3 | Width 4ft | 6012720.87909 | 2103581.41048 | 37.7567499739592 | -122.398989421832 | (37.7567499739592, -122.398989421832) | 10 | 3 | 8 | 28856 | 29 | |||
| 134399 | 251283 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1299x Hudson Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 06/06/1997 12:00:00 AM | 3x3 | 6017207 | 2095414 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | 10 | 3 | 8 | 58 | 1 | ||
| 170132 | 88064 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2055 Silver Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51066 | 6012497.5295 | 2096095.30681 | 37.7361822871662 | -122.399236364881 | (37.7361822871662, -122.399236364881) | 10 | 3 | 8 | 58 | 1 | |
| 179898 | 258001 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1150 Golden Gate Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004329 | 2112216 | 37.7799872696874 | -122.428627101331 | (37.7799872696874, -122.428627101331) | 7 | 9 | 11 | 29490 | 41 | ||||
| 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 | |||
| 37405 | 258000 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1150 Golden Gate Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004329 | 2112216 | 37.7799872696874 | -122.428627101331 | (37.7799872696874, -122.428627101331) | 7 | 9 | 11 | 29490 | 41 | ||||
| 62112 | 188324 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 800 Wisconsin St | 8 | : | Tree | Private 2 | 3 | Width 4ft | 6012719.06472 | 2103600.79409 | 37.756803096012 | -122.39899705709 | (37.756803096012, -122.39899705709) | 10 | 3 | 8 | 28856 | 29 | |||
| 78077 | 37236 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2200X Moraga St | 8 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 03/26/2013 12:00:00 AM | Permit Number 770085 | 5987459.55498562 | 2104367.82715752 | 37.7574692259463 | -122.486408967056 | (37.7574692259463, -122.486408967056) | 1 | 8 | 3 | 56 | 35 | |||
| 121399 | 188345 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2055 Silver Ave | 8 | : | Tree | Private 2 | 5 | Width 3ft | 6012515.97712 | 2096106.68244 | 37.7362145503607 | -122.399173381754 | (37.7362145503607, -122.399173381754) | 10 | 3 | 8 | 58 | 1 | |||
| 128554 | 30747 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 496X Page St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34630 | 6004231.9845 | 2109799.7949 | 37.7733474740483 | -122.428790423308 | (37.7733474740483, -122.428790423308) | 7 | 9 | 11 | 28852 | 10 |
| 162242 | 116354 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4051X 24TH ST | 8 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 10 | 3x3 | 6002850 | 2101803 | 37.7513118941202 | -122.432999456035 | (37.7513118941202, -122.432999456035) | 2 | 4 | 5 | 28862 | 22 | |||
| 167923 | 251287 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1299x Hudson Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 02/09/1998 12:00:00 AM | 3x3 | 6017207 | 2095414 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | 10 | 3 | 8 | 58 | 1 | ||
| 2149 | 204638 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 180 Staples Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 1ft | 5998850.55813 | 2093801.2422 | 37.7291133164211 | -122.446254382837 | (37.7291133164211, -122.446254382837) | 9 | 7 | 4 | 28861 | 40 | |||
| 5527 | 204642 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 290 Granada Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 5995680.91746 | 2091957.81811 | 37.7238701852543 | -122.457078728228 | (37.7238701852543, -122.457078728228) | 9 | 8 | 4 | 28861 | 24 | |||
| 34591 | 251286 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1299x Hudson Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 02/09/1998 12:00:00 AM | 3x3 | 6017207 | 2095414 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | 10 | 3 | 8 | 58 | 1 | ||
| 53307 | 257999 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1150 Golden Gate Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004329 | 2112216 | 37.7799872696874 | -122.428627101331 | (37.7799872696874, -122.428627101331) | 7 | 9 | 11 | 29490 | 41 | ||||
| 74685 | 30746 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 490X Page St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34630 | 6004256.1031 | 2109802.2559 | 37.7733555963905 | -122.428707169176 | (37.7733555963905, -122.428707169176) | 7 | 9 | 11 | 28852 | 10 |
| 87948 | 116353 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4051X 24TH ST | 7 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 6002850 | 2101803 | 37.7513118941202 | -122.432999456035 | (37.7513118941202, -122.432999456035) | 2 | 4 | 5 | 28862 | 22 | ||||
| 95201 | 24238 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 200X Willow St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/22/1999 12:00:00 AM | 6 | 4X4 | 6006547.3507 | 2113418.3192 | 37.7834138390239 | -122.421038210119 | (37.7834138390239, -122.421038210119) | 7 | 9 | 11 | 28858 | 41 | ||
| 100796 | 96937 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 901 Bay Shore Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010960.45235 | 2094890.17175 | 37.7327874579767 | -122.404465894707 | (37.7327874579767, -122.404465894707) | 10 | 3 | 8 | 58 | 1 | |||
| 122856 | 222583 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 193 Diamond St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6001753.50389 | 2104887.2031 | 37.7597181171131 | -122.43701204208 | (37.7597181171131, -122.43701204208) | 2 | 4 | 5 | 28862 | 3 | |||
| 133982 | 175759 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 201 Tocoloma Ave | 7 | Front Yard : Yard | Tree | Private 2 | 5 | 6012872.74847 | 2087577.73375 | 37.7128156646891 | -122.397341941199 | (37.7128156646891, -122.397341941199) | 10 | 3 | 8 | 309 | 1 | ||||
| 136262 | 27129 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2095X Silver Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/16/1999 12:00:00 AM | 6 | 3X3 | 6012407.8106259 | 2096047.4553772 | 37.7360458965855 | -122.399543203223 | (37.7360458965855, -122.399543203223) | 10 | 3 | 8 | 58 | 1 | ||
| 148169 | 116626 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 5732X GEARY BLVD | 7 | Front Yard : Cutout | Tree | MTA 3 | DPW | 3x3 | 5989254 | 2112678 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | 11 | 6 | 2 | 55 | 26 | |||
| 152283 | 188344 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2055 Silver Ave | 7 | : | Tree | Private 2 | 8 | Width 3ft | 6012532.5163 | 2096115.82901 | 37.7362405866356 | -122.399116840463 | (37.7362405866356, -122.399116840463) | 10 | 3 | 8 | 58 | 1 | |||
| 170318 | 27200 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 302 Silver Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/23/2005 12:00:00 AM | 3 | 3X3 | 6003430.01422 | 2093478.36539 | 37.7284872425726 | -122.430399810923 | (37.7284872425726, -122.430399810923) | 9 | 7 | 6 | 28861 | 5 | ||
| 121455 | 186786 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1200 Sunset Blvd | 60 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5984829.112 | 2106870.9818 | 37.7641885128796 | -122.495690587985 | (37.7641885128796, -122.495690587985) | 1 | 8 | 3 | 56 | 35 | |||
| 12104 | 204637 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 180 Staples Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 1ft | 5998869.73196 | 2093802.12764 | 37.7291168426482 | -122.446188161278 | (37.7291168426482, -122.446188161278) | 9 | 7 | 4 | 28861 | 40 | |||
| 19519 | 222582 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 193 Diamond St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001750.89139 | 2104845.17495 | 37.7596025695234 | -122.437018068443 | (37.7596025695234, -122.437018068443) | 2 | 4 | 5 | 28862 | 3 | |||
| 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 |
| 50927 | 26893 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1275X HUDSON AVE | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/09/1999 12:00:00 AM | 6 | 3X4 | 6017281 | 2095243 | 37.734107450868 | -122.382638493216 | (37.734107450868, -122.382638493216) | 10 | 3 | 8 | 58 | 1 | ||
| 72533 | 116876 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 824 Carolina St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6012412.72368 | 2104109.13047 | 37.7581818007698 | -122.400092202897 | (37.7581818007698, -122.400092202897) | 10 | 3 | 8 | 28856 | 29 | |||
| 77637 | 27128 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2095X Silver Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/16/1999 12:00:00 AM | 6 | 3X3 | 6012407.8106259 | 2096047.4553772 | 37.7360458965855 | -122.399543203223 | (37.7360458965855, -122.399543203223) | 10 | 3 | 8 | 58 | 1 | ||
| 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 | ||
| 100401 | 116352 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4051X 24TH ST | 6 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 6002850 | 2101803 | 37.7513118941202 | -122.432999456035 | (37.7513118941202, -122.432999456035) | 2 | 4 | 5 | 28862 | 22 | ||||
| 101323 | 188323 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 800 Wisconsin St | 6 | : | Tree | Private 2 | 3 | Width 3ft | 6012718.59247 | 2103642.79546 | 37.7569183962771 | -122.399001638237 | (37.7569183962771, -122.399001638237) | 10 | 3 | 8 | 28856 | 29 | |||
| 103570 | 257998 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1150 Golden Gate Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004329 | 2112216 | 37.7799872696874 | -122.428627101331 | (37.7799872696874, -122.428627101331) | 7 | 9 | 11 | 29490 | 41 | ||||
| 108590 | 19415 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 600X Sloat Blvd | 6 | Median : Cutout | Tree | DPW 1 | 05/04/1999 12:00:00 AM | 3 | 20 | 5989744.8312093 | 2096044.8028161 | 37.7347493206824 | -122.477897219949 | (37.7347493206824, -122.477897219949) | 1 | 8 | 3 | 64 | 35 | ||
| 140714 | 47217 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 102 Colby St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | Permit Number 45167 | 6008165.27144692 | 2093507.30784615 | 37.7288338073717 | -122.414031775389 | (37.7288338073717, -122.414031775389) | 9 | 3 | 7 | 309 | 28 | ||
| 144481 | 96936 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 901 Bay Shore Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010967.89306 | 2094873.35668 | 37.7327417031574 | -122.404438986978 | (37.7327417031574, -122.404438986978) | 10 | 3 | 8 | 58 | 1 | |||
| 155439 | 48437 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2399 Post St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2002 12:00:00 AM | Permit Number 45814 | 6000698.38093235 | 2113767.30398552 | 37.784040615681 | -122.441298346596 | (37.784040615681, -122.441298346596) | 15 | 6 | 11 | 29490 | 13 | |||
| 189295 | 27199 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 302 Silver Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1999 12:00:00 AM | 3 | 3X3 | 6003401.87305 | 2093484.57619 | 37.7285027019175 | -122.43049753934 | (37.7285027019175, -122.43049753934) | 9 | 7 | 6 | 28861 | 5 | ||
| 15684 | 204670 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 380 Monterey Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5999483.78605 | 2094717.68964 | 37.7316658109241 | -122.4441310961 | (37.7316658109241, -122.4441310961) | 9 | 7 | 4 | 63 | 40 | |||
| 17042 | 116875 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 824 Carolina St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6012413.40755 | 2104121.29509 | 37.7582152402716 | -122.400090692059 | (37.7582152402716, -122.400090692059) | 10 | 3 | 8 | 28856 | 29 | |||
| 36294 | 16142 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 370 Monterey Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 5999632.4946283 | 2094718.5075125 | 37.7316765391045 | -122.443617041287 | (37.7316765391045, -122.443617041287) | 9 | 7 | 4 | 63 | 40 | |||
| 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 | ||
| 41211 | 188316 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 850 Carolina St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6012420.02519 | 2103984.29593 | 37.7578394396596 | -122.400058184238 | (37.7578394396596, -122.400058184238) | 10 | 3 | 8 | 28856 | 29 | |||
| 45337 | 251284 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1299x Hudson Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 06/21/1996 12:00:00 AM | 3x3 | 6017207 | 2095414 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | 10 | 3 | 8 | 58 | 1 | ||
| 45571 | 244276 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 480 Page St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004294.0037 | 2109808.1625 | 37.7733739594079 | -122.428576486808 | (37.7733739594079, -122.428576486808) | 7 | 9 | 11 | 28852 | 10 | |||
| 66695 | 175758 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 201 Tocoloma Ave | 5 | Front Yard : Yard | Tree | Private 2 | 4 | 6012839.87945 | 2087571.56346 | 37.7127968922232 | -122.397455115464 | (37.7127968922232, -122.397455115464) | 10 | 3 | 8 | 309 | 1 | ||||
| 70980 | 96020 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 810 Jones St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767661 | 6008769 | 2115301 | 37.7887082111555 | -122.413485341988 | (37.7887082111555, -122.413485341988) | 5 | 1 | 10 | 28858 | 21 | |
| 71072 | 257997 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1150 Golden Gate Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004329 | 2112216 | 37.7799872696874 | -122.428627101331 | (37.7799872696874, -122.428627101331) | 7 | 9 | 11 | 29490 | 41 | ||||
| 72831 | 30743 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 490X Page St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/1995 12:00:00 AM | 3 | 3x3 | Permit Number 34630 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.429051358355 | (37.7740034947051, -122.429051358355) | 7 | 9 | 11 | 28852 | 10 |
| 80882 | 188322 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 800 Wisconsin St | 5 | : | Tree | Private 2 | 3 | Width 3ft | 6012715.86863 | 2103660.87857 | 37.7569678967592 | -122.399012327554 | (37.7569678967592, -122.399012327554) | 10 | 3 | 8 | 28856 | 29 | |||
| 83367 | 103511 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 100X Leroy Pl | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6008356 | 2116660 | 37.7924164947138 | -122.415010494885 | (37.7924164947138, -122.415010494885) | 5 | 1 | 10 | 28858 | 21 | |||
| 86810 | 139384 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1492 Broderick St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6000711.3822 | 2113738.0773 | 37.7839611073263 | -122.441251269333 | (37.7839611073263, -122.441251269333) | 15 | 6 | 11 | 29490 | 13 | |||
| 101504 | 119916 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3801 Anza St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5986867.20951 | 2111818.56024 | 37.7778923194923 | -122.489005232889 | (37.7778923194923, -122.489005232889) | 11 | 6 | 2 | 55 | 26 | |||
| 101610 | 188297 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1582 12th St | 5 | : | Tree | Private 2 | 7 | Width 5ft | 6008118.01492 | 2108896.99552 | 37.7710877753987 | -122.415284140848 | (37.7710877753987, -122.415284140848) | 8 | 2 | 9 | 28853 | 19 | |||
| 102157 | 96935 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 901 Bay Shore Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010973.7505 | 2094855.21788 | 37.7326922251695 | -122.404417459925 | (37.7326922251695, -122.404417459925) | 10 | 3 | 8 | 58 | 1 | |||
| 102976 | 27198 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 302 Silver Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1999 12:00:00 AM | 3 | 3X3 | 6003379.22854 | 2093490.3772 | 37.7285173473825 | -122.43057623633 | (37.7285173473825, -122.43057623633) | 9 | 7 | 6 | 28861 | 5 | ||
| 119024 | 175766 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5989094.03032 | 2089506.27121 | 37.7167583770722 | -122.47966897135 | (37.7167583770722, -122.47966897135) | 1 | 8 | 4 | 64 | 14 | ||||
| 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 | |||
| 134728 | 48438 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2399 Post St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2002 12:00:00 AM | Permit Number 45814 | 6000698.38093235 | 2113767.30398552 | 37.784040615681 | -122.441298346596 | (37.784040615681, -122.441298346596) | 15 | 6 | 11 | 29490 | 13 | |||
| 151876 | 116351 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4051X 24TH ST | 5 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 6002850 | 2101803 | 37.7513118941202 | -122.432999456035 | (37.7513118941202, -122.432999456035) | 2 | 4 | 5 | 28862 | 22 | ||||
| 157797 | 47218 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 102 Colby St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | Permit Number 45167 | 6008165.27144692 | 2093507.30784615 | 37.7288338073717 | -122.414031775389 | (37.7288338073717, -122.414031775389) | 9 | 3 | 7 | 309 | 28 | ||
| 162228 | 124077 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 701 Funston Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 3ft | 5991933.73963 | 2110279.93645 | 37.7739620806591 | -122.471366355942 | (37.7739620806591, -122.471366355942) | 11 | 6 | 2 | 54 | 11 | |||
| 176963 | 175772 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 5989911.02174 | 2089222.5365 | 37.716026738112 | -122.476824346492 | (37.716026738112, -122.476824346492) | 1 | 8 | 4 | 64 | 14 | ||||
| 184803 | 27127 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2095X Silver Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/16/1999 12:00:00 AM | 6 | 3X3 | 6012407.8106259 | 2096047.4553772 | 37.7360458965855 | -122.399543203223 | (37.7360458965855, -122.399543203223) | 10 | 3 | 8 | 58 | 1 | ||
| 189422 | 10856 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1299X HUDSON AVE | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/21/1996 12:00:00 AM | 6 | 3X4 | 6017281 | 2095243 | 37.734107450868 | -122.382638493216 | (37.734107450868, -122.382638493216) | 10 | 3 | 8 | 58 | 1 | ||
| 191530 | 175770 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 27 | 5989758.80887 | 2089246.54995 | 37.7160838423675 | -122.477352214341 | (37.7160838423675, -122.477352214341) | 1 | 8 | 4 | 64 | 14 | ||||
| 7037 | 222537 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 540 28th St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 6002401.94091 | 2099473.87361 | 37.7448912373558 | -122.43438238755 | (37.7448912373558, -122.43438238755) | 2 | 7 | 5 | 63 | 22 | |||
| 12100 | 96019 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 810 Jones St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767661 | 6008769 | 2115301 | 37.7887082111555 | -122.413485341988 | (37.7887082111555, -122.413485341988) | 5 | 1 | 10 | 28858 | 21 | |
| 17548 | 252893 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 300x Howth St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 04:25:00 PM | 3 | 3x3 | 5997131 | 2090234 | 37.7192201544045 | -122.451941749186 | (37.7192201544045, -122.451941749186) | 9 | 8 | 6 | 28861 | 24 | ||
| 25180 | 30744 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 380 Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34630 | 6004178.56485 | 2109886.01831 | 37.7735811988523 | -122.428981357915 | (37.7735811988523, -122.428981357915) | 7 | 9 | 11 | 28852 | 10 |
| 25949 | 30741 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 490X Page St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34630 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.429051358355 | (37.7740034947051, -122.429051358355) | 7 | 9 | 11 | 28852 | 10 |
| 26486 | 47221 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 102 Colby St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | Permit Number 45167 | 6008165.27144692 | 2093507.30784615 | 37.7288338073717 | -122.414031775389 | (37.7288338073717, -122.414031775389) | 9 | 3 | 7 | 309 | 28 | ||
| 26959 | 10888 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1270X Hudson Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/1996 12:00:00 AM | 6 | 3X4 | 6017265.0162454 | 2095327.7862917 | 37.734339374173 | -122.382699652574 | (37.734339374173, -122.382699652574) | 10 | 3 | 8 | 58 | 1 | ||
| 34401 | 27126 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2095X Silver Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/16/1999 12:00:00 AM | 6 | 3X3 | 6012407.8106259 | 2096047.4553772 | 37.7360458965855 | -122.399543203223 | (37.7360458965855, -122.399543203223) | 10 | 3 | 8 | 58 | 1 | ||
| 37552 | 101159 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1490X 19th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6013387.24003 | 2105243.87751 | 37.7613518552239 | -122.396801432457 | (37.7613518552239, -122.396801432457) | 10 | 3 | 8 | 28856 | 29 | |||
| 44956 | 103510 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 100X Leroy Pl | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6008356 | 2116660 | 37.7924164947138 | -122.415010494885 | (37.7924164947138, -122.415010494885) | 5 | 1 | 10 | 28858 | 21 | |||
| 46332 | 27197 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 302 Silver Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1999 12:00:00 AM | 3 | 3X3 | 6003357.92548 | 2093496.29859 | 37.7285323993286 | -122.430650304475 | (37.7285323993286, -122.430650304475) | 9 | 7 | 6 | 28861 | 5 | ||
| 46632 | 21528 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1300 Sutter St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2007 12:00:00 AM | 3 | 4X4 | 6006219.82958 | 2114935.40618 | 37.7875609181413 | -122.422279128893 | (37.7875609181413, -122.422279128893) | 13 | 9 | 1 | 28858 | 41 | ||
| 47264 | 256155 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 80X Peralta Ave | 4 | Median : Cutout | Tree | Private 2 | 3x3 | 6010428 | 2100359 | 37.747773912222 | -122.406691992098 | (37.747773912222, -122.406691992098) | 2 | 7 | 7 | 28859 | 2 | ||||
| 54152 | 48439 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2399 Post St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2002 12:00:00 AM | Permit Number 45814 | 6000698.38093235 | 2113767.30398552 | 37.784040615681 | -122.441298346596 | (37.784040615681, -122.441298346596) | 15 | 6 | 11 | 29490 | 13 | |||
| 55247 | 124076 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 701 Funston Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 5991934.28865 | 2110305.99584 | 37.7740336644487 | -122.471366355947 | (37.7740336644487, -122.471366355947) | 11 | 6 | 2 | 54 | 11 | |||
| 55248 | 96934 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 901 Bay Shore Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010990.76512 | 2094811.66283 | 37.7325735829947 | -122.404355571269 | (37.7325735829947, -122.404355571269) | 10 | 3 | 8 | 58 | 1 | |||
| 58433 | 27082 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 799X Silver Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2000 12:00:00 AM | 6 | 2X3 | 6006577.59669 | 2093640.72947 | 37.7291108536609 | -122.419529947915 | (37.7291108536609, -122.419529947915) | 9 | 7 | 7 | 309 | 5 | ||
| 60157 | 30142 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 410X Mansell St | 4 | Median : Cutout | Tree | DPW 1 | 9 | M | 6010678.994322 | 2090457.626596 | 37.7206008798567 | -122.405126964413 | (37.7206008798567, -122.405126964413) | 10 | 3 | 7 | 309 | 28 | |||
| 67207 | 188299 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1022 Minna St | 4 | : | Tree | Private 2 | 4 | Width 3ft | 6007530.78901 | 2109693.3141 | 37.7732412569071 | -122.417371822555 | (37.7732412569071, -122.417371822555) | 8 | 2 | 9 | 28853 | 19 | |||
| 68435 | 188303 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 90 Kissling St | 4 | : | Tree | Private 2 | 8 | Width 3ft | 6008234.3659 | 2109502.33979 | 37.7727564467773 | -122.414924528938 | (37.7727564467773, -122.414924528938) | 8 | 2 | 9 | 28853 | 34 | |||
| 70458 | 188315 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 850 Carolina St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6012418.40198 | 2104012.51765 | 37.7579168397997 | -122.400065779927 | (37.7579168397997, -122.400065779927) | 10 | 3 | 8 | 28856 | 29 | |||
| 81110 | 9507 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 935 Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005077.1287 | 2112297.1038 | 37.7802522713917 | -122.426044762205 | (37.7802522713917, -122.426044762205) | 7 | 9 | 11 | 28852 | 41 | |||
| 86372 | 10855 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1299X HUDSON AVE | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/21/1996 12:00:00 AM | 6 | 3X4 | 6017281 | 2095243 | 37.734107450868 | -122.382638493216 | (37.734107450868, -122.382638493216) | 10 | 3 | 8 | 58 | 1 | ||
| 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 | ||
| 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 | |||
| 91061 | 188355 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1339 Hudson Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017230.94644 | 2095282.00984 | 37.7342117988404 | -122.38281425957 | (37.7342117988404, -122.38281425957) | 10 | 3 | 8 | 58 | 1 | |||
| 101122 | 175771 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 0 Gonzalez Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 5989791.93538 | 2089208.15493 | 37.7159803412063 | -122.477234910356 | (37.7159803412063, -122.477234910356) | 1 | 8 | 4 | 64 | 14 | ||||
| 106097 | 181661 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2706 Irving St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5987293.6389 | 2106455.5367 | 37.7631918321241 | -122.487136093376 | (37.7631918321241, -122.487136093376) | 1 | 8 | 3 | 56 | 35 | |||
| 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 |
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) );