230 rows where qCareAssistant = "FUF" and qSpecies_id = 97 sorted by Police Districts

View and edit SQL

qCareAssistant

  • FUF · 230
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)
28593 66848 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 919 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/15/1991 12:00:00 AM     Permit Number 30152 6008182.6560056 2115155.17049763 37.7882748588768 -122.415503684404 (37.7882748588768, -122.415503684404) 13 1 10 28858 21
41084 48790 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 1405 Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/21/2006 12:00:00 AM     Permit Number 46040 6008874.44924411 2117680.29283989 37.7952470886304 -122.413288823995 (37.7952470886304, -122.413288823995) 5 1 10 308 21
57362 65894 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 649 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/05/1990 12:00:00 AM     Permit Number 28901 6009912.39060761 2119145.15114701 37.7993274494867 -122.409800817555 (37.7993274494867, -122.409800817555) 3 1 10 308 4
58481 65402 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 760 Geary St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/1989 12:00:00 AM 12 3x3 Permit Number 28251 6008077 2114493 37.7864507606031 -122.415822330961 (37.7864507606031, -122.415822330961) 13 1 9 28858 36
76403 66852 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 805 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/15/1991 12:00:00 AM     Permit Number 30158 6008246.52380896 2115214.16051417 37.7884404207738 -122.415286889274 (37.7884404207738, -122.415286889274) 13 1 10 28858 21
80740 35236 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1198 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/17/1998 12:00:00 AM 10   Permit Number 38733 6007268.58471 2119527.95161 37.8002300077587 -122.418976495462 (37.8002300077587, -122.418976495462) 5 1 1 28858 32
83298 65478 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 601 Stockton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/12/1989 12:00:00 AM     Permit Number 28359 6010541.36110634 2116214.27782437 37.7913152098094 -122.407417612453 (37.7913152098094, -122.407417612453) 5 1 10 28857 21
84852 65486 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 801 Bush St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/15/1989 12:00:00 AM     Permit Number 28370 6009649.36997858 2115707.80146662 37.7898745823318 -122.410468114048 (37.7898745823318, -122.410468114048) 5 1 10 28857 21
107326 66869 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 640 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/18/1991 12:00:00 AM     Permit Number 30178 6009507.57601331 2115392.34348399 37.789000460867 -122.410936420318 (37.789000460867, -122.410936420318) 5 1 10 28857 21
125743 35237 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1198 Filbert St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/17/1998 12:00:00 AM 8   Permit Number 38733 6007256.14978 2119525.96271 37.8002238465228 -122.419019384135 (37.8002238465228, -122.419019384135) 5 1 1 28858 32
149996 64775 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 517 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/05/1989 12:00:00 AM     Permit Number 25767 6010461.649147 2119569.81510368 37.8005242381712 -122.407930145171 (37.8005242381712, -122.407930145171) 3 1 10 308 23
152169 65423 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 801 California St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/05/1989 12:00:00 AM     Permit Number 28281 6010517.63649674 2116529.16048818 37.7921784739149 -122.407521909343 (37.7921784739149, -122.407521909343) 5 1 10 28857 21
160598 34453 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1167 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/1997 12:00:00 AM 10   Permit Number 38197 6007453.34661 2118811.22971 37.7982724714417 -122.418286300874 (37.7982724714417, -122.418286300874) 5 1 10 28858 32
170465 64776 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 816 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/05/1989 12:00:00 AM     Permit Number 25768 6010808.79838009 2116967.92817235 37.7933995175775 -122.406545412053 (37.7933995175775, -122.406545412053) 3 1 10 28857 4
176360 53343 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 620 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/13/1995 12:00:00 AM     Permit Number 30179 6009598.94591555 2115405.06508937 37.7890405143898 -122.410621189952 (37.7890405143898, -122.410621189952) 5 1 10 28857 21
183193 65401 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 747 Geary St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/1989 12:00:00 AM     Permit Number 28250 6008150.2130763 2114455.0011203 37.7863505404889 -122.415566339973 (37.7863505404889, -122.415566339973) 13 1 9 28858 36
74931 64702 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 110 Cyril Magnin St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/14/1988 12:00:00 AM     Permit Number 25683 6010200.02442425 2113768.63085544 37.7845809377612 -122.408426051637 (37.7845809377612, -122.408426051637) 14 10 10 28852 36
98731 64717 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 35 Powell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/14/1988 12:00:00 AM     Permit Number 25671 6010371.58706878 2113906.86566108 37.7849701038252 -122.407842251054 (37.7849701038252, -122.407842251054) 14 10 10 28852 36
111103 64725 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 174 Ellis St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/14/1988 12:00:00 AM     Permit Number 25680 6010012.44318345 2114072.97215331 37.7854060800363 -122.409096504402 (37.7854060800363, -122.409096504402) 14 10 9 28852 36
140818 65399 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 471 Ellis St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/1989 12:00:00 AM     Permit Number 28247 6008612.45505665 2113822.69504434 37.7846403524021 -122.41392234969 (37.7846403524021, -122.41392234969) 7 10 9 28852 36
144563 64727 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 166 Eddy St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/14/1988 12:00:00 AM     Permit Number 25682 6009623.89289745 2113671.39889681 37.7842816815144 -122.410412412425 (37.7842816815144, -122.410412412425) 14 10 9 28852 36
186261 64726 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 127 Ellis St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/14/1988 12:00:00 AM     Permit Number 25681 6010217.12887008 2114048.91615067 37.7853514923776 -122.40838665256 (37.7853514923776, -122.40838665256) 14 10 10 28852 36
27707 66488 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 1043 Minna St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/21/1991 12:00:00 AM     Permit Number 29647 6007587.84875499 2109703.11754078 37.7732713850209 -122.417175139527 (37.7732713850209, -122.417175139527) 8 2 9 28853 19
60993 61785 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 1495 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/06/1987 12:00:00 AM     Permit Number 24636 6012051.50334521 2101403.29784414 37.7507320294913 -122.401151335946 (37.7507320294913, -122.401151335946) 10 3 8 28856 29
71033 62088 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 474 Connecticut St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/20/1985 12:00:00 AM     Permit Number 22174 6013214.9408475 2104861.98073646 37.7602936588903 -122.397370564655 (37.7602936588903, -122.397370564655) 10 3 8 28856 29
75846 32047 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 501 Tunnel Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/13/1999 12:00:00 AM     Permit Number 35428 6012610 2086139 37.7088505533644 -122.398149216451 (37.7088505533644, -122.398149216451) 10 3 8 309 1
90644 61306 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 1494 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/10/1984 12:00:00 AM     Permit Number 21205 6011999.58311152 2101400.41872379 37.7507212274206 -122.401330679383 (37.7507212274206, -122.401330679383) 10 3 8 28856 29
115001 67594 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 308 Missouri St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/05/1992 12:00:00 AM     Permit Number 31161 6013452.45067872 2105638.02121278 37.7624377166869 -122.39660352483 (37.7624377166869, -122.39660352483) 10 3 8 28856 29
121851 61725 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 66 Williams Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/12/1985 12:00:00 AM     Permit Number 21727 6013825.41276045 2093670.69143799 37.7295987054368 -122.394475571882 (37.7295987054368, -122.394475571882) 10 3 8 58 1
124236 30843 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 1375 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/14/1995 12:00:00 AM     Permit Number 34691 6011743.60320296 2101979.83639733 37.7522978969141 -122.40225661865 (37.7522978969141, -122.40225661865) 10 3 8 28856 29
134941 61310 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 2337 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/10/1984 12:00:00 AM     Permit Number 21209 6011897.61971652 2101840.97458612 37.7519252086186 -122.4017142423 (37.7519252086186, -122.4017142423) 10 3 8 28856 29
165378 61309 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 2325 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/10/1984 12:00:00 AM     Permit Number 21208 6011929.28683038 2101842.72936764 37.7519317939639 -122.40160485559 (37.7519317939639, -122.40160485559) 10 3 8 28856 29
167803 41049 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 1452 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/26/1999 12:00:00 AM     Permit Number 41829 6011713.00642169 2101589.94219711 37.7512256245579 -122.402335016202 (37.7512256245579, -122.402335016202) 10 3 8 28856 29
173842 32046 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 501 Tunnel Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/13/1999 12:00:00 AM     Permit Number 35428 6012610 2086139 37.7088505533644 -122.398149216451 (37.7088505533644, -122.398149216451) 10 3 8 309 1
1692 61474 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 1960 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/10/1984 12:00:00 AM     Permit Number 21417 6004396.86379546 2107211.14447839 37.7662489975602 -122.428035576337 (37.7662489975602, -122.428035576337) 8 4 5 28862 3
7424 61750 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 3235 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/18/1984 12:00:00 AM     Permit Number 21761 6005283.427251 2106614.91851966 37.7646620214784 -122.424926696656 (37.7646620214784, -122.424926696656) 8 4 5 28859 19
15629 66830 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 393 Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/06/1991 12:00:00 AM     Permit Number 30127 6001175.80343985 2104102.01378806 37.7575293253254 -122.438953746382 (37.7575293253254, -122.438953746382) 2 4 5 28862 3
17311 61740 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 219 Clipper St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/15/1984 12:00:00 AM     Permit Number 21745 6003738.99947337 2100964.64707663 37.7490603587459 -122.429865402911 (37.7490603587459, -122.429865402911) 2 4 5 28862 22
17850 60829 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 82 Jersey St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/1983 12:00:00 AM     Permit Number 20508 6004586.81845905 2101649.91280729 37.7509899147675 -122.426982435992 (37.7509899147675, -122.426982435992) 2 4 5 28862 22
20637 50305 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 1217@ ARMY Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/22/2003 12:00:00 AM     Permit Number 47015 6001375.35048187 2100228.68999583 37.7469054591013 -122.437986196494 (37.7469054591013, -122.437986196494) 2 4 5 63 22
25933 60830 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 282 Chattanooga St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/1983 12:00:00 AM 22   Permit Number 20603 6004748.95976393 2102035.39189802 37.7520575177016 -122.426449179292 (37.7520575177016, -122.426449179292) 2 4 5 28862 22
27423 121150 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 1918 15th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   24     6004687.86766006 2107227.29036829 37.766309789845 -122.427030199286 (37.766309789845, -122.427030199286) 8 4 5 28862 3
36047 69485 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 560 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/24/1994 12:00:00 AM     Permit Number 33606 6008946.01217425 2105621.19939594 37.7621396967865 -122.412188502645 (37.7621396967865, -122.412188502645) 8 4 7 28859 19
39537 61715 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 281 Clinton Park 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/04/1984 12:00:00 AM     Permit Number 21715 6004926.94134289 2108179.4823523 37.7689377963385 -122.42627108706 (37.7689377963385, -122.42627108706) 8 4 5 28853 19
40421 61705 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 57 Rosemont Pl 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/06/1984 12:00:00 AM     Permit Number 21704 6005150.34156307 2107947.67774505 37.7683139415326 -122.42548186082 (37.7683139415326, -122.42548186082) 8 4 5 28853 19
50241 61716 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 271 Clinton Park 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/04/1984 12:00:00 AM     Permit Number 21716 6004986.55656035 2108182.89626107 37.7689505396343 -122.426065124893 (37.7689505396343, -122.426065124893) 8 4 5 28853 19
50861 60838 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 261 Chattanooga St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/1983 12:00:00 AM     Permit Number 20611 6004794.55991917 2102160.27475876 37.75240299462 -122.426300377591 (37.75240299462, -122.426300377591) 2 4 5 28862 22
51538 66220 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 1 Dolores Ter 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/23/1990 12:00:00 AM     Permit Number 29312 6005304.82019082 2105877.54249684 37.7626385702507 -122.424800241819 (37.7626385702507, -122.424800241819) 8 4 5 28859 19
56192 61710 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 1975 Market St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/06/1984 12:00:00 AM     Permit Number 21709 6004910.69371619 2108330.79575039 37.7693523480889 -122.426338061309 (37.7693523480889, -122.426338061309) 8 4 5 28862 19
56378 34142 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 400 Treat Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/13/1997 12:00:00 AM     Permit Number 37990 6008524.65557539 2106230.12436926 37.7637880127631 -122.413688890617 (37.7637880127631, -122.413688890617) 8 4 7 28859 19
59240 60839 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 271 Chattanooga St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/1983 12:00:00 AM     Permit Number 20613 6004797.43728628 2102104.7326602 37.7522506515925 -122.426286473113 (37.7522506515925, -122.426286473113) 2 4 5 28862 22
62313 61708 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 580 14th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/06/1984 12:00:00 AM     Permit Number 21707 6004928.75046121 2107826.22237424 37.767967931643 -122.426239675726 (37.767967931643, -122.426239675726) 8 4 5 28853 19
63739 60831 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 205 Chattanooga St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/1983 12:00:00 AM     Permit Number 20604 6004778.44666437 2102471.31049199 37.7532561154195 -122.426378243722 (37.7532561154195, -122.426378243722) 2 4 5 28862 22
64691 60840 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 315 Chattanooga St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/1983 12:00:00 AM     Permit Number 20614 6004809.28697134 2101883.59513704 37.7516441291888 -122.426229752639 (37.7516441291888, -122.426229752639) 2 4 5 28862 22
65684 65243 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 1086 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/26/1989 12:00:00 AM     Permit Number 28037 6009165.76758609 2102839.33295033 37.7545136503205 -122.411231929366 (37.7545136503205, -122.411231929366) 2 4 7 28859 19
65803 66224 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 32 Dorland St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/24/1990 12:00:00 AM     Permit Number 29318 6005343.90687 2105779.62004334 37.7623719059493 -122.424658088706 (37.7623719059493, -122.424658088706) 8 4 5 28859 19
67426 63397 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 4300 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/15/1991 12:00:00 AM     Permit Number 30165 6001730.87094671 2104708.68623731 37.7592266666695 -122.437077536949 (37.7592266666695, -122.437077536949) 2 4 5 28862 3
69007 64894 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 1450 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/04/1989 12:00:00 AM     Permit Number 25920 6005836.52150612 2100535.66309095 37.7480010261231 -122.422581663865 (37.7480010261231, -122.422581663865) 2 4 5 28859 19
69132 60836 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 253 Chattanooga St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/1983 12:00:00 AM     Permit Number 20609 6004792.25802571 2102204.70843345 37.7525248690267 -122.426311501214 (37.7525248690267, -122.426311501214) 2 4 5 28862 22
72854 61763 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 390 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/19/1984 12:00:00 AM     Permit Number 21777 6005479.130443 2106713.50276565 37.7649437627207 -122.424256822517 (37.7649437627207, -122.424256822517) 8 4 5 28853 19
75679 57103 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 3743 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/1983 12:00:00 AM     Permit Number 20509 6004792.79553424 2102485.90723803 37.7532970057744 -122.426329661558 (37.7532970057744, -122.426329661558) 2 4 5 28862 22
76206 63396 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 4326 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/11/1987 12:00:00 AM     Permit Number 23978 6001653.34817436 2104704.40880226 37.759210515065 -122.437345341266 (37.759210515065, -122.437345341266) 2 4 5 28862 3
79246 60832 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 210 Chattanooga St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/1983 12:00:00 AM     Permit Number 20605 6004728.24272246 2102435.29497545 37.7531543871846 -122.426549294945 (37.7531543871846, -122.426549294945) 2 4 5 28862 22
80884 60279 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 890 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/09/1982 12:00:00 AM     Permit Number 19841 6007951.11915857 2102749.5563076 37.7541989479338 -122.415426159541 (37.7541989479338, -122.415426159541) 2 4 7 28859 19
80902 64591 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 3375 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/09/1988 12:00:00 AM     Permit Number 25492 6005853.76544152 2103715.18666196 37.7567322373374 -122.422747957423 (37.7567322373374, -122.422747957423) 2 4 5 28859 19
88565 36252 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 243 Clinton Park 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/06/1998 12:00:00 AM     Permit Number 39269 6005153.47922718 2108192.45520893 37.7689862189606 -122.42548843025 (37.7689862189606, -122.42548843025) 8 4 5 28853 19
90119 61733 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 1352 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/15/1984 12:00:00 AM     Permit Number 21738 6004486.387982 2101012.81721841 37.7492349189645 -122.427284356874 (37.7492349189645, -122.427284356874) 2 4 5 28862 22
97223 67815 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 967 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/17/1992 12:00:00 AM     Permit Number 31469 6003802.17585758 2102641.49083741 37.7536681560563 -122.429766523917 (37.7536681560563, -122.429766523917) 2 4 5 28862 22
98843 64576 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 3524 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/10/1988 12:00:00 AM     Permit Number 25474 6006109.43020381 2104951.42696267 37.760141086622 -122.421951589354 (37.760141086622, -122.421951589354) 2 4 5 28859 19
102238 60837 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 255 Chattanooga St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/1983 12:00:00 AM     Permit Number 20610 6004792.83349827 2102193.60003035 37.7524944004681 -122.426308720309 (37.7524944004681, -122.426308720309) 2 4 5 28862 22
102803 60834 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 233 Chattanooga St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/1983 12:00:00 AM     Permit Number 20607 6004786.50329151 2102315.79263057 37.752829555056 -122.426339310434 (37.752829555056, -122.426339310434) 2 4 5 28862 22
105533 63872 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 426 Hill St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/16/1987 12:00:00 AM     Permit Number 24575 6003557.23375757 2103346.48170692 37.7555900208672 -122.430663891517 (37.7555900208672, -122.430663891517) 2 4 5 28862 22
107780 66216 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 438 Treat Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/23/1990 12:00:00 AM     Permit Number 29307 6008473.34152559 2106010.06053059 37.7631808865324 -122.413850803115 (37.7631808865324, -122.413850803115) 8 4 7 28859 19
109279 68204 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 1110 York St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/18/1993 12:00:00 AM 16 3x3 Permit Number 32363 6009978.53990017 2102725.22931804 37.7542458964916 -122.408413088762 (37.7542458964916, -122.408413088762) 2 4 7 28859 19
110561 54295 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 3761 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/1983 12:00:00 AM     Permit Number 20600 6004679.68604313 2102479.51319776 37.7532730549459 -122.426720362353 (37.7532730549459, -122.426720362353) 2 4 5 28862 22
110682 61727 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 106 Clipper St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/15/1984 12:00:00 AM     Permit Number 21732 6004453.38447501 2101057.16682643 37.7493548261549 -122.427401642555 (37.7493548261549, -122.427401642555) 2 4 5 28862 22
111937 61712 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 239 Clinton Park 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/04/1984 12:00:00 AM     Permit Number 21712 6005177.32533199 2108193.82077345 37.768991315779 -122.425406045223 (37.768991315779, -122.425406045223) 8 4 5 28853 19
116320 64674 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 3672 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/07/1988 12:00:00 AM     Permit Number 25610 6005829.7777873 2104349.72005691 37.7584731646091 -122.422876010971 (37.7584731646091, -122.422876010971) 2 4 5 28859 19
118466 116773 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 400 Vicksburg St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF         6004132.01414207 2101578.81224199 37.7507689616906 -122.428550126724 (37.7507689616906, -122.428550126724) 2 4 5 28862 22
119041 63779 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 143 Jersey St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/09/1987 12:00:00 AM     Permit Number 24460 6004205.74848694 2101576.80650466 37.7507676268483 -122.428295003883 (37.7507676268483, -122.428295003883) 2 4 5 28862 22
122779 61739 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 232 Clipper St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/15/1984 12:00:00 AM     Permit Number 21744 6003650.07025761 2101012.01224764 37.7491853759856 -122.430176299432 (37.7491853759856, -122.430176299432) 2 4 5 28862 22
122852 58069 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 4525 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/06/1991 12:00:00 AM     Permit Number 30131 6000914.77254872 2105195.89592401 37.7605180033322 -122.439934925187 (37.7605180033322, -122.439934925187) 2 4 5 28862 3
125961 63244 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 3686 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/14/1987 12:00:00 AM 14 4x4 Permit Number 23795 6005743.604902 2104344.93890143 37.7584551740166 -122.423173695837 (37.7584551740166, -122.423173695837) 2 4 5 28859 19
127691 61741 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 175 Clipper St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/15/1984 12:00:00 AM     Permit Number 21746 6004036.62237664 2100981.15253515 37.7491225287463 -122.428837396831 (37.7491225287463, -122.428837396831) 2 4 5 28862 22
128740 61713 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 269 Clinton Park 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/04/1984 12:00:00 AM     Permit Number 21713 6004998.47961276 2108183.57904333 37.7689530882522 -122.42602393242 (37.7689530882522, -122.42602393242) 8 4 5 28853 19
129506 66222 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 48 Dorland St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/23/1990 12:00:00 AM     Permit Number 29314 6005242.33190892 2105774.60229973 37.7623523912444 -122.425009042016 (37.7623523912444, -122.425009042016) 8 4 5 28859 19
129773 66218 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 81 Dorland St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/23/1990 12:00:00 AM     Permit Number 29310 6005039.41557773 2105712.51494257 37.7621704498093 -122.425706435205 (37.7621704498093, -122.425706435205) 8 4 5 28859 19
131070 61754 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 3208 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/18/1984 12:00:00 AM     Permit Number 21766 6005459.89972761 2106676.78980679 37.7648418717739 -122.424320725398 (37.7648418717739, -122.424320725398) 8 4 5 28853 19
135237 61717 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 126 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/04/1984 12:00:00 AM     Permit Number 21717 6005390.65318574 2108294.55770451 37.7692799656993 -122.424675324148 (37.7692799656993, -122.424675324148) 8 4 5 28853 19
135891 61714 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 236 Clinton Park 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/04/1984 12:00:00 AM     Permit Number 21714 6005186.275415 2108246.41850013 37.7691362421663 -122.425378830956 (37.7691362421663, -122.425378830956) 8 4 5 28853 19
137705 66878 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 281 Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/18/1991 12:00:00 AM     Permit Number 30189 6001145.91509222 2104727.87963003 37.7592460999874 -122.439101967223 (37.7592460999874, -122.439101967223) 2 4 5 28862 3
138825 60292 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 2902 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/09/1982 12:00:00 AM     Permit Number 19857 6009437.54414231 2102795.33502096 37.7544080802013 -122.410288944543 (37.7544080802013, -122.410288944543) 2 4 7 28859 19
144984 61731 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 1250 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/15/1984 12:00:00 AM     Permit Number 21736 6003842.20340405 2100987.35465575 37.7491285523468 -122.42951014206 (37.7491285523468, -122.42951014206) 2 4 5 28862 22
146150 61734 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 264 Clipper St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/15/1984 12:00:00 AM     Permit Number 21739 6003453.08659842 2101001.58454059 37.7491455850179 -122.430856727417 (37.7491455850179, -122.430856727417) 2 4 5 28862 22
146304 63405 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 4330 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/11/1987 12:00:00 AM     Permit Number 23987 6001641.42159443 2104703.75073536 37.7592080301488 -122.437386541918 (37.7592080301488, -122.437386541918) 2 4 5 28862 3
146840 64693 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 110 Liberty St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/13/1988 12:00:00 AM     Permit Number 25636 6005573.37725141 2104043.9306623 37.7576190678174 -122.423741017308 (37.7576190678174, -122.423741017308) 2 4 5 28859 19
152129 35055 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 570 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/21/1998 12:00:00 AM     Permit Number 38614 6008948.51314843 2105576.68374234 37.7620176073252 -122.41217670641 (37.7620176073252, -122.41217670641) 8 4 7 28859 19
152493 61711 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 232 Clinton Park 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/1991 12:00:00 AM     Permit Number 29947 6005210.12151982 2108247.78406465 37.7691413389079 -122.425296445755 (37.7691413389079, -122.425296445755) 8 4 5 28853 19
152804 60714 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 21 Oakwood St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/23/1989 12:00:00 AM     Permit Number 20367 6005264.975818 2105333.47768938 37.7611424464321 -122.424899339668 (37.7611424464321, -122.424899339668) 2 4 5 28859 19
164254 59572 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 893 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/1991 12:00:00 AM     Permit Number 24583 6003136.10237421 2103049.36160406 37.7547503322276 -122.432099077639 (37.7547503322276, -122.432099077639) 2 4 5 28862 22

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