trees
835 rows where qSpecies_id = 122 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
68768 | 50067 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 408 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46795 | 6003569.75244558 | 2105901.71860795 | 37.7626068007008 | -122.430802940638 | (37.7626068007008, -122.430802940638) | 15 | 4 | 5 | 28862 | 3 | ||
68986 | 35558 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 801 Guerrero St | 1 | 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 | ||
70503 | 50653 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 151 Lawrence Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2003 12:00:00 AM | Permit Number 47235 | 5996872.39579561 | 2087134.54464453 | 37.710694953359 | -122.452612074363 | (37.710694953359, -122.452612074363) | 9 | 7 | 6 | 28861 | 25 | |||
70512 | 64256 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 191 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/03/1988 12:00:00 AM | Permit Number 25057 | 6004710.43221145 | 2098679.48425343 | 37.7428407913605 | -122.426343498945 | (37.7428407913605, -122.426343498945) | 2 | 7 | 5 | 63 | 22 | ||
71322 | 66256 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 198 Juanita Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1990 12:00:00 AM | Permit Number 29359 | 5996422.28373213 | 2098491.67117902 | 37.7418531174549 | -122.454987856884 | (37.7418531174549, -122.454987856884) | 9 | 7 | 4 | 59 | 40 | ||
73002 | 37857 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 50 Ina Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/1998 12:00:00 AM | Permit Number 40144 | 6004964.50568845 | 2091639.69049004 | 37.7235254489092 | -122.424964225997 | (37.7235254489092, -122.424964225997) | 9 | 7 | 6 | 28861 | 5 | ||
73126 | 45525 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1700 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2001 12:00:00 AM | Permit Number 44286 | 5999707.83752219 | 2110208.85696406 | 37.7742135578008 | -122.444469428603 | (37.7742135578008, -122.444469428603) | 15 | 5 | 11 | 29492 | 16 | |||
73895 | 84017 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1109 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50426 | 6002531.06648038 | 2102355.71188239 | 37.7528114140683 | -122.434141870719 | (37.7528114140683, -122.434141870719) | 2 | 4 | 5 | 28862 | 22 | ||
74457 | 38531 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1426 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/16/1998 12:00:00 AM | Permit Number 40513 | 6007984.37872155 | 2099748.42101744 | 37.74596037533 | -122.415098722892 | (37.74596037533, -122.415098722892) | 2 | 7 | 7 | 28859 | 2 | ||
75755 | 39220 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1143 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41443 | 6005801.05573922 | 2102320.92573379 | 37.7529009461356 | -122.422831161336 | (37.7529009461356, -122.422831161336) | 2 | 4 | 5 | 28859 | 19 | ||
76050 | 37317 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 576 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39832 | 6002608.13051852 | 2103294.09534049 | 37.7553923649469 | -122.433942439191 | (37.7553923649469, -122.433942439191) | 2 | 4 | 5 | 28862 | 22 | ||
76223 | 33122 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 2363 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37356 | 6001608.80596075 | 2119029.55221322 | 37.7985412065447 | -122.438525775033 | (37.7985412065447, -122.438525775033) | 13 | 9 | 1 | 57 | 17 | ||
76417 | 66117 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 840 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1990 12:00:00 AM | Permit Number 29176 | 6003830.73518673 | 2110784.28562667 | 37.7760279254083 | -122.430248650411 | (37.7760279254083, -122.430248650411) | 7 | 9 | 11 | 29492 | 10 | ||
76704 | 36079 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 2170 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1998 12:00:00 AM | Permit Number 39193 | 6008724.90392173 | 2105792.20395445 | 37.7625968269406 | -122.412965325481 | (37.7625968269406, -122.412965325481) | 8 | 4 | 7 | 28859 | 19 | ||
77821 | 64512 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 830 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/21/1988 12:00:00 AM | Permit Number 25393 | 6000501.90082075 | 2111793.8331913 | 37.7786107760856 | -122.441836408094 | (37.7786107760856, -122.441836408094) | 15 | 5 | 11 | 29490 | 41 | ||
78673 | 51542 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 419 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50569 | 6005029.52693365 | 2110412.24682315 | 37.7750742252257 | -122.42607521942 | (37.7750742252257, -122.42607521942) | 7 | 9 | 11 | 28852 | 10 | ||
78892 | 36515 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 263 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39393 | 6006742.46472301 | 2095809.17822197 | 37.735074223818 | -122.419113734428 | (37.735074223818, -122.419113734428) | 2 | 7 | 7 | 28859 | 2 | ||
79064 | 50672 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 3305 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47252 | 5998970.56266258 | 2115921.05690667 | 37.7898556796393 | -122.447431022041 | (37.7898556796393, -122.447431022041) | 13 | 6 | 1 | 54 | 31 | ||||
79363 | 67088 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 104 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1992 12:00:00 AM | Permit Number 30490 | 6010217.49465897 | 2100245.63061 | 37.7474508447186 | -122.407411920985 | (37.7474508447186, -122.407411920985) | 2 | 7 | 7 | 28859 | 2 | ||
80369 | 36529 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 3653 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39401 | 6008503.02776352 | 2097873.6031148 | 37.7408416720866 | -122.413172749536 | (37.7408416720866, -122.413172749536) | 10 | 7 | 7 | 28859 | 2 | ||
80503 | 39100 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 3376 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1998 12:00:00 AM | Permit Number 40789 | 6006536.85037285 | 2102635.06060624 | 37.7538049769481 | -122.420308934903 | (37.7538049769481, -122.420308934903) | 2 | 4 | 7 | 28859 | 19 | ||
81321 | 65300 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 3675 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1989 12:00:00 AM | 4x4 | Permit Number 768627 | 6005114.50774825 | 2104844.14529262 | 37.7597903550193 | -122.425384921015 | (37.7597903550193, -122.425384921015) | 2 | 4 | 5 | 28859 | 19 | |
81817 | 42334 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 207 Flood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42540 | 5999365.95160297 | 2094049.74226531 | 37.7298250607238 | -122.444490484515 | (37.7298250607238, -122.444490484515) | 9 | 7 | 4 | 28861 | 40 | ||
81881 | 33643 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 473 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 37737 | 6005146.14820368 | 2110741.54826683 | 37.7759849973486 | -122.425695243602 | (37.7759849973486, -122.425695243602) | 7 | 9 | 11 | 28852 | 10 | |||
81889 | 36919 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 699 Alvarado St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/27/1998 12:00:00 AM | Permit Number 39565 | 6001900 | 2102596 | 37.7534353511669 | -122.436341406283 | (37.7534353511669, -122.436341406283) | 2 | 4 | 5 | 28862 | 22 | ||
81972 | 35001 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 8028 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/1997 12:00:00 AM | Permit Number 38578 | 5982135.81465862 | 2112401.83483279 | 37.7792165374199 | -122.505415750841 | (37.7792165374199, -122.505415750841) | 11 | 6 | 2 | 55 | 26 | |||
82438 | 40860 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 32 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42377 | 6007537.55147065 | 2099272.41006031 | 37.7446282354142 | -122.416610080854 | (37.7446282354142, -122.416610080854) | 2 | 7 | 7 | 28859 | 2 | ||
82896 | 68073 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 335 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/1993 12:00:00 AM | Permit Number 31811 | 5993016.05828809 | 2103198.83445662 | 37.7545817907356 | -122.467107528535 | (37.7545817907356, -122.467107528535) | 1 | 8 | 4 | 56 | 12 | ||
83014 | 34299 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 2460 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38087 | 6009686.14840404 | 2103014.07472331 | 37.7550226229561 | -122.409444639751 | (37.7550226229561, -122.409444639751) | 2 | 4 | 7 | 28859 | 19 | ||
83570 | 139500 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 748 CENTRAL AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 5999620.0523 | 2111133.4316 | 37.7767471946184 | -122.444839566612 | (37.7767471946184, -122.444839566612) | 15 | 5 | 11 | 29492 | 16 | ||||
83995 | 42373 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 531 Foerster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42548 | 5998094.3919548 | 2095072.92519048 | 37.7325618425703 | -122.448960067148 | (37.7325618425703, -122.448960067148) | 9 | 7 | 4 | 59 | 40 | ||
84611 | 69196 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1463 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1994 12:00:00 AM | Permit Number 33243 | 6009335.03931842 | 2100741.36404906 | 37.7487625875096 | -122.410498405401 | (37.7487625875096, -122.410498405401) | 2 | 4 | 7 | 28859 | 19 | ||
84697 | 67840 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 3848 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1993 12:00:00 AM | Permit Number 31508 | 6004878.46361538 | 2100495.10573235 | 37.7478355684339 | -122.425891704855 | (37.7478355684339, -122.425891704855) | 2 | 4 | 5 | 63 | 22 | ||
85548 | 67164 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1550 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1992 12:00:00 AM | Permit Number 30604 | 6010144.81466304 | 2100398.61683821 | 37.7478668430794 | -122.407674029985 | (37.7478668430794, -122.407674029985) | 2 | 7 | 7 | 28859 | 2 | ||
85645 | 42113 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 136 Judson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42412 | 5999169.44681663 | 2093518.27568943 | 37.7283545633122 | -122.445131627679 | (37.7283545633122, -122.445131627679) | 9 | 7 | 4 | 28861 | 40 | ||
85691 | 49583 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 400REVISED Alemany Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2003 12:00:00 AM | Permit Number 46462 | 6008204.64175087 | 2095122.01632245 | 37.7332696598424 | -122.414009852171 | (37.7332696598424, -122.414009852171) | 2 | 7 | 7 | 28859 | 2 | |||
85779 | 37474 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1642 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | Permit Number 39945 | 5992805.4256232 | 2104283.42646812 | 37.7575476379464 | -122.467914829169 | (37.7575476379464, -122.467914829169) | 1 | 8 | 4 | 56 | 12 | ||
86594 | 117034 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 2220x SUTTER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001781 | 2114465 | 37.7860179225956 | -122.437602866759 | (37.7860179225956, -122.437602866759) | 13 | 6 | 1 | 29490 | 27 | ||||
88116 | 32739 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 137 Lobos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37122 | 5995581.47746257 | 2088674.4560737 | 37.7148491391882 | -122.457185072361 | (37.7148491391882, -122.457185072361) | 9 | 8 | 6 | 28861 | 24 | ||
90150 | 63606 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 717 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1987 12:00:00 AM | Permit Number 24243 | 5999597.4131629 | 2110926.64814812 | 37.7761781281102 | -122.444903013727 | (37.7761781281102, -122.444903013727) | 15 | 5 | 11 | 29492 | 16 | ||
90689 | 98707 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 105X Ord St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6000883.6 | 2105740.8 | 37.7620124016568 | -122.440081810476 | (37.7620124016568, -122.440081810476) | 15 | 5 | 5 | 28862 | 3 | ||||
91314 | 34169 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 3738 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/1998 12:00:00 AM | Permit Number 39486 | 6005390.32082668 | 2104325.33751818 | 37.7583814098433 | -122.424394116765 | (37.7583814098433, -122.424394116765) | 2 | 4 | 5 | 28859 | 19 | ||
91404 | 43365 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 4245 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/2000 12:00:00 AM | Permit Number 43115 | 6002281.52408985 | 2101178.21709517 | 37.7495641270708 | -122.434920630419 | (37.7495641270708, -122.434920630419) | 2 | 4 | 5 | 28862 | 22 | ||
91513 | 61034 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 130 Swiss Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/2011 12:00:00 AM | 3x5 | Permit Number 768338 | 6001256.29714973 | 2096400.69751215 | 37.7363879207533 | -122.438123700701 | (37.7363879207533, -122.438123700701) | 2 | 7 | 5 | 63 | 7 | |
92529 | 38702 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1508 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/07/1998 12:00:00 AM | Permit Number 40610 | 6001927.2408902 | 2111561.6017671 | 37.7780542409849 | -122.436888988053 | (37.7780542409849, -122.436888988053) | 15 | 5 | 11 | 29490 | 41 | ||
92759 | 52598 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 423@ FELL Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/2006 12:00:00 AM | Permit Number 48692 | 6005028.51137557 | 2110420.01312959 | 37.7750954922138 | -122.426079285457 | (37.7750954922138, -122.426079285457) | 7 | 9 | 11 | 28852 | 10 | |||
93321 | 30761 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1575 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | Permit Number 34642 | 6014875.77973499 | 2093824.0033781 | 37.7300780049156 | -122.39085502492 | (37.7300780049156, -122.39085502492) | 10 | 3 | 8 | 58 | 1 | ||
93401 | 49840 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 626@ CASTRO 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/17/2003 12:00:00 AM | Permit Number 46623 | 6002452.84285908 | 2100074.93808821 | 37.7465445086172 | -122.434249340793 | (37.7465445086172, -122.434249340793) | 2 | 7 | 5 | 63 | 22 | |||
94339 | 67793 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 4381 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1992 12:00:00 AM | Permit Number 31435 | 6001427.36985446 | 2101130.88060421 | 37.7493856180132 | -122.437870927363 | (37.7493856180132, -122.437870927363) | 2 | 4 | 5 | 28862 | 22 | ||
94464 | 41149 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1653 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/1999 12:00:00 AM | Permit Number 41881 | 5997742.91613306 | 2108148.62427098 | 37.7684443776569 | -122.45111780839 | (37.7684443776569, -122.45111780839) | 15 | 5 | 11 | 29492 | 9 | |||
94524 | 50321 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 3615 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2003 12:00:00 AM | Permit Number 47024 | 6006189.66048824 | 2104317.6075576 | 37.7584052908739 | -122.421629093037 | (37.7584052908739, -122.421629093037) | 2 | 4 | 5 | 28859 | 19 | |||
95101 | 109671 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 798x GRAFTON AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994496 | 2090624 | 37.7201397218642 | -122.461078132621 | (37.7201397218642, -122.461078132621) | 9 | 8 | 6 | 28861 | 24 | ||||
95210 | 39622 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1201 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41021 | 5997705.33041065 | 2106460.2771729 | 37.7638064542355 | -122.451126043319 | (37.7638064542355, -122.451126043319) | 15 | 5 | 11 | 29492 | 9 | ||
96296 | 67367 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 622 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1992 12:00:00 AM | Permit Number 30860 | 5991947.66141854 | 2111184.68459598 | 37.7764470789457 | -122.471384134831 | (37.7764470789457, -122.471384134831) | 11 | 6 | 2 | 54 | 11 | ||
97588 | 67124 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1616 Florida St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/1992 12:00:00 AM | 3x3 | Permit Number 50077 | 6009627.64848121 | 2100263.06396072 | 37.7474656808625 | -122.409452808897 | (37.7474656808625, -122.409452808897) | 2 | 7 | 7 | 28859 | 2 | ||
98134 | 30758 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1557 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | Permit Number 34639 | 6014967.84012217 | 2093755.65118605 | 37.7298954311335 | -122.390531983655 | (37.7298954311335, -122.390531983655) | 10 | 3 | 8 | 58 | 1 | ||
98889 | 35681 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 4521 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2000 12:00:00 AM | Permit Number 41986 | 6000920.86314017 | 2101102.84545022 | 37.7492798248008 | -122.439620425959 | (37.7492798248008, -122.439620425959) | 2 | 4 | 5 | 28862 | 22 | |||
98912 | 32273 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1750 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1996 12:00:00 AM | Permit Number 36859 | 5998193.43438826 | 2108958.37890696 | 37.7706935405733 | -122.449617870473 | (37.7706935405733, -122.449617870473) | 15 | 5 | 11 | 29492 | 9 | |||
99336 | 33133 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 3016 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37363 | 6001491.05795368 | 2118756.44455004 | 37.7977846260596 | -122.438913636839 | (37.7977846260596, -122.438913636839) | 13 | 9 | 1 | 57 | 17 | ||
99442 | 111844 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1550 York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6010144.81466304 | 2100398.61683821 | 37.7478668430794 | -122.407674029985 | (37.7478668430794, -122.407674029985) | 2 | 7 | 7 | 28859 | 2 | ||||
100607 | 40633 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1385 Masonic Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/1999 12:00:00 AM | Permit Number 41908 | 5999539.52102625 | 2107847.36223217 | 37.7677198855431 | -122.444881875249 | (37.7677198855431, -122.444881875249) | 15 | 5 | 11 | 29492 | 9 | |||
101106 | 68703 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 2081 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1993 12:00:00 AM | Permit Number 32615 | 6003689.8407303 | 2107120.9618087 | 37.7659613518454 | -122.430474597791 | (37.7659613518454, -122.430474597791) | 8 | 4 | 5 | 28862 | 3 | ||
101675 | 64665 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 933 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/19/1991 12:00:00 AM | Permit Number 25595 | 6006330.05327332 | 2104167.32767008 | 37.7580005727281 | -122.42113288094 | (37.7580005727281, -122.42113288094) | 2 | 4 | 7 | 28859 | 19 | ||
101682 | 66237 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 422 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1990 12:00:00 AM | Permit Number 29335 | 5995558.06563814 | 2090587.62307484 | 37.7201008998033 | -122.45740432201 | (37.7201008998033, -122.45740432201) | 9 | 8 | 6 | 28861 | 24 | ||
102174 | 41993 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 75 Manor Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42333 | 5993572.90365136 | 2093435.37616672 | 37.7278059137082 | -122.464472962263 | (37.7278059137082, -122.464472962263) | 9 | 8 | 4 | 59 | 40 | ||
102533 | 94017 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 3951 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/12/2010 12:00:00 AM | 3x3 | Permit Number 53436 | 6004200 | 2100707 | 37.7483790153575 | -122.428252898939 | (37.7483790153575, -122.428252898939) | 2 | 4 | 5 | 63 | 22 | ||
102840 | 51951 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 2 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/2005 12:00:00 AM | Permit Number 48175 | 6001005.9274955 | 2106259.83007157 | 37.7634444939099 | -122.439695940154 | (37.7634444939099, -122.439695940154) | 15 | 5 | 5 | 28862 | 3 | |||
103248 | 103895 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1750 Fulton St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999354.6 | 2110868.3 | 37.7760040584969 | -122.445738770051 | (37.7760040584969, -122.445738770051) | 15 | 5 | 11 | 29492 | 16 | ||||
103337 | 69125 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 447 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/18/1994 12:00:00 AM | Permit Number 33148 | 6005264.64007943 | 2110758.08466494 | 37.7760370972093 | -122.425286525812 | (37.7760370972093, -122.425286525812) | 7 | 9 | 11 | 28852 | 10 | ||
105121 | 61745 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 16 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1984 12:00:00 AM | Permit Number 21751 | 6005058.850293 | 2101091.32092731 | 37.7494828305195 | -122.425310356629 | (37.7494828305195, -122.425310356629) | 2 | 4 | 5 | 28862 | 22 | ||
106096 | 75790 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 2080 FOLSOM ST | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 03/15/1997 12:00:00 AM | 3x3 | 6008075 | 2106289 | 37.7639244108872 | -122.415248284425 | (37.7639244108872, -122.415248284425) | 8 | 4 | 7 | 28859 | 19 | |||
106487 | 42112 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 100@ Detroit Judson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42411 | 5999403.96940848 | 2093509.81726433 | 37.7283447217324 | -122.444320267584 | (37.7283447217324, -122.444320267584) | 9 | 7 | 4 | 28861 | 40 | ||
107016 | 66876 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 311 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1991 12:00:00 AM | Permit Number 30186 | 6001155.37730733 | 2104574.8455135 | 37.7588264440048 | -122.439058274593 | (37.7588264440048, -122.439058274593) | 2 | 4 | 5 | 28862 | 3 | ||
107205 | 98339 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 3434 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992637 | 2110058.2 | 37.7733939086093 | -122.468917542393 | (37.7733939086093, -122.468917542393) | 11 | 6 | 2 | 54 | 11 | ||||
107976 | 53006 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 3647@ VALENCIA 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/22/2006 12:00:00 AM | Permit Number 48989 | 6005992.69388586 | 2104306.67920181 | 37.7583641756106 | -122.42230951547 | (37.7583641756106, -122.42230951547) | 2 | 4 | 5 | 28859 | 19 | ||
108593 | 67774 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 50 Potomac St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1992 12:00:00 AM | Permit Number 31407 | 6003128.8589186 | 2108744.804056 | 37.7703882320696 | -122.43253091541 | (37.7703882320696, -122.43253091541) | 15 | 5 | 5 | 29492 | 9 | ||
109176 | 45035 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 2306 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43925 | 6002524.20413383 | 2117822.12502906 | 37.7952779539251 | -122.435271803602 | (37.7952779539251, -122.435271803602) | 13 | 9 | 1 | 57 | 17 | |||
109969 | 66155 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1741 Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/04/1990 12:00:00 AM | Permit Number 29226 | 6013929.0546693 | 2095023.1611058 | 37.7333180723286 | -122.394211919223 | (37.7333180723286, -122.394211919223) | 10 | 3 | 8 | 58 | 1 | ||
110083 | 66324 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 88 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/05/1995 12:00:00 AM | Permit Number 29443 | 6000832.40008628 | 2095235.41670142 | 37.7331642137768 | -122.439505779041 | (37.7331642137768, -122.439505779041) | 9 | 7 | 5 | 63 | 40 | ||
110200 | 37020 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1061 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | Permit Number 39632 | 6008655.69574399 | 2102373.47059511 | 37.7532058777371 | -122.412962961361 | (37.7532058777371, -122.412962961361) | 2 | 4 | 7 | 28859 | 19 | ||
110436 | 117044 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 2297 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6001629.48989293 | 2114242.74964382 | 37.7853990645293 | -122.438111123258 | (37.7853990645293, -122.438111123258) | 13 | 6 | 11 | 29490 | 13 | |||
110437 | 43707 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 503 Capitol Ave | 3 | 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 | ||
110529 | 36509 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 734 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39386 | 6007727.24180812 | 2095500.96385803 | 37.7342833425639 | -122.415687181505 | (37.7342833425639, -122.415687181505) | 2 | 7 | 7 | 28859 | 2 | ||
111000 | 39506 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 216 Jersey St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | Permit Number 40959 | 6003716.05884842 | 2101601.85489178 | 37.7508086831914 | -122.429990180024 | (37.7508086831914, -122.429990180024) | 2 | 4 | 5 | 28862 | 22 | ||
111231 | 43223 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1303 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/2004 12:00:00 AM | Permit Number 44301 | 6009289.62355935 | 2101563.81507978 | 37.7510183090213 | -122.410713527989 | (37.7510183090213, -122.410713527989) | 2 | 4 | 7 | 28859 | 19 | ||
111234 | 67937 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 82 Saint Mary's Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31650 | 6004338.16538286 | 2095684.17990183 | 37.7345953163648 | -122.427417358908 | (37.7345953163648, -122.427417358908) | 2 | 7 | 5 | 28861 | 2 | ||
111827 | 61742 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 33 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/1987 12:00:00 AM | Permit Number 24596 | 6004949.79749465 | 2101033.09819364 | 37.7493168026727 | -122.425683321129 | (37.7493168026727, -122.425683321129) | 2 | 4 | 5 | 28862 | 22 | ||
112476 | 38501 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 2133 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1998 12:00:00 AM | Permit Number 40492 | 6006816.69957876 | 2118509.8967936 | 37.7974092298161 | -122.420467894474 | (37.7974092298161, -122.420467894474) | 13 | 9 | 10 | 28858 | 32 | ||
112764 | 61746 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 3873 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1984 12:00:00 AM | Permit Number 21752 | 6004713.22212882 | 2100726.95185307 | 37.7484628246013 | -122.426479608106 | (37.7484628246013, -122.426479608106) | 2 | 4 | 5 | 63 | 22 | ||
112973 | 38068 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 2299 SUTTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/1998 12:00:00 AM | Permit Number 40258 | 6001654 | 2114215 | 37.7853242650019 | -122.438024337369 | (37.7853242650019, -122.438024337369) | 13 | 6 | 11 | 29490 | 13 | |||
113238 | 43731 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 766 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43368 | 5994373.49554275 | 2089956.67715953 | 37.7183003625969 | -122.461453233071 | (37.7183003625969, -122.461453233071) | 9 | 8 | 6 | 28861 | 24 | ||
113430 | 46891 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1442 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/26/2002 12:00:00 AM | Permit Number 44947 | 5993067.98197095 | 2105653.75631803 | 37.7613253640923 | -122.46710643925 | (37.7613253640923, -122.46710643925) | 1 | 8 | 4 | 56 | 12 | |||
113788 | 67803 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 211 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/2015 12:00:00 AM | Permit Number 776671 | 6003788.24539392 | 2100967.25400369 | 37.7490703054266 | -122.429695296026 | (37.7490703054266, -122.429695296026) | 2 | 4 | 5 | 28862 | 22 | ||
113874 | 33256 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 2669 30th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/1996 12:00:00 AM | Permit Number 37434 | 5986956.33101058 | 2097199.71207947 | 37.7377581609646 | -122.487622710626 | (37.7377581609646, -122.487622710626) | 1 | 8 | 3 | 29491 | 35 | |||
113974 | 43143 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 140 Gambier St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2000 12:00:00 AM | Permit Number 42956 | 6005786.06556581 | 2093081.91758291 | 37.7275318626033 | -122.422226653074 | (37.7275318626033, -122.422226653074) | 9 | 7 | 7 | 309 | 5 | ||
114135 | 52789 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1420@ 26th ST Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/25/2006 12:00:00 AM | Permit Number 48830 | 6009273.59871726 | 2100910.89270255 | 37.7492246309201 | -122.410722838262 | (37.7492246309201, -122.410722838262) | 2 | 4 | 7 | 28859 | 19 | ||
114424 | 85500 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1 Nebraska St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009335 | 2098038 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | 10 | 7 | 7 | 28859 | 2 | |||||
114869 | 64176 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 7 Cerritos Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/2000 12:00:00 AM | Permit Number 24959 | 5992913.91992547 | 2093156.51419592 | 37.7270022179247 | -122.466730800624 | (37.7270022179247, -122.466730800624) | 9 | 8 | 4 | 59 | 40 | ||
115462 | 32345 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1201 35th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | Permit Number 37068 | 5985179.95256355 | 2107022.76154853 | 37.7646257968319 | -122.494488338591 | (37.7646257968319, -122.494488338591) | 1 | 8 | 3 | 56 | 35 | ||
115504 | 40071 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1459 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/19/1999 12:00:00 AM | Permit Number 41297 | 6015490.41779177 | 2093366.98866113 | 37.7288572181843 | -122.388698234625 | (37.7288572181843, -122.388698234625) | 10 | 3 | 8 | 58 | 1 |
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) );