trees

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

✎ View and edit SQL

This data as json, CSV (advanced)

Police Districts ✖

  • 7 467
  • 4 348
  • 3 340
  • 6 327
  • 8 312
  • 5 229
  • 9 190
  • 2 129
  • 1 59
  • - 15
  • 10 5
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)
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
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
4634 61780 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 2127 24th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/22/1985 12:00:00 AM 9   Permit Number 21802 6012087.28443 2102320.53166 37.7532525500908 -122.401092043975 (37.7532525500908, -122.401092043975) 10 3 8 28856 29
5985 247277 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 404 Ashbury St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/27/2015 12:00:00 AM 9 Width 0ft   5998904.2718 2109290.33 37.7716456345938 -122.447182976567 (37.7716456345938, -122.447182976567) 15 5 11 29492 9
10256 68236 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1515 Clement St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/27/1993 12:00:00 AM 9   Permit Number 32031 5990787.04658 2113362.94185 37.7823607651124 -122.475558077431 (37.7823607651124, -122.475558077431) 11 6 2 54 26
10285 64550 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1407 Lane St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/1988 12:00:00 AM 9   Permit Number 25433 6015557.9064 2094994.5115 37.7333298097375 -122.388578480063 (37.7333298097375, -122.388578480063) 10 3 8 58 1
16533 74989 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1660 Mason St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     6009226.90425 2118994.74178 37.798876023557 -122.412162212732 (37.798876023557, -122.412162212732) 3 1 10 308 4
17045 176247 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 10 Ordway St 5 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6011833.80931 2090345.75054 37.7203581824627 -122.401127251532 (37.7203581824627, -122.401127251532) 10 7 8 309 28
19771 31015 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1200 Naples St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/13/1995 12:00:00 AM 9   Permit Number 34784 6001104.8718 2087440.43661 37.7117764674692 -122.438005613962 (37.7117764674692, -122.438005613962) 9 7 6 28861 5
24453 120820 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 101 20th Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   5989571.70093 2114608.17958 37.7857093094708 -122.47985374027 (37.7857093094708, -122.47985374027) 11 6 2 55 26
27943 31680 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 55 Carl St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/1995 12:00:00 AM 9   Permit Number 35186 5998329.53554 2107192.57672 37.7658528820189 -122.44901987369 (37.7658528820189, -122.44901987369) 15 5 11 29492 9
28283 223478 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 147 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6006034.33786 2095867.87013 37.7351954754822 -122.42156615355 (37.7351954754822, -122.42156615355) 2 7 7 28859 2
31809 223570 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 404 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6007482.05364 2095699.08707 37.7348135594986 -122.416548907823 (37.7348135594986, -122.416548907823) 2 7 7 28859 2
33288 191666 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 535 Brannan St 13 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6013244.57038 2111045.61556 37.7772741883968 -122.397701819284 (37.7772741883968, -122.397701819284) 6 2 9 28856 34
33358 189266 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 550 Bay Shore Blvd 2 : Tree Private 2     9 Width 4ft   6010210.57589 2097161.88665 37.7389831663466 -122.407218500042 (37.7389831663466, -122.407218500042) 10 3 7 58 2
40532 223443 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 400 Day St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6003241.07095 2098648.16117 37.742671617906 -122.431421899403 (37.742671617906, -122.431421899403) 2 7 5 63 22
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
43141 207571 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1563 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   5993664.12129 2104858.25974 37.7591755300323 -122.464986884242 (37.7591755300323, -122.464986884242) 1 8 4 56 12
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
46350 223481 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 412 Anderson St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6007869.12634 2096919.97239 37.7381876044595 -122.415297058717 (37.7381876044595, -122.415297058717) 2 7 7 28859 2
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
53297 99646 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1795 34th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3 Permit Number 768958 5985627.2622 2103048.7649 37.7537404715173 -122.492648532329 (37.7537404715173, -122.492648532329) 1 8 3 56 35
57493 64965 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1695 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/03/1989 12:00:00 AM 9   Permit Number 26000 6004890.47461 2119142.08334 37.7990363142334 -122.42717819022 (37.7990363142334, -122.42717819022) 13 9 1 57 17
61714 223582 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 57 Bessie St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6008286.43047 2100056.77298 37.7468240108166 -122.414076076165 (37.7468240108166, -122.414076076165) 2 7 7 28859 2
63011 102695 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 384 Sussex St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6000881 2096712 37.7372213335044 -122.439443565515 (37.7372213335044, -122.439443565515) 2 7 5 63 7
63012 207610 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 51 Majestic Ave 1 : Tree Private 2     9 Width 3ft   5997347.38565 2089696.67863 37.7177571866363 -122.451155061159 (37.7177571866363, -122.451155061159) 9 8 6 28861 24
71780 72330 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 2761 McAllister St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/24/1996 12:00:00 AM 9     5995926.57923 2110675.1717 37.7752774586568 -122.457583143432 (37.7752774586568, -122.457583143432) 11 6 2 54 16
72717 246573 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 100 Laguna St 2 : Tree Private 2     9 Width 3ft   6005236.998 2109273.038 37.771957957636 -122.425276447877 (37.771957957636, -122.425276447877) 7 9 11 28852 10
73755 223547 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 577 Frederick St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5996845.23673 2107329.23539 37.7661431103528 -122.454163594697 (37.7661431103528, -122.454163594697) 15 5 11 29492 12
76374 126521 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 250 Alhambra St 4 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6000953.24503 2120036.11736 37.8012676554495 -122.440866459913 (37.8012676554495, -122.440866459913) 13 9 1 57 17
77306 31710 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 619 Frederick St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/1995 12:00:00 AM 9   Permit Number 35210 5996583.34698 2107294.12432 37.7660316834511 -122.45506687734 (37.7660316834511, -122.45506687734) 15 5 11 29492 12
77337 64966 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1690 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/03/1989 12:00:00 AM 9   Permit Number 26001 6004915.29698 2119193.66495 37.79917934781 -122.427095972412 (37.79917934781, -122.427095972412) 13 9 1 57 17
77685 68223 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1330 Clement St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/27/1993 12:00:00 AM 9   Permit Number 781803 5991325.89713 2113444.25067 37.7826152391743 -122.473699843984 (37.7826152391743, -122.473699843984) 11 6 2 54 26
79628 68421 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 2207 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/10/1993 12:00:00 AM 9   Permit Number 32265 6011906.60073 2102309.43328 37.7532119951541 -122.401716108723 (37.7532119951541, -122.401716108723) 10 3 8 28856 29
83029 33172 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 2311 Taraval St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/05/1996 12:00:00 AM 9   Permit Number 37388 5986066.5372792 2098877.4979138 37.7423129763845 -122.490822533573 (37.7423129763845, -122.490822533573) 1 8 3 29491 35
83955 126526 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3101 Octavia St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6004207.10509 2119826.7769 37.8008776374509 -122.429591735885 (37.8008776374509, -122.429591735885) 13 9 1 57 17
85915 223458 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 557 Belvedere St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   5998600.4522 2105970.1234 37.7625118232919 -122.44799481022 (37.7625118232919, -122.44799481022) 15 5 11 29492 9
87618 207651 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1243 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   5992350.99659 2106967.18215 37.7648902719794 -122.469681788681 (37.7648902719794, -122.469681788681) 11 8 11 56 12
88817 223483 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 562 Banks St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6008521.06241 2096162.71972 37.7361449725004 -122.412989453223 (37.7361449725004, -122.412989453223) 10 7 7 28859 2
95447 32498 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 676 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/15/1996 12:00:00 AM 9   Permit Number 37003 6007391.76195 2095838.15833 37.7351903403438 -122.416870928073 (37.7351903403438, -122.416870928073) 2 7 7 28859 2
102701 223409 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 898 Hampshire St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6010169.99414 2104057.76493 37.7579154611487 -122.407844947098 (37.7579154611487, -122.407844947098) 2 4 7 28859 19
105687 61989 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3245 Octavia St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/03/1985 12:00:00 AM 9   Permit Number 22056 6004135.50024 2120335.16174 37.802269475902 -122.429875802037 (37.802269475902, -122.429875802037) 13 9 1 57 17
106066 191079 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1559 Howard St 2 : Tree Private 2     9 Width 3ft   6007858.27887 2109378.13672 37.7723942745191 -122.416216661379 (37.7723942745191, -122.416216661379) 8 2 9 28853 19
108110 207678 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3137 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5990981.20237 2100859.62837 37.7480412755876 -122.473973874217 (37.7480412755876, -122.473973874217) 1 8 4 29491 40
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
109462 223623 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 457 Bartlett St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6006809.22741 2101132.82627 37.7496955290349 -122.419260433921 (37.7496955290349, -122.419260433921) 2 4 7 28859 19
111167 246473 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 300 Duncan St 4 : Tree Private 2     9 Width 3ft   6004475.07524 2099887.00412 37.7461430567683 -122.427243293056 (37.7461430567683, -122.427243293056) 2 7 5 63 22
111503 31688 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 816 Clayton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/1995 12:00:00 AM 9   Permit Number 35192 5998677.08875 2107434.65955 37.7665374513772 -122.447835194931 (37.7665374513772, -122.447835194931) 15 5 11 29492 9
116915 223408 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 898 Hampshire St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6010170.12734 2104071.29966 37.7579526319374 -122.407845440824 (37.7579526319374, -122.407845440824) 2 4 7 28859 19
122456 207547 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1329 07th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5993917.02159 2106451.10735 37.7635636541512 -122.464227879808 (37.7635636541512, -122.464227879808) 1 5 11 56 12
132916 207652 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1249 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   5992353.95742 2106910.47377 37.7647347369382 -122.469667419325 (37.7647347369382, -122.469667419325) 11 8 11 56 12
133604 217739 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 695 Frederick St 2 : Tree Private 2     9 Width 3ft   5996222.62463 2107246.57774 37.7658804318647 -122.456311097499 (37.7658804318647, -122.456311097499) 15 5 11 29492 12
134349 114648 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 2200 Post St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6001582.412 2113946.0192 37.7845816411392 -122.438252733323 (37.7845816411392, -122.438252733323) 15 6 11 29490 13
139588 246579 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 140 Laguna St 1 : Tree Private 2     9 Width 3ft   6005220.7586 2109411.73941 37.772337880726 -122.425342493187 (37.772337880726, -122.425342493187) 7 9 11 28852 10
140307 191091 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 150 Wisconsin St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6012554.29768 2106630.73656 37.7651134657424 -122.399779633617 (37.7651134657424, -122.399779633617) 14 3 8 28856 20
140396 66887 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1324 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/06/1991 12:00:00 AM 9   Permit Number 30200 6013938.0874 2104806.5934 37.7601818129701 -122.394865641745 (37.7601818129701, -122.394865641745) 10 3 8 28856 29
142445 32504 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 399 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/15/1996 12:00:00 AM 9   Permit Number 37008 6007356.06097 2095755.17697 37.7349604835245 -122.416988482053 (37.7349604835245, -122.416988482053) 2 7 7 28859 2
143703 176260 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 282 Athens St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6004334.87033 2091639.7615 37.723490058001 -122.427140768546 (37.723490058001, -122.427140768546) 9 7 6 28861 5
146042 246472 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 300 Duncan St 3 : Tree Private 2     9 Width 3ft   6004489.61116 2099886.70473 37.7461430567511 -122.42719300835 (37.7461430567511, -122.42719300835) 2 7 5 63 22
150359 223472 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 905 Ashbury St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   5999167.22172 2107046.81544 37.7655005312494 -122.446112018354 (37.7655005312494, -122.446112018354) 15 5 11 29492 9
154494 223495 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 825 Shotwell St 8 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6007975.84228 2103064.94118 37.7550663126612 -122.415362986219 (37.7550663126612, -122.415362986219) 2 4 7 28859 19
155694 31037 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 722 Prague St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/13/1995 12:00:00 AM 9   Permit Number 34796 6002553.27762 2087290.2882 37.7114464558494 -122.432988809779 (37.7114464558494, -122.432988809779) 9 7 6 28861 5
161598 63432 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 127 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/02/1987 12:00:00 AM 9   Permit Number 24018 6005906.17265772 2095879.01582361 37.7352188514571 -122.422010059455 (37.7352188514571, -122.422010059455) 2 7 7 28859 2
173282 223533 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 53 Newburg St 1 Front Yard : Yard Tree Private 2     9 Width 10ft   6002432.22452 2099844.06913 37.7459094263876 -122.434304133936 (37.7459094263876, -122.434304133936) 2 7 5 63 22
173635 126547 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 2007 Jones St 5 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6008156.84893 2119375.98217 37.7998627156539 -122.41589197733 (37.7998627156539, -122.41589197733) 5 1 1 308 32
176082 207574 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 447 Lawton St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   5992827.2239 2104547.60821 37.7582742708466 -122.467858656946 (37.7582742708466, -122.467858656946) 1 8 4 56 12
176821 223410 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 898 Hampshire St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/18/1993 12:00:00 AM 9 Width 4ft Permit Number 32344 6010171.02881 2104045.21453 37.7578810584907 -122.407840483778 (37.7578810584907, -122.407840483778) 2 4 7 28859 19
177087 207531 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1325 18th Ave 14 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   5990492.61494 2106135.12336 37.7624980762427 -122.476048615548 (37.7624980762427, -122.476048615548) 1 8 3 56 12
180300 223665 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3821 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6002927.69572 2103554.21162 37.7561247121999 -122.432855868402 (37.7561247121999, -122.432855868402) 2 4 5 28862 22
181745 49495 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 2X ORDWAY ST 2 Sidewalk: Curb side : Cutout Tree Private 2   04/21/2003 12:00:00 AM 9 3x3 Permit Number 46411 6011821 2090323 37.720294999502 -122.401169931587 (37.720294999502, -122.401169931587) 10 7 8 309 28
192545 126515 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3616 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5997525.9275 2115116.25328 37.7875632438067 -122.452371201775 (37.7875632438067, -122.452371201775) 11 6 1 54 31
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
7031 126517 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3835 Scott St 6 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 5ft   6000579.5194 2121468.07283 37.8051781307269 -122.44226256568 (37.8051781307269, -122.44226256568) 13 9 1 57 17
8681 223586 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 10x Tompkins Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6007519 2096543 37.7371328370553 -122.416480929712 (37.7371328370553, -122.416480929712) 2 7 7 28859 2
10369 223584 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 10x Tompkins Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6007576 2096576 37.7372266531625 -122.41628619091 (37.7372266531625, -122.41628619091) 2 7 7 28859 2
10927 74852 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1660 Mason St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6009221.87688 2119018.0672 37.7989397873109 -122.412181258567 (37.7989397873109, -122.412181258567) 3 1 10 308 4
15380 74967 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 998 Sansome St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8 3x3   6012084.12824 2119041.91729 37.7991654604723 -122.402278540244 (37.7991654604723, -122.402278540244) 3 1 10 28860 6
23051 223487 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 315 Park St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6006838.49776 2096321.93409 37.7364875458659 -122.418818066419 (37.7364875458659, -122.418818066419) 2 7 7 28859 2
23958 31714 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 122 Rivoli St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/1995 12:00:00 AM 8   Permit Number 35214 5998115.88312 2105983.06318 37.7625196419841 -122.449671682498 (37.7625196419841, -122.449671682498) 15 5 11 29492 9
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
25721 207622 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1226 02nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   5995492.16828 2107225.03182 37.7657793129775 -122.458836016967 (37.7657793129775, -122.458836016967) 15 5 11 56 12
26406 33945 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 2858 Gough St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/28/2002 12:00:00 AM 8   Permit Number 45901 6004794.02705 2119422.76429 37.7998015374823 -122.427531938546 (37.7998015374823, -122.427531938546) 13 9 1 57 17
26465 176246 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 10 Ordway St 4 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6011847.19322 2090350.44098 37.7203718080967 -122.401081316846 (37.7203718080967, -122.401081316846) 10 7 8 309 28
28703 223452 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 100 Rivoli St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   5998137.72031 2105984.6438 37.7625252312687 -122.449596269873 (37.7625252312687, -122.449596269873) 15 5 11 29492 9
29099 33334 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3360 Octavia St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/14/1996 12:00:00 AM 8 6x9 Permit Number 37474 6004131.26666 2120719.53303 37.8033246198945 -122.42991788582 (37.8033246198945, -122.42991788582) 13 9 1 28858 17
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
32252 224064 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 253 Corbett Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5999797.09097 2105500.9321 37.761291869548 -122.443822376823 (37.761291869548, -122.443822376823) 15 5 5 28862 3
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
37052 223427 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 357 Precita Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6008897.95249 2100223.67255 37.747316608191 -122.411973275956 (37.747316608191, -122.411973275956) 2 7 7 28859 2
38208 207601 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 129 Granada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   5995608.85604 2090759.60342 37.720576034226 -122.457241192545 (37.720576034226, -122.457241192545) 9 8 6 28861 24
43406 31661 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 4812 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/05/1995 12:00:00 AM 8   Permit Number 35169 5998134.62707 2105673.01843 37.7616694094477 -122.449584512135 (37.7616694094477, -122.449584512135) 15 5 11 29492 9
43410 176244 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 10 Ordway St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6011881.09111 2090360.91966 37.7204024713802 -122.400964878027 (37.7204024713802, -122.400964878027) 10 7 8 309 28
43469 64884 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 2550 23rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/27/1989 12:00:00 AM 8   Permit Number 25910 5989263.5772 2097984.1265 37.7400462586589 -122.479702916678 (37.7400462586589, -122.479702916678) 1 8 3 29491 35
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
51931 223568 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 500 Crescent Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6007653.2155 2095688.14958 37.7347931520797 -122.415956366103 (37.7347931520797, -122.415956366103) 2 7 7 28859 2
52671 43032 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 2111 26th St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/06/2000 12:00:00 AM 8   Permit Number 42893 6012270.45394 2101364.96859 37.7506389979096 -122.400391489185 (37.7506389979096, -122.400391489185) 10 3 8 28856 1
52716 114651 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 2200 Post St 5 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6001524.5433 2113938.4711 37.7845576244995 -122.438452398093 (37.7845576244995, -122.438452398093) 15 6 11 29490 13
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
53500 223412 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1726 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6009299.39544 2099281.89074 37.7447531977014 -122.410518617161 (37.7447531977014, -122.410518617161) 2 7 7 28859 2
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

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