trees
6,714 rows where qSpecies_id = 7 sorted by PlotSize
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9 | 32966 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 556 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/17/2020 12:00:00 AM | 3 | Permit Number 37281 | 6014072.59224 | 2104507.52941 | 37.759368126158 | -122.394379509632 | (37.759368126158, -122.394379509632) | 10 | 3 | 8 | 28856 | 29 | |
189 | 178694 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 184 Mount Vernon Ave | 7 | Side Yard : Yard | Tree | Private 2 | 9 | 5998957.82756 | 2089383.479 | 37.7169892861082 | -122.445565994978 | (37.7169892861082, -122.445565994978) | 9 | 7 | 6 | 28861 | 25 | ||||
259 | 196282 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 25th St | 13 | : Yard | Tree | Private 2 | 12 | 6015015.25562 | 2102205.64875 | 37.7531000097757 | -122.390958410295 | (37.7531000097757, -122.390958410295) | 10 | 3 | 8 | 28856 | 29 | ||||
389 | 121965 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 20 15th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 5991180.37033 | 2114963.80683 | 37.7867790889821 | -122.474314218886 | (37.7867790889821, -122.474314218886) | 11 | 6 | 1 | 54 | 33 | ||||
518 | 70144 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 8 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5991175.64413 | 2115000.10527 | 37.7868784805694 | -122.474333220033 | (37.7868784805694, -122.474333220033) | 11 | 6 | 1 | 54 | 33 | |||
560 | 97763 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 115 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/08/2011 12:00:00 AM | 1 | Permit Number 768298 | 5996511.5635 | 2113681.1555 | 37.783564683267 | -122.455776900676 | (37.783564683267, -122.455776900676) | 11 | 6 | 1 | 54 | 31 | ||
587 | 37078 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1318 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 2 | Permit Number 39680 | 5982466.3981 | 2106106.9098 | 37.7619519432804 | -122.50380580728 | (37.7619519432804, -122.50380580728) | 1 | 8 | 3 | 56 | 35 | |
651 | 59344 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 532 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1980 12:00:00 AM | 8 | Permit Number 18692 | 6000155.0247 | 2110781.0357 | 37.7758101209138 | -122.44296363094 | (37.7758101209138, -122.44296363094) | 15 | 5 | 11 | 29492 | 16 | |
681 | 71797 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2033 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5998131.4502 | 2109940.9744 | 37.7733879494567 | -122.449903100064 | (37.7733879494567, -122.449903100064) | 15 | 5 | 11 | 29492 | 16 | |||
816 | 248050 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 38 Rutledge St | 7 | Side Yard : Yard | Tree | Private 2 | 5 | 6010496.13368 | 2099436.61391 | 37.7452450531093 | -122.406391405264 | (37.7452450531093, -122.406391405264) | 2 | 7 | 7 | 28859 | 2 | ||||
839 | 71209 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2170 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5988552.6315 | 2100561.3439 | 37.7470812936995 | -122.48234982645 | (37.7470812936995, -122.48234982645) | 1 | 8 | 3 | 29491 | 35 | |||
967 | 78568 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1192 Bowdoin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6009666.22083 | 2090670.9365 | 37.7211299140849 | -122.408642858878 | (37.7211299140849, -122.408642858878) | 9 | 3 | 7 | 309 | 28 | |||
996 | 70145 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 32 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5991181.63526 | 2114912.21638 | 37.7866375092707 | -122.474306076539 | (37.7866375092707, -122.474306076539) | 11 | 6 | 1 | 54 | 33 | |||
1000 | 52636 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 185@ BELMONT Edgewood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 48718 | 5996563.25999555 | 2105933.66378054 | 37.7622950546263 | -122.455038038603 | (37.7622950546263, -122.455038038603) | 15 | 5 | 11 | 29492 | 12 | ||||
1074 | 80599 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 888 Tennessee St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6015456.30873 | 2104984.78613 | 37.7607553924711 | -122.389627233831 | (37.7607553924711, -122.389627233831) | 10 | 3 | 8 | 28856 | 29 | |||
1159 | 70451 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2683 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5983041.4986 | 2096885.6865 | 37.7366668238827 | -122.5011347377 | (37.7366668238827, -122.5011347377) | 1 | 8 | 3 | 29491 | 35 | |||
1207 | 39056 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 2800X 18th St | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009422.123 | 2105494.394 | 37.7618182216771 | -122.410532856099 | (37.7618182216771, -122.410532856099) | 8 | 4 | 7 | 28859 | 19 | ||
1235 | 54485 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 524 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/1972 12:00:00 AM | 3 | Permit Number 10277 | 5983807.43995 | 2112211.38308 | 37.7787918392432 | -122.499618921418 | (37.7787918392432, -122.499618921418) | 11 | 6 | 2 | 55 | 26 | |
1236 | 78452 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3075 23rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5989337.22841 | 2094863.71499 | 37.7314826909771 | -122.479220054956 | (37.7314826909771, -122.479220054956) | 1 | 8 | 4 | 64 | 35 | |||
1276 | 72277 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 819 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5983524.1138 | 2110218.5518 | 37.7733034736496 | -122.500451657892 | (37.7733034736496, -122.500451657892) | 11 | 6 | 2 | 55 | 26 | |||
1471 | 68309 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 273 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/27/1993 12:00:00 AM | 5 | Permit Number 32120 | 5990851.78966 | 2113569.99779 | 37.7829330362374 | -122.47534921912 | (37.7829330362374, -122.47534921912) | 11 | 6 | 2 | 54 | 26 | |
1515 | 31846 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
1627 | 35149 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 11 Laussat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/1998 12:00:00 AM | Permit Number 38681 | 6004664.75137838 | 2109286.2995173 | 37.7719620248453 | -122.427256837171 | (37.7719620248453, -122.427256837171) | 7 | 9 | 11 | 28852 | 10 | ||
1789 | 39904 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2807 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/30/2001 12:00:00 AM | 6 | Permit Number 44042 | 6001235.05057 | 2115912.0484 | 37.7899600881353 | -122.439595474174 | (37.7899600881353, -122.439595474174) | 13 | 6 | 1 | 29490 | 27 | |
1797 | 72003 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1991 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5987539.672 | 2101751.7111 | 37.7502907477313 | -122.485939871711 | (37.7502907477313, -122.485939871711) | 1 | 8 | 3 | 29491 | 35 | |||
1801 | 73988 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3380 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5998684.41396 | 2115276.24554 | 37.7880688417562 | -122.448374611919 | (37.7880688417562, -122.448374611919) | 13 | 6 | 1 | 54 | 31 | |||
1814 | 43257 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 400 Burrows St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/2000 12:00:00 AM | Permit Number 43041 | 6010158.39254276 | 2093206.15154528 | 37.7281186387281 | -122.407120168437 | (37.7281186387281, -122.407120168437) | 10 | 3 | 7 | 309 | 28 | ||
1955 | 55970 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1246 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2017 12:00:00 AM | 3 | Permit Number 12041 | 6008815.91632 | 2116679.99391 | 37.7924972267216 | -122.413420580993 | (37.7924972267216, -122.413420580993) | 5 | 1 | 10 | 28857 | 21 | ||
1971 | 60793 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 300 Ewing Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/14/1983 12:00:00 AM | 7 | Permit Number 20467 | 5998509.2912 | 2112152.7993 | 37.779482661953 | -122.448755442586 | (37.779482661953, -122.448755442586) | 15 | 6 | 2 | 54 | 16 | |
2046 | 72250 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 360 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6002105.68115 | 2091634.84352 | 37.7233502412928 | -122.434846310935 | (37.7233502412928, -122.434846310935) | 9 | 7 | 6 | 28861 | 5 | |||
2141 | 70199 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 479-481 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5990281.69585 | 2112130.11385 | 37.7789464534529 | -122.477216227307 | (37.7789464534529, -122.477216227307) | 11 | 6 | 2 | 55 | 26 | |||
2255 | 236751 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 420 Collingwood St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | 6002101.36864 | 2103370.60532 | 37.7555736715096 | -122.435700446513 | (37.7555736715096, -122.435700446513) | 2 | 4 | 5 | 28862 | 22 | ||||
2466 | 68381 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 42 Uranus Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32206 | 5999268.74613245 | 2105519.44927205 | 37.7613125625383 | -122.445651023552 | (37.7613125625383, -122.445651023552) | 15 | 5 | 5 | 28862 | 3 | ||
2482 | 31979 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 246 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/30/1995 12:00:00 AM | 7 | Permit Number 35378 | 5995256.47104 | 2113909.90159 | 37.7841206491804 | -122.460135585049 | (37.7841206491804, -122.460135585049) | 11 | 6 | 2 | 54 | 11 | |
2508 | 40281 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 379 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41433 | 6007237.3550509 | 2105117.81917656 | 37.7606615087743 | -122.418062420589 | (37.7606615087743, -122.418062420589) | 2 | 4 | 7 | 28859 | 19 | ||
2535 | 70599 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 346 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6004344.49924 | 2091141.9903 | 37.7221238322355 | -122.427072045934 | (37.7221238322355, -122.427072045934) | 9 | 7 | 6 | 28861 | 5 | |||
2596 | 70483 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 939 Avalon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6005126.74678 | 2092081.98496 | 37.7247490558006 | -122.424434831697 | (37.7247490558006, -122.424434831697) | 9 | 7 | 6 | 28861 | 5 | |||
2634 | 40957 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 735 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | 7 | Permit Number 42441 | 5990344.94056 | 2110364.54527 | 37.7741023575346 | -122.476868403223 | (37.7741023575346, -122.476868403223) | 11 | 6 | 2 | 55 | 26 | |
2662 | 51421 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 655 05th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2004 12:00:00 AM | 3 | Permit Number 47745 | 6013248.9695 | 2110513.26704 | 37.7758127253049 | -122.397649253932 | (37.7758127253049, -122.397649253932) | 6 | 2 | 9 | 28856 | 34 | |
2712 | 84610 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 535 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5987793.08995 | 2112320.51653 | 37.7793245451935 | -122.485839179975 | (37.7793245451935, -122.485839179975) | 11 | 6 | 2 | 55 | 26 | |||
2922 | 72315 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3526 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5997893.64237 | 2115823.01153 | 37.7895248738152 | -122.451149975496 | (37.7895248738152, -122.451149975496) | 11 | 6 | 1 | 54 | 31 | |||
2984 | 261389 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 611 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010649.76194 | 2118553.23001 | 37.7977434736118 | -122.407207494731 | (37.7977434736118, -122.407207494731) | 3 | 1 | 10 | 308 | 4 | |||||
3097 | 52514 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 145 Naglee Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48619 | 5998354.2402014 | 2087816.66554809 | 37.7126526970659 | -122.447539577442 | (37.7126526970659, -122.447539577442) | 9 | 7 | 6 | 28861 | 25 | ||
3116 | 71316 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 558 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 6003372.2866 | 2090101.06042 | 37.7192106439431 | -122.430358515827 | (37.7192106439431, -122.430358515827) | 9 | 7 | 6 | 28861 | 5 | |||
3145 | 68594 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1776 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/21/1993 12:00:00 AM | Permit Number 32496 | 5991255.24615708 | 2103348.30667764 | 37.7548904064419 | -122.473207725085 | (37.7548904064419, -122.473207725085) | 1 | 8 | 4 | 56 | 12 | ||
3151 | 47936 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 235 Hazelwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2002 12:00:00 AM | Permit Number 45671 | 5996315.56567541 | 2094902.75702129 | 37.7319927097789 | -122.455097570602 | (37.7319927097789, -122.455097570602) | 9 | 7 | 4 | 59 | 40 | ||
3173 | 78509 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 750 Eucalyptus Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5988915.04586 | 2094775.69423 | 37.7312164799499 | -122.480673162464 | (37.7312164799499, -122.480673162464) | 1 | 8 | 4 | 64 | 35 | |||
3220 | 41670 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 500 Corbett Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42131 | 5999528.76445246 | 2104225.15584588 | 37.7577735947767 | -122.444658701666 | (37.7577735947767, -122.444658701666) | 2 | 5 | 5 | 28862 | 3 | ||
3242 | 43297 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1501 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2000 12:00:00 AM | Permit Number 43066 | |||||||||||||
3278 | 72888 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2506 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5989566.1304 | 2098258.2718 | 37.7408165618747 | -122.478676867492 | (37.7408165618747, -122.478676867492) | 1 | 8 | 3 | 29491 | 35 | |||
3475 | 78427 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 721 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6001123.96924 | 2089480.39079 | 37.7173788130682 | -122.438085642862 | (37.7173788130682, -122.438085642862) | 9 | 7 | 6 | 28861 | 5 | |||
3539 | 65220 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 438 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | 15 | Permit Number 28007 | 6002076.3517 | 2091079.52692 | 37.7218238013198 | -122.434908002604 | (37.7218238013198, -122.434908002604) | 9 | 7 | 6 | 28861 | 5 | |
3582 | 71321 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 336 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6004246.97959 | 2090473.39754 | 37.7202825081141 | -122.427361543098 | (37.7202825081141, -122.427361543098) | 9 | 7 | 6 | 28861 | 5 | |||
3609 | 68347 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 479 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 10 | Permit Number 32166 | 5989354.45266 | 2112083.78554 | 37.7787654076266 | -122.480420503546 | (37.7787654076266, -122.480420503546) | 11 | 6 | 2 | 55 | 26 | |
3610 | 45141 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1300 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/2001 12:00:00 AM | Permit Number 43998 | 6000329.1714268 | 2109256.8846269 | 37.7716351145449 | -122.442251776367 | (37.7716351145449, -122.442251776367) | 15 | 5 | 11 | 29492 | 9 | ||
3685 | 42239 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 526 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | 5 | Permit Number 42488 | 6010182.46318 | 2111990.4424 | 37.7796974691974 | -122.408361341411 | (37.7796974691974, -122.408361341411) | 14 | 2 | 9 | 28853 | 34 | |
3703 | 47931 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 421 Congo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2002 12:00:00 AM | Permit Number 45666 | 6000072.19761127 | 2095017.15680877 | 37.7325216284483 | -122.442118334295 | (37.7325216284483, -122.442118334295) | 9 | 7 | 4 | 63 | 40 | ||
3888 | 66831 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 356 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1991 12:00:00 AM | Permit Number 30128 | 6001116.30976088 | 2104258.47469613 | 37.7579555437732 | -122.439170712808 | (37.7579555437732, -122.439170712808) | 2 | 4 | 5 | 28862 | 38 | ||
3895 | 78222 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1186 Bowdoin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6009661.32539 | 2090689.78042 | 37.7211813813865 | -122.408661109741 | (37.7211813813865, -122.408661109741) | 9 | 3 | 7 | 309 | 28 | |||
3940 | 60357 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1265 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 9 | Permit Number 19935 | 6016646.4135 | 2093895.0122 | 37.7303710665679 | -122.384738607351 | (37.7303710665679, -122.384738607351) | 10 | 3 | 8 | 58 | 1 | |
3972 | 73489 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 45 Newton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6000901.50106 | 2088195.84142 | 37.7138390733861 | -122.438762613813 | (37.7138390733861, -122.438762613813) | 9 | 7 | 6 | 28861 | 5 | |||
4104 | 78658 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 650 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6012076.11303 | 2105354.08238 | 37.761581389203 | -122.401343843369 | (37.761581389203, -122.401343843369) | 10 | 3 | 8 | 28856 | 29 | |||
4223 | 54535 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 107 Gaven St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/18/1972 12:00:00 AM | 8 | Permit Number 10330 | 6009992.40019 | 2095186.16028 | 37.7335460325239 | -122.407833574281 | (37.7335460325239, -122.407833574281) | 10 | 3 | 7 | 309 | 28 | |
4420 | 54537 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 115 Gaven St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/18/1972 12:00:00 AM | 5 | Permit Number 10332 | 6009964.96309 | 2095176.72453 | 37.7335185878995 | -122.407927767479 | (37.7335185878995, -122.407927767479) | 10 | 3 | 7 | 309 | 28 | |
4424 | 261436 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 375 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6007268 | 2095787 | 37.7350429085654 | -122.417295195055 | (37.7350429085654, -122.417295195055) | 2 | 7 | 7 | 28859 | 2 | ||||
4548 | 47112 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 195 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | Permit Number 45096 | 6007059.72881336 | 2097900.35480797 | 37.7408339935349 | -122.418165045885 | (37.7408339935349, -122.418165045885) | 2 | 7 | 7 | 28859 | 2 | ||
4779 | 73552 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1558 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6000334.7955 | 2110645.229 | 37.7754474779657 | -122.4423320082 | (37.7754474779657, -122.4423320082) | 15 | 5 | 11 | 29492 | 16 | |||
4827 | 60908 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 290 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/19/1983 12:00:00 AM | 11 | Permit Number 20698 | 5989656.87054 | 2113476.17839 | 37.7826060996657 | -122.479476231341 | (37.7826060996657, -122.479476231341) | 11 | 6 | 2 | 55 | 26 | |
4919 | 64744 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1058 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/17/1988 12:00:00 AM | Permit Number 25706 | 6001496.66932698 | 2109419.88262313 | 37.7721491365124 | -122.43822501871 | (37.7721491365124, -122.43822501871) | 15 | 5 | 11 | 29492 | 9 | ||
4921 | 71593 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 34 Rhine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5994443.94493 | 2086683.28618 | 37.7093164601484 | -122.46097260021 | (37.7093164601484, -122.46097260021) | 9 | 8 | 6 | 28861 | 25 | |||
4963 | 72437 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3770 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5996832.97473 | 2115019.84204 | 37.7872588007918 | -122.4547616987 | (37.7872588007918, -122.4547616987) | 11 | 6 | 1 | 54 | 31 | |||
5034 | 71218 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2271 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5988222.5624 | 2099870.3089 | 37.7451646891306 | -122.483440513109 | (37.7451646891306, -122.483440513109) | 1 | 8 | 3 | 29491 | 35 | |||
5057 | 72416 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3764 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5996845.41624 | 2115021.64069 | 37.7872644530409 | -122.454718783966 | (37.7872644530409, -122.454718783966) | 11 | 6 | 1 | 54 | 31 | |||
5125 | 38779 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 534 04th St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/20/1998 12:00:00 AM | Permit Number 40639 | 6013303.96708897 | 2111684.86517271 | 37.7790327294989 | -122.397541189965 | (37.7790327294989, -122.397541189965) | 6 | 2 | 9 | 28856 | 34 | ||
5153 | 72328 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2836 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5996013.17509 | 2111084.70561 | 37.7764069050201 | -122.457313223935 | (37.7764069050201, -122.457313223935) | 11 | 6 | 2 | 54 | 16 | |||
5196 | 72221 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1927 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5987523.8589 | 2102155.7654 | 37.7513992507221 | -122.486024209623 | (37.7513992507221, -122.486024209623) | 1 | 8 | 3 | 29491 | 35 | |||
5219 | 78496 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 837 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6011334.80311 | 2104438.72087 | 37.7590266229899 | -122.403843331831 | (37.7590266229899, -122.403843331831) | 10 | 3 | 8 | 28856 | 29 | |||
5231 | 45591 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1762 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/2001 12:00:00 AM | 2 | Permit Number 44327 | 5985671.2041 | 2103229.2894 | 37.7542387115456 | -122.492509867059 | (37.7542387115456, -122.492509867059) | 1 | 8 | 3 | 56 | 35 | |
5242 | 42053 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 470 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42368 | 6003495.60283243 | 2099833.79882234 | 37.7459415266501 | -122.430626387026 | (37.7459415266501, -122.430626387026) | 2 | 7 | 5 | 63 | 22 | ||
5398 | 71818 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1274 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5988967.2555 | 2106670.2084 | 37.7638787087739 | -122.481363401299 | (37.7638787087739, -122.481363401299) | 1 | 8 | 3 | 56 | 35 | |||
5417 | 36107 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1342 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/1998 12:00:00 AM | Permit Number 39204 | 5992735.49126181 | 2106322.00548974 | 37.7631410027064 | -122.468304991085 | (37.7631410027064, -122.468304991085) | 1 | 8 | 11 | 56 | 12 | ||
5445 | 71037 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2655 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5990171.0618 | 2097314.9079 | 37.7382614326886 | -122.476516364987 | (37.7382614326886, -122.476516364987) | 1 | 8 | 3 | 29491 | 35 | |||
5566 | 78781 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 75 Laura St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 0 | 5997342.70536 | 2086993.54413 | 37.7103347346378 | -122.450976426135 | (37.7103347346378, -122.450976426135) | 9 | 7 | 6 | 28861 | 25 | |||
5593 | 78471 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 62 Colby St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6007985.29967 | 2093778.54228 | 37.7295684489024 | -122.414673138765 | (37.7295684489024, -122.414673138765) | 9 | 3 | 7 | 309 | 28 | |||
5643 | 73340 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 591 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5990617.8075 | 2111391.14287 | 37.7769369378188 | -122.475999510441 | (37.7769369378188, -122.475999510441) | 11 | 6 | 2 | 55 | 26 | |||
5648 | 59701 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3169 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/1981 12:00:00 AM | 9 | Permit Number 19131 | 5999559.99552 | 2116003.4997 | 37.7901157113065 | -122.44539757625 | (37.7901157113065, -122.44539757625) | 13 | 6 | 1 | 29490 | 27 | |
5703 | 59347 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 505 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/1988 12:00:00 AM | 9 | Permit Number 25437 | 6000118.7378 | 2110712.049 | 37.7756186320467 | -122.443084200577 | (37.7756186320467, -122.443084200577) | 15 | 5 | 11 | 29492 | 16 | |
5753 | 39480 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 890 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | 7 | Permit Number 40940 | 6012732.47578 | 2103336.91838 | 37.7560792982424 | -122.3989321566 | (37.7560792982424, -122.3989321566) | 10 | 3 | 8 | 28856 | 29 | |
5783 | 78260 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 567 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6011132.16494 | 2092178.53307 | 37.7253514585786 | -122.403681510512 | (37.7253514585786, -122.403681510512) | 10 | 3 | 7 | 309 | 28 | |||
5815 | 43587 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2006 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | 1 | Permit Number 43248 | 5986971.0019 | 2101586.3374 | 37.7498035204361 | -122.487894195347 | (37.7498035204361, -122.487894195347) | 1 | 8 | 3 | 29491 | 35 | |
5823 | 73063 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 774 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5992292.3763 | 2110183.95951 | 37.7737192935019 | -122.470118792738 | (37.7737192935019, -122.470118792738) | 11 | 6 | 2 | 54 | 11 | |||
5829 | 70329 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 791 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5988807.23069 | 2109962.85259 | 37.7729101002624 | -122.482158112101 | (37.7729101002624, -122.482158112101) | 11 | 6 | 2 | 55 | 26 | |||
5866 | 73526 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 807 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6009578.52705 | 2116144.74687 | 37.7910703569642 | -122.410744096059 | (37.7910703569642, -122.410744096059) | 5 | 1 | 10 | 28857 | 21 | |||
6039 | 60368 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1423 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 6 | Permit Number 19946 | 6015801.9343 | 2094530.6388 | 37.7320696291014 | -122.387702446866 | (37.7320696291014, -122.387702446866) | 10 | 3 | 8 | 58 | 1 | |
6136 | 35480 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1011 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/2002 12:00:00 AM | 4 | Permit Number 44832 | 6007756.21553 | 2093380.89962 | 37.7284637342957 | -122.415436968047 | (37.7284637342957, -122.415436968047) | 9 | 3 | 7 | 309 | 5 | |
6171 | 31268 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 2555 17th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5991067.84001 | 2098080.24601 | 37.7404148266578 | -122.47347158803 | (37.7404148266578, -122.47347158803) | 1 | 8 | 4 | 29491 | 40 | ||
6234 | 68658 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 247 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1993 12:00:00 AM | 7 | Permit Number 32565 | 5993663.87786 | 2113851.92985 | 37.7838697436255 | -122.465641127643 | (37.7838697436255, -122.465641127643) | 11 | 6 | 2 | 54 | 11 | |
6310 | 71322 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 426 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6003937.60452 | 2089980.93172 | 37.718912802856 | -122.428395868697 | (37.718912802856, -122.428395868697) | 9 | 7 | 6 | 28861 | 5 | |||
6396 | 36746 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 5555 Woodward St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39516 | |||||||||||||
6494 | 72378 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 543 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5995284.05494 | 2111855.93801 | 37.7784826006561 | -122.459891318727 | (37.7784826006561, -122.459891318727) | 11 | 6 | 2 | 54 | 11 |
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) );