trees

348 rows where Police Districts = 4 and qSpecies_id = 8 sorted by Zip Codes

✎ View and edit SQL

This data as json, CSV (advanced)

Police Districts ✖

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)
13425 223490 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1810 Harrison St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6008605.30011 2107940.39716 37.768488553924 -122.41353093232 (37.768488553924, -122.41353093232) 8 4 7 28853 19
13567 243284 Planning Code 138.1 required 2 Eriobotrya deflexa :: Bronze Loquat 8 1450 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/31/2017 12:00:00 AM 3 3x4 Permit Number 775137 6007678.08789 2107386.86578 37.766916579475 -122.416698868869 (37.766916579475, -122.416698868869) 8 4 7 28853 19
14895 42944 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 30 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/2000 12:00:00 AM     Permit Number 42839 6007671.6020798 2107773.96917263 37.7679791099284 -122.416748729284 (37.7679791099284, -122.416748729284) 8 4 7 28853 19
30436 223435 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 335 Valencia St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6006142.1002 2107638.15055 37.7675200389439 -122.422029465401 (37.7675200389439, -122.422029465401) 8 4 7 28853 19
32151 22922 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 333 Valencia St 5 Sidewalk: Curb side : Cutout Tree Private 2     30 3x3   6006142.65939 2107729.77965 37.7677716622264 -122.422034041273 (37.7677716622264, -122.422034041273) 8 4 7 28853 19
39376 223432 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 321 Valencia St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 2ft   6006137.48741 2107733.43659 37.7677814116141 -122.422052190377 (37.7677814116141, -122.422052190377) 8 4 7 28853 19
43767 223603 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 66 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6007689.4598 2107580.51877 37.7674489448444 -122.416673255272 (37.7674489448444, -122.416673255272) 8 4 7 28853 19
56214 38319 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1810 Harrison St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2016 12:00:00 AM     Permit Number 774280 6008623.68390919 2107918.42733823 37.7684292621485 -122.413465790173 (37.7684292621485, -122.413465790173) 8 4 7 28853 19
60680 223433 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 321 Valencia St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6006139.56315 2107708.41808 37.7677128338021 -122.422043233108 (37.7677128338021, -122.422043233108) 8 4 7 28853 19
105198 223491 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1810 Harrison St 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6008605.65376 2107931.14375 37.768463166072 -122.413529054538 (37.768463166072, -122.413529054538) 8 4 7 28853 19
107596 151878 Planning Code 138.1 required 2 Eriobotrya deflexa :: Bronze Loquat 8 1450 15th St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/31/2017 12:00:00 AM 3 3x4 Permit Number 775137 6007623.77597 2107385.08821 37.7669086438472 -122.416886599646 (37.7669086438472, -122.416886599646) 8 4 7 28853 19
108207 223605 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 28 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6007673.38803 2107757.3509 37.767933580499 -122.416741374417 (37.767933580499, -122.416741374417) 8 4 7 28853 19
114581 22921 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 333 Valencia St 4 Sidewalk: Curb side : Cutout Tree Private 2   02/08/1999 12:00:00 AM 16 3X3   6006144.43338 2107707.65753 37.7677110201932 -122.42202633352 (37.7677110201932, -122.42202633352) 8 4 7 28853 19
128623 223651 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1810 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6008609.3878 2107944.17122 37.7684991461388 -122.413517060262 (37.7684991461388, -122.413517060262) 8 4 7 28853 19
129574 22918 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 333 Valencia St 1 Sidewalk: Curb side : Cutout Tree DPW 1     20 3X3   6006138.94284 2107682.09275 37.7676405157139 -122.422043508318 (37.7676405157139, -122.422043508318) 8 4 7 28853 19
131944 38317 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1810 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/05/2016 12:00:00 AM   3x3 Permit Number 774280 6008623.68390919 2107918.42733823 37.7684292621485 -122.413465790173 (37.7684292621485, -122.413465790173) 8 4 7 28853 19
138809 38321 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1810 Harrison St 3 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2016 12:00:00 AM     Permit Number 774280 6008623.68390919 2107918.42733823 37.7684292621485 -122.413465790173 (37.7684292621485, -122.413465790173) 8 4 7 28853 19
147588 22920 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 333 Valencia St 3 Sidewalk: Curb side : Cutout Tree DPW 1     20 3X3   6006146.18632 2107684.74759 37.767648213805 -122.422018642617 (37.767648213805, -122.422018642617) 8 4 7 28853 19
152460 223604 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 54 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6007683.47887 2107616.29854 37.7675468513265 -122.416696477566 (37.7675468513265, -122.416696477566) 8 4 7 28853 19
154975 22919 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 333 Valencia St 2 Sidewalk: Curb side : Cutout Tree DPW 1     20 3X3   6006146.38467 2107662.66758 37.7675875985285 -122.422016387826 (37.7675875985285, -122.422016387826) 8 4 7 28853 19
155159 223492 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1810 Harrison St 4 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6008606.40077 2107919.47331 37.7684311637055 -122.413525645189 (37.7684311637055, -122.413525645189) 8 4 7 28853 19
163011 223649 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1812 Harrison St 8 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6008605.94683 2107884.16729 37.7683341961038 -122.413524717993 (37.7683341961038, -122.413524717993) 8 4 7 28853 19
170272 31068 Planning Code 138.1 required 2 Eriobotrya deflexa :: Bronze Loquat 8 1450 15th St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/31/2017 12:00:00 AM 3 3x4 Permit Number 775137 6007659.7746 2107385.50696 37.7669118184545 -122.4167621155 (37.7669118184545, -122.4167621155) 8 4 7 28853 19
176477 223434 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 335 Valencia St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6006140.81563 2107660.72515 37.7675819509849 -122.422035512441 (37.7675819509849, -122.422035512441) 8 4 7 28853 19
176996 223650 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1810 Harrison St 5 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6008607.48155 2107905.07917 37.7683917014338 -122.413520888701 (37.7683917014338, -122.413520888701) 8 4 7 28853 19
186859 236267 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 98X Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/31/2017 12:00:00 AM 3 Width 3ft Permit Number 775137 6007694.337 2107447.14933 37.7670830178903 -122.41664693662 (37.7670830178903, -122.41664693662) 8 4 7 28853 19
1153 223389 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 99x Oakwood St 3 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6005306 2104928 37.7600314174308 -122.424728608314 (37.7600314174308, -122.424728608314) 2 4 5 28859 19
1161 223387 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 99x Oakwood St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   6005306 2104928 37.7600314174308 -122.424728608314 (37.7600314174308, -122.424728608314) 2 4 5 28859 19
1507 74233 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 2400 Mariposa St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   1     6010292.05063 2106000.69739 37.7632571481177 -122.407559806245 (37.7632571481177, -122.407559806245) 8 4 8 28859 19
2303 223507 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3351 23rd St 5 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6006548.17508 2102589.95451 37.7536817641104 -122.420266570244 (37.7536817641104, -122.420266570244) 2 4 7 28859 19
2337 223401 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3647 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6005476.77928 2102530.01598 37.7534567573481 -122.423967438743 (37.7534567573481, -122.423967438743) 2 4 5 28859 19
3440 223611 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 255 Bartlett St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6006745.90219 2102323.75764 37.752961988114 -122.419563899379 (37.752961988114, -122.419563899379) 2 4 7 28859 19
3889 223641 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200X Bartlett St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6006696.02527 2102542.97279 37.753561093073 -122.419751936808 (37.753561093073, -122.419751936808) 2 4 7 28859 19
5257 62102 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 440 Bartlett St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/28/1985 12:00:00 AM     Permit Number 22195 6006762.92692973 2101210.352632 37.7499057910946 -122.419426042368 (37.7499057910946, -122.419426042368) 2 4 7 28859 19
7729 223606 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 552 Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007244.98796 2104086.07115 37.7578289967226 -122.417962880381 (37.7578289967226, -122.417962880381) 2 4 7 28859 19
7811 10192 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1169 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1   07/16/2016 04:46:00 AM 3 3X3   6005805.59526 2102140.15786 37.7524048554241 -122.422802617046 (37.7524048554241, -122.422802617046) 2 4 5 28859 19
8809 223493 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 825 Shotwell St 4 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6007980.72085 2102939.00638 37.7547207985381 -122.415337199951 (37.7547207985381, -122.415337199951) 2 4 7 28859 19
10631 106353 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 3520X 26TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6006283 2100840 37.7488618444312 -122.421059362487 (37.7488618444312, -122.421059362487) 2 4 5 28859 19
11823 223370 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 99 Lapidge St 3 Sidewalk: Curb side : Yard Tree Private 2     10 Width 3ft   6006029.2284 2104988.85011 37.7602393183104 -122.422231628499 (37.7602393183104, -122.422231628499) 2 4 5 28859 19
12094 223388 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 99x Oakwood St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   6005306 2104928 37.7600314174308 -122.424728608314 (37.7600314174308, -122.424728608314) 2 4 5 28859 19
13899 223627 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 324 Bartlett St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6006726 2101710 37.7512756289395 -122.419589182986 (37.7512756289395, -122.419589182986) 2 4 7 28859 19
14213 74019 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 2400 Mariposa St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10 3x3   6010272.25282 2105997.87843 37.7632482996846 -122.407628081878 (37.7632482996846, -122.407628081878) 8 4 8 28859 19
15080 223395 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3641 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6005336.13601 2104859.99107 37.7598463829262 -122.424619544351 (37.7598463829262, -122.424619544351) 2 4 5 28859 19
15659 26852 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1201 Guerrero St 2 Sidewalk: Curb side : Cutout Tree DPW 1   07/19/2016 05:13:00 AM 3 2X2   6005817.98305 2101925.96787 37.7518174380456 -122.422744557734 (37.7518174380456, -122.422744557734) 2 4 5 28859 19
16530 223386 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3665 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6005227.03743 2104855.48781 37.7598278559952 -122.424996542879 (37.7598278559952, -122.424996542879) 2 4 5 28859 19
17404 37672 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 3270 18th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/29/1998 12:00:00 AM 3 3x3 Permit Number 40070 6007686 2105618 37.7620601307471 -122.416546187971 (37.7620601307471, -122.416546187971) 8 4 7 28859 19
18040 33037 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 494 Bartlett St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/05/1996 12:00:00 AM     Permit Number 37315 6006779.65662971 2100908.40918731 37.7490776652966 -122.41934677281 (37.7490776652966, -122.41934677281) 2 4 7 28859 19
18129 223629 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200X Bartlett St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6006717.33389 2102164.58545 37.7525233285091 -122.419651401605 (37.7525233285091, -122.419651401605) 2 4 7 28859 19
18151 72422 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 2400 Mariposa St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10 3x3   6010224.23312 2105998.24791 37.7632466260627 -122.407794192953 (37.7632466260627, -122.407794192953) 8 4 8 28859 19
18943 166174 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3356 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x5   6006632.30883 2102638.63296 37.7538201643798 -122.419979070489 (37.7538201643798, -122.419979070489) 2 4 7 28859 19
19933 223498 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 255 Bartlett St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6006745.96401 2102320.90162 37.7529541496195 -122.41956348298 (37.7529541496195, -122.41956348298) 2 4 7 28859 19
21102 223642 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200X Bartlett St 15 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6006690.61182 2102567.74424 37.753628804832 -122.419772415291 (37.753628804832, -122.419772415291) 2 4 7 28859 19
21897 223405 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 201 Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6005449.32896 2102471.93612 37.7532957337303 -122.424058237901 (37.7532957337303, -122.424058237901) 2 4 5 28859 19
23459 223514 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3349 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6006548.63349 2106093.81796 37.763302585471 -122.420513683285 (37.763302585471, -122.420513683285) 8 4 7 28859 19
24237 223512 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3351 18th St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6007094.15413 2105540.45939 37.7618139197035 -122.418587660093 (37.7618139197035, -122.418587660093) 2 4 7 28859 19
25347 98970 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 825 Shotwell St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6008234.2 2102998.9 37.7548994960031 -122.414464835105 (37.7548994960031, -122.414464835105) 2 4 7 28859 19
28255 39127 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 739 Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/19/1998 12:00:00 AM     Permit Number 40808 6007354.16846215 2103008.55652832 37.7548765329449 -122.417508922955 (37.7548765329449, -122.417508922955) 2 4 7 28859 19
28415 223396 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 90 Lapidge St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 5ft   6006003.81464 2104993.73555 37.7602512990686 -122.42231986997 (37.7602512990686, -122.42231986997) 2 4 5 28859 19
29054 223592 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1142 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6009191.70637 2102498.92995 37.7535804348003 -122.411118182576 (37.7535804348003, -122.411118182576) 2 4 7 28859 19
29160 223644 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3266 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6008388.34903 2104490.30808 37.759003221729 -122.414037245221 (37.759003221729, -122.414037245221) 2 4 7 28859 19
29275 257895 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3644 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6005306 2104928 37.7600314174308 -122.424728608314 (37.7600314174308, -122.424728608314) 2 4 5 28859 19
30499 83186 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 3453 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/02/2008 12:00:00 AM   3x3 Permit Number 50577 6006512.76900503 2105506.90807829 37.7616890471737 -122.420596061932 (37.7616890471737, -122.420596061932) 2 4 7 28859 19
30646 223609 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3330 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6006825.79297 2102649.13813 37.7538599081198 -122.419310701547 (37.7538599081198, -122.419310701547) 2 4 7 28859 19
31318 223620 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 439 Bartlett St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6006808.42719 2101225.05572 37.7499487250622 -122.419269742819 (37.7499487250622, -122.419269742819) 2 4 7 28859 19
32577 35506 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 3451 22nd St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/1998 12:00:00 AM     Permit Number 38909 6005392.68349986 2103106.02983212 37.75503360932 -122.424299225131 (37.75503360932, -122.424299225131) 2 4 5 28859 19
35960 99029 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200X Bartlett St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6006692 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314) 2 4 7 28859 19
38908 223615 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 408 Bartlett St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6006795.31694 2101399.56356 37.7504271455035 -122.419327456816 (37.7504271455035, -122.419327456816) 2 4 7 28859 19
39001 99032 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200X Bartlett St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   5 3x3   6006692 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314) 2 4 7 28859 19
39142 223599 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 300 Shotwell St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 5ft   6007767.1377 2106084.40018 37.7633453203425 -122.416298598605 (37.7633453203425, -122.416298598605) 8 4 7 28859 19
39722 223593 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 930 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6009378.63549 2103724.24958 37.756955368323 -122.41055825836 (37.756955368323, -122.41055825836) 2 4 7 28859 19
40081 223634 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200x Bartlett St 7 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6006707.09054 2102321.33719 37.7529531558696 -122.419697945997 (37.7529531558696, -122.419697945997) 2 4 7 28859 19
40144 40254 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3351X 23rd St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/13/1999 12:00:00 AM 10 3x3 Permit Number 41415 6006702.84210434 2102592.14346256 37.7536964884672 -122.419731851285 (37.7536964884672, -122.419731851285) 2 4 7 28859 19
40964 99037 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200X Bartlett St 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6006692 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314) 2 4 7 28859 19
42503 229348 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 2970 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 6ft   6009679.24982 2101052.76499 37.7496369166219 -122.409330094713 (37.7496369166219, -122.409330094713) 2 4 7 28859 19
42828 223602 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 280x Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/25/2017 12:00:00 AM 3 Width 3ft   6007724 2106220 37.7637152201621 -122.416457403809 (37.7637152201621, -122.416457403809) 8 4 7 28859 19
42971 103367 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 290X Bartlett St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6006718.6 2102097 37.7523378256517 -122.419642228322 (37.7523378256517, -122.419642228322) 2 4 7 28859 19
43583 223616 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 408 Bartlett St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6006796.55753 2101381.3101 37.75037709553 -122.419321872018 (37.75037709553, -122.419321872018) 2 4 7 28859 19
45663 223608 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3336 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6006799.35896 2102646.46368 37.7538510758905 -122.419401926961 (37.7538510758905, -122.419401926961) 2 4 7 28859 19
46230 99035 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200X Bartlett St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6006692 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314) 2 4 7 28859 19
46394 66647 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 972 Hampshire St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/25/2000 12:00:00 AM     Permit Number 29858 6010191.86940681 2103559.76448884 37.756549288119 -122.407734178809 (37.756549288119, -122.407734178809) 2 4 7 28859 19
46659 223403 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3624 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6005621.17135 2101994.19422 37.7519936655859 -122.423430010205 (37.7519936655859, -122.423430010205) 2 4 5 28859 19
47805 46326 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 3649 23rd St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/12/2002 12:00:00 AM     Permit Number 44579 6005434.40207527 2102522.16800234 37.7534328160504 -122.424113430233 (37.7534328160504, -122.424113430233) 2 4 5 28859 19
48192 99026 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3351X 23rd St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3 Permit Number 41415 6006571 2102346.4 37.7530143054678 -122.420170352411 (37.7530143054678, -122.420170352411) 2 4 7 28859 19
48313 223502 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3433 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6006860.5286 2101435.19922 37.7505286654636 -122.419104477086 (37.7505286654636, -122.419104477086) 2 4 7 28859 19
51446 223363 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 2676 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6009986.00474 2103992.15144 37.757724999121 -122.40847663451 (37.757724999121, -122.40847663451) 2 4 7 28859 19
52398 223365 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1451 Hampshire St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6010379.01275 2101132.73007 37.7498956641741 -122.406915913261 (37.7498956641741, -122.406915913261) 10 4 7 28859 19
52900 40252 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3351X 23rd St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/13/1999 12:00:00 AM 8 3x3 Permit Number 41415 6006702.84210434 2102592.14346256 37.7536964884672 -122.419731851285 (37.7536964884672, -122.419731851285) 2 4 7 28859 19
53539 35777 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 3528 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/21/1998 12:00:00 AM     Permit Number 39032 6006085.57014843 2104950.10312581 37.7601361059974 -122.422034016017 (37.7601361059974, -122.422034016017) 2 4 5 28859 19
55160 108690 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 61 OAKWOOD ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005327.5 2105108.8 37.7605290659119 -122.424667111807 (37.7605290659119, -122.424667111807) 2 4 5 28859 19
55473 39119 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 552 Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/19/1998 12:00:00 AM     Permit Number 40804 6007242.03781645 2104093.13141214 37.7578482165395 -122.417973583722 (37.7578482165395, -122.417973583722) 2 4 7 28859 19
56396 103366 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 290X Bartlett St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3 Permit Number 769396 6006718.6 2102097 37.7523378256517 -122.419642228322 (37.7523378256517, -122.419642228322) 2 4 7 28859 19
58531 223496 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 825 Shotwell St 9 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6007971.83825 2103118.56148 37.7552133167577 -122.415380629129 (37.7552133167577, -122.415380629129) 2 4 7 28859 19
60745 223399 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3438 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6005409.07211 2103737.92814 37.7567695800561 -122.424287488577 (37.7567695800561, -122.424287488577) 2 4 5 28859 19
62996 99030 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200X Bartlett St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6006692 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314) 2 4 7 28859 19
63331 223637 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200x Bartlett St 10 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6006705.76334 2102387.84087 37.7531356849695 -122.419707254007 (37.7531356849695, -122.419707254007) 2 4 7 28859 19
63646 223379 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 2730 22nd St 3 Sidewalk: Curb side : Yard Tree Private 2     17 Width 7ft   6009758.65341 2103393.8455 37.7560694506528 -122.4092206931 (37.7560694506528, -122.4092206931) 2 4 7 28859 19
65134 223638 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200X Bartlett St 11 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6006702.00783 2102414.72297 37.7532092854977 -122.419722148578 (37.7532092854977, -122.419722148578) 2 4 7 28859 19
65825 223503 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3421 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6006951.65327 2101439.66063 37.7505460466667 -122.41878967662 (37.7505460466667, -122.41878967662) 2 4 7 28859 19
65936 223499 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 255 Bartlett St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   6006746.2446 2102306.01848 37.752913299731 -122.419561456798 (37.752913299731, -122.419561456798) 2 4 7 28859 19
66136 99033 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200X Bartlett St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6006692 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314) 2 4 7 28859 19

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