trees
1,013 rows where qSpecies_id = 42 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
135081 | 42127 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 57 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42423 | 5999631.06894657 | 2093753.11151717 | 37.7290257055547 | -122.443552646594 | (37.7290257055547, -122.443552646594) | 9 | 7 | 4 | 63 | 40 | ||
135903 | 36704 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 3690x 19TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/1998 12:00:00 AM | Permit Number 39496 | 6005025.9 | 2104880.3 | 37.7598846207262 | -122.425693945182 | (37.7598846207262, -122.425693945182) | 2 | 4 | 5 | 28859 | 19 | ||
136213 | 39757 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 513 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41124 | 6002972.50040311 | 2103846.50934997 | 37.7569298331089 | -122.432721798166 | (37.7569298331089, -122.432721798166) | 2 | 4 | 5 | 28862 | 3 | ||
142242 | 100072 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 96X Douglass St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Address is 1200-1204 17th St | 6001034.7 | 2105837.1 | 37.7622854187027 | -122.439566119284 | (37.7622854187027, -122.439566119284) | 15 | 5 | 5 | 28862 | 3 | |||
143564 | 101395 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 305X Hickory St | 4 | Front Yard : Yard | Tree | DPW 1 | 6005503.9 | 2110451.5 | 37.775208804322 | -122.42443704976 | (37.775208804322, -122.42443704976) | 7 | 9 | 11 | 28852 | 10 | |||||
143725 | 113706 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2801x CLEMENT ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 4x4 | 5986698 | 2113245 | 37.7817990393362 | -122.4896955071 | (37.7817990393362, -122.4896955071) | 11 | 6 | 2 | 55 | 26 | |||
143772 | 173766 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1100x Bacon St | 2 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6008195 | 2092351 | 37.725660503016 | -122.413847240833 | (37.725660503016, -122.413847240833) | 9 | 3 | 7 | 309 | 28 | ||||
144064 | 103614 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 200X Buchanan St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 6004748.9 | 2109266.8 | 37.7719132424086 | -122.426964371637 | (37.7719132424086, -122.426964371637) | 7 | 9 | 5 | 28852 | 10 | |||||
144957 | 41136 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1890 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1999 12:00:00 AM | Permit Number 41875 | 5997533.67783563 | 2108867.16274176 | 37.7704053182028 | -122.451893385496 | (37.7704053182028, -122.451893385496) | 15 | 5 | 11 | 29492 | 9 | ||
146563 | 35830 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 800 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1998 12:00:00 AM | Permit Number 39062 | 6001828.61140297 | 2089175.38471651 | 37.7165813830219 | -122.435628217621 | (37.7165813830219, -122.435628217621) | 9 | 7 | 6 | 28861 | 5 | ||
146945 | 52587 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 690@ CABRILLO 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/27/2006 12:00:00 AM | Permit Number 48680 | 5989145.55322023 | 2110639.08863484 | 37.7747865297245 | -122.481037351164 | (37.7747865297245, -122.481037351164) | 11 | 6 | 2 | 55 | 26 | |||
148472 | 113707 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2801x CLEMENT ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 4x4 | 5986698 | 2113245 | 37.7817990393362 | -122.4896955071 | (37.7817990393362, -122.4896955071) | 11 | 6 | 2 | 55 | 26 | |||
148594 | 253644 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1200x La Salle Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 11/05/1992 12:00:00 AM | 3x3 | 6017461 | 2094327 | 37.7316022380495 | -122.381952476407 | (37.7316022380495, -122.381952476407) | 10 | 3 | 8 | 58 | 1 | ||
149109 | 100071 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 96X Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Address is 4200-4204 17th St | 6001034.7 | 2105837.1 | 37.7622854187027 | -122.439566119284 | (37.7622854187027, -122.439566119284) | 15 | 5 | 5 | 28862 | 3 | |||
149333 | 46585 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 496 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/05/2002 12:00:00 AM | Permit Number 44714 | 6005497.60346294 | 2100827.74105942 | 37.7487838789143 | -122.423774394842 | (37.7487838789143, -122.423774394842) | 2 | 4 | 5 | 28859 | 19 | ||
150033 | 39734 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 3698 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41104 | 6004245.08369654 | 2106017.71232833 | 37.7629635309961 | -122.428475481414 | (37.7629635309961, -122.428475481414) | 8 | 4 | 5 | 28862 | 3 | ||
157441 | 35825 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 618 Edinburg St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1998 12:00:00 AM | Permit Number 39058 | 6002465.48488427 | 2090189.48175621 | 37.7194020221485 | -122.433499297304 | (37.7194020221485, -122.433499297304) | 9 | 7 | 6 | 28861 | 5 | ||
159886 | 255452 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1300 25th St | Side Yard : Yard | Tree | Private 2 | 3x3 | 6014722 | 2102062 | 37.7526893042179 | -122.391962509783 | (37.7526893042179, -122.391962509783) | 10 | 3 | 8 | 28856 | 29 | |||||
161810 | 42476 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 50 Phelan Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997093.60501 | 2092371.50101 | 37.7250870883021 | -122.452225158319 | (37.7250870883021, -122.452225158319) | 9 | 7 | 4 | 28861 | 40 | ||
162250 | 42217 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 661 Howard St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42483 | 6012771.23281155 | 2114106.53972764 | 37.785652410342 | -122.399554213705 | (37.785652410342, -122.399554213705) | 6 | 2 | 9 | 28853 | 6 | ||
167489 | 104452 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1045 Mission St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x6 | Permit Number 770594 | 6009749.9 | 2112056.4 | 37.7798543407434 | -122.409862429103 | (37.7798543407434, -122.409862429103) | 14 | 2 | 9 | 28853 | 34 | |||
167704 | 43517 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 165 Newman St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2000 12:00:00 AM | Permit Number 43192 | 6007354.1406378 | 2096784.95342482 | 37.7377879152119 | -122.41706806364 | (37.7377879152119, -122.41706806364) | 2 | 7 | 7 | 28859 | 2 | ||
169853 | 101394 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 305X Hickory St | 3 | Front Yard : Yard | Tree | DPW 1 | 6005503.9 | 2110451.5 | 37.775208804322 | -122.42443704976 | (37.775208804322, -122.42443704976) | 7 | 9 | 11 | 28852 | 10 | |||||
170051 | 46612 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 394 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2002 12:00:00 AM | Permit Number 44735. Tree 1 on 25th St | 6005464.68638444 | 2101420.18882448 | 37.750408745884 | -122.423930345056 | (37.750408745884, -122.423930345056) | 2 | 4 | 5 | 28859 | 19 | ||
170110 | 45473 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1301 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2001 12:00:00 AM | Permit Number 44252 | 5993960.36650023 | 2094413.72258595 | 37.730514541433 | -122.463204465727 | (37.730514541433, -122.463204465727) | 9 | 8 | 4 | 59 | 40 | ||
172245 | 187611 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 100 Northridge Rd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6018548 | 2094208 | 37.7313354560629 | -122.378186204537 | (37.7313354560629, -122.378186204537) | 10 | 3 | 8 | 58 | 1 | ||||
172262 | 103613 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 200X Buchanan St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6004748.9 | 2109266.8 | 37.7719132424086 | -122.426964371637 | (37.7719132424086, -122.426964371637) | 7 | 9 | 5 | 28852 | 10 | |||||
172390 | 40278 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 327 Bartlett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41430 | 6006777.24179017 | 2101874.53362521 | 37.751730286944 | -122.41942365409 | (37.751730286944, -122.41942365409) | 2 | 4 | 7 | 28859 | 19 | ||
172594 | 254410 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1176x Ingalls St | 23 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6017715 | 2093956 | 37.7305975684905 | -122.381048555108 | (37.7305975684905, -122.381048555108) | 10 | 3 | 8 | 58 | 1 | ||||
173202 | 187607 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 101 Northridge Rd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6018884 | 2094052 | 37.730925622785 | -122.377013758979 | (37.730925622785, -122.377013758979) | 10 | 3 | 8 | 58 | 1 | ||||
173319 | 39210 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 101 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/1999 12:00:00 AM | Permit Number 41852 | 5998202.98711321 | 2108218.1904746 | 37.7686617185434 | -122.449531484363 | (37.7686617185434, -122.449531484363) | 15 | 5 | 11 | 29492 | 9 | ||
173520 | 258387 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2770 Lombard St | 1 | Front Yard : Cutout | Tree | Private 2 | 5999223 | 2119112 | 37.7986315842223 | -122.446787313103 | (37.7986315842223, -122.446787313103) | 13 | 9 | 1 | 57 | 17 | |||||
173820 | 104912 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 606 Gonzalez Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||||
176639 | 42670 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1575 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42698 | 6006081.0251203 | 2117910.0746574 | 37.7957207841663 | -122.422970868865 | (37.7957207841663, -122.422970868865) | 13 | 9 | 10 | 28858 | 32 | ||
176646 | 72854 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 24 Lunado Way | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/26/1998 12:00:00 AM | 5991516.52955398 | 2091408.89207172 | 37.7221229357531 | -122.471434223035 | (37.7221229357531, -122.471434223035) | 9 | 8 | 4 | 59 | 40 | ||||
177293 | 253645 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1200x La Salle Ave | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 03/11/2006 12:00:00 AM | 3x3 | 6017461 | 2094327 | 37.7316022380495 | -122.381952476407 | (37.7316022380495, -122.381952476407) | 10 | 3 | 8 | 58 | 1 | ||
180155 | 122595 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 524 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6010413.68618597 | 2119615.98935706 | 37.8006483359763 | -122.408099375454 | (37.8006483359763, -122.408099375454) | 3 | 1 | 10 | 308 | 23 | |||
180385 | 101839 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 3815-3817 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003483 | 2105926 | 37.762668556024 | -122.431104719068 | (37.762668556024, -122.431104719068) | 15 | 4 | 5 | 28862 | 3 | |||||
180886 | 101392 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 305X Hickory St | 1 | Front Yard : Yard | Tree | DPW 1 | 6005503.9 | 2110451.5 | 37.775208804322 | -122.42443704976 | (37.775208804322, -122.42443704976) | 7 | 9 | 11 | 28852 | 10 | |||||
181753 | 36701 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 3698x 19th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/1998 12:00:00 AM | Permit Number 39496 | 6005001.97582164 | 2104885.80884876 | 37.7598983948026 | -122.425777079422 | (37.7598983948026, -122.425777079422) | 2 | 4 | 5 | 28859 | 19 | ||
182906 | 103611 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 200X Buchanan St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6004748.9 | 2109266.8 | 37.7719132424086 | -122.426964371637 | (37.7719132424086, -122.426964371637) | 7 | 9 | 5 | 28852 | 10 | |||||
183366 | 251343 | Property Tree 8 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 934 Brannan St | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6010724 | 2108745 | 37.7708165471861 | -122.406259194073 | (37.7708165471861, -122.406259194073) | 14 | 2 | 9 | 28853 | 34 | ||||
186579 | 114967 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 469 Hill St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 6003301.68334873 | 2103280.29729908 | 37.7553938131292 | -122.431542939454 | (37.7553938131292, -122.431542939454) | 2 | 4 | 5 | 28862 | 22 | ||||
187583 | 87251 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2 Argonaut Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 50275 | 6008259 | 2086838.7 | 37.7105284764145 | -122.413236372693 | (37.7105284764145, -122.413236372693) | 9 | 7 | 8 | 309 | 39 | |||
190584 | 42121 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 110 Melrose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42418 | 5999349.45513333 | 2095526.80253467 | 37.7338797805201 | -122.44465363726 | (37.7338797805201, -122.44465363726) | 9 | 7 | 4 | 59 | 40 | ||
193296 | 113324 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1234 10th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 5993019.12807809 | 2107069.22790191 | 37.76520905664 | -122.467378332531 | (37.76520905664, -122.467378332531) | 11 | 8 | 11 | 56 | 12 | |||
176756 | 38350 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1666 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/31/1998 12:00:00 AM | 0 | Permit Number 40417 | 5981619.44120207 | 2103744.31851256 | 37.7554151050669 | -122.506559824318 | (37.7554151050669, -122.506559824318) | 1 | 8 | 3 | 56 | 35 | |
61235 | 191898 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1195 La Salle Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6017470.90731 | 2094331.10043 | 37.7316140441423 | -122.381918509648 | (37.7316140441423, -122.381918509648) | 10 | 3 | 8 | 58 | 1 | |||
108316 | 181839 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2301 22nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5989478.1431 | 2099509.7425 | 37.7442476652043 | -122.479072610686 | (37.7442476652043, -122.479072610686) | 1 | 8 | 3 | 29491 | 35 | |||
156430 | 181838 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2301 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5989472.8976 | 2099634.4509 | 37.744589777235 | -122.479099868709 | (37.744589777235, -122.479099868709) | 1 | 8 | 3 | 29491 | 35 | |||
159015 | 105846 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 227-229 09th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | Permit Number 772678 | 6008913.98004 | 2110186.85299 | 37.774674124254 | -122.41262205766 | (37.774674124254, -122.41262205766) | 8 | 2 | 9 | 28853 | 34 | ||
175663 | 176363 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 0 Font Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 5988462.77344 | 2091307.96071 | 37.7216686718604 | -122.481982796584 | (37.7216686718604, -122.481982796584) | 1 | 8 | 4 | 64 | 14 | ||||
189988 | 45055 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2311 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/2011 12:00:00 AM | 1 | Permit Number 767715 | 5988234.443 | 2099548.661 | 37.7442822204704 | -122.483375858058 | (37.7442822204704, -122.483375858058) | 1 | 8 | 3 | 29491 | 35 | ||
15434 | 209153 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2055 15th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 04/26/2004 12:00:00 AM | 10 | Width 3ft | Permit Number 47392 | 5991594.69528 | 2101440.30789 | 37.7496711879902 | -122.471894774741 | (37.7496711879902, -122.471894774741) | 1 | 8 | 4 | 29491 | 12 | |
19640 | 191970 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1322 Hudson Ave | 34 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6017432.11339 | 2095036.9566 | 37.7335500434817 | -122.382101713228 | (37.7335500434817, -122.382101713228) | 10 | 3 | 8 | 58 | 1 | |||
19984 | 126584 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2626 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5999652.4856 | 2117862.36135 | 37.7952249343347 | -122.445211270002 | (37.7952249343347, -122.445211270002) | 13 | 9 | 1 | 57 | 17 | |||
30341 | 10799 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1139X Hudson Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3x4 | 6017498.59701 | 2094875.26301 | 37.7331097364037 | -122.381860615174 | (37.7331097364037, -122.381860615174) | 10 | 3 | 8 | 58 | 1 | |||
30850 | 107104 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 468 07th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 5993765.38968 | 2112353.04093 | 37.7797600550809 | -122.465181030316 | (37.7797600550809, -122.465181030316) | 11 | 6 | 2 | 54 | 11 | ||||
40471 | 126583 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2626 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5999651.95245 | 2117866.72111 | 37.7952368746476 | -122.445213428381 | (37.7952368746476, -122.445213428381) | 13 | 9 | 1 | 57 | 17 | |||
47575 | 36974 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 181 07th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | 10 | Permit Number 39602 | 5993649.0736 | 2114306.93888 | 37.7851182205824 | -122.465725413866 | (37.7851182205824, -122.465725413866) | 11 | 6 | 2 | 54 | 11 | |
48626 | 126582 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2626 Baker St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5999650.13095 | 2117889.12235 | 37.7952982785411 | -122.445221342394 | (37.7952982785411, -122.445221342394) | 13 | 9 | 1 | 57 | 17 | |||
62742 | 32598 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1488 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/1996 12:00:00 AM | 10 | Permit Number 770751 | 5985603.1005 | 2105094.5695 | 37.7593562741507 | -122.492882766578 | (37.7593562741507, -122.492882766578) | 1 | 8 | 3 | 56 | 35 | ||
69307 | 142351 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 101 Anza St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 0ft | 5998422.6314 | 2112618.3418 | 37.7807559646987 | -122.449088780977 | (37.7807559646987, -122.449088780977) | 15 | 6 | 2 | 54 | 16 | |||
72812 | 250989 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 401 45th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 5981864.98937 | 2112954.26036 | 37.7807173939441 | -122.506393608376 | (37.7807173939441, -122.506393608376) | 11 | 6 | 2 | 55 | 26 | ||||
74148 | 176357 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 775 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6001956.61403 | 2089291.23497 | 37.7169067517126 | -122.43519405898 | (37.7169067517126, -122.43519405898) | 9 | 7 | 6 | 28861 | 5 | |||
88717 | 54678 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 425 Wheeler Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/1972 12:00:00 AM | 10 | Permit Number 10509 | 6011983.59997 | 2086741.21676 | 37.7104692111425 | -122.40035642553 | (37.7104692111425, -122.40035642553) | 10 | 3 | 8 | 309 | 1 | ||
99379 | 209155 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 180 Madrone Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5992577.19802 | 2097975.58381 | 37.7402147411155 | -122.468245255719 | (37.7402147411155, -122.468245255719) | 1 | 8 | 4 | 59 | 40 | |||
111370 | 191838 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 601 Arthur Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6015983.89903 | 2099622.43883 | 37.7460607544004 | -122.387428428292 | (37.7460607544004, -122.387428428292) | 10 | 3 | 8 | 58 | 1 | ||||
117506 | 47203 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2801X Clement St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/08/2002 12:00:00 AM | 10 | 3x3 | Permit Number 45157 | 5986727.74959 | 2113216.77029 | 37.7817232655044 | -122.489590512271 | (37.7817232655044, -122.489590512271) | 11 | 6 | 2 | 55 | 26 |
118917 | 37523 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1112 Larkin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | 10 | Permit Number 39974 | 6007334.6804 | 2115172.44683 | 37.7882745958345 | -122.418438771946 | (37.7882745958345, -122.418438771946) | 13 | 9 | 10 | 28858 | 21 | |
130117 | 113705 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2801x CLEMENT ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 10 | 4x4 | 5986698 | 2113245 | 37.7817990393362 | -122.4896955071 | (37.7817990393362, -122.4896955071) | 11 | 6 | 2 | 55 | 26 | ||
134133 | 209068 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 150 Aptos Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5992855.99521 | 2093918.70226 | 37.7290916553422 | -122.466986431495 | (37.7290916553422, -122.466986431495) | 9 | 8 | 4 | 59 | 40 | |||
141123 | 137781 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1773 Golden Gate Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6001134.2143 | 2111741.6364 | 37.7785034663724 | -122.439645254888 | (37.7785034663724, -122.439645254888) | 15 | 5 | 11 | 29490 | 41 | |||
151951 | 209058 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 184 Lomita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5991272.74141 | 2104114.85285 | 37.7569961534705 | -122.473203123738 | (37.7569961534705, -122.473203123738) | 1 | 8 | 4 | 56 | 12 | |||
161730 | 246721 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 75 Stoneman St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 6007902.05533 | 2099361.90416 | 37.7448944596047 | -122.415356029063 | (37.7448944596047, -122.415356029063) | 2 | 7 | 7 | 28859 | 2 | ||||
169113 | 191954 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1322 Hudson Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6017703.17741 | 2094755.78291 | 37.7327929627105 | -122.381145014457 | (37.7327929627105, -122.381145014457) | 10 | 3 | 8 | 58 | 1 | |||
170783 | 206259 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 125 Congo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6000067.98121 | 2094222.95928 | 37.7303407066468 | -122.442075923983 | (37.7303407066468, -122.442075923983) | 9 | 7 | 4 | 63 | 40 | |||
182770 | 32599 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1488 34th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/1996 12:00:00 AM | 10 | Permit Number 770751 | 5985602.7329 | 2105115.8853 | 37.7594147799348 | -122.492885607985 | (37.7594147799348, -122.492885607985) | 1 | 8 | 3 | 56 | 35 | ||
188488 | 224316 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 3450 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6005324.68635 | 2103732.49106 | 37.756749885806 | -122.424578939078 | (37.756749885806, -122.424578939078) | 2 | 4 | 5 | 28859 | 19 | |||
190091 | 224303 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 3750 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 6005452.8742 | 2101399.0795 | 37.7503501176724 | -122.423969691544 | (37.7503501176724, -122.423969691544) | 2 | 4 | 5 | 28859 | 19 | |||
8156 | 73675 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 510 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6010458.2549 | 2119616.6906 | 37.8006527567523 | -122.407945198153 | (37.8006527567523, -122.407945198153) | 3 | 1 | 10 | 308 | 23 | |||
10014 | 30472 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 524 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1956 12:00:00 AM | 11 | 3x3 | Permit Number 119 | 6010416.9297 | 2119611.1498 | 37.8006352293469 | -122.408087810014 | (37.8006352293469, -122.408087810014) | 3 | 1 | 10 | 308 | 23 |
30316 | 64381 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1546 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1988 12:00:00 AM | 11 | Permit Number 25221 | 5982207.2717 | 2104557.9741 | 37.757683766928 | -122.504587243143 | (37.757683766928, -122.504587243143) | 1 | 8 | 3 | 56 | 35 | ||
35872 | 200227 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1079 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 11 | Width 0ft | 6013668.3894 | 2090192.8153 | 37.7200404277679 | -122.394774954905 | (37.7200404277679, -122.394774954905) | 10 | 3 | 8 | 58 | 1 | |||
40291 | 223972 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 50 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003884.37691 | 2108498.70054 | 37.7697553065857 | -122.429900020783 | (37.7697553065857, -122.429900020783) | 7 | 9 | 5 | 29492 | 10 | |||
48704 | 247206 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 800 Duboce Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 6001887.4156 | 2108287.94496 | 37.7690633322277 | -122.436792352994 | (37.7690633322277, -122.436792352994) | 15 | 5 | 5 | 29492 | 9 | |||
69986 | 209142 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 436 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5995442.59804 | 2091242.15059 | 37.7218914438109 | -122.457850790783 | (37.7218914438109, -122.457850790783) | 9 | 8 | 4 | 28861 | 24 | |||
73776 | 191832 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2090 Jerrold Ave | 3 | : | Tree | Private 2 | 11 | Width 2ft | 6012753.47483 | 2098931.66521 | 37.7439845912186 | -122.398550422262 | (37.7439845912186, -122.398550422262) | 10 | 3 | 8 | 58 | 1 | |||
76880 | 201402 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1051 Ingalls St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6018102.67767 | 2094695.98571 | 37.7326508158711 | -122.379759673583 | (37.7326508158711, -122.379759673583) | 10 | 3 | 8 | 58 | 1 | |||
79943 | 185749 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1816 Rivera St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5987525.7541 | 2100343.7859 | 37.746424150759 | -122.485884671652 | (37.746424150759, -122.485884671652) | 1 | 8 | 3 | 29491 | 35 | |||
97556 | 66037 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2000 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1990 12:00:00 AM | 11 | Permit Number 29074 | 5986756.4233 | 2096936.5987 | 37.7370240595256 | -122.488294548713 | (37.7370240595256, -122.488294548713) | 1 | 8 | 3 | 29491 | 35 | ||
98668 | 142474 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 510 UNION ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6010402.6159 | 2119608.8411 | 37.8006280887775 | -122.408137178948 | (37.8006280887775, -122.408137178948) | 3 | 1 | 10 | 308 | 23 | |||
111995 | 191864 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1196 La Salle Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6017117.94287 | 2094521.51298 | 37.7321173811971 | -122.383152037763 | (37.7321173811971, -122.383152037763) | 10 | 3 | 8 | 58 | 1 | |||
112343 | 224319 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 142 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6010095.00353 | 2100177.86923 | 37.7472579301113 | -122.407830711729 | (37.7472579301113, -122.407830711729) | 2 | 7 | 7 | 28859 | 2 | |||
120793 | 209122 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 90 Terrace Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 8ft | 5993231.35441 | 2096936.94625 | 37.7374006626082 | -122.465908015739 | (37.7374006626082, -122.465908015739) | 1 | 8 | 4 | 59 | 40 | |||
121766 | 118433 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 5428 Anza St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 4ft | 5981776.05342 | 2111693.4588 | 37.7772503684982 | -122.506607740669 | (37.7772503684982, -122.506607740669) | 11 | 6 | 2 | 55 | 26 | |||
139012 | 107109 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 468 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 5993767.08799 | 2112314.81311 | 37.7796551897306 | -122.465172377758 | (37.7796551897306, -122.465172377758) | 11 | 6 | 2 | 54 | 11 | ||||
148918 | 223927 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 500 Corbett Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5999649.73447 | 2104078.7393 | 37.7573784732567 | -122.444229817356 | (37.7573784732567, -122.444229817356) | 2 | 5 | 5 | 28862 | 3 | |||
164492 | 140905 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2307 Geary Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6000436.7487 | 2113330.0429 | 37.7828251019589 | -122.442172097736 | (37.7828251019589, -122.442172097736) | 15 | 5 | 1 | 29490 | 41 | |||
179711 | 246870 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 3090x Market St | 3 | Median : Yard | Tree | DPW 1 | 11 | 5999943.44665 | 2105326.58667 | 37.7608215070397 | -122.443303673043 | (37.7608215070397, -122.443303673043) | 15 | 5 | 5 | 28862 | 3 |
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) );