trees

2,421 rows where qSpecies_id = 8 sorted by qSiteInfo descending

✎ View and edit SQL

This data as json, CSV (advanced)

Fire Prevention 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)
23656 191084 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1050 18th St 2 Sidewalk: Property side : Yard Tree Private 2     13     6014440.03961 2105781.9689 37.7628878793072 -122.393197865211 (37.7628878793072, -122.393197865211) 14 3 8 28856 29
25131 185158 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 2500 Sunset Blvd 7 Sidewalk: Property side : Yard Tree Private 2     8 Width 0ft   5985178.5125 2097636.1993 37.7388527871834 -122.493801554637 (37.7388527871834, -122.493801554637) 1 8 3 29491 35
33794 191086 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1050 18th St 4 Sidewalk: Property side : Yard Tree Private 2     13 Width 10ft   6014399.78897 2105779.8886 37.762879931094 -122.393336933676 (37.762879931094, -122.393336933676) 14 3 8 28856 29
46308 191085 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1050 18th St 3 Sidewalk: Property side : Yard Tree Private 2     12     6014420.63086 2105780.43179 37.762882580487 -122.393264886285 (37.762882580487, -122.393264886285) 14 3 8 28856 29
48749 103917 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1300X Fitzgerald Ave 4 Sidewalk: Property side : Yard Tree Private 2   06/19/2013 12:00:00 AM     Permit Number 770276 6014139.7 2090933.3 37.7220998454463 -122.393197569728 (37.7220998454463, -122.393197569728) 10 3 8 58 1
69865 207591 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 207 Flood Ave 2 Sidewalk: Property side : Yard Tree Private 2     7 Width 10ft   5999361.39835 2094045.00117 37.7298117829776 -122.444505884965 (37.7298117829776, -122.444505884965) 9 7 4 28861 40
76174 104074 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 841 32nd Ave 1 Sidewalk: Property side : Yard Tree Private 2   08/06/2013 12:00:00 AM 2   Permit Number 770392 5986000.25731 2110187.13166 37.7733622428275 -122.491884144737 (37.7733622428275, -122.491884144737) 11 6 2 55 26
76198 103919 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1300X Fitzgerald Ave 6 Sidewalk: Property side : Yard Tree Private 2   06/19/2013 12:00:00 AM     Permit Number 770276 6014139.7 2090933.3 37.7220998454463 -122.393197569728 (37.7220998454463, -122.393197569728) 10 3 8 58 1
124140 191087 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1050 18th St 5 Sidewalk: Property side : Yard Tree Private 2     8     6014377.05875 2105781.79588 37.762883905197 -122.393415683687 (37.762883905197, -122.393415683687) 14 3 8 28856 29
150648 181341 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 2500 Sunset Blvd 11 Sidewalk: Property side : Yard Tree Private 2     6 Width 0ft   5985179.8406 2097655.4564 37.7389057397188 -122.493798381455 (37.7389057397188, -122.493798381455) 1 8 3 29491 35
159416 103923 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1300X Fitzgerald Ave 10 Sidewalk: Property side : Yard Tree Private 2   06/19/2013 12:00:00 AM     Permit Number 770276 6014139.7 2090933.3 37.7220998454463 -122.393197569728 (37.7220998454463, -122.393197569728) 10 3 8 58 1
179325 103921 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1300X Fitzgerald Ave 8 Sidewalk: Property side : Yard Tree Private 2   06/19/2013 12:00:00 AM     Permit Number 770276 6014139.7 2090933.3 37.7220998454463 -122.393197569728 (37.7220998454463, -122.393197569728) 10 3 8 58 1
179767 224078 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 37 Mars St 1 Sidewalk: Property side : Yard Tree Private 2     21 Width 3ft   5999600.02239 2105581.97574 37.7615031526571 -122.444509776331 (37.7615031526571, -122.444509776331) 15 5 5 28862 3
186400 191083 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1050 18th St 1 Sidewalk: Property side : Yard Tree Private 2     13     6014452.20409 2105784.61715 37.7628958266015 -122.39315597749 (37.7628958266015, -122.39315597749) 14 3 8 28856 29
187500 103915 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1300X Fitzgerald Ave 2 Sidewalk: Property side : Yard Tree Private 2   06/19/2013 12:00:00 AM     Permit Number 770276 6014139.7 2090933.3 37.7220998454463 -122.393197569728 (37.7220998454463, -122.393197569728) 10 3 8 58 1
2999 94036 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1300X Lane St 4 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 10/14/2019 09:52:00 AM 3 5x5   6015673.325 2095216.0053 37.7339443827642 -122.388194894968 (37.7339443827642, -122.388194894968) 10 3 8 58 1
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
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
63210 96591 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
81530 96594 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
91912 107688 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 300X ALEMANY BLVD 2 Sidewalk: Property side : Cutout Tree Private 2     16     6008820.4 2095497.5 37.7343352217744 -122.411907523711 (37.7343352217744, -122.411907523711) 10 7 7 28859 2
145479 96592 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
156111 96589 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
162179 85184 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 501 Bartlett St   Sidewalk: Property side : Cutout Landscaping Private 2   12/13/2006 12:00:00 AM   3x25 Permit Number 768657 6006822 2100867 37.7489663498096 -122.419197411761 (37.7489663498096, -122.419197411761) 2 4 7 28859 19
1085 223588 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 890x Jarboe Ave 1 Sidewalk: Curb side : Yard Tree Private 2     2 Width 3ft   6009063.07444 2096876.26549 37.7381346254237 -122.411165877211 (37.7381346254237, -122.411165877211) 10 7 7 28859 2
9295 223587 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 890x Jarboe Ave 2 Sidewalk: Curb side : Yard Tree Private 2     2 Width 3ft   6009072.26343 2096875.24392 37.7381323357409 -122.411134034011 (37.7381323357409, -122.411134034011) 10 7 7 28859 2
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
20515 216642 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 50 Lee Ave 1 Sidewalk: Curb side : Yard Tree Private 2   10/04/2017 01:57:00 PM 3 Width 2ft   5996528.83108 2090217.47656 37.7191402755735 -122.45402201442 (37.7191402755735, -122.45402201442) 9 8 6 28861 24
25492 251734 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 898X Prague St 3 Sidewalk: Curb side : Yard Tree Private 2   10/05/2017 08:08:00 AM 3 Width 6ft   6002039.21061 2086908.72872 37.7103696049432 -122.434738288839 (37.7103696049432, -122.434738288839) 9 7 6 28861 5
32065 216902 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 174 Bright St 1 Sidewalk: Curb side : Yard Tree Private 2   10/11/2017 11:02:00 AM 3 Width 3ft   5993764.72474 2088364.55203 37.7138937098892 -122.463442003639 (37.7138937098892, -122.463442003639) 9 8 6 64 24
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
42001 223564 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 130 Nevada St 1 Sidewalk: Curb side : Yard Tree Private 2     9 Width 3ft   6009029.83515 2097858.62477 37.7408301058168 -122.411350181559 (37.7408301058168, -122.411350181559) 10 7 7 28859 2
46447 175836 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 101 Rhine St 3 Sidewalk: Curb side : Yard Tree Private 2     5 Width 3ft   5994366.58552 2086543.72285 37.7089288002067 -122.46122985489 (37.7089288002067, -122.46122985489) 9 8 6 28861 25
47759 246581 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 184 Laguna St 1 Sidewalk: Curb side : Yard Tree Private 2     5 Width 6ft   6005207.86965 2109476.17522 37.772514077681 -122.425391663601 (37.772514077681, -122.425391663601) 7 9 11 28852 10
50524 207695 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1222 Plymouth Ave 1 Sidewalk: Curb side : Yard Tree Private 2     4 Width 3ft   5995891.52818 2092172.3625 37.7244713658451 -122.456366191771 (37.7244713658451, -122.456366191771) 9 7 4 28861 40
51071 246580 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 182 Laguna St 1 Sidewalk: Curb side : Yard Tree Private 2     6 Width 6ft   6005210.93182 2109452.28431 37.7724486520281 -122.425379370776 (37.7724486520281, -122.425379370776) 7 9 11 28852 10
51936 123028 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 738 Funston Ave 2 Sidewalk: Curb side : Yard Tree Private 2     9 Width 3ft   5991970.4168 2110394.80661 37.7742796046287 -122.471247855577 (37.7742796046287, -122.471247855577) 11 6 2 54 11
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
67765 223367 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3450 26th St 2 Sidewalk: Curb side : Yard Tree Private 2     8 Width 6ft   6006755.66784 2100887.58392 37.7490191327351 -122.419428249231 (37.7490191327351, -122.419428249231) 2 4 7 28859 19
72623 223539 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1661 Noe St 2 Sidewalk: Curb side : Yard Tree Private 2     8 Width 4ft   6003387.19904 2098534.72149 37.7423684195723 -122.430908536723 (37.7423684195723, -122.430908536723) 2 7 5 63 22
78086 207586 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1917 08th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     1 Width 6ft   5993746.75792 2102455.06491 37.7525817412531 -122.464526593251 (37.7525817412531, -122.464526593251) 1 8 4 29491 12
78250 176236 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 19 Brunswick St 3 Sidewalk: Curb side : Yard Tree Private 2     6 Width 5ft   6001058.00654 2087498.50838 37.711933254377 -122.438171750223 (37.711933254377, -122.438171750223) 9 7 6 28861 5
78457 176269 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 273 Curtis St 3 Sidewalk: Curb side : Yard Tree Private 2     2 Width 6ft   6000993.66237 2087160.73145 37.7110021341048 -122.438369957219 (37.7110021341048, -122.438369957219) 9 7 6 28861 5
91032 223537 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1300 Noe St 2 Sidewalk: Curb side : Yard Tree Private 2     15 Width 5ft   6003218.0959 2100594.3408 37.7480140720016 -122.431640256605 (37.7480140720016, -122.431640256605) 2 4 5 63 22
103871 223538 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1661 Noe St 1 Sidewalk: Curb side : Yard Tree Private 2     12 Width 4ft   6003388.52326 2098515.37807 37.74231538204 -122.430902577793 (37.74231538204, -122.430902577793) 2 7 5 63 22
104269 223565 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 134 Nevada St 1 Sidewalk: Curb side : Yard Tree Private 2     10 Width 3ft   6009029.93492 2097846.57394 37.7407970224666 -122.411348985471 (37.7407970224666, -122.411348985471) 10 7 7 28859 2
109185 176268 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 273 Curtis St 2 Sidewalk: Curb side : Yard Tree Private 2     2 Width 6ft   6000987.65781 2087139.8501 37.7109444570035 -122.43838921531 (37.7109444570035, -122.43838921531) 9 7 6 28861 5
111369 182485 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1563 35th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     6 Width 0ft   5985266.5327 2104584.1284 37.7579350567147 -122.494009145875 (37.7579350567147, -122.494009145875) 1 8 3 56 35
116146 246582 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 198 Laguna St 1 Sidewalk: Curb side : Yard Tree Private 2     14 Width 6ft   6005203.89906 2109501.9724 37.7725846861634 -122.425407234452 (37.7725846861634, -122.425407234452) 7 9 11 28852 10
123773 216862 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 272 Sadowa St 1 Sidewalk: Curb side : Yard Tree Private 2   10/10/2017 08:43:00 AM 3 Width 3ft   5994260.82584 2087785.69998 37.7123328897311 -122.461685361516 (37.7123328897311, -122.461685361516) 9 8 6 28861 24
124905 246577 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 126 Laguna St 1 Sidewalk: Curb side : Yard Tree Private 2     13 Width 6ft   6005225.24464 2109364.93457 37.7722096193969 -122.425323644264 (37.7722096193969, -122.425323644264) 7 9 11 28852 10
127368 176267 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 273 Curtis St 1 Sidewalk: Curb side : Yard Tree Private 2     1 Width 6ft   6000986.70381 2087103.40671 37.7108443372623 -122.438389903289 (37.7108443372623, -122.438389903289) 9 7 6 28861 5
128027 246163 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 642 Shrader St 1 Sidewalk: Curb side : Yard Tree Private 2     2 Width 0ft   5997583.9235 2108279.5679 37.7687948112177 -122.451677193811 (37.7687948112177, -122.451677193811) 15 5 11 29492 9
132262 124029 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 101 Funston Ave 4 Sidewalk: Curb side : Yard Tree Private 2     14 Width 3ft   5991795.62331 2114277.55052 37.7849304438848 -122.472135568047 (37.7849304438848, -122.472135568047) 11 6 2 54 11
136200 223540 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1661 Noe St 3 Sidewalk: Curb side : Yard Tree Private 2     12 Width 4ft   6003385.20059 2098555.09449 37.7424242458904 -122.430916900407 (37.7424242458904, -122.430916900407) 2 7 5 63 22
136243 246160 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 654 Shrader St 1 Sidewalk: Curb side : Yard Tree Private 2     2 Width 0ft   5997594.3711 2108214.0054 37.7686153917025 -122.451636326624 (37.7686153917025, -122.451636326624) 15 5 11 29492 9
141049 180766 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1206 Naples St 1 Sidewalk: Curb side : Yard Tree Private 2   10/10/2017 09:29:00 AM 3 Width 8ft   6001093.57723 2087421.33847 37.7117233858917 -122.438043283865 (37.7117233858917, -122.438043283865) 9 7 6 28861 5
142733 218237 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 345 Wawona St 1 Sidewalk: Curb side : Yard Tree Private 2     5 Width 2ft   5992002.51219 2097168.37657 37.7379651463641 -122.470173504717 (37.7379651463641, -122.470173504717) 1 8 4 59 40
153436 223368 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3450 26th St 6 Sidewalk: Curb side : Yard Tree Private 2     10 Width 6ft   6006716.93708 2100883.67936 37.7490062301666 -122.419561903754 (37.7490062301666, -122.419561903754) 2 4 7 28859 19
158433 124028 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 101 Funston Ave 5 Sidewalk: Curb side : Yard Tree Private 2     13 Width 3ft   5991796.1991 2114253.0901 37.7848633156564 -122.472131792452 (37.7848633156564, -122.472131792452) 11 6 2 54 11
172015 223566 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 144 Nevada St 1 Sidewalk: Curb side : Yard Tree Private 2     11 Width 3ft   6009026.08799 2097793.63743 37.7406514546128 -122.411358547973 (37.7406514546128, -122.411358547973) 10 7 7 28859 2
176065 176235 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 19 Brunswick St 2 Sidewalk: Curb side : Yard Tree Private 2     6 Width 5ft   6001042.78255 2087493.58621 37.7119188733302 -122.438224016125 (37.7119188733302, -122.438224016125) 9 7 6 28861 5
178180 246578 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 126 Laguna St 2 Sidewalk: Curb side : Yard Tree Private 2     13 Width 6ft   6005224.61763 2109380.51832 37.7722523731835 -122.425326922304 (37.7722523731835, -122.425326922304) 7 9 11 28852 10
179288 180663 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 355 Chicago Way 1 Sidewalk: Curb side : Yard Tree Private 2   10/10/2017 01:48:00 PM 3 Width 6ft   6002383.84355 2086445.14687 37.7091162701556 -122.433514058849 (37.7091162701556, -122.433514058849) 9 7 6 28861 5
181103 83378 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 586 Athens St 1 Sidewalk: Curb side : Yard Tree Private 2   07/01/2009 12:00:00 AM 3 3x3 Permit Number 52310 6003277.11077 2089949.83191 37.7187900121188 -122.430676716663 (37.7187900121188, -122.430676716663) 9 7 6 28861 5
188987 216737 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 11 Lee Ave 1 Sidewalk: Curb side : Yard Tree Private 2   10/04/2017 02:31:00 PM 3 Width 2ft   5996481.70655 2089974.50939 37.7184704425356 -122.454167365558 (37.7184704425356, -122.454167365558) 9 8 6 28861 24
9989 176265 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 928 Excelsior Ave 1 Sidewalk: Curb side : Pot Tree Private 2     5 Width 5ft   6004683.74002 2091261.8142 37.7224720200432 -122.425907897826 (37.7224720200432, -122.425907897826) 9 7 6 28861 5
102958 176266 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 928 Excelsior Ave 2 Sidewalk: Curb side : Pot Tree Private 2     5 Width 5ft   6004692.43448 2091256.7125 37.7224585032472 -122.425877480072 (37.7224585032472, -122.425877480072) 9 7 6 28861 5
108687 224097 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1414 Castro St 1 Sidewalk: Curb side : Pot Tree Private 2     9 Width 3ft   6002522.98232 2101416.25277 37.7502314233618 -122.434102675005 (37.7502314233618, -122.434102675005) 2 4 5 28862 22
137831 246486 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 346 Duncan St 1 Sidewalk: Curb side : Pot Tree Private 2     7 Width 3ft   6004013.8028 2099862.02066 37.7460483608489 -122.4288365338 (37.7460483608489, -122.4288365338) 2 7 5 63 22
147442 182142 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1418 25th Ave 2 Sidewalk: Curb side : Pot Tree Private 2     6 Width 0ft   5988379.3786 2105646.146 37.7610327154794 -122.483321592218 (37.7610327154794, -122.483321592218) 1 8 3 56 35
10 264794 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 31 Dwight St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/01/2020 12:00:00 AM 3 3x3   6011433 2091603 37.7237879639177 -122.40260109208 (37.7237879639177, -122.40260109208) 10 3 7 309 28
32 264850 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 172 University St 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/01/2020 12:00:00 AM 3     6007951 2093149 37.7278379340298 -122.414747181337 (37.7278379340298, -122.414747181337) 9 3 7 309 5
495 69056 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1235 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/10/1994 12:00:00 AM     Permit Number 33064 5992348.34951393 2107046.09564514 37.7651067945026 -122.469696689595 (37.7651067945026, -122.469696689595) 11 8 11 56 12
814 261435 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 371 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF         6007244 2095778 37.7350168462428 -122.417377534221 (37.7350168462428, -122.417377534221) 2 7 7 28859 2
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
908 207538 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 725 Irving St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   5993510.99578 2106611.92865 37.7639818164203 -122.465643867796 (37.7639818164203, -122.465643867796) 1 8 11 56 12
1004 50532 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 315 Parnassus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/06/2003 12:00:00 AM     Permit Number 47171 5996679.82856356 2106618.62344586 37.7641824656847 -122.454684361894 (37.7641824656847, -122.454684361894) 15 5 11 29492 12
1037 63388 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 139 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/10/1987 12:00:00 AM     Permit Number 23969 6005989.66886949 2095872.0431692 37.7352044148911 -122.421720887046 (37.7352044148911, -122.421720887046) 2 7 7 28859 2
1123 72265 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 358 Paris St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     6002353.80444 2091524.36294 37.7230609707806 -122.433980702666 (37.7230609707806, -122.433980702666) 9 7 6 28861 5
1140 223581 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 85 Bessie St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6008353.87265 2100058.32291 37.7468320543491 -122.413842976384 (37.7468320543491, -122.413842976384) 2 7 7 28859 2
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
1156 31893 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 333 12th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/1995 12:00:00 AM 8   Permit Number 35323 6008432.94494 2108718.71395 37.7706159506067 -122.414182168285 (37.7706159506067, -122.414182168285) 8 2 9 28853 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
1238 144982 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 676 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/18/2019 12:00:00 AM 3 Width 3ft   5990689.31249 2110785.3324 37.7752776943529 -122.4757079065 (37.7752776943529, -122.4757079065) 11 6 2 54 26
1268 261097 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1999 Carroll Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/19/2019 12:00:00 AM 3 4x6   6012390 2093339 37.7286080475288 -122.399414697344 (37.7286080475288, -122.399414697344) 10 3 8 58 1
1304 91006 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 2401X Balboa St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/17/2018 12:00:00 AM 3 3x3   5988072.26413 2111179.36369 37.7762075240837 -122.484789675521 (37.7762075240837, -122.484789675521) 11 6 2 55 26
1308 52427 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1815X Octavia St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/22/2005 12:00:00 AM 5 3x3 Permit Number 48544 6004786.32091155 2115731.58720361 37.7896660673411 -122.427295522794 (37.7896660673411, -122.427295522794) 13 9 11 28858 27
1327 261443 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 354 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007142 2095710 37.7348243937619 -122.417725367022 (37.7348243937619, -122.417725367022) 2 7 7 28859 2
1419 148015 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 703 Italy Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6002502.98722 2088786.72578 37.7155524923237 -122.433269485517 (37.7155524923237, -122.433269485517) 9 7 6 28861 5
1423 223556 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 701x Andover St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6007456 2095683 37.7347679226533 -122.416637845271 (37.7347679226533, -122.416637845271) 2 7 7 28859 2
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
1511 260421 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200x Bacon St 5 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 08/17/2019 12:00:00 AM 3                        
1530 191101 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 2041 26th St 5 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6012369.93883 2101402.46492 37.7507475020033 -122.400050093052 (37.7507475020033, -122.400050093052) 10 3 8 28856 1
1541 70231 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 535 Hayes St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     6005265.5585 2110935.6138 37.7765246008409 -122.425295984643 (37.7765246008409, -122.425295984643) 7 9 11 28852 10
1628 72055 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 2161 Jones St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   11     6008082.6141 2119894.27994 37.8012816578905 -122.416185586193 (37.8012816578905, -122.416185586193) 5 1 1 308 32
1653 159947 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 157 Bertita St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/27/2019 12:00:00 AM 3 Width 0ft   6000525.42449 2090002.91659 37.7187794927682 -122.440191978283 (37.7187794927682, -122.440191978283) 9 7 6 28861 25
1793 260413 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1510 Jerrold Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6015825 2096697 37.7380192974637 -122.387773802776 (37.7380192974637, -122.387773802776) 10 3 8 58 1
1997 61779 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 2227 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/22/1985 12:00:00 AM 9   Permit Number 21800 6011831.44367 2102306.03776 37.7531984774519 -122.401975779864 (37.7531984774519, -122.401975779864) 10 3 8 28856 29
2148 154032 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1662 Kirkwood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6014879.40227 2097032.81009 37.7388889362706 -122.391066694069 (37.7388889362706, -122.391066694069) 10 3 8 58 1

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