trees

2,421 rows where qSpecies_id = 8 sorted by Zip Codes 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)
5781 207615 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 134 Ralston St 1 : Tree Private 2     4 Width 3ft   5992209.13787 2088815.67824 37.7150426450832 -122.46885145275 (37.7150426450832, -122.46885145275) 9 8 6 64 24
8593 91087 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 134 Ralston St   Sidewalk: Curb side : Cutout Tree Private 2   12/31/2008 12:00:00 AM   3x3 Permit Number 51982 5992207 2088764 37.7149006256244 -122.46885508368 (37.7149006256244, -122.46885508368) 9 8 6 64 24
21319 91088 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 132 Ralston St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/31/2008 12:00:00 AM   3x3 Permit Number 51983 5992207 2088751 37.7148649307688 -122.468854138233 (37.7148649307688, -122.468854138233) 9 8 6 64 24
25810 48572 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 301 Shields St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/23/2002 12:00:00 AM     Permit Number 45886 5993237.92929814 2089815.21510238 37.7178465167843 -122.465368104118 (37.7178465167843, -122.465368104118) 9 8 6 64 24
26966 207618 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 720 Head St 1 : Tree Private 2     7 Width 3ft   5993529.31712 2090633.69129 37.720110655762 -122.464420306879 (37.720110655762, -122.464420306879) 9 8 6 64 24
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
32297 48573 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 301 Shields St 3 Sidewalk: Curb side : Cutout Tree Private 2   08/23/2002 12:00:00 AM     Permit Number 45886 5993237.92929814 2089815.21510238 37.7178465167843 -122.465368104118 (37.7178465167843, -122.465368104118) 9 8 6 64 24
36741 207621 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 259 Bright St 1 : Tree Private 2     1 Width 3ft   5993736.2843 2088924.46634 37.7154294623887 -122.463580914754 (37.7154294623887, -122.463580914754) 9 8 6 64 24
37755 39665 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 720 Head St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1998 12:00:00 AM     Permit Number 41055 5993542.26347395 2090641.85281267 37.7201338116039 -122.464376148313 (37.7201338116039, -122.464376148313) 9 8 6 64 24
48084 39666 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 724 Head St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1998 12:00:00 AM     Permit Number 41056 5993542.5872035 2090669.62247691 37.7202100790578 -122.464377044443 (37.7202100790578, -122.464377044443) 9 8 6 64 24
73572 207616 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 385 Victoria St 1 : Tree Private 2     6 Width 3ft   5993229.18719 2089803.61986 37.7178141748665 -122.46539747963 (37.7178141748665, -122.46539747963) 9 8 6 64 24
92656 207620 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 724 Head St 3 : Tree Private 2     5 Width 3ft   5993530.06082 2090669.11588 37.7202079660024 -122.464420306871 (37.7202079660024, -122.464420306871) 9 8 6 64 24
99353 48571 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 301 Shields St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/23/2002 12:00:00 AM     Permit Number 45886 5993237.92929814 2089815.21510238 37.7178465167843 -122.465368104118 (37.7178465167843, -122.465368104118) 9 8 6 64 24
107804 112688 Section 143 10 Eriobotrya deflexa :: Bronze Loquat 8 259 BRIGHT ST 1 Sidewalk: Curb side : Cutout Tree Private 2   08/18/2015 12:00:00 AM 3 5x4   5993720 2088919 37.71541351482 -122.4636368036 (37.71541351482, -122.4636368036) 9 8 6 64 24
142224 207619 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 724 Head St 2 : Tree Private 2     7 Width 3ft   5993530.3141 2090655.88648 37.7201716558646 -122.464418471342 (37.7201716558646, -122.464418471342) 9 8 6 64 24
176884 39667 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 724 Head St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1998 12:00:00 AM     Permit Number 41056 5993542.5872035 2090669.62247691 37.7202100790578 -122.464377044443 (37.7202100790578, -122.464377044443) 9 8 6 64 24
178147 207617 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 385 Victoria St 2 : Tree Private 2     6 Width 3ft   5993228.76427 2089783.48491 37.7177588647558 -122.46539747963 (37.7177588647558, -122.46539747963) 9 8 6 64 24
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
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
4370 38420 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1542 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/21/2000 12:00:00 AM     Permit Number 42357 6004548.16357043 2099910.23270392 37.7462109701995 -122.426992216906 (37.7462109701995, -122.426992216906) 2 7 5 63 22
15086 207588 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1 Chilton Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6001743.96601 2095815.79538 37.7348096375426 -122.436395778947 (37.7348096375426, -122.436395778947) 2 7 5 63 7
15246 242850 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 483 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6003468.14105 2098906.5693 37.7433940136201 -122.430655192302 (37.7433940136201, -122.430655192302) 2 7 5 63 22
16056 243760 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 2432 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 1x3   6001985.30347 2097161.30264 37.7385177995686 -122.435657623519 (37.7385177995686, -122.435657623519) 2 7 5 63 7
20325 223546 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 384 Sussex St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6000939.02096 2096709.07098 37.7372165929608 -122.439242751069 (37.7372165929608, -122.439242751069) 2 7 5 63 7
20990 4475 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1521 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/01/1992 12:00:00 AM 6 3X3   6004596.9832 2100011.91057 37.7464929146108 -122.426830644527 (37.7464929146108, -122.426830644527) 2 7 5 63 22
28306 223532 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 529 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6002464.30667 2099434.4104 37.7447864204556 -122.434163917953 (37.7447864204556, -122.434163917953) 2 7 5 63 22
29985 59550 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 374 Day St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/05/1987 12:00:00 AM     Permit Number 24919 6003521.85163486 2098666.09972032 37.7427367824396 -122.43045232079 (37.7427367824396, -122.43045232079) 2 7 5 63 22
31788 64128 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 627 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/05/1987 12:00:00 AM     Permit Number 24899 6002528.44281747 2098851.45130448 37.7431893908467 -122.433900486749 (37.7431893908467, -122.433900486749) 2 7 5 63 7
32770 60516 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 273 Duncan St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/08/1982 12:00:00 AM     Permit Number 20119 6004763.14449697 2099853.52664846 37.7460674222913 -122.42624480255 (37.7460674222913, -122.42624480255) 2 7 5 63 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
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
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
55466 52669 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 346@ SANCHEZ Duncan St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/29/2006 12:00:00 AM     Permit Number 48750 6004271.44295602 2099877.18374076 37.7461045741604 -122.427946728117 (37.7461045741604, -122.427946728117) 2 7 5 63 22
59875 223439 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 391 Day St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   6003417.4163 2098613.92622 37.7425876095457 -122.430809705719 (37.7425876095457, -122.430809705719) 2 7 5 63 22
60323 64125 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 623 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/05/1987 12:00:00 AM     Permit Number 24896 6002552.88374737 2098852.79748639 37.7431944740998 -122.433816072766 (37.7431944740998, -122.433816072766) 2 7 5 63 7
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
63475 246471 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 300 Duncan St 2 : Tree Private 2     6 Width 3ft   6004508.79253 2099888.97742 37.7461503817506 -122.427126843434 (37.7461503817506, -122.427126843434) 2 7 5 63 22
64284 223521 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 793 27th St 6 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   6001408.82629 2099966.50087 37.7461874535894 -122.437851664431 (37.7461874535894, -122.437851664431) 2 7 5 63 22
65784 224099 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 33 Harper St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 5ft   6003688.86609 2098162.22587 37.7413627203269 -122.429838900151 (37.7413627203269, -122.429838900151) 2 7 5 63 7
68615 246490 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 399 Duncan St 4 : Tree Private 2     11 Width 3ft   6004063.56102 2099816.02709 37.7459248893202 -122.428661198349 (37.7459248893202, -122.428661198349) 2 7 5 63 22
70702 64142 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 387 Day St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/05/1987 12:00:00 AM     Permit Number 24915 6003450.8356786 2098610.10956553 37.7425790233006 -122.430693879032 (37.7425790233006, -122.430693879032) 2 7 5 63 22
72272 45790 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 399 Duncan St 3 Sidewalk: Curb side : Cutout Tree Private 2   11/19/2001 12:00:00 AM     Permit Number 44428 6003953.11185898 2099806.69128577 37.7458930039208 -122.429042450873 (37.7458930039208, -122.429042450873) 2 7 5 63 22
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
72718 64414 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 33 Harper St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/03/1988 12:00:00 AM     Permit Number 25261 6003697.20020727 2098175.28884646 37.741399060208 -122.429811015213 (37.741399060208, -122.429811015213) 2 7 5 63 7
73815 117002 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 161 Joost Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/13/2016 12:00:00 AM 3 3x3 Permit Number 778235 6001002.4 2094897.4 37.7322457718664 -122.438893830128 (37.7322457718664, -122.438893830128) 9 7 4 63 40
74307 64143 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 461 Day St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/05/1987 12:00:00 AM     Permit Number 24917 6002822.78297859 2098575.51836339 37.7424484420328 -122.432863028806 (37.7424484420328, -122.432863028806) 2 7 5 63 22
76450 64808 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 53 Newburg St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/05/1989 12:00:00 AM     Permit Number 25810 6002470.46019505 2099868.65232966 37.745979096274 -122.434173677497 (37.745979096274, -122.434173677497) 2 7 5 63 22
77707 64130 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 650 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/05/1987 12:00:00 AM 24   Permit Number 24901 6002310.61439363 2098891.53580323 37.7432870897096 -122.434656544552 (37.7432870897096, -122.434656544552) 2 7 5 63 22
79547 223531 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 650 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 3ft   6002360.62699 2098888.4177 37.7432813672398 -122.434483391309 (37.7432813672398, -122.434483391309) 2 7 5 63 22
79670 64117 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 606 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/05/1987 12:00:00 AM     Permit Number 24888 6002640.14988451 2098909.68283406 37.7433556196147 -122.433518394217 (37.7433556196147, -122.433518394217) 2 7 5 63 22
84859 246470 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 300 Duncan St 1 : Tree Private 2     5 Width 3ft   6004524.4919 2099889.41625 37.7461524744566 -122.42707258823 (37.7461524744566, -122.42707258823) 2 7 5 63 22
87007 246500 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 273 Duncan St 1 : Tree Private 2     10 Width 5ft   6004745.35521 2099854.76299 37.746069811469 -122.426306403626 (37.746069811469, -122.426306403626) 2 7 5 63 22
90393 38422 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1542 Church St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/21/2000 12:00:00 AM     Permit Number 42357 6004548.16357043 2099910.23270392 37.7462109701995 -122.426992216906 (37.7462109701995, -122.426992216906) 2 7 5 63 22
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
95635 223440 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 374 Day St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 2ft   6003528.78647 2098662.81871 37.7427281663791 -122.43042810807 (37.7427281663791, -122.43042810807) 2 7 5 63 22
99926 27292 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 56 Chilton Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6001688.66279 2095714.91034 37.7345294879464 -122.436579762262 (37.7345294879464, -122.436579762262) 2 7 5 63 7
100118 219821 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 544 Laidley St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/01/2018 12:00:00 AM 3 Width 3ft Permit Number 781970 6003112.54338 2096066.43499 37.7355755064901 -122.43168202563 (37.7355755064901, -122.43168202563) 2 7 5 63 7
100320 48882 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 585 Laidley St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/21/2002 12:00:00 AM   3x3 Permit Number 46088 6002980.45045304 2095906.61168613 37.7351291798742 -122.432127311126 (37.7351291798742, -122.432127311126) 2 7 5 63 7
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
105828 207702 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 182 Stillings Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5999557.67926 2095791.1114 37.7346173903777 -122.44395272994 (37.7346173903777, -122.44395272994) 9 7 4 63 40
106081 223544 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 585 Laidley St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6002953.97122 2095898.0136 37.7351040701821 -122.432218245472 (37.7351040701821, -122.432218245472) 2 7 5 63 7
106655 223545 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 219 Miguel St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6004195.70944 2096761.73033 37.7375459678815 -122.427986637589 (37.7375459678815, -122.427986637589) 2 7 5 63 7
108805 5086 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 2575 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/26/2011 12:00:00 AM 3 3x3   6002278.04095 2096864.42797 37.737719273515 -122.4346242575 (37.737719273515, -122.4346242575) 2 7 5 63 7
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
111409 223442 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 400 Day St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6003266.99586 2098649.35837 37.742676374416 -122.431332344034 (37.742676374416, -122.431332344034) 2 7 5 63 22
112459 223530 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 606 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6002608.27814 2098903.45091 37.7433366998417 -122.433628153123 (37.7433366998417, -122.433628153123) 2 7 5 63 22
114458 88149 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 980 Corbett Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/07/2008 12:00:00 AM   3x3 Permit Number 51177 5999654.9 2101769.7 37.7510387106784 -122.444046045087 (37.7510387106784, -122.444046045087) 2 5 5 63 38
116040 207587 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 60 Chilton Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6001679.03512 2095671.87202 37.7344107675387 -122.43660996867 (37.7344107675387, -122.43660996867) 2 7 5 63 7
116503 223441 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 400 Day St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6003293.90646 2098651.49754 37.742683773149 -122.431239447646 (37.742683773149, -122.431239447646) 2 7 5 63 22
116907 67855 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 340 Duncan St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/04/1993 12:00:00 AM     Permit Number 31525 6004308.51979611 2099879.32748922 37.7461125578998 -122.427818673872 (37.7461125578998, -122.427818673872) 2 7 5 63 22
117533 95391 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 529 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/24/2011 12:00:00 AM   3x3 Permit Number 767260 6002482 2099437 37.7447945350785 -122.434102922936 (37.7447945350785, -122.434102922936) 2 7 5 63 22
125149 223518 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 988 Corbett Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5999648.8119 2101706.51559 37.7508648743372 -122.444062558736 (37.7508648743372, -122.444062558736) 2 5 5 63 38
125704 223438 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 270 Valley St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6004159.88516 2099284.24689 37.7444701945428 -122.428290228918 (37.7444701945428, -122.428290228918) 2 7 5 63 22
126421 64123 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 319 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/05/1987 12:00:00 AM     Permit Number 24894 6003820.50853257 2099508.65029248 37.7450671453675 -122.429479723764 (37.7450671453675, -122.429479723764) 2 7 5 63 22
128906 37406 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1710 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/22/2002 12:00:00 AM     Permit Number 45479 6002579.2352778 2100599.04049757 37.7479907436881 -122.433849744568 (37.7479907436881, -122.433849744568) 2 4 5 63 22
131925 169674 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 67 Sussex St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/19/2018 12:00:00 AM 3 3x3 Permit Number 781222 6002394.02072 2096615.67364 37.7370428349616 -122.43420548191 (37.7370428349616, -122.43420548191) 2 7 5 63 7
135101 83726 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 219 Miguel St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/30/2008 12:00:00 AM   3x3 Permit Number 50486 6004171.06042013 2096811.82293441 37.7376821162511 -122.428075429636 (37.7376821162511, -122.428075429636) 2 7 5 63 7
135641 223436 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 222 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6005015.06842 2099039.9459 37.7438477521768 -122.425315796791 (37.7438477521768, -122.425315796791) 2 7 5 63 22
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
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
138468 12972 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 84 Lippard Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6001913.39953 2095585.02929 37.7341856330519 -122.435793484091 (37.7341856330519, -122.435793484091) 2 7 5 63 7
138873 223444 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 319 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6003651.97677 2099506.05827 37.7450504848013 -122.430062291736 (37.7450504848013, -122.430062291736) 2 7 5 63 22
141294 51961 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 2680 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/09/2005 12:00:00 AM     Permit Number 48182 6002292.28789306 2096370.56832846 37.7363640576921 -122.434539697316 (37.7363640576921, -122.434539697316) 2 7 5 63 7
143019 64122 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 330 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/05/1987 12:00:00 AM     Permit Number 24893 6003743.68198418 2099556.50648257 37.7451941972726 -122.429748789002 (37.7451941972726, -122.429748789002) 2 7 5 63 22
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
148006 60514 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1551 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/08/1982 12:00:00 AM     Permit Number 20115 6004602.91474331 2099861.26634292 37.7460796156332 -122.426799407471 (37.7460796156332, -122.426799407471) 2 7 5 63 22
150769 56599 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 548 Laidley St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/30/2008 12:00:00 AM   3x3 Permit Number 50484 6003117.57249137 2096080.2960431 37.7356138508419 -122.43166562739 (37.7356138508419, -122.43166562739) 2 7 5 63 7
155063 66518 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 811 27th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/22/1991 12:00:00 AM     Permit Number 29686 6001320.92036786 2099966.32859782 37.7461819814772 -122.438155619166 (37.7461819814772, -122.438155619166) 2 4 5 63 22
155940 223446 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 422 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6003080.60278 2099509.24195 37.7450268497235 -122.432038227307 (37.7450268497235, -122.432038227307) 2 7 5 63 22
156822 4390 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 56 Chilton Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6001657.8215553 2095631.9001159 37.7342998083721 -122.436680450501 (37.7342998083721, -122.436680450501) 2 7 5 63 7
157791 223517 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 980 Corbett Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   5999663.10864 2101754.10727 37.7509963650963 -122.44401653863 (37.7509963650963, -122.44401653863) 2 5 5 63 38
159901 38421 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1542 Church St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/21/2000 12:00:00 AM     Permit Number 42357 6004548.16357043 2099910.23270392 37.7462109701995 -122.426992216906 (37.7462109701995, -122.426992216906) 2 7 5 63 22
160973 45791 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 399 Duncan St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/19/2001 12:00:00 AM     Permit Number 44428 6003953.11185898 2099806.69128577 37.7458930039208 -122.429042450873 (37.7458930039208, -122.429042450873) 2 7 5 63 22
163515 223437 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 512 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6003198.53842 2098939.40251 37.7434688884883 -122.431589752474 (37.7434688884883, -122.431589752474) 2 7 5 63 22
168221 64250 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 665 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/18/1988 12:00:00 AM     Permit Number 25048 6002286.59850584 2098838.14561874 37.7431391293174 -122.434735768073 (37.7431391293174, -122.434735768073) 2 7 5 63 7
168842 223445 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 318 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 5ft   6003784.31175 2099553.81383 37.7451891045094 -122.429608106246 (37.7451891045094, -122.429608106246) 2 7 5 63 22
170398 246489 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 399 Duncan St 3 : Tree Private 2     10 Width 3ft   6004042.8614 2099814.35756 37.745919133669 -122.428732655803 (37.745919133669, -122.428732655803) 2 7 5 63 22
172061 207703 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 161 Joost Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 5ft   6000991.68804 2094917.78379 37.7323011315777 -122.438932323977 (37.7323011315777, -122.438932323977) 9 7 4 63 40
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
176611 223543 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 558 Laidley St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6003065.83042 2096030.39341 37.735473896589 -122.431840957411 (37.735473896589, -122.431840957411) 2 7 5 63 7

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