trees

1,381 rows where qSpecies_id = 54 sorted by Police Districts descending

✎ View and edit SQL

This data as json, CSV (advanced)

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)
1388 49516 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1910 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2     16   Permit Number 46422 6002507.7627 2114881.9371 37.7872040200664 -122.435118299397 (37.7872040200664, -122.435118299397) 13 9 11 29490 27
1614 140208 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 708 Fillmore St 3 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6003569 2110758 37.7759409231905 -122.431152184499 (37.7759409231905, -122.431152184499) 7 9 11 29492 10
2145 140433 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1499 Turk St 12 Sidewalk: Curb side : Cutout Tree Police Dept 10     15 Width 0ft   6003251.7396 2112391.1099 37.7804070531695 -122.432366335522 (37.7804070531695, -122.432366335522) 15 9 11 29490 41
2251 143510 Permitted Site 7 Ficus retusa nitida :: Banyan Fig 54 2026 UNION ST 1 Sidewalk: Curb side : Cutout Tree Private 2   08/21/2006 12:00:00 AM 14 Width 0ft Permit Number 48982 6003323.1573 2118630.9053 37.797543994409 -122.432565097779 (37.797543994409, -122.432565097779) 13 9 1 57 17
2553 140071 Undocumented 4 Ficus retusa nitida :: Banyan Fig 54 601X Octavia St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6005402 2111410 37.7778348570605 -122.424857751543 (37.7778348570605, -122.424857751543) 7 9 11 28852 10
3207 111734 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 313 Ivy St 6 Sidewalk: Curb side : Cutout Tree Private 2     11 2.5x3   6005865.3001 2111209.4164 37.777310260787 -122.423240771205 (37.777310260787, -122.423240771205) 7 9 11 28852 10
3486 12249 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 511 Laguna St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6004989.1563 2110705.1842 37.7758762780635 -122.426235730542 (37.7758762780635, -122.426235730542) 7 9 11 28852 10
3763 73629 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 530 Grove St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   20 5x7   6005222.8265 2111323.2215 37.7775864626885 -122.425471398253 (37.7775864626885, -122.425471398253) 7 9 11 28852 10
6485 71703 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 530 Grove St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   14     6005189.8095 2111320.4314 37.7775769362179 -122.425585416633 (37.7775769362179, -122.425585416633) 7 9 11 28852 10
7894 7178 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 837 Fillmore St 2 Sidewalk: Curb side : Cutout Tree DPW 1   01/24/2020 11:28:00 AM 12 6x6   6003458.7438 2111235.1971 37.7772449397217 -122.431567664925 (37.7772449397217, -122.431567664925) 15 9 11 29492 10
7900 138130 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2145 Bush St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6003041.4675 2114785.2401 37.7869688058807 -122.433264885414 (37.7869688058807, -122.433264885414) 13 9 11 29490 27
8024 59162 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 465 Grove St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/16/1981 12:00:00 AM 16 3x3 Permit Number 19443 6005553.1697 2111320.8777 37.7775986862615 -122.424328461999 (37.7775986862615, -122.424328461999) 7 9 11 28852 10
8308 143512 Permitted Site 7 Ficus retusa nitida :: Banyan Fig 54 2030 UNION ST 1 Sidewalk: Curb side : Cutout Tree Private 2   08/21/2006 12:00:00 AM 16 Width 0ft Permit Number 48982 6003288.5063 2118622.406 37.7975186924595 -122.432684391924 (37.7975186924595, -122.432684391924) 13 9 1 57 17
8341 16938 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 595X Oak St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6004175.1129 2110087.9596 37.7741354848182 -122.429007699423 (37.7741354848182, -122.429007699423) 7 9 11 28852 10
8783 7166 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 745 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   6003498.9011 2110946.3415 37.7764540897977 -122.431408122706 (37.7764540897977, -122.431408122706) 15 9 11 29492 10
8801 138109 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1600 SUTTER ST 1 Sidewalk: Curb side : Cutout Tree DPW 1     10 Width 0ft   6004876.0712 2114750.6655 37.7869777775164 -122.426915105637 (37.7869777775164, -122.426915105637) 13 9 11 28858 27
8916 140525 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1190 McAllister St 2 Sidewalk: Curb side : Cutout Tree Private 2     24 Width 0ft   6003468.9224 2111772.2595 37.7787201566355 -122.431570805288 (37.7787201566355, -122.431570805288) 15 9 11 29490 41
9567 143511 Permitted Site 7 Ficus retusa nitida :: Banyan Fig 54 2026 UNION ST 2 Sidewalk: Curb side : Cutout Tree Private 2   08/21/2006 12:00:00 AM 14 Width 0ft Permit Number 48982 6003307.4663 2118627.6363 37.7975341287535 -122.432619159147 (37.7975341287535, -122.432619159147) 13 9 1 57 17
9948 16864 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 230 Oak St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6005857.5291 2110371.9412 37.7750103183132 -122.423208108745 (37.7750103183132, -122.423208108745) 7 9 11 28852 10
11382 140207 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 708 Fillmore St 2 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 0ft   6003569 2110758 37.7759409231905 -122.431152184499 (37.7759409231905, -122.431152184499) 7 9 11 29492 10
11850 66378 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 624 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/04/1991 12:00:00 AM 8   Permit Number 29503 6003604.7588 2110527.1817 37.7753091794017 -122.431012007993 (37.7753091794017, -122.431012007993) 7 9 11 29492 10
12129 57526 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 501 Grove St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/16/1981 12:00:00 AM 13 3x3 Permit Number 19437 6005352.078 2111299.9206 37.7775297860553 -122.425022615137 (37.7775297860553, -122.425022615137) 7 9 11 28852 10
12468 9697 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 423 Gough St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   6005890.102 2111192.506 37.7772652286056 -122.423153770988 (37.7772652286056, -122.423153770988) 7 9 11 28852 10
12978 7162 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 727 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6003506.9326 2110884.8593 37.7762857300682 -122.431375949555 (37.7762857300682, -122.431375949555) 15 9 11 29492 10
13607 140513 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1060 Fillmore St 2 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 0ft   6003397.5169 2112023.698 37.7794064966556 -122.431835782497 (37.7794064966556, -122.431835782497) 15 9 11 29490 41
13989 137919 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1963 PINE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6004551.2938 2115340.9969 37.788580310137 -122.428080846949 (37.788580310137, -122.428080846949) 13 9 11 28858 27
14320 143346 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1910 UNION ST 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6003772.2749 2118686.9893 37.7977234452078 -122.431015036831 (37.7977234452078, -122.431015036831) 13 9 1 57 17
14805 143525 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1957 UNION ST 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6003628.1215 2118621.4061 37.7975352014281 -122.43150916251 (37.7975352014281, -122.43150916251) 13 9 1 57 17
16934 143369 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1763 UNION ST 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6004565.1185 2118753.222 37.7979501963148 -122.428276302626 (37.7979501963148, -122.428276302626) 13 9 1 57 17
17155 140539 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1025 FILLMORE ST 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6003373.4703 2111871.9826 37.7789885607925 -122.43190813363 (37.7789885607925, -122.43190813363) 15 9 11 29490 41
17483 247328 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 696X Oak St 1 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 0ft Permit Number 785235 6003691.2873 2110070.3794 37.7740598153428 -122.430680081912 (37.7740598153428, -122.430680081912) 7 9 11 29492 10
17922 21738 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2045 Sutter St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6002837.9936 2114410.7158 37.7859289122324 -122.433942077336 (37.7859289122324, -122.433942077336) 13 9 11 29490 13
18163 140072 Undocumented 4 Ficus retusa nitida :: Banyan Fig 54 601X Octavia St 3 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6005402 2111410 37.7778348570605 -122.424857751543 (37.7778348570605, -122.424857751543) 7 9 11 28852 10
18647 138987 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 661 FILLMORE ST 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6003459.8516 2110684.9037 37.7757340330654 -122.431524537427 (37.7757340330654, -122.431524537427) 15 9 11 29492 10
18863 138123 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1850 FILLMORE ST 3 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6003035.9259 2114580.1998 37.7864055028496 -122.433269401448 (37.7864055028496, -122.433269401448) 13 9 11 29490 27
19361 61824 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 568 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/04/1985 12:00:00 AM 19   Permit Number 21857 6005139.9121 2110969.4321 37.7766103583758 -122.425733039566 (37.7766103583758, -122.425733039566) 7 9 11 28852 10
22833 244381 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 221 Oak St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 0ft   6005910.0454 2110329.5608 37.7748969155572 -122.423023430361 (37.7748969155572, -122.423023430361) 7 9 11 28852 10
23337 142265 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 500 FELL ST 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 0ft   6004973.0459 2110598.408 37.7755821860494 -122.426283856756 (37.7755821860494, -122.426283856756) 7 9 11 28852 10
23351 33662 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 453 Linden St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/11/2016 12:00:00 AM 3   Permit Number 37750 6005235.3039 2110769.7304 37.7760674161616 -122.425388836438 (37.7760674161616, -122.425388836438) 7 9 11 28852 10
23537 143389 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1800 UNION ST 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6004330.7069 2118766.2088 37.7979725882879 -122.429088360064 (37.7979725882879, -122.429088360064) 13 9 1 57 17
23592 7266 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1740 Fillmore St 2 Sidewalk: Curb side : Cutout Tree DPW 1     16 4X4   6003064.3461 2114369.1192 37.7858275412041 -122.433155987425 (37.7858275412041, -122.433155987425) 13 9 11 29490 13
23704 7163 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 730 Fillmore St 1 Sidewalk: Curb side : Cutout Tree DPW 1     21 3X3   6003538.8779 2111021.3343 37.7766622670699 -122.431275186 (37.7766622670699, -122.431275186) 7 9 11 29492 10
23778 21585 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1500 Sutter St 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 2X2   6005366.3574 2114813.7602 37.7871787298771 -122.425223316098 (37.7871787298771, -122.425223316098) 13 9 11 28858 27
24167 31656 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1708 Laguna St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/05/1995 12:00:00 AM 9 3x3 Permit Number 35163 6004478.3831 2114720.074 37.7868712864461 -122.428288835726 (37.7868712864461, -122.428288835726) 13 9 11 28858 27
24303 139447 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 508 OCTAVIA ST 4 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6005464.5232 2111090.4798 37.7769610637771 -122.424618726949 (37.7769610637771, -122.424618726949) 7 9 11 28852 10
24735 137798 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1900 Laguna St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 0ft   6004365.9463 2115528.293 37.7890840898669 -122.428735478435 (37.7890840898669, -122.428735478435) 13 9 11 28858 27
24828 143520 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2174 UNION ST 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6002609.217 2118527.6063 37.7972198497902 -122.435028126326 (37.7972198497902, -122.435028126326) 13 9 1 57 17
25184 244323 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 719 Oak St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6003563.5505 2110000.7658 37.7738614359578 -122.431116975625 (37.7738614359578, -122.431116975625) 15 9 11 29492 10
25242 142827 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1714 POLK ST 1 Sidewalk: Curb side : Pot Tree Private 2     5 Width 0ft   6006619.3625 2116773.8493 37.7926313555217 -122.421027406021 (37.7926313555217, -122.421027406021) 13 9 10 28858 32
25325 140508 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1020 FILLMORE ST 6 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   6003419.5462 2111864.9347 37.778971820926 -122.431748235324 (37.778971820926, -122.431748235324) 15 9 11 29490 41
26277 138359 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2060 SUTTER ST 1 Sidewalk: Curb side : Cutout Tree DPW 1     15 Width 0ft   6002861.592 2114464.6761 37.7860784126894 -122.433864291751 (37.7860784126894, -122.433864291751) 13 9 11 29490 27
27001 7264 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1730 Fillmore St 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 4X4   6003073.6496 2114318.6841 37.78568958693 -122.433120195092 (37.78568958693, -122.433120195092) 13 9 11 29490 13
27215 13203 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2143 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6002126.2145 2119425.2487 37.7996571038373 -122.436763723295 (37.7996571038373, -122.436763723295) 13 9 1 57 17
27263 140420 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1120 STEINER ST 4 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6002874.2144 2112292.0633 37.7801136820125 -122.433665289686 (37.7801136820125, -122.433665289686) 15 9 11 29490 41
27540 59659 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 906 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/30/1981 12:00:00 AM 16   Permit Number 19081 6002986.1752 2111478.2094 37.7778853946604 -122.433219797973 (37.7778853946604, -122.433219797973) 15 9 11 29492 41
27853 13195 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2098 Lombard St 3 Sidewalk: Curb side : Cutout Tree Private 2     40 3X3   6002408.3176 2119538.5881 37.7999843325384 -122.435795658785 (37.7999843325384, -122.435795658785) 13 9 1 57 17
27911 121250 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 31 Orben Pl 1 Sidewalk: Curb side : Cutout Tree Private 2     16 4x3 Permit Number 778957 6003136.4072 2115361.6956 37.7885569916775 -122.432977615629 (37.7885569916775, -122.432977615629) 13 9 1 29490 27
28061 244147 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 405 Rose St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6004529.1957 2109628.6007 37.7728942335898 -122.427750128017 (37.7728942335898, -122.427750128017) 7 9 11 28852 10
28390 140425 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1499 TURK ST 4 Sidewalk: Curb side : Cutout Tree Police Dept 10     12 Width 0ft   6003006.2764 2112357.3766 37.7803005084328 -122.43321309579 (37.7803005084328, -122.43321309579) 15 9 11 29490 41
28509 13126 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1701 Lombard St 1 Sidewalk: Curb side : Cutout Tree DPW 1     21 3X3   6004190.6649 2119706.135 37.8005454550984 -122.429640016754 (37.8005454550984, -122.429640016754) 13 9 1 57 17
28705 143354 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1651 UNION ST 8 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 0ft   6005214.4581 2118841.5322 37.7982293936322 -122.426035690785 (37.7982293936322, -122.426035690785) 13 9 1 57 17
29165 108003 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 520 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2     21 4x4   6005338.5862 2110997.1319 37.7766976400209 -122.425047738741 (37.7766976400209, -122.425047738741) 7 9 11 28852 10
29405 21724 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1942X Sutter St 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/27/2003 12:00:00 AM 17 4X4   6003291.3026 2114524.3217 37.786266559771 -122.432381870835 (37.786266559771, -122.432381870835) 13 9 11 29490 27
30158 244277 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 595 Oak St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 Width 0ft   6004143 2110087 37.7741310322057 -122.429118715156 (37.7741310322057, -122.429118715156) 7 9 11 28852 10
30976 143334 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1820 UNION ST 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6004249.5395 2118755.17 37.7979376836352 -122.429368434888 (37.7979376836352, -122.429368434888) 13 9 1 57 17
30992 141781 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1480 ELLIS ST 3 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   6003816.5092 2113214.7018 37.7827004390473 -122.430471315153 (37.7827004390473, -122.430471315153) 7 9 11 29490 41
31175 7267 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1750 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   6003061.8978 2114394.5816 37.7858973156258 -122.433166277822 (37.7858973156258, -122.433166277822) 13 9 11 29490 13
32007 7200 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 949 Fillmore St 7 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6003420.9887 2111521.8792 37.7780299575939 -122.431718745255 (37.7780299575939, -122.431718745255) 15 9 11 29492 41
32066 110467 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 465 Grove St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   15 3x3   6005585.7014 2111327.1742 37.7776178118347 -122.424216371681 (37.7776178118347, -122.424216371681) 7 9 11 28852 10
33318 66182 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1819 Laguna St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/06/1990 12:00:00 AM 12   Permit Number 29259 6004371.7533 2115130.5363 37.7879922787707 -122.428687021207 (37.7879922787707, -122.428687021207) 13 9 11 29490 27
33663 14813 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1195 McAllister St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6003481.2511 2111720.7527 37.7785794305459 -122.431524477475 (37.7785794305459, -122.431524477475) 15 9 11 29492 41
33826 59960 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 492 Grove St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/19/1981 12:00:00 AM 21   Permit Number 19438 6005457.1486 2111358.1318 37.7776955544263 -122.424663282479 (37.7776955544263, -122.424663282479) 7 9 11 28852 10
33837 138854 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 519 Ivy St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6004884.6976 2111071.1642 37.7768752647693 -122.426623147275 (37.7768752647693, -122.426623147275) 7 9 11 28852 10
34326 138368 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2060 SUTTER ST 10 Sidewalk: Curb side : Cutout Tree DPW 1     13 Width 0ft   6002679.2262 2114443.3671 37.786009553219 -122.434493703661 (37.786009553219, -122.434493703661) 13 9 11 29490 27
34430 13280 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2524 Lombard St 1 Sidewalk: Curb side : Cutout Tree DPW 1   08/15/1993 12:00:00 AM 40 3X3   6000256.3025 2119240.7621 37.7990441048198 -122.443221023077 (37.7990441048198, -122.443221023077) 13 9 1 57 17
34586 143521 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2224 UNION ST 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   6002337.2397 2118485.1098 37.7970877186103 -122.435966192289 (37.7970877186103, -122.435966192289) 13 9 1 57 17
34952 21609 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1531 Sutter St 2 Sidewalk: Curb side : Cutout Tree DPW 1   04/09/1990 12:00:00 AM 12 4X4   6005037.9058 2114711.086 37.7868782513618 -122.42635237507 (37.7868782513618, -122.42635237507) 13 9 11 28858 13
35150 138369 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2060 SUTTER ST 11 Sidewalk: Curb side : Cutout Tree DPW 1     16 Width 0ft   6002665.8461 2114439.4026 37.7859979081747 -122.434539711553 (37.7859979081747, -122.434539711553) 13 9 11 29490 27
36350 137858 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 22 Orben Pl 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6003153.1523 2115433.6928 37.7887556274538 -122.43292482586 (37.7887556274538, -122.43292482586) 13 9 1 29490 27
36792 244324 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 717 Oak St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6003593.9138 2110004.6215 37.7738737432923 -122.431012219304 (37.7738737432923, -122.431012219304) 15 9 11 29492 10
36803 143527 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1979 UNION ST 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6003537.8633 2118608.4193 37.7974944269949 -122.431820551935 (37.7974944269949, -122.431820551935) 13 9 1 57 17
37007 13191 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2095 Lombard St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6002470.5921 2119469.4635 37.7997980716779 -122.435575217756 (37.7997980716779, -122.435575217756) 13 9 1 57 17
37114 13143 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1800 Lombard St 1 Sidewalk: Curb side : Cutout Tree DPW 1     100 3X3   6003680.9036 2119717.0807 37.8005466318744 -122.431404778789 (37.8005466318744, -122.431404778789) 13 9 1 57 17
37528 13212 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2190 Lombard St 2 Sidewalk: Curb side : Cutout Tree Private 2     70 3X3   6001925.0681 2119471.9545 37.7997739121356 -122.437463108341 (37.7997739121356, -122.437463108341) 13 9 1 57 17
37814 13181 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2001 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6002704.7439 2119503.7145 37.7999054122901 -122.434767417241 (37.7999054122901, -122.434767417241) 13 9 1 57 17
37910 244243 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 150 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   6005806.4217 2110019.2116 37.7740389237303 -122.423359820085 (37.7740389237303, -122.423359820085) 7 9 11 28852 10
38110 138007 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1803 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6003877.7864 2114559.3667 37.7863960226531 -122.430355290708 (37.7863960226531, -122.430355290708) 13 9 11 29490 13
38247 21606 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1525 Sutter St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6005078.2447 2114724.3621 37.7869169843519 -122.426213757225 (37.7869169843519, -122.426213757225) 13 9 11 28858 13
38313 31337 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 745 Buchanan St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/12/1995 12:00:00 AM 16 6x18 Permit Number 34951 6004453.62375 2111092.99154 37.7769108173179 -122.428115918737 (37.7769108173179, -122.428115918737) 7 9 11 28852 10
38809 140069 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 582 GROVE ST 2 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 0ft   6005006.5887 2111294.3898 37.7774950779447 -122.426217384893 (37.7774950779447, -122.426217384893) 7 9 11 28852 10
38929 138927 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 901 HAYES ST 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6003523.5494 2110764.9413 37.7759574066142 -122.431309905462 (37.7759574066142, -122.431309905462) 15 9 11 29492 10
39578 140070 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 601X Octavia St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6005402 2111410 37.7778348570605 -122.424857751543 (37.7778348570605, -122.424857751543) 7 9 11 28852 10
40612 6232 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1220 Ellis St 4 Sidewalk: Curb side : Cutout Tree DPW 1   01/02/1991 12:00:00 AM 12 3X3   6005007.0756 2113377.0261 37.7832135118405 -122.426364020332 (37.7832135118405, -122.426364020332) 7 9 11 28858 41
40681 140585 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 949 FILLMORE ST 11 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 0ft   6003432.0437 2111445.4153 37.7778206333488 -122.431675041477 (37.7778206333488, -122.431675041477) 15 9 11 29492 41
40875 138980 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 712 STEINER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   6003074.6186 2110844.4251 37.7761501973749 -122.432868552462 (37.7761501973749, -122.432868552462) 15 9 11 29492 10
40947 111735 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 313 Ivy St 7 Sidewalk: Curb side : Cutout Tree Private 2     11 2.5x3   6005874.8827 2111210.5438 37.7773138971451 -122.423207702005 (37.7773138971451, -122.423207702005) 7 9 11 28852 10
41042 143548 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2237 UNION ST 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6002268.9185 2118432.4796 37.7969393283412 -122.4361988317 (37.7969393283412, -122.4361988317) 13 9 1 57 17
41692 138365 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2060 SUTTER ST 7 Sidewalk: Curb side : Cutout Tree DPW 1     19 Width 0ft   6002748.6045 2114451.296 37.7860352620012 -122.434254240878 (37.7860352620012, -122.434254240878) 13 9 11 29490 27
41892 138372 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1801 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6002563.7609 2114481.5252 37.7861077705586 -122.434895911649 (37.7861077705586, -122.434895911649) 13 9 11 29490 27
42302 16867 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 235 Oak St 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 5x5   6005854.7098 2110323.2964 37.7748765923478 -122.423214402753 (37.7748765923478, -122.423214402753) 7 9 11 28852 10

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