trees
186 rows where Supervisor Districts = 5 and qSpecies_id = 53 sorted by Latitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
89944 | 108971 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 20x ROUSSEAU ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003466 | 2095297.3 | 37.7334836652593 | -122.430405132046 | (37.7334836652593, -122.430405132046) | 2 | 7 | 5 | 28861 | 25 | ||||
166856 | 95409 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2885 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Added tree to database on 2/28/11. Appears to be 15-20 yrs old. | 6002410 | 2095371 | 37.7336261540057 | -122.434061286386 | (37.7336261540057, -122.434061286386) | 2 | 7 | 5 | 63 | 7 | ||
107111 | 44172 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 59 Milton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2000 12:00:00 AM | Permit Number 43639 | 6003760.97911216 | 2095401.48581894 | 37.733786440894 | -122.429392732684 | (37.733786440894, -122.429392732684) | 2 | 7 | 5 | 28861 | 25 | |||
129658 | 5136 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2842 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 1x1 | 6002395.52907 | 2095496.33738 | 37.7339694804636 | -122.434120273378 | (37.7339694804636, -122.434120273378) | 2 | 7 | 5 | 63 | 7 | |||
140034 | 95413 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 691 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2016 12:00:00 AM | 12 | 3x3 | Permit Number 779045 | 6002523 | 2095666 | 37.7344425689427 | -122.433691689524 | (37.7344425689427, -122.433691689524) | 2 | 7 | 5 | 63 | 7 | |
181257 | 109235 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 670 CHENERY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 6002570.3 | 2095716.9 | 37.7345850124828 | -122.433531794387 | (37.7345850124828, -122.433531794387) | 2 | 7 | 5 | 63 | 7 | ||||
184670 | 59431 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3033 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1980 12:00:00 AM | 14 | 3x3 | Permit Number 18793 | 6002899.25612306 | 2096070.04882186 | 37.7355733371118 | -122.432419698468 | (37.7355733371118, -122.432419698468) | 2 | 7 | 5 | 63 | 7 | |
20606 | 15650 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3718 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3X3 | 6005292.79028 | 2096596.92241 | 37.7371554485093 | -122.42418178869 | (37.7371554485093, -122.42418178869) | 2 | 7 | 5 | 28859 | 2 | |||
141296 | 15649 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3718 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3X3 | 6005292.79028 | 2096596.92241 | 37.7371554485093 | -122.42418178869 | (37.7371554485093, -122.42418178869) | 2 | 7 | 5 | 28859 | 2 | |||
122006 | 4883 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 87 Crags Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 2X2 | 6000657.5251593 | 2098217.505729 | 37.7413423773337 | -122.440324154875 | (37.7413423773337, -122.440324154875) | 2 | 7 | 5 | 63 | 7 | |||
160495 | 5728 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1688 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X3 | 6005263.1161773 | 2098508.6699422 | 37.742402999925 | -122.42442032403 | (37.742402999925, -122.42442032403) | 2 | 7 | 5 | 63 | 22 | |||
61784 | 59066 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1658 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/16/1980 12:00:00 AM | Permit Number 18361 | 6003975.177671 | 2098610.37486855 | 37.7426094440159 | -122.428880876877 | (37.7426094440159, -122.428880876877) | 2 | 7 | 5 | 63 | 22 | |||
38445 | 4501 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1748 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6004612.9512322 | 2098708.9638206 | 37.74291622476 | -122.4266826598 | (37.74291622476, -122.4266826598) | 2 | 7 | 5 | 63 | 22 | |||
142768 | 112396 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 574 VALLEY ST | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6002248 | 2099192 | 37.7441085392299 | -122.434894531673 | (37.7441085392299, -122.434894531673) | 2 | 7 | 5 | 63 | 22 | ||||
57759 | 4493 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1616 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6004570.9658455 | 2099475.4807252 | 37.7450185306318 | -122.426882412261 | (37.7450185306318, -122.426882412261) | 2 | 7 | 5 | 63 | 22 | |||
161145 | 706 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1509X Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6005302.49516 | 2099477.85942 | 37.7450663972586 | -122.424353081707 | (37.7450663972586, -122.424353081707) | 2 | 7 | 5 | 28859 | 22 | |||
82935 | 39773 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 112 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/29/2001 12:00:00 AM | 14 | 6x6 | Permit Number 41140 | 6005154.17276637 | 2099634.09116827 | 37.7454869972987 | -122.424877067697 | (37.7454869972987, -122.424877067697) | 2 | 7 | 5 | 63 | 22 |
116920 | 39774 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 112 28th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/1999 12:00:00 AM | 14 | 5.5x6 | Permit Number 41140 | 6005154.17276637 | 2099634.09116827 | 37.7454869972987 | -122.424877067697 | (37.7454869972987, -122.424877067697) | 2 | 7 | 5 | 63 | 22 | |
170923 | 109294 | Significant Tree 6 | Ficus nitida :: Laurel Fig 53 | 370 27TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 6004104.9 | 2100171.3 | 37.7469027259862 | -122.428543573264 | (37.7469027259862, -122.428543573264) | 2 | 7 | 5 | 63 | 22 | ||||
150324 | 702 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1399X Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X3 | 6005246.2674799 | 2100192.367786 | 37.74702509847 | -122.424598323807 | (37.74702509847, -122.424598323807) | 2 | 7 | 5 | 28859 | 22 | |||
144703 | 220211 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1399 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 7ft | 6005241 | 2100194 | 37.747029282671 | -122.424616654405 | (37.747029282671, -122.424616654405) | 2 | 7 | 5 | 28859 | 22 | |||
115017 | 4281 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 4270 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 2X2 | 6002137.7495821 | 2100347.8176818 | 37.7472758823749 | -122.435358414005 | (37.7472758823749, -122.435358414005) | 2 | 4 | 5 | 63 | 22 | |||
178363 | 5655 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1332 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005148.4988519 | 2100582.0357256 | 37.7480895150856 | -122.424964119184 | (37.7480895150856, -122.424964119184) | 2 | 4 | 5 | 63 | 22 | |||
152624 | 4455 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1404 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/13/2015 12:00:00 AM | 70 | 3X3 | 6004493.5375 | 2100668.30282 | 37.7482893665971 | -122.427235096559 | (37.7482893665971, -122.427235096559) | 2 | 4 | 5 | 63 | 22 | ||
192632 | 5633 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1256 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6005118.39805 | 2100997.74937 | 37.749229268656 | -122.425097781596 | (37.749229268656, -122.425097781596) | 2 | 4 | 5 | 28862 | 22 | |||
103514 | 4559 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1250X Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 10x6 | 6005144.0595933 | 2101075.0968609 | 37.7494430966122 | -122.425014546007 | (37.7494430966122, -122.425014546007) | 2 | 4 | 5 | 28862 | 22 | |||
159337 | 98224 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 4068 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/06/2012 12:00:00 AM | 3x3 | Permit Number 56734 | 6003417.8 | 2101304.1 | 37.7499742222019 | -122.431000336814 | (37.7499742222019, -122.431000336814) | 2 | 4 | 5 | 28862 | 22 | ||
61535 | 5622 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1202 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 3X3 | 6005101.96034 | 2101291.72603 | 37.7500355321086 | -122.425175538874 | (37.7500355321086, -122.425175538874) | 2 | 4 | 5 | 28862 | 22 | |||
125904 | 57425 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3870 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/1976 12:00:00 AM | 20 | 6x10 | Permit Number 16267 | 6004690.36073914 | 2101363.26470881 | 37.750208699936 | -122.426603966833 | (37.750208699936, -122.426603966833) | 2 | 4 | 5 | 28862 | 22 | |
168783 | 96335 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3705 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | Permit Number 28622 | 6005781 | 2101380 | 37.7503162492489 | -122.422833652647 | (37.7503162492489, -122.422833652647) | 2 | 4 | 5 | 28859 | 19 | ||
43227 | 110731 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3515 25TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006381 | 2101411 | 37.7504352040325 | -122.420761009138 | (37.7504352040325, -122.420761009138) | 2 | 4 | 5 | 28859 | 19 | ||||
54160 | 110730 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3515 25TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006381 | 2101411 | 37.7504352040325 | -122.420761009138 | (37.7504352040325, -122.420761009138) | 2 | 4 | 5 | 28859 | 19 | ||||
125549 | 110733 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3515 25TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006381 | 2101411 | 37.7504352040325 | -122.420761009138 | (37.7504352040325, -122.420761009138) | 2 | 4 | 5 | 28859 | 19 | ||||
190351 | 110732 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3515 25TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006381 | 2101411 | 37.7504352040325 | -122.420761009138 | (37.7504352040325, -122.420761009138) | 2 | 4 | 5 | 28859 | 19 | ||||
93776 | 110724 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3514 25TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006378 | 2101471 | 37.7505997812246 | -122.420775642469 | (37.7505997812246, -122.420775642469) | 2 | 4 | 5 | 28859 | 19 | ||||
95408 | 110726 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3514 25TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006378 | 2101471 | 37.7505997812246 | -122.420775642469 | (37.7505997812246, -122.420775642469) | 2 | 4 | 5 | 28859 | 19 | ||||
95901 | 110725 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3514 25TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006378 | 2101471 | 37.7505997812246 | -122.420775642469 | (37.7505997812246, -122.420775642469) | 2 | 4 | 5 | 28859 | 19 | ||||
115099 | 110727 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3514 25TH ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006378 | 2101471 | 37.7505997812246 | -122.420775642469 | (37.7505997812246, -122.420775642469) | 2 | 4 | 5 | 28859 | 19 | ||||
123934 | 110723 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3514 25TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6006378 | 2101471 | 37.7505997812246 | -122.420775642469 | (37.7505997812246, -122.420775642469) | 2 | 4 | 5 | 28859 | 19 | |||
93614 | 109925 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 375 FAIR OAKS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6005525.2 | 2101540.6 | 37.7507427833765 | -122.423729644924 | (37.7507427833765, -122.423729644924) | 2 | 4 | 5 | 28859 | 19 | |||
43818 | 24454 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1384 Valencia St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6006362.58284 | 2101545.07315 | 37.7508023001764 | -122.420834214589 | (37.7508023001764, -122.420834214589) | 2 | 4 | 5 | 28859 | 19 | |||
53498 | 24453 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1384 Valencia St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6006362.58284 | 2101545.07315 | 37.7508023001764 | -122.420834214589 | (37.7508023001764, -122.420834214589) | 2 | 4 | 5 | 28859 | 19 | |||
58653 | 24451 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1384 Valencia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6006362.58284 | 2101545.07315 | 37.7508023001764 | -122.420834214589 | (37.7508023001764, -122.420834214589) | 2 | 4 | 5 | 28859 | 19 | |||
72643 | 24452 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1384 Valencia St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6006362.58284 | 2101545.07315 | 37.7508023001764 | -122.420834214589 | (37.7508023001764, -122.420834214589) | 2 | 4 | 5 | 28859 | 19 | |||
10358 | 120965 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1145x Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003243 | 2101623 | 37.7508399403415 | -122.43162756863 | (37.7508399403415, -122.43162756863) | 2 | 4 | 5 | 28862 | 22 | ||||
43513 | 120964 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1145x Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003243 | 2101623 | 37.7508399403415 | -122.43162756863 | (37.7508399403415, -122.43162756863) | 2 | 4 | 5 | 28862 | 22 | ||||
140782 | 120966 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1145x Noe St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003243 | 2101623 | 37.7508399403415 | -122.43162756863 | (37.7508399403415, -122.43162756863) | 2 | 4 | 5 | 28862 | 22 | ||||
120502 | 57735 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 364 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/1993 12:00:00 AM | 16 | Permit Number 31982 | 6005454.9599493 | 2101588.78174199 | 37.7508711140338 | -122.423975967283 | (37.7508711140338, -122.423975967283) | 2 | 4 | 5 | 28859 | 19 | ||
155520 | 58902 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 15 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/03/1980 12:00:00 AM | Permit Number 18176 | 6005036.25199829 | 2101622.63318287 | 37.7509404143338 | -122.425426308198 | (37.7509404143338, -122.425426308198) | 2 | 4 | 5 | 28862 | 22 | |||
102319 | 61449 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1330-1332 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/1984 12:00:00 AM | Permit Number 21384 | 6002514.93546023 | 2101705.58374617 | 37.7510254010171 | -122.434151182595 | (37.7510254010171, -122.434151182595) | 2 | 4 | 5 | 28862 | 22 | |||
53386 | 55163 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1328 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/1993 12:00:00 AM | Permit Number 31912 | 6002514.24849197 | 2101716.89965545 | 37.751056432833 | -122.434154367056 | (37.751056432833, -122.434154367056) | 2 | 4 | 5 | 28862 | 22 | |||
175062 | 97110 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1095X Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6003193.9 | 2101874 | 37.751526344012 | -122.431815280512 | (37.751526344012, -122.431815280512) | 2 | 4 | 5 | 28862 | 22 | |||
181736 | 5595 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1100 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3x3 | 6005095.5235026 | 2101950.1341989 | 37.7518430048639 | -122.425244643333 | (37.7518430048639, -122.425244643333) | 2 | 4 | 5 | 28862 | 22 | |||
172156 | 97109 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1095X Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6003187 | 2102045 | 37.7519954785262 | -122.431851350128 | (37.7519954785262, -122.431851350128) | 2 | 4 | 5 | 28862 | 22 | |||
44231 | 57108 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 280 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/1974 12:00:00 AM | 24 | 6x6 | Permit Number 14378 | 6004748.38429029 | 2102046.50032189 | 37.7520879863161 | -122.426451960244 | (37.7520879863161, -122.426451960244) | 2 | 4 | 5 | 28862 | 22 | |
124546 | 5589 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1082 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6005080.54834 | 2102051.49498 | 37.7521204720239 | -122.425303641737 | (37.7521204720239, -122.425303641737) | 2 | 4 | 5 | 28862 | 22 | |||
69799 | 59060 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 4437 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/1992 12:00:00 AM | 14 | 2x2 | Permit Number 30882 | 6000423.21385776 | 2102243.23045707 | 37.7523827100743 | -122.441423120737 | (37.7523827100743, -122.441423120737) | 2 | 4 | 5 | 28862 | 22 | |
138560 | 121561 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1044 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | 6003754 | 2102206 | 37.7524696725481 | -122.429902065263 | (37.7524696725481, -122.429902065263) | 2 | 4 | 5 | 28862 | 22 | |||
139096 | 51485 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 253 Chattanooga St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/11/2005 12:00:00 AM | Permit Number 47796 | 6004792.25802571 | 2102204.70843345 | 37.7525248690267 | -122.426311501214 | (37.7525248690267, -122.426311501214) | 2 | 4 | 5 | 28862 | 22 | |||
63433 | 4418 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1128 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004420.05713 | 2102283.99445 | 37.752721523998 | -122.427604283815 | (37.752721523998, -122.427604283815) | 2 | 4 | 5 | 28862 | 22 | |||
127066 | 96913 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 65X Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005919.1 | 2102263.8 | 37.7527507518094 | -122.422418882903 | (37.7527507518094, -122.422418882903) | 2 | 4 | 5 | 28859 | 19 | ||||
8959 | 113224 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 4244 23RD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001623 | 2102374 | 37.7528100494278 | -122.437283434624 | (37.7528100494278, -122.437283434624) | 2 | 4 | 5 | 28862 | 22 | ||||
28234 | 109001 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 525x BURNETT AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1x1 | 5999530 | 2102478 | 37.7529764040195 | -122.444528861079 | (37.7529764040195, -122.444528861079) | 2 | 5 | 5 | 63 | 38 | ||||
65899 | 109000 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 525x BURNETT AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2x2 circle | 5999530 | 2102478 | 37.7529764040195 | -122.444528861079 | (37.7529764040195, -122.444528861079) | 2 | 5 | 5 | 63 | 38 | |||
130690 | 109005 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 525x BURNETT AVE | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1x1 | 5999530 | 2102478 | 37.7529764040195 | -122.444528861079 | (37.7529764040195, -122.444528861079) | 2 | 5 | 5 | 63 | 38 | ||||
140999 | 109004 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 525x BURNETT AVE | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1x1 | 5999530 | 2102478 | 37.7529764040195 | -122.444528861079 | (37.7529764040195, -122.444528861079) | 2 | 5 | 5 | 63 | 38 | ||||
141541 | 109003 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 525x BURNETT AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1x1 | 5999530 | 2102478 | 37.7529764040195 | -122.444528861079 | (37.7529764040195, -122.444528861079) | 2 | 5 | 5 | 63 | 38 | ||||
184960 | 109002 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 525x BURNETT AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1x1 | 5999530 | 2102478 | 37.7529764040195 | -122.444528861079 | (37.7529764040195, -122.444528861079) | 2 | 5 | 5 | 63 | 38 | ||||
61113 | 57802 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 107 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/1988 12:00:00 AM | 8 | 3x3 | Permit Number 25561 | 6000622.33928566 | 2102551.03510935 | 37.7532392091702 | -122.440756591601 | (37.7532392091702, -122.440756591601) | 2 | 4 | 5 | 28862 | 22 | |
66076 | 112051 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3748x 22ND ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | 3x3 | 6003448 | 2103060 | 37.7547972209553 | -122.431021210073 | (37.7547972209553, -122.431021210073) | 2 | 4 | 5 | 28862 | 22 | |||
162339 | 10147 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 940 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 2x3 | 6005660.7422371 | 2103489.3240903 | 37.7561011788947 | -122.423399446987 | (37.7561011788947, -122.423399446987) | 2 | 4 | 5 | 28859 | 19 | |||
44100 | 115215 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3395x 21ST ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2016 12:00:00 AM | 3 | 9x5 | Permit Number 779049 | 6005778 | 2103691 | 37.7566615513452 | -122.423008263345 | (37.7566615513452, -122.423008263345) | 2 | 4 | 5 | 28859 | 19 | |
155548 | 115216 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3395x 21ST ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2016 12:00:00 AM | 3 | 3x3 | 6005778 | 2103691 | 37.7566615513452 | -122.423008263345 | (37.7566615513452, -122.423008263345) | 2 | 4 | 5 | 28859 | 19 | ||
4294 | 117126 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 766 NOE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | 6003023 | 2103770 | 37.7567226205836 | -122.432541687014 | (37.7567226205836, -122.432541687014) | 2 | 4 | 5 | 28862 | 3 | |||
113469 | 117124 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 766 NOE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | 3x3 | 6003023 | 2103770 | 37.7567226205836 | -122.432541687014 | (37.7567226205836, -122.432541687014) | 2 | 4 | 5 | 28862 | 3 | |||
188536 | 117125 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 766 NOE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003023 | 2103770 | 37.7567226205836 | -122.432541687014 | (37.7567226205836, -122.432541687014) | 2 | 4 | 5 | 28862 | 3 | ||||
62161 | 109596 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3332 21ST ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6006085.3 | 2103802.1 | 37.7569839418566 | -122.421953398845 | (37.7569839418566, -122.421953398845) | 2 | 4 | 5 | 28859 | 19 | |||
32408 | 54027 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 246 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2016 12:00:00 AM | 3 | 6x6 | Permit Number 778679 | 6004696.3346429 | 2103995.33974478 | 37.7574361004301 | -122.426770728763 | (37.7574361004301, -122.426770728763) | 2 | 4 | 5 | 28862 | 3 | |
51820 | 12942 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 725X Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 6 | 6005046.7981655 | 2104134.69405 | 37.7578385432445 | -122.425568603003 | (37.7578385432445, -122.425568603003) | 2 | 4 | 5 | 28859 | 19 | |||
139295 | 59013 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3755 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/1980 12:00:00 AM | 20 | Permit Number 18304 | 6005291.98683548 | 2104267.80164023 | 37.7582178764875 | -122.424730106513 | (37.7582178764875, -122.424730106513) | 2 | 4 | 5 | 28859 | 19 | ||
60853 | 97999 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 30 Eagle St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6000135 | 2104379 | 37.7582305885461 | -122.442573139957 | (37.7582305885461, -122.442573139957) | 2 | 4 | 5 | 28862 | 3 | |||
85172 | 98001 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 30 Eagle St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6000135 | 2104379 | 37.7582305885461 | -122.442573139957 | (37.7582305885461, -122.442573139957) | 2 | 4 | 5 | 28862 | 3 | |||
64331 | 5481 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 700X Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 80 | 6 | 6004966.5668947 | 2104283.6095193 | 37.7582428963987 | -122.425856676166 | (37.7582428963987, -122.425856676166) | 2 | 4 | 5 | 28862 | 3 | |||
171840 | 69122 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3744 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/1994 12:00:00 AM | 22 | 5x9 | Permit Number 33140 | 6005352.36529805 | 2104323.23161765 | 37.7583734841408 | -122.424525234112 | (37.7583734841408, -122.424525234112) | 2 | 4 | 5 | 28859 | 19 | |
163561 | 101313 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 4244X 19th St | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 14 | 5x6 | 6001912 | 2104709 | 37.7592378221466 | -122.436451128899 | (37.7592378221466, -122.436451128899) | 2 | 4 | 5 | 28862 | 3 | |||
111149 | 53710 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 4067 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/1970 12:00:00 AM | 14 | Permit Number 6657 | 6002578.30950532 | 2104703.42856113 | 37.7592603634983 | -122.434146313573 | (37.7592603634983, -122.434146313573) | 2 | 4 | 5 | 28862 | 3 | ||
189703 | 66879 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 277 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1991 12:00:00 AM | Permit Number 768127 | 6001144.84674667 | 2104743.15871911 | 37.7592879918503 | -122.439106757133 | (37.7592879918503, -122.439106757133) | 2 | 4 | 5 | 28862 | 3 | ||
20709 | 109328 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1349 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2015 12:00:00 AM | 3 | 3x3 | 5999000.5 | 2104870.1 | 37.7595142924854 | -122.446532051538 | (37.7595142924854, -122.446532051538) | 15 | 5 | 5 | 28862 | 12 | ||
138351 | 107659 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1324 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 5999078.1 | 2104991.6 | 37.759852333413 | -122.446272413537 | (37.759852333413, -122.446272413537) | 15 | 5 | 5 | 28862 | 3 | |||
135877 | 109331 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1325 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 3x3 | 5998933 | 2105018 | 37.7599165333482 | -122.446776141106 | (37.7599165333482, -122.446776141106) | 15 | 5 | 5 | 28862 | 12 | |||
188517 | 109332 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1321 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 3x3 | 5998933 | 2105018 | 37.7599165333482 | -122.446776141106 | (37.7599165333482, -122.446776141106) | 15 | 5 | 5 | 28862 | 12 | |||
27436 | 107660 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1316 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 5999083.9 | 2105040.7 | 37.7599874810533 | -122.446255886285 | (37.7599874810533, -122.446255886285) | 15 | 5 | 5 | 28862 | 3 | |||
158811 | 225015 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 157 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780170 | 6002699.82559 | 2104972.04176 | 37.7600048066089 | -122.433745251143 | (37.7600048066089, -122.433745251143) | 2 | 4 | 5 | 28862 | 3 | |
75176 | 173949 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1306 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999102 | 2105133 | 37.7602419475954 | -122.446199926833 | (37.7602419475954, -122.446199926833) | 15 | 5 | 5 | 28862 | 3 | ||||
66858 | 173948 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1300 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999106 | 2105162 | 37.7603218028196 | -122.446188178838 | (37.7603218028196, -122.446188178838) | 15 | 5 | 5 | 28862 | 3 | ||||
177096 | 51793 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 65 Oakwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2005 12:00:00 AM | Permit Number 48042 | 6005279.64463313 | 2105087.60921781 | 37.7604681781651 | -122.42483111417 | (37.7604681781651, -122.42483111417) | 2 | 4 | 5 | 28859 | 19 | |||
107245 | 58071 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 4545 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/28/1977 12:00:00 AM | 13 | Permit Number 17041 | 6000791.5456109 | 2105188.83821507 | 37.7604916091053 | -122.440360603481 | (37.7604916091053, -122.440360603481) | 2 | 4 | 5 | 28862 | 3 | ||
190159 | 225029 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 4543 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/14/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 17041 | 6000793.7951 | 2105198.47261 | 37.7605181908718 | -122.440353514511 | (37.7605181908718, -122.440353514511) | 2 | 4 | 5 | 28862 | 3 | |
72782 | 58078 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 4624 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/28/1977 12:00:00 AM | Permit Number 17049 | 6000401 | 2105218 | 37.7605494356876 | -122.441713410467 | (37.7605494356876, -122.441713410467) | 15 | 4 | 5 | 28862 | 3 | |||
24098 | 50784 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 4425@ EUREKA 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/02/2004 12:00:00 AM | Permit Number 47310 | 6001319.3692016 | 2105218.84665198 | 37.760604043869 | -122.438537258087 | (37.760604043869, -122.438537258087) | 2 | 4 | 5 | 28862 | 3 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );