trees
835 rows where qSpecies_id = 122 sorted by rowid 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
193919 | 10634 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 830 Hayes St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/02/1990 12:00:00 AM | 12 | 3X3 | 6003840.507 | 2110782.2115 | 37.7760227838468 | -122.430214699132 | (37.7760227838468, -122.430214699132) | 7 | 9 | 11 | 29492 | 10 | ||
193476 | 67801 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 881 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1992 12:00:00 AM | Permit Number 31447 | 6000722.4252572 | 2102556.2611987 | 37.7532592580737 | -122.440410849633 | (37.7532592580737, -122.440410849633) | 2 | 4 | 5 | 28862 | 22 | ||
192577 | 42099 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 337 Detroit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42405 | 5999399.61952202 | 2094185.90721086 | 37.7302008588662 | -122.444383872809 | (37.7302008588662, -122.444383872809) | 9 | 7 | 4 | 28861 | 40 | ||
192506 | 36124 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1324 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/1998 12:00:00 AM | 10 | Permit Number 39220 | 5988358.7841 | 2106301.1655 | 37.7628300220311 | -122.483440838848 | (37.7628300220311, -122.483440838848) | 1 | 8 | 3 | 56 | 35 | |
192367 | 50662 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1 Santa Ynez Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47244 | 6000978.87890111 | 2091807.60057831 | 37.7237605529163 | -122.43875382021 | (37.7237605529163, -122.43875382021) | 9 | 7 | 6 | 28861 | 25 | ||||
192293 | 35368 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 627 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | Permit Number 38828 | 6011631.82829511 | 2091600.41039567 | 37.72379195201 | -122.401913589843 | (37.72379195201, -122.401913589843) | 10 | 3 | 7 | 309 | 28 | ||
191999 | 220028 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 685 Alvarado St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001938.58535 | 2102624.90259 | 37.7535169030985 | -122.436210038379 | (37.7535169030985, -122.436210038379) | 2 | 4 | 5 | 28862 | 22 | |||
191757 | 220085 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 223 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004732.04309 | 2103949.70152 | 37.757312807464 | -122.426643984833 | (37.757312807464, -122.426643984833) | 2 | 4 | 5 | 28862 | 3 | |||
191733 | 38582 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1565 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | Permit Number 40542 | 6015429.1390942 | 2094459.97574961 | 37.7318549452945 | -122.388986360684 | (37.7318549452945, -122.388986360684) | 10 | 3 | 8 | 58 | 1 | ||
191396 | 38575 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1511 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 6 | Permit Number 40535 | 6015329.8173 | 2094876.8945 | 37.7329942141717 | -122.389358843431 | (37.7329942141717, -122.389358843431) | 10 | 3 | 8 | 58 | 1 | |
191328 | 39196 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 948 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40848 | 6009924.75641086 | 2103679.40260243 | 37.7568628308131 | -122.408666394738 | (37.7568628308131, -122.408666394738) | 2 | 4 | 7 | 28859 | 19 | ||
191158 | 102771 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1438 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6006063.66154 | 2119354.00796 | 37.7996844799161 | -122.423133635925 | (37.7996844799161, -122.423133635925) | 13 | 9 | 1 | 28858 | 32 | |||
191071 | 49975 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1337@ 14th Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/18/2003 12:00:00 AM | Permit Number 46726 | 6007190.27597203 | 2107705.69793456 | 37.7677645693117 | -122.418408745471 | (37.7677645693117, -122.418408745471) | 8 | 4 | 7 | 28853 | 19 | ||
191045 | 36912 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 462 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/27/1998 12:00:00 AM | Permit Number 39558 | 6001795.24469861 | 2103152.27063521 | 37.7549567840787 | -122.436743488368 | (37.7549567840787, -122.436743488368) | 2 | 4 | 5 | 28862 | 22 | ||
190817 | 220669 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 684 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007464.46218 | 2105680.20341 | 37.7622184653282 | -122.417316811922 | (37.7622184653282, -122.417316811922) | 8 | 4 | 7 | 28859 | 19 | |||
190113 | 67397 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 615 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1992 12:00:00 AM | Permit Number 30894 | 5990626.25534689 | 2111189.00376145 | 37.7763824092147 | -122.475955520815 | (37.7763824092147, -122.475955520815) | 11 | 6 | 2 | 55 | 26 | ||
189994 | 40169 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1901 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/1999 12:00:00 AM | 0 | Permit Number 41362 | 6000480.4385885 | 2111652.95524414 | 37.7782227381789 | -122.441900539984 | (37.7782227381789, -122.441900539984) | 15 | 5 | 11 | 29490 | 16 | |
189981 | 43706 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 503 Capitol Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43349 | 5995017.92037976 | 2088722.8136211 | 37.7149495354327 | -122.459136447344 | (37.7149495354327, -122.459136447344) | 9 | 8 | 6 | 28861 | 24 | ||
189947 | 50449 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1418 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2003 12:00:00 AM | Permit Number 47096 | 5998923.01373461 | 2108365.57348999 | 37.7691075589972 | -122.447051586739 | (37.7691075589972, -122.447051586739) | 15 | 5 | 11 | 29492 | 9 | |||
189776 | 49841 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 622@ CASTRO 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/17/2003 12:00:00 AM | Permit Number 46624 | 6002475.85227317 | 2100073.54426279 | 37.7465419874536 | -122.434169677199 | (37.7465419874536, -122.434169677199) | 2 | 7 | 5 | 63 | 22 | |||
189736 | 220036 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1711 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6002636.29383 | 2100481.40221 | 37.7476709743414 | -122.43364403244 | (37.7476709743414, -122.43364403244) | 2 | 4 | 5 | 63 | 22 | |||
189601 | 61340 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 441 Hickory St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/17/1984 12:00:00 AM | Permit Number 21245 | 6004862.65889815 | 2110356.13037945 | 37.7749107106258 | -122.426648455983 | (37.7749107106258, -122.426648455983) | 7 | 9 | 11 | 28852 | 10 | ||
189089 | 124759 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2534 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6006240.40404 | 2119512.60207 | 37.8001299114167 | -122.422533316862 | (37.8001299114167, -122.422533316862) | 13 | 9 | 1 | 28858 | 32 | |||
188431 | 23664 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 311 Virginia Ave | 3 | Median : Cutout | Tree | DPW 1 | 12 | 12 | 6006938.1768512 | 2098312.3803834 | 37.7419584813283 | -122.41861453897 | (37.7419584813283, -122.41861453897) | 2 | 7 | 7 | 28859 | 2 | |||
188187 | 33019 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 3447 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37307 | 6006830.46712311 | 2101429.94248045 | 37.7505125387217 | -122.419208059366 | (37.7505125387217, -122.419208059366) | 2 | 4 | 7 | 28859 | 19 | ||
188125 | 220011 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 110 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006153.26604 | 2102345.16587 | 37.7529873705964 | -122.421614871629 | (37.7529873705964, -122.421614871629) | 2 | 4 | 5 | 28859 | 19 | |||
187795 | 137613 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1502 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6001914.7987 | 2111556.8609 | 37.7780405165886 | -122.436931690487 | (37.7780405165886, -122.436931690487) | 15 | 5 | 11 | 29490 | 41 | |||
187603 | 61341 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 434 Hickory St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1985 12:00:00 AM | Permit Number 22558 | 6004883.03697194 | 2110411.47227967 | 37.7750638180483 | -122.426581905478 | (37.7750638180483, -122.426581905478) | 7 | 9 | 11 | 28852 | 10 | ||
187446 | 37835 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 450X Moscow St | 21 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003752 | 2090699 | 37.720873955994 | -122.429088601305 | (37.720873955994, -122.429088601305) | 9 | 7 | 6 | 28861 | 5 |
186914 | 67491 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1053 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/1992 12:00:00 AM | 11 | Permit Number 31016 | 6011662.71218 | 2103457.28078 | 37.7563501191849 | -122.402640243074 | (37.7563501191849, -122.402640243074) | 10 | 3 | 8 | 28856 | 29 | |
186868 | 65182 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 49 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | Permit Number 27166 | 6000612.59181755 | 2102724.86163023 | 37.7537159395855 | -122.440802768402 | (37.7537159395855, -122.440802768402) | 2 | 4 | 5 | 28862 | 22 | ||
186832 | 30760 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1571 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | Permit Number 34641 | 6014896.23757332 | 2093808.81402101 | 37.7300374330916 | -122.390783237924 | (37.7300374330916, -122.390783237924) | 10 | 3 | 8 | 58 | 1 | ||
186545 | 103891 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1750 Fulton St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 5999322.5796 | 2110851.5262 | 37.7759561736689 | -122.445848329979 | (37.7759561736689, -122.445848329979) | 15 | 5 | 11 | 29492 | 16 | |||
186276 | 219992 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 101 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007124.70017 | 2098812.58313 | 37.7433424258272 | -122.418005051385 | (37.7433424258272, -122.418005051385) | 2 | 7 | 7 | 28859 | 2 | |||
185889 | 203648 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1907 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5993437.25696 | 2102479.71785 | 37.7526315852957 | -122.46559868313 | (37.7526315852957, -122.46559868313) | 1 | 8 | 4 | 29491 | 12 | |||
185826 | 174960 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 103 De Long St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 10ft | 5994409.59914 | 2086788.11813 | 37.7096023276577 | -122.461098897396 | (37.7096023276577, -122.461098897396) | 9 | 8 | 6 | 28861 | 25 | |||
185634 | 220689 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 119 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004994.55037 | 2099284.37518 | 37.744517739909 | -122.425404134514 | (37.744517739909, -122.425404134514) | 2 | 7 | 5 | 63 | 22 | |||
185574 | 10632 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 830 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/02/1990 12:00:00 AM | 12 | 3X3 | 6003878.786 | 2110787.057 | 37.7760382564385 | -122.430082627746 | (37.7760382564385, -122.430082627746) | 7 | 9 | 11 | 29492 | 10 | ||
185557 | 138347 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1770 SCOTT ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6001586.1357 | 2114554.9139 | 37.7862537218777 | -122.438283486898 | (37.7862537218777, -122.438283486898) | 13 | 6 | 1 | 29490 | 27 | |||
185229 | 69216 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1144 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1994 12:00:00 AM | Permit Number 33267 | 6008630.78048604 | 2101877.2067938 | 37.7518418503447 | -122.413014037434 | (37.7518418503447, -122.413014037434) | 2 | 4 | 7 | 28859 | 19 | ||
185050 | 39226 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 770 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1998 12:00:00 AM | 9 | Permit Number 40869 | 5984798.64138 | 2110605.07298 | 37.774439483359 | -122.49607147975 | (37.774439483359, -122.49607147975) | 11 | 6 | 2 | 55 | 26 | ||
184622 | 34898 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 267 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/1997 12:00:00 AM | Permit Number 38503 | 6001403.8262241 | 2096433.01440588 | 37.7364850446475 | -122.437615945523 | (37.7364850446475, -122.437615945523) | 2 | 7 | 5 | 63 | 7 | |||
184532 | 138533 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2299 SUTTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6001645.5525 | 2114240.3384 | 37.7853933573613 | -122.438055378776 | (37.7853933573613, -122.438055378776) | 13 | 6 | 11 | 29490 | 13 | |||
184336 | 37815 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 450X Moscow St | 2 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003965.72194 | 2090553.13154 | 37.7204855291627 | -122.428339438009 | (37.7204855291627, -122.428339438009) | 9 | 7 | 6 | 28861 | 5 |
184117 | 141691 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 101 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5996753.535 | 2112367.4021 | 37.7799713474759 | -122.45484482437 | (37.7799713474759, -122.45484482437) | 15 | 6 | 2 | 54 | 16 | |||
183393 | 113369 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 999x JARBOE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x9 | 6009304 | 2096928 | 37.7382901856605 | -122.410336525414 | (37.7382901856605, -122.410336525414) | 10 | 7 | 7 | 28859 | 2 | |||
183386 | 95791 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 25 Cumberland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767534 | 6005461 | 2104579 | 37.7590818984674 | -122.424167716579 | (37.7590818984674, -122.424167716579) | 2 | 4 | 5 | 28859 | 19 | |
182859 | 44451 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 81 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/31/2005 12:00:00 AM | 10 | Permit Number 48336 | 6002602.78622 | 2086898.2858 | 37.7103729108497 | -122.43278970978 | (37.7103729108497, -122.43278970978) | 9 | 7 | 6 | 28861 | 5 | |
182634 | 36580 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 2970 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1998 12:00:00 AM | Permit Number 39441 | 6009675.57743886 | 2101054.36494821 | 37.7496411039984 | -122.409342906887 | (37.7496411039984, -122.409342906887) | 2 | 4 | 7 | 28859 | 19 | ||
182428 | 98341 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 790X 11th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5992573.13535 | 2110349.8527 | 37.7741910183852 | -122.469159688197 | (37.7741910183852, -122.469159688197) | 11 | 6 | 2 | 54 | 11 | |||
182375 | 220052 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 50 Coleridge St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006851.99562 | 2099403.94647 | 37.7449508246175 | -122.418989930439 | (37.7449508246175, -122.418989930439) | 2 | 7 | 7 | 28859 | 2 | |||
182273 | 220075 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 311 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001146.06945 | 2104525.99341 | 37.7586917784127 | -122.439086964192 | (37.7586917784127, -122.439086964192) | 2 | 4 | 5 | 28862 | 3 | |||
181498 | 53298 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 4136 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1992 12:00:00 AM | Permit Number 30418 | 6002261.36449756 | 2102398.30282758 | 37.7529130479403 | -122.43507759426 | (37.7529130479403, -122.43507759426) | 2 | 4 | 5 | 28862 | 22 | ||
181068 | 34626 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1474 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 0 | Permit Number 38308 | 5988706.2204337 | 2105294.39494794 | 37.760085918568 | -122.48216543102 | (37.760085918568, -122.48216543102) | 1 | 8 | 3 | 56 | 35 | |
180947 | 220071 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 3854 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003950.57262 | 2104825.46317 | 37.7596732292507 | -122.429409067394 | (37.7596732292507, -122.429409067394) | 2 | 4 | 5 | 28862 | 3 | |||
180634 | 137667 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1901 GOLDEN GATE AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6000415.6663 | 2111642.14 | 37.7781893511619 | -122.442123833863 | (37.7781893511619, -122.442123833863) | 15 | 5 | 11 | 29490 | 16 | |||
180484 | 36724 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 63 Rondel Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | Permit Number 39508 | 6006392.72419267 | 2106420.79209113 | 37.7641915920141 | -122.421076141152 | (37.7641915920141, -122.421076141152) | 8 | 4 | 7 | 28859 | 19 | ||
179981 | 246998 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 33 Clipper St | 1 | : | Tree | Private 2 | 10 | Width 4ft | 6004927.94792 | 2101037.11705 | 37.7493266028416 | -122.425759163476 | (37.7493266028416, -122.425759163476) | 2 | 4 | 5 | 28862 | 22 | |||
179587 | 35336 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2311 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/12/2005 12:00:00 AM | 1 | Permit Number 48271 | 6010839.4517 | 2105063.96093 | 37.7607157062843 | -122.405600536935 | (37.7607157062843, -122.405600536935) | 10 | 3 | 8 | 28856 | 29 | |
179390 | 203657 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 226 Joost Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 10ft | 6000556.64604 | 2094979.31291 | 37.7324453144793 | -122.440440771241 | (37.7324453144793, -122.440440771241) | 9 | 7 | 5 | 63 | 40 | |||
179347 | 37729 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1424 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/01/1998 12:00:00 AM | Permit Number 40093 | 6009274.50535547 | 2100894.4740614 | 37.74917959981 | -122.410718543725 | (37.74917959981, -122.410718543725) | 2 | 4 | 7 | 28859 | 19 | ||
178756 | 139655 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 848 BAKER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6000491.15 | 2111934.8144 | 37.7789972619427 | -122.441883720544 | (37.7789972619427, -122.441883720544) | 15 | 5 | 11 | 29490 | 41 | |||
178676 | 220017 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 78 Berkeley Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001185.23014 | 2097348.08527 | 37.7389851844145 | -122.438437264296 | (37.7389851844145, -122.438437264296) | 2 | 7 | 5 | 63 | 7 | |||
178339 | 141630 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1801 GROVE ST | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5999025.3732 | 2110414.9246 | 37.774740403046 | -122.446845016858 | (37.774740403046, -122.446845016858) | 15 | 5 | 11 | 29492 | 16 | |||
178319 | 1378 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 65 Amethyst Way | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/1998 12:00:00 AM | 7 | 1X1 | 5998886.8781591 | 2099985.9166978 | 37.7460970335049 | -122.446573608518 | (37.7460970335049, -122.446573608518) | 2 | 7 | 5 | 63 | 22 | ||
178294 | 859 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 400X Alemany Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3x3 | 6008091.17818 | 2095049.40427 | 37.7330639095777 | -122.414396992023 | (37.7330639095777, -122.414396992023) | 2 | 7 | 7 | 28859 | 2 | |||
178228 | 117038 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 2220x SUTTER ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001781 | 2114465 | 37.7860179225956 | -122.437602866759 | (37.7860179225956, -122.437602866759) | 13 | 6 | 1 | 29490 | 27 | ||||
178000 | 241057 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 158 Carmel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5998015.2353 | 2105374.43537 | 37.7608427445162 | -122.449975917752 | (37.7608427445162, -122.449975917752) | 15 | 5 | 11 | 29492 | 12 | |||
177748 | 67906 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 351 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31609 | 5999092.51556245 | 2094349.39726639 | 37.7306322373229 | -122.44545731887 | (37.7306322373229, -122.44545731887) | 9 | 7 | 4 | 28861 | 40 | ||
177732 | 38051 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2700 Bush St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1998 12:00:00 AM | 0 | Permit Number 40248 | 6000571.40891222 | 2114495.1875697 | 37.7860319624569 | -122.441789880059 | (37.7860319624569, -122.441789880059) | 13 | 6 | 1 | 29490 | 27 | |
177578 | 35559 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 801 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38931 | 6005679.14966284 | 2104317.39620731 | 37.7583759105796 | -122.423394653078 | (37.7583759105796, -122.423394653078) | 2 | 4 | 5 | 28859 | 19 | ||
177563 | 38525 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 3031 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/15/1998 12:00:00 AM | 11 | Permit Number 40508 | 6001946.95136 | 2118602.51648 | 37.7973879072825 | -122.437325094293 | (37.7973879072825, -122.437325094293) | 13 | 9 | 1 | 57 | 17 | ||
177297 | 184961 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1990 41st Ave | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5983548.8239 | 2101628.263 | 37.7497184185455 | -122.4997311455 | (37.7497184185455, -122.4997311455) | 1 | 8 | 3 | 29491 | 35 | |||
176498 | 220665 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 215 Webster St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6004174.50762 | 2109590.46036 | 37.7727694393 | -122.428974316228 | (37.7727694393, -122.428974316228) | 7 | 9 | 11 | 29492 | 10 | |||
176387 | 67797 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 4545 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1992 12:00:00 AM | Permit Number 31440 | 6000849.66169786 | 2101098.90444447 | 37.7492649509789 | -122.439866358772 | (37.7492649509789, -122.439866358772) | 2 | 4 | 5 | 28862 | 22 | ||
176078 | 67651 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1919 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1992 12:00:00 AM | Permit Number 31250 | 6013521.72915428 | 2095881.08409425 | 37.7356511027367 | -122.395680256471 | (37.7356511027367, -122.395680256471) | 10 | 3 | 8 | 58 | 1 | ||
175850 | 103892 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1750 Fulton St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5999308.7043 | 2110849.4957 | 37.7759498061666 | -122.44589618201 | (37.7759498061666, -122.44589618201) | 15 | 5 | 11 | 29492 | 16 | |||
175721 | 220684 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 452 Hickory St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6004755.35153 | 2110353.8827 | 37.7748984718146 | -122.427019494961 | (37.7748984718146, -122.427019494961) | 7 | 9 | 11 | 28852 | 10 | |||
175410 | 50664 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1 Santa Ynez Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47244 | 6000978.87890111 | 2091807.60057831 | 37.7237605529163 | -122.43875382021 | (37.7237605529163, -122.43875382021) | 9 | 7 | 6 | 28861 | 25 | ||||
175021 | 42685 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2335 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | 8 | Permit Number 42709 | 6006717.2254 | 2119230.45195 | 37.7993820864644 | -122.420863284838 | (37.7993820864644, -122.420863284838) | 5 | 9 | 1 | 28858 | 32 | |
174508 | 50469 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 3010X Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2003 12:00:00 AM | 5 | 3x3 | Permit Number 47106 | 5999184.20401146 | 2119093.85477845 | 37.7985795459747 | -122.446920252577 | (37.7985795459747, -122.446920252577) | 13 | 9 | 1 | 57 | 17 | |
173566 | 203636 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 418 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5997970.50252 | 2094115.71728 | 37.7299264906074 | -122.449319440552 | (37.7299264906074, -122.449319440552) | 9 | 7 | 4 | 28861 | 40 | |||
173447 | 220005 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2080 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008062.79185 | 2106290.9953 | 37.7639292034025 | -122.415290650144 | (37.7639292034025, -122.415290650144) | 8 | 4 | 7 | 28859 | 19 | |||
173430 | 220675 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 3681 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005766.61271 | 2104299.30973 | 37.758331185361 | -122.423090881238 | (37.758331185361, -122.423090881238) | 2 | 4 | 5 | 28859 | 19 | |||
173155 | 10631 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 829 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/02/1990 12:00:00 AM | 18 | 3X3 | 6003873.4823 | 2110738.4269 | 37.7759044297862 | -122.430097504694 | (37.7759044297862, -122.430097504694) | 7 | 9 | 11 | 29492 | 10 | ||
173134 | 115807 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 742 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5999623.0981 | 2111117.8642 | 37.7767046243395 | -122.444827911038 | (37.7767046243395, -122.444827911038) | 15 | 5 | 11 | 29492 | 16 | |||
173009 | 67794 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 4385 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1992 12:00:00 AM | Permit Number 31436 | 6001403.12898277 | 2101129.53886862 | 37.7493805554463 | -122.437954656615 | (37.7493805554463, -122.437954656615) | 2 | 4 | 5 | 28862 | 22 | ||
172925 | 103890 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1750 Fulton St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | 5999343.5617 | 2110855.9257 | 37.7759694515949 | -122.445776064165 | (37.7759694515949, -122.445776064165) | 15 | 5 | 11 | 29492 | 16 | |||
172865 | 220061 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 496 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006778.4719 | 2100919.5429 | 37.7491081692173 | -122.419351659351 | (37.7491081692173, -122.419351659351) | 2 | 4 | 7 | 28859 | 19 | |||
172731 | 70953 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 76 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/2008 12:00:00 AM | 3x3 | Permit Number 50393 | 5992532.60289704 | 2098624.81220808 | 37.7419947820759 | -122.468446668857 | (37.7419947820759, -122.468446668857) | 1 | 8 | 4 | 29491 | 40 | ||
172691 | 203632 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1400 Monterey Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 10ft | 5993831.29855 | 2094857.6984 | 37.7317261536347 | -122.463682879865 | (37.7317261536347, -122.463682879865) | 9 | 8 | 4 | 59 | 40 | |||
172682 | 32332 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 301 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/1996 12:00:00 AM | 12 | Permit Number 36896 | 6006735.75103 | 2098040.81049 | 37.7412014125113 | -122.419295203505 | (37.7412014125113, -122.419295203505) | 2 | 7 | 7 | 28859 | 2 | ||
172635 | 44033 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 230 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/02/2000 12:00:00 AM | 9 | Permit Number 43569 | 5998819.8857 | 2109894.1205 | 37.7732986671632 | -122.447518341015 | (37.7732986671632, -122.447518341015) | 15 | 5 | 11 | 29492 | 16 | |
172612 | 84098 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 3800 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51813 | 6003059.47886598 | 2103613.0333106 | 37.7562936960779 | -122.432404319205 | (37.7562936960779, -122.432404319205) | 2 | 4 | 5 | 28862 | 3 | ||
172487 | 142298 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1501 GROVE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6000546.8174 | 2110627.5355 | 37.775410978082 | -122.441597306223 | (37.775410978082, -122.441597306223) | 15 | 5 | 11 | 29492 | 16 | |||
171790 | 203640 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 216 Ralston St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 5ft | 5992221.60329 | 2089317.43063 | 37.7164210557753 | -122.468844858002 | (37.7164210557753, -122.468844858002) | 9 | 8 | 6 | 64 | 24 | |||
171717 | 39894 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 715 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/1999 12:00:00 AM | Permit Number 41176 | 5999001.16721708 | 2108236.78492637 | 37.7687584031098 | -122.446771991368 | (37.7687584031098, -122.446771991368) | 15 | 5 | 11 | 29492 | 9 | |||
171199 | 174961 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 54 Santa Ynez Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6000769.59798 | 2092028.99302 | 37.7243565377 | -122.439493130409 | (37.7243565377, -122.439493130409) | 9 | 7 | 6 | 28861 | 25 | ||||
171024 | 68908 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 67 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | Permit Number 32883 | 6001725.7944262 | 2105449.29562811 | 37.7612599114424 | -122.43714812038 | (37.7612599114424, -122.43714812038) | 15 | 4 | 5 | 28862 | 3 | ||
170814 | 219999 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 62 Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6005999.49716 | 2097639.92479 | 37.740059177277 | -122.421812441905 | (37.740059177277, -122.421812441905) | 2 | 7 | 7 | 28859 | 2 |
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) );