trees

348 rows where Police Districts = 4 and qSpecies_id = 8

✎ 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)
893 226590 Private 9 Eriobotrya deflexa :: Bronze Loquat 8 837 Duncan St 1 Sidewalk: Curb side : Cutout Tree Private 2 Port 08/14/2019 12:00:00 AM 3 3x3 Permit Number 784594 6001099.54842 2099653.23365 37.7453097044788 -122.438898660558 (37.7453097044788, -122.438898660558) 2 4 5 63 22
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
2915 223666 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 1511 Castro St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4   02/16/2016 05:50:00 AM 2 Width 3ft   6002610.0457 2101075.27233 37.7493001124297 -122.433777236447 (37.7493001124297, -122.433777236447) 2 4 5 28862 22
3218 84023 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 309 Chattanooga St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/29/2008 12:00:00 AM   3x3 Permit Number 773233 6004808.26935881 2101900.57071737 37.7516906826671 -122.42623448013 (37.7516906826671, -122.42623448013) 2 4 5 28862 22
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
3984 243570 Private 9 Eriobotrya deflexa :: Bronze Loquat 8 837 Duncan St 2 Sidewalk: Curb side : Cutout Tree Private 2 Port   3 3x3 Permit Number 784594 6001117.2647 2099653.19311 37.7453106011164 -122.438837397829 (37.7453106011164, -122.438837397829) 2 4 5 63 22
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
5373 224056 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 4609 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/10/2020 12:00:00 AM 3 Width 3ft Permit Number 787677 6000381.16624 2105168.69891 37.7604129369301 -122.441778467817 (37.7604129369301, -122.441778467817) 2 4 5 28862 3
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
8807 224036 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 1511 Castro St 5 Sidewalk: Curb side : Cutout Tree Private 2   02/16/2016 07:10:00 AM 2 Width 3ft   6002606.66337 2101060.9954 37.7492607194187 -122.433787912303 (37.7492607194187, -122.433787912303) 2 4 5 28862 22
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
8863 224037 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 4136 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6002973.28417 2101264.18156 37.7498394178669 -122.432534643177 (37.7498394178669, -122.432534643177) 2 4 5 28862 22
8997 47687 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1045 Sanchez St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/22/2002 12:00:00 AM     Permit Number 45486 6003826.76338909 2102198.68251842 37.7524537008518 -122.429649915481 (37.7524537008518, -122.429649915481) 2 4 5 28862 22
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
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
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
14883 242086 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 4185 25th St 12 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   02/16/2016 05:57:00 AM 2 Width 3ft   6002948.22198 2101215.85126 37.7497052929799 -122.432617857444 (37.7497052929799, -122.432617857444) 2 4 5 28862 22
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
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
21456 34943 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 3968 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/25/2016 12:00:00 AM 3   Permit Number 775333 6003347.35755113 2102457.99102165 37.7531385434777 -122.43132628846 (37.7531385434777, -122.43132628846) 2 4 5 28862 22
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
22090 224049 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 260 Collingwood St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6002051.64145 2104349.66378 37.7582591055966 -122.435942470278 (37.7582591055966, -122.435942470278) 2 4 5 28862 3
22315 113814 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 4101x 25TH ST 7 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD 02/16/2016 06:05:00 AM 3 3x3   6002889 2101238 37.7497627495089 -122.43282423124 (37.7497627495089, -122.43282423124) 2 4 5 28862 22
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
25072 223529 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 4175 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6002046.64832 2102339.03335 37.7527381135931 -122.435815881724 (37.7527381135931, -122.435815881724) 2 4 5 28862 22
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
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
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
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
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
34878 224062 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 67 Landers St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6004498.44679 2107387.20492 37.7667381638479 -122.427696765417 (37.7667381638479, -122.427696765417) 8 4 5 28862 3
34948 63791 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 4079 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/09/1987 12:00:00 AM     Permit Number 24477 6003353.40286408 2101237.77442121 37.7497884585709 -122.43121829162 (37.7497884585709, -122.43121829162) 2 4 5 28862 22
35182 224055 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3810 20th St 1 Sidewalk: Curb side : Yard Tree Private 2     8 Width 3ft   6004350.69854 2104285.65184 37.7582136808258 -122.427986763479 (37.7582136808258, -122.427986763479) 2 4 5 28862 3
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
36383 223525 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 4126 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6002321.16912 2101815.04035 37.7513149436309 -122.434829071802 (37.7513149436309, -122.434829071802) 2 4 5 28862 22
36552 37407 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1710 Castro St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/15/1998 12:00:00 AM     Permit Number 39887 6002579.2352778 2100599.04049757 37.7479907436881 -122.433849744568 (37.7479907436881, -122.433849744568) 2 4 5 63 22
37767 35299 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 4128 24th St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/24/1998 12:00:00 AM     Permit Number 38772 6002342.17007059 2101820.0635556 37.7513299284774 -122.434756807393 (37.7513299284774, -122.434756807393) 2 4 5 28862 22
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
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
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
39751 96590 Property Tree 8 Eriobotrya deflexa :: Bronze Loquat 8 450 Church St   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF         6004088.8 2106523.6 37.7643437320395 -122.429052084094 (37.7643437320395, -122.429052084094) 8 4 5 28862 3
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
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
44908 96593 Property Tree 8 Eriobotrya deflexa :: Bronze Loquat 8 450 Church St   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF         6004088.8 2106523.6 37.7643437320395 -122.429052084094 (37.7643437320395, -122.429052084094) 8 4 5 28862 3
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
47083 224046 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 208 Caselli Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5999979.04483 2104876.63266 37.7595880742544 -122.443148238699 (37.7595880742544, -122.443148238699) 2 4 5 28862 3
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
48287 50062 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 259 Liberty St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/2003 12:00:00 AM     Permit Number 46792 6004623.22870051 2103939.22214247 37.7572778811094 -122.427019561527 (37.7572778811094, -122.427019561527) 2 4 5 28862 3
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
54683 223522 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 811 27th St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6001294.89764 2099975.47242 37.7462056082153 -122.438246257254 (37.7462056082153, -122.438246257254) 2 4 5 63 22
54927 223447 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1261 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   6003898.74209 2100909.80549 37.7489188214426 -122.429309101453 (37.7489188214426, -122.429309101453) 2 4 5 28862 22
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
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
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
57602 223527 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 647 Alvarado St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6002187.40945 2102635.29602 37.7535595750195 -122.435350295491 (37.7535595750195, -122.435350295491) 2 4 5 28862 22
58200 223663 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 838 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/30/1996 12:00:00 AM 8 Width 3ft Permit Number 37197 6001879.47646 2101560.46909 37.750590864394 -122.436338275392 (37.750590864394, -122.436338275392) 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)
);