835 rows where qSpecies_id = 122 sorted by DBH

View and edit SQL

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)
1762 30595 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 265 Walter St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/26/1995 12:00:00 AM     Permit Number 34562                    
1889 259158 DPW Maintained 1 Acacia baileyana :: Bailey's Acacia 122 475 Hickory St 1 Sidewalk: Curb side : Cutout Tree Private 2       2x   6004817 2110376 37.7749626863145 -122.426807815207 (37.7749626863145, -122.426807815207) 7 9 11 28852 10
2542 32891 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 1515 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/30/1996 12:00:00 AM     Permit Number 37234 5994269.30013039 2105266.22888454 37.7603305839468 -122.462923499947 (37.7603305839468, -122.462923499947) 1 5 4 56 12
2756 39703 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 634 Edna St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/05/1999 12:00:00 AM     Permit Number 41088 5998596.64163755 2094795.02743762 37.7318275120035 -122.4472036828 (37.7318275120035, -122.4472036828) 9 7 4 59 40
4487 259159 DPW Maintained 1 Acacia baileyana :: Bailey's Acacia 122 475 Hickory St 2 Sidewalk: Curb side : Cutout Tree Private 2       2x   6004817 2110376 37.7749626863145 -122.426807815207 (37.7749626863145, -122.426807815207) 7 9 11 28852 10
4696 117040 Undocumented 4 Acacia baileyana :: Bailey's Acacia 122 2220x SUTTER ST 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001781 2114465 37.7860179225956 -122.437602866759 (37.7860179225956, -122.437602866759) 13 6 1 29490 27
5032 85509 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 1 Nebraska St 3 Sidewalk: Property side : Yard Tree Private 2         Permit Number 49678 6009335 2098038 37.7413397420659 -122.410307693317 (37.7413397420659, -122.410307693317) 10 7 7 28859 2
6049 35103 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 786 Edinburg St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/28/1998 12:00:00 AM     Permit Number 38645 6001885.65115289 2089265.94057695 37.7168332689419 -122.435437534334 (37.7168332689419, -122.435437534334) 9 7 6 28861 5
6554 51248 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 684 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/17/2004 12:00:00 AM     Permit Number 47625 6007471.15651424 2105682.67696043 37.7622256337552 -122.417293833991 (37.7622256337552, -122.417293833991) 8 4 7 28859 19
6630 30591 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 253 Walter St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/26/1995 12:00:00 AM     Permit Number 34560                    
8576 32346 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 1201 35th Ave 3 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
8595 66640 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 2620 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/18/1993 12:00:00 AM     Permit Number 32335 6010387.14006944 2103433.53881978 37.7562136300125 -122.407049963033 (37.7562136300125, -122.407049963033) 10 4 7 28859 19
9025 30594 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 265 Walter St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/26/1995 12:00:00 AM     Permit Number 34562                    
9093 33190 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 76 Hernandez Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/06/1996 12:00:00 AM     Permit Number 37397 5996015.45875929 2099706.92373099 37.7451665539633 -122.456482373988 (37.7451665539633, -122.456482373988) 1 5 4 59 40
9783 261822 Significant Tree 6 Acacia baileyana :: Bailey's Acacia 122 3580 21st St 2 Front Yard : Yard Tree Private 2       Width 3ft Permit Number 785112 6004538.52309 2103691.84305 37.7565938462521 -122.427294885373 (37.7565938462521, -122.427294885373) 2 4 5 28862 3
11302 34144 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 1754 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1998 12:00:00 AM     Permit Number 39666 6003955.69985192 2098004.27278913 37.7409441243389 -122.428905023889 (37.7409441243389, -122.428905023889) 2 7 5 63 7
12666 48033 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 61 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2002 12:00:00 AM     Permit Number 45754 6001724.06677399 2105480.90222389 37.7613465972478 -122.437156358638 (37.7613465972478, -122.437156358638) 15 4 5 28862 3
12702 32557 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 3822 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/22/1996 12:00:00 AM     Permit Number 770192 6002956.41958884 2103022.59282687 37.7546666427143 -122.432718557235 (37.7546666427143, -122.432718557235) 2 4 5 28862 22
13307 37952 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 1308 Mariposa St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/08/1998 12:00:00 AM     Permit Number 40191 6013419.73141926 2106176.98186548 37.7639157629311 -122.396754475262 (37.7639157629311, -122.396754475262) 14 3 8 28856 29
15287 40295 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 48 Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/13/1999 12:00:00 AM     Permit Number 41439 6005981.28847445 2102313.08870522 37.7528895951686 -122.422207325088 (37.7528895951686, -122.422207325088) 2 4 5 28859 19
15560 261375 DPW Maintained 1 Acacia baileyana :: Bailey's Acacia 122 434 Hickory St 2 Sidewalk: Curb side : Cutout Tree Private 2       Width 3ft   6004866.02058 2110397.15298 37.7750235387365 -122.426639749043 (37.7750235387365, -122.426639749043) 7 9 11 28852 10
16325 38333 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 684 Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/27/1998 12:00:00 AM     Permit Number 40387 6006701.38591008 2112874.96361955 37.7819305989802 -122.420466726707 (37.7819305989802, -122.420466726707) 7 9 9 28852 36
18718 262041 DPW Maintained 1 Acacia baileyana :: Bailey's Acacia 122 1550 10th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       Width 3ft   5993090.57371 2104919.01452 37.7593092592319 -122.466974886903 (37.7593092592319, -122.466974886903) 1 8 4 56 12
19224 261621 DPW Maintained 1 Acacia baileyana :: Bailey's Acacia 122 1821 25th St 2 Sidewalk: Property side : Cutout Tree DPW 1       3x3   6013134 2101730 37.751689413587 -122.397430852298 (37.751689413587, -122.397430852298) 10 3 8 28856 29
19563 261622 DPW Maintained 1 Acacia baileyana :: Bailey's Acacia 122 1281x Wisconsin St 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6012916 2101714 37.7516333407735 -122.398183607514 (37.7516333407735, -122.398183607514) 10 3 8 28856 29
20408 39701 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 625 Edna St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/05/1999 12:00:00 AM     Permit Number 41086 5998544.21434681 2094768.39031032 37.7317513769747 -122.447383017512 (37.7317513769747, -122.447383017512) 9 7 4 59 40
20938 33356 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 200 Kenwood Way 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/14/1996 12:00:00 AM     Permit Number 37493 5994058.57591139 2093537.34847989 37.7281138896418 -122.462801390817 (37.7281138896418, -122.462801390817) 9 8 4 59 40
21427 49185 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 220 Palo Alto Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2003 12:00:00 AM     Permit Number 46291 5997532.34805472 2103898.27952644 37.7567619489163 -122.451539524782 (37.7567619489163, -122.451539524782) 15 5 4 63 38
21787 32344 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 1201 35th Ave 4 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
22337 43381 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 706 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/2000 12:00:00 AM     Permit Number 43129 6001854.12345529 2102032.01903245 37.7518841875031 -122.436459694241 (37.7518841875031, -122.436459694241) 2 4 5 28862 22
23452 85510 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 1 Nebraska St 4 Sidewalk: Property side : Yard Tree Private 2         Permit Number 49678 6009335 2098038 37.7413397420659 -122.410307693317 (37.7413397420659, -122.410307693317) 10 7 7 28859 2
24178 50663 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 1 Santa Ynez Ave 4 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
24211 35786 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 580 Elizabeth St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/22/1998 12:00:00 AM     Permit Number 39038 6002648.18507624 2102127.11023082 37.7521903746122 -122.433720516444 (37.7521903746122, -122.433720516444) 2 4 5 28862 22
24313 36920 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 699 Alvarado St 3 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
24531 43380 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 700 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/2000 12:00:00 AM     Permit Number 43128 6001853.17321705 2102048.95584272 37.751930637944 -122.436464192392 (37.751930637944, -122.436464192392) 2 4 5 28862 22
24848 63851 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 1233 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/16/1987 12:00:00 AM     Permit Number 24548 6001965.88884277 2110471.51360831 37.775063328726 -122.43667724184 (37.775063328726, -122.43667724184) 15 5 11 29492 10
25315 33658 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 575 Linden St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/03/1996 12:00:00 AM     Permit Number 37746 6004659.15076187 2110673.58419475 37.7757708537128 -122.427375053318 (37.7757708537128, -122.427375053318) 7 9 11 28852 10
25439 98708 Undocumented 4 Acacia baileyana :: Bailey's Acacia 122 105X Ord St 2 Sidewalk: Curb side : Cutout Tree DPW 1           6000883.6 2105740.8 37.7620124016568 -122.440081810476 (37.7620124016568, -122.440081810476) 15 5 5 28862 3
25580 117035 Undocumented 4 Acacia baileyana :: Bailey's Acacia 122 2220x SUTTER ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001781 2114465 37.7860179225956 -122.437602866759 (37.7860179225956, -122.437602866759) 13 6 1 29490 27
26802 37051 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 364 Day St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1998 12:00:00 AM     Permit Number 39656 6003583.41460965 2098669.49042288 37.7427495797017 -122.430239695512 (37.7427495797017, -122.430239695512) 2 7 5 63 22
27101 52597 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 421@ FELL Laguna St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/03/2006 12:00:00 AM     Permit Number 48691 6005029.01915461 2110416.12997637 37.7750848587198 -122.426077252438 (37.7750848587198, -122.426077252438) 7 9 11 28852 10
27399 39221 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 1143 Guerrero St 2 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
27992 49579 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 400REVISED Alemany Blvd 9 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
28414 36508 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 584 Anderson St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/29/2003 12:00:00 AM     Permit Number 39385 6007790.43718065 2096197.35426509 37.7361990307601 -122.415517981354 (37.7361990307601, -122.415517981354) 2 7 7 28859 2
28426 33399 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 300 Santa Ana Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/19/1996 12:00:00 AM     Permit Number 37517 5992600.35501271 2094892.48894855 37.7317506732587 -122.467940993296 (37.7317506732587, -122.467940993296) 9 8 4 59 40
30127 68814 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 125 Brompton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/30/1993 12:00:00 AM     Permit Number 32757 6002131.57604717 2095277.55167817 37.7333537609923 -122.435017196532 (37.7333537609923, -122.435017196532) 9 7 5 63 40
30776 67143 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 303 Bocana St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/30/1992 12:00:00 AM     Permit Number 30573 6006940.4062177 2097313.36453869 37.7392155318486 -122.418536006241 (37.7392155318486, -122.418536006241) 2 7 7 28859 2
31049 66174 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 70 Bronte St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/05/1990 12:00:00 AM     Permit Number 29247 6009314.15806324 2097044.09702117 37.7386095323365 -122.410309598587 (37.7386095323365, -122.410309598587) 10 7 7 28859 2
32201 117042 Undocumented 4 Acacia baileyana :: Bailey's Acacia 122 2220x SUTTER ST 10 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001781 2114465 37.7860179225956 -122.437602866759 (37.7860179225956, -122.437602866759) 13 6 1 29490 27
32668 36576 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 2959 25th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/20/1998 12:00:00 AM     Permit Number 39438 6009743.48880831 2101591.28473575 37.7511191714417 -122.409145947985 (37.7511191714417, -122.409145947985) 2 4 7 28859 19
32895 109672 Undocumented 4 Acacia baileyana :: Bailey's Acacia 122 798x GRAFTON AVE 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5994496 2090624 37.7201397218642 -122.461078132621 (37.7201397218642, -122.461078132621) 9 8 6 28861 24
33013 51076 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 232 San Carlos St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/22/2006 12:00:00 AM     Permit Number 47538 6006664.07662334 2104758.9078781 37.7596437391075 -122.420019665049 (37.7596437391075, -122.420019665049) 2 4 7 28859 19
33613 49479 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 560@ Pacific Davis St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/14/2003 12:00:00 AM     Permit Number 46402 6013205.44581331 2118473.26826983 37.7976666140298 -122.39835845145 (37.7976666140298, -122.39835845145) 3 1 10 28860 6
35601 39507 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 216 Jersey St 4 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
37537 32890 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 1515 06th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/30/1996 12:00:00 AM     Permit Number 37234 5994269.30013039 2105266.22888454 37.7603305839468 -122.462923499947 (37.7603305839468, -122.462923499947) 1 5 4 56 12
38603 32274 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 623 Anderson St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/1998 12:00:00 AM     Permit Number 39911 6007825.97257693 2096019.31993336 37.7357121847697 -122.415382520688 (37.7357121847697, -122.415382520688) 2 7 7 28859 2
40096 32740 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 139 Lobos St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/29/1996 12:00:00 AM     Permit Number 37123 5995564.95354615 2088674.66529796 37.7148487646576 -122.457242200681 (37.7148487646576, -122.457242200681) 9 8 6 28861 24
41100 68174 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 449 Parker Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/01/1995 12:00:00 AM     Permit Number 31945 5997091.52876923 2111801.84543591 37.778437859612 -122.45363471008 (37.778437859612, -122.45363471008) 15 6 2 54 16
41465 67531 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 55 Mississippi St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/22/1992 12:00:00 AM     Permit Number 31069 6014000.26557437 2106870.40644282 37.7658520487611 -122.394795132512 (37.7658520487611, -122.394795132512) 14 3 8 28856 20
41811 37853 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 639 Excelsior Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/07/1998 12:00:00 AM     Permit Number 40143 6003947.74961722 2091786.98448726 37.7238724004315 -122.428489463759 (37.7238724004315, -122.428489463759) 9 7 6 28861 5
41929 35367 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 619 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/23/1998 12:00:00 AM     Permit Number 38827 6011631.49743277 2091601.49478662 37.7237949110596 -122.401914809778 (37.7237949110596, -122.401914809778) 10 3 7 309 28
42343 39503 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 216 Jersey St 5 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
42433 30931 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 407 Holloway Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/13/1995 12:00:00 AM     Permit Number 34744 5995614.80249177 2091194.83311768 37.7217714131354 -122.457252106382 (37.7217714131354, -122.457252106382) 9 8 6 28861 24
43083 248977 DPW Maintained 1 Acacia baileyana :: Bailey's Acacia 122 748 Central Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999650 2111146 37.7767834132689 -122.444736872581 (37.7767834132689, -122.444736872581) 15 5 11 29492 16
43669 43708 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 503 Capitol Ave 1 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
44531 64135 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 674 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1992 12:00:00 AM     Permit Number 31501 6002183.05937143 2098884.5643421 37.7432607055203 -122.435097097554 (37.7432607055203, -122.435097097554) 2 7 5 63 22
46210 63850 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 1259 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/16/1987 12:00:00 AM     Permit Number 24547 6001845.15733033 2110454.5773622 37.7750099641834 -122.437093665021 (37.7750099641834, -122.437093665021) 15 5 11 29492 10
46532 42111 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 100 Judson Ave 1 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
48530 38069 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 1654X SCOTT ST 2 Sidewalk: Curb side : Cutout Tree Private 2   07/10/1998 12:00:00 AM     Permit Number 40258 6001625 2114095 37.7849931264589 -122.438116069267 (37.7849931264589, -122.438116069267) 15 6 11 29490 13
49476 42106 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 305 Hearst Ave 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/21/2000 12:00:00 AM     Permit Number 42409 5999382.77994639 2094344.80390055 37.730636191214 -122.444453504412 (37.730636191214, -122.444453504412) 9 7 4 28861 40
49717 42335 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 207 Flood Ave 1 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
52547 65160 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 878 Alvarado St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/24/1989 12:00:00 AM     Permit Number 27140 6000731.49768107 2102608.84071127 37.7534041452721 -122.440383246008 (37.7534041452721, -122.440383246008) 2 4 5 28862 22
52636 46270 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 16 Joost Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/16/2002 12:00:00 AM     Permit Number 44554 6001971.15717323 2094954.12044598 37.7324565829795 -122.435548678389 (37.7324565829795, -122.435548678389) 9 7 5 63 40
54989 67804 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 215 Clipper St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/12/1994 12:00:00 AM     Permit Number 31453 6003763.62243652 2100965.95054031 37.7490653321175 -122.429780349464 (37.7490653321175, -122.429780349464) 2 4 5 28862 22
56879 67907 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 557 Hearst Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/08/1994 12:00:00 AM     Permit Number 31610 5997734.62104287 2094370.88558597 37.7306136268107 -122.450153291964 (37.7306136268107, -122.450153291964) 9 7 4 28861 40
58697 45250 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 200 Juanita Way 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/12/2001 12:00:00 AM     Permit Number 44097 5996410.1880044 2098465.43898756 37.7417803963921 -122.455027784646 (37.7417803963921, -122.455027784646) 9 7 4 59 40
59224 61737 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 213 Clipper St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/14/1993 12:00:00 AM     Permit Number 31452 6003775.93391522 2100966.602272 37.7490678187798 -122.429737822747 (37.7490678187798, -122.429737822747) 2 4 5 28862 22
59827 117033 Undocumented 4 Acacia baileyana :: Bailey's Acacia 122 2220x SUTTER ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001781 2114465 37.7860179225956 -122.437602866759 (37.7860179225956, -122.437602866759) 13 6 1 29490 27
59945 33582 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 157 Bonview St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/26/1996 12:00:00 AM     Permit Number 37690 6007165.20249785 2098095.43390853 37.7413755735349 -122.417814180983 (37.7413755735349, -122.417814180983) 2 7 7 28859 2
60595 49477 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 560@ Pacific Davis St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/14/2003 12:00:00 AM     Permit Number 46402 6013205.44581331 2118473.26826983 37.7976666140298 -122.39835845145 (37.7976666140298, -122.39835845145) 3 1 10 28860 6
60882 61342 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 430 Hickory St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/17/1984 12:00:00 AM     Permit Number 21247 6004909.43277367 2110408.16939621 37.7750562413416 -122.426490361334 (37.7750562413416, -122.426490361334) 7 9 11 28852 10
61503 64794 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 700 27th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/05/1989 12:00:00 AM     Permit Number 25792 6001971.04512503 2100046.68918075 37.7464395858784 -122.435913321642 (37.7464395858784, -122.435913321642) 2 7 5 63 22
61974 37714 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 879 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/29/1998 12:00:00 AM   3x3 Permit Number 40084 6007585.89861945 2104551.15151716 37.7591251811896 -122.416816815015 (37.7591251811896, -122.416816815015) 2 4 7 28859 19
61987 67673 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 1776 Revere Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/05/1992 12:00:00 AM     Permit Number 31276 6014200.74997189 2095090.82766105 37.733518969016 -122.393277319642 (37.733518969016, -122.393277319642) 10 3 8 58 1
62316 31180 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 344 Shields St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/21/1995 12:00:00 AM     Permit Number 34878 5993129.55455829 2089868.58886975 37.717986817508 -122.465746580217 (37.717986817508, -122.465746580217) 9 8 6 64 24
62359 61344 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 477 Hickory St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/17/1984 12:00:00 AM     Permit Number 21249 6004697.33191231 2110333.09347915 37.7748381087345 -122.427218716009 (37.7748381087345, -122.427218716009) 7 9 11 28852 10
62374 68758 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 216 Dorland St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/16/1993 12:00:00 AM     Permit Number 32681 6004133.43114203 2105726.5811327 37.762157835439 -122.428840893 (37.762157835439, -122.428840893) 8 4 5 28862 3
63342 48833 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 1019 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/07/2002 12:00:00 AM     Permit Number 46053 6002516.40077061 2102618.9246623 37.7535333013465 -122.434211402781 (37.7535333013465, -122.434211402781) 2 4 5 28862 22
63385 87024 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 650 Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 49965 6001199 2102605 37.7534202073623 -122.438766252724 (37.7534202073623, -122.438766252724) 2 4 5 28862 22
63797 49970 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 577 36th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/11/2003 12:00:00 AM   3x3 Permit Number 46721 5984701.98485126 2111935.6867193 37.7780873043924 -122.496504036563 (37.7780873043924, -122.496504036563) 11 6 2 55 26
64191 51723 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 1148 Treat Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/02/2005 12:00:00 AM     Permit Number 47992 6008632.05923166 2101854.75826991 37.7517802835227 -122.413008028247 (37.7517802835227, -122.413008028247) 2 4 7 28859 19
64202 253615 DPW Maintained 1 Acacia baileyana :: Bailey's Acacia 122 2325 Polk St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/17/1998 12:00:00 AM   3x3 Permit Number 38749 6006221 2118816 37.7982161239914 -122.422550935399 (37.7982161239914, -122.422550935399) 13 9 10 28858 32
64398 50661 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 1 Santa Ynez Ave 2 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
64639 42110 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 100@ Detroit Judson Ave 5 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
64962 66113 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 818 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/15/1990 12:00:00 AM     Permit Number 29168 6003931.34560658 2110798.34494674 37.7760722269843 -122.429901615557 (37.7760722269843, -122.429901615557) 7 9 11 29492 10
64977 34443 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 65 Whitney St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/1997 12:00:00 AM     Permit Number 38187 6004317.14831895 2097838.60614012 37.7405096935375 -122.427643467723 (37.7405096935375, -122.427643467723) 2 7 5 63 7
65063 50320 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 3615 20th St 2 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
65212 33257 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 2669 30th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 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
66532 67603 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 168 Missouri St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/06/1992 12:00:00 AM     Permit Number 31174 6013416.46891349 2106299.39948246 37.7642517131045 -122.39677434216 (37.7642517131045, -122.39677434216) 14 3 8 28856 29
67846 51518 Permitted Site 7 Acacia baileyana :: Bailey's Acacia 122 622 Edna St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/13/2005 12:00:00 AM     Permit Number 47821 5998596.12110377 2094762.07724114 37.7317370088004 -122.447203111837 (37.7317370088004, -122.447203111837) 9 7 4 59 40

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);