trees
1,381 rows where qSpecies_id = 54 sorted by XCoord descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
133221 | 199982 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1081 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6018036.5838 | 2092513.2332 | 37.7266537566215 | -122.379836574534 | (37.7266537566215, -122.379836574534) | 10 | 3 | 8 | 58 | 1 | |||
170076 | 199769 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1197 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6016909.41 | 2092306.5247 | 37.7260239336289 | -122.383718829233 | (37.7260239336289, -122.383718829233) | 10 | 3 | 8 | 58 | 1 | |||
141408 | 199975 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1233 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6016858.7319 | 2092693.7716 | 37.7270844364031 | -122.383920974413 | (37.7270844364031, -122.383920974413) | 10 | 3 | 8 | 58 | 1 | |||
42028 | 97242 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1300X Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6016235.0824 | 2094868.9009 | 37.7330224130953 | -122.386228519291 | (37.7330224130953, -122.386228519291) | 10 | 3 | 8 | 58 | 1 | |||
95718 | 97243 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1300X Keith St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6016226.9194 | 2094855.7145 | 37.7329857540551 | -122.386255822187 | (37.7329857540551, -122.386255822187) | 10 | 3 | 8 | 58 | 1 | |||
113982 | 97244 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1300X Keith St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6016216.2447 | 2094842.5281 | 37.7329489559822 | -122.386291808735 | (37.7329489559822, -122.386291808735) | 10 | 3 | 8 | 58 | 1 | |||
6447 | 38608 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1570 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/15/2002 12:00:00 AM | 6 | Permit Number 45423 | 6015284.7491 | 2094285.2369 | 37.7313671428977 | -122.389473352601 | (37.7313671428977, -122.389473352601) | 10 | 3 | 8 | 58 | 1 | |
70044 | 38609 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1570 Revere Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/15/2002 12:00:00 AM | 6 | Permit Number 45423 | 6015273.2073 | 2094293.4811 | 37.7313891398709 | -122.38951383063 | (37.7313891398709, -122.38951383063) | 10 | 3 | 8 | 58 | 1 | |
75827 | 38610 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1570 Revere Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/15/2002 12:00:00 AM | 6 | Permit Number 45423 | 6015263.8639 | 2094301.7253 | 37.7314112587254 | -122.389546708337 | (37.7314112587254, -122.389546708337) | 10 | 3 | 8 | 58 | 1 | |
23864 | 38611 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1570 Revere Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 6 | Permit Number 40556 | 6015254.5205 | 2094308.8703 | 37.7314303593885 | -122.389579509324 | (37.7314303593885, -122.389579509324) | 10 | 3 | 8 | 58 | 1 | |
163064 | 199721 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2300 Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6015103.6937 | 2092236.9895 | 37.7257330254006 | -122.389956274684 | (37.7257330254006, -122.389956274684) | 10 | 3 | 8 | 58 | 1 | |||
65580 | 199722 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2300 Jennings St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6015093.5789 | 2092222.3792 | 37.72569234746 | -122.38999022092 | (37.72569234746, -122.38999022092) | 10 | 3 | 8 | 58 | 1 | |||
122068 | 200196 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1124 Fitzgerald Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | Width 0ft | 6015063.1024 | 2090263.455 | 37.720311838731 | -122.389958798873 | (37.720311838731, -122.389958798873) | 10 | 3 | 8 | 58 | 1 | |||
165455 | 199757 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1555 Yosemite Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6015056.6652 | 2092285.8367 | 37.7258645418149 | -122.390122260939 | (37.7258645418149, -122.390122260939) | 10 | 3 | 8 | 58 | 1 | |||
157672 | 199724 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2300 Jennings St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6015054.2433 | 2092170.681 | 37.7255482128528 | -122.390122592124 | (37.7255482128528, -122.390122592124) | 10 | 3 | 8 | 58 | 1 | |||
82719 | 200689 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 4705 03rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6015031.9275 | 2095672.1834 | 37.7351613961063 | -122.390444284047 | (37.7351613961063, -122.390444284047) | 10 | 3 | 8 | 58 | 1 | |||
88983 | 200684 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1618 Oakdale Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6015017.6376 | 2095531.4827 | 37.7347742678836 | -122.390483861704 | (37.7347742678836, -122.390483861704) | 10 | 3 | 8 | 58 | 1 | |||
146069 | 199726 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2300 Jennings St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6015013.7839 | 2092118.9829 | 37.7254040160333 | -122.390258847729 | (37.7254040160333, -122.390258847729) | 10 | 3 | 8 | 58 | 1 | |||
109427 | 199728 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2300 Jennings St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6014985.6871 | 2092077.3996 | 37.725288278052 | -122.390353072543 | (37.725288278052, -122.390353072543) | 10 | 3 | 8 | 58 | 1 | |||
85967 | 199730 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1500 Armstrong Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6014897.5638 | 2092133.7733 | 37.725438180339 | -122.390661646389 | (37.725438180339, -122.390661646389) | 10 | 3 | 8 | 58 | 1 | |||
57000 | 199732 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1500 Armstrong Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6014820.4695 | 2092191.1459 | 37.7255914365754 | -122.390932164611 | (37.7255914365754, -122.390932164611) | 10 | 3 | 8 | 58 | 1 | |||
7692 | 199749 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1555 Yosemite Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6014744.6664 | 2092522.7122 | 37.7264976449454 | -122.391217378098 | (37.7264976449454, -122.391217378098) | 10 | 3 | 8 | 58 | 1 | |||
84858 | 199734 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1500 Armstrong Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6014741.5822 | 2092253.0007 | 37.725756899909 | -122.391209195431 | (37.725756899909, -122.391209195431) | 10 | 3 | 8 | 58 | 1 | |||
23493 | 199735 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1500 Armstrong Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6014648.3519 | 2092320.2341 | 37.7259363350419 | -122.391536186534 | (37.7259363350419, -122.391536186534) | 10 | 3 | 8 | 58 | 1 | |||
178727 | 199743 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2351 Keith St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6014556.9144 | 2092538.9669 | 37.7265318557922 | -122.391867570434 | (37.7265318557922, -122.391867570434) | 10 | 3 | 8 | 58 | 1 | |||
86641 | 199738 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1500 Armstrong Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6014531.8139 | 2092406.2929 | 37.7261661660829 | -122.39194506905 | (37.7261661660829, -122.39194506905) | 10 | 3 | 8 | 58 | 1 | |||
42630 | 199741 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2399 Keith St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6014513.885 | 2092478.0086 | 37.7263620876399 | -122.392012061617 | (37.7263620876399, -122.392012061617) | 10 | 3 | 8 | 58 | 1 | |||
86084 | 199739 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1500 Armstrong Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6014497.7489 | 2092432.2899 | 37.7262356573725 | -122.392064648003 | (37.7262356573725, -122.392064648003) | 10 | 3 | 8 | 58 | 1 | |||
139603 | 32290 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1400 Egbert Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1996 12:00:00 AM | 13 | Permit Number 36872 | 6014301.1518 | 2091179.5011 | 37.7227848326743 | -122.392656680249 | (37.7227848326743, -122.392656680249) | 10 | 3 | 8 | 58 | 1 | ||
165518 | 32291 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1400 Egbert Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1996 12:00:00 AM | 7 | Permit Number 36872 | 6014236.59 | 2091225.7906 | 37.7229083485403 | -122.3928830953 | (37.7229083485403, -122.3928830953) | 10 | 3 | 8 | 58 | 1 | ||
80537 | 199852 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2501 Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6014213.4453 | 2092166.8088 | 37.7254909106612 | -122.393028911239 | (37.7254909106612, -122.393028911239) | 10 | 3 | 8 | 58 | 1 | |||
22206 | 199853 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2503 Keith St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6014209.1818 | 2092155.2364 | 37.7254588983374 | -122.393042840565 | (37.7254588983374, -122.393042840565) | 10 | 3 | 8 | 58 | 1 | |||
44260 | 199854 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2505 Keith St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6014200.0457 | 2092143.0549 | 37.7254249428706 | -122.393073571548 | (37.7254249428706, -122.393073571548) | 10 | 3 | 8 | 58 | 1 | |||
105727 | 199855 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2507 Keith St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6014175.0737 | 2092094.9381 | 37.7252914365514 | -122.393156532831 | (37.7252914365514, -122.393156532831) | 10 | 3 | 8 | 58 | 1 | |||
62896 | 199856 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2509 Keith St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6014162.2831 | 2092076.0569 | 37.7252388819994 | -122.393199428445 | (37.7252388819994, -122.393199428445) | 10 | 3 | 8 | 58 | 1 | |||
2761 | 199857 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2511 Keith St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6014147.0563 | 2092057.1756 | 37.725186191812 | -122.393250745752 | (37.725186191812, -122.393250745752) | 10 | 3 | 8 | 58 | 1 | |||
108876 | 199858 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2513 Keith St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6014132.4385 | 2092038.2943 | 37.7251335354362 | -122.393299957721 | (37.7251335354362, -122.393299957721) | 10 | 3 | 8 | 58 | 1 | |||
37283 | 201180 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 608 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6013469.6258 | 2113973.5593 | 37.785326180656 | -122.397128630227 | (37.785326180656, -122.397128630227) | 6 | 2 | 9 | 28855 | 6 | |||
147457 | 201181 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 608 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6013452.1456 | 2113958.1356 | 37.7852828576216 | -122.39718802493 | (37.7852828576216, -122.39718802493) | 6 | 2 | 9 | 28855 | 6 | |||
74806 | 201182 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 620 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6013434.6654 | 2113939.6272 | 37.7852310646842 | -122.397247203178 | (37.7852310646842, -122.397247203178) | 6 | 2 | 9 | 28855 | 6 | |||
2413 | 201183 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 620 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6013416.1569 | 2113924.2034 | 37.7851876840649 | -122.397310155353 | (37.7851876840649, -122.397310155353) | 6 | 2 | 9 | 28855 | 6 | |||
14187 | 201882 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 633 Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6013405.8744 | 2113823.4352 | 37.7849104254124 | -122.397338660811 | (37.7849104254124, -122.397338660811) | 6 | 2 | 9 | 28856 | 6 | |||
134048 | 201184 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 620 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6013400.7332 | 2113908.7797 | 37.7851444754357 | -122.397362434941 | (37.7851444754357, -122.397362434941) | 6 | 2 | 9 | 28855 | 6 | |||
98202 | 110911 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 633 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 6013393.5354 | 2113814.1809 | 37.7848843282601 | -122.397380700853 | (37.7848843282601, -122.397380700853) | 6 | 2 | 9 | 28856 | 6 | ||||
34608 | 201185 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 620 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6013380.1682 | 2113890.2713 | 37.7850925106546 | -122.397432285471 | (37.7850925106546, -122.397432285471) | 6 | 2 | 9 | 28855 | 6 | |||
120865 | 110909 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 633 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 6013356.5185 | 2113781.277 | 37.7847919207208 | -122.397506459776 | (37.7847919207208, -122.397506459776) | 6 | 2 | 9 | 28856 | 6 | ||||
136076 | 110908 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 633 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 6013338.0101 | 2113761.7403 | 37.7847372468928 | -122.397569122522 | (37.7847372468928, -122.397569122522) | 6 | 2 | 9 | 28856 | 6 | ||||
151202 | 110907 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 633 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 6013321.5581 | 2113739.1188 | 37.7846742173914 | -122.397624454233 | (37.7846742173914, -122.397624454233) | 6 | 2 | 9 | 28856 | 6 | ||||
118043 | 98468 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1500 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6011948.2516 | 2107041.0959 | 37.7662064164751 | -122.401904660337 | (37.7662064164751, -122.401904660337) | 8 | 3 | 8 | 28853 | 20 | |||
38615 | 98470 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1500 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6011914.0134 | 2107036.3406 | 37.7661914486194 | -122.402022750022 | (37.7661914486194, -122.402022750022) | 8 | 3 | 8 | 28853 | 20 | |||
55406 | 98471 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1500 16th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6011899.7475 | 2107035.3895 | 37.7661880408824 | -122.402072026424 | (37.7661880408824, -122.402072026424) | 8 | 3 | 8 | 28853 | 20 | |||
85272 | 98472 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1500 16th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6011885.4815 | 2107033.4874 | 37.766182021887 | -122.402121236301 | (37.766182021887, -122.402121236301) | 8 | 3 | 8 | 28853 | 20 | |||
66866 | 98473 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1500 16th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6011870.2645 | 2107034.4384 | 37.7661837837598 | -122.402173936122 | (37.7661837837598, -122.402173936122) | 8 | 3 | 8 | 28853 | 20 | |||
9445 | 32298 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1616 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/1996 12:00:00 AM | 12 | Permit Number 36875 | 6011655.3244 | 2107023.9767 | 37.7661430585802 | -122.40291664053 | (37.7661430585802, -122.40291664053) | 8 | 3 | 8 | 28853 | 20 | |
141675 | 32294 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1616 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/1996 12:00:00 AM | 12 | Permit Number 36875 | 6011626.7926 | 2107023.9767 | 37.7661414653506 | -122.403015326989 | (37.7661414653506, -122.403015326989) | 8 | 3 | 8 | 28853 | 20 | ||
70658 | 32296 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1616 16th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/1996 12:00:00 AM | 8 | Permit Number 36875 | 6011540.2459 | 2107019.2214 | 37.7661235750542 | -122.403314342162 | (37.7661235750542, -122.403314342162) | 8 | 3 | 8 | 28853 | 20 | ||
167706 | 32297 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1616 16th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/1996 12:00:00 AM | 12 | Permit Number 36875 | 6011502.2034 | 2107015.4172 | 37.7661110048054 | -122.403445656745 | (37.7661110048054, -122.403445656745) | 8 | 3 | 8 | 28853 | 20 | ||
109940 | 258056 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 600 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011288 | 2116842 | 37.793080546408 | -122.404878460446 | (37.793080546408, -122.404878460446) | 3 | 1 | 10 | 28857 | 4 | ||||
120425 | 258058 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 600 California St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011288 | 2116842 | 37.793080546408 | -122.404878460446 | (37.793080546408, -122.404878460446) | 3 | 1 | 10 | 28857 | 4 | ||||
137907 | 258057 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 600 California St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011288 | 2116842 | 37.793080546408 | -122.404878460446 | (37.793080546408, -122.404878460446) | 3 | 1 | 10 | 28857 | 4 | ||||
191059 | 258059 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 600 California St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011288 | 2116842 | 37.793080546408 | -122.404878460446 | (37.793080546408, -122.404878460446) | 3 | 1 | 10 | 28857 | 4 | ||||
78902 | 143556 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 848 KEARNY ST | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 0ft | 6011275.0549 | 2117918.4465 | 37.7960354859857 | -122.404999078913 | (37.7960354859857, -122.404999078913) | 3 | 1 | 10 | 28857 | 4 | |||
180082 | 143557 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 848 KEARNY ST | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 0ft | 6011271.7921 | 2117938.489 | 37.7960903354635 | -122.405011780806 | (37.7960903354635, -122.405011780806) | 3 | 1 | 10 | 28857 | 4 | |||
37866 | 67753 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 900 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1992 12:00:00 AM | 11 | 3x3 | Permit Number 31377 | 6011258.7412 | 2118020.5233 | 37.79631485229 | -122.405062718866 | (37.79631485229, -122.405062718866) | 3 | 1 | 10 | 308 | 4 | |
158367 | 115983 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 900 Kearny St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6011256.8768 | 2118034.0404 | 37.796351862759 | -122.405070122367 | (37.796351862759, -122.405070122367) | 3 | 1 | 10 | 308 | 4 | |||
153254 | 115984 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 900 Kearny St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6011255.4785 | 2118051.2862 | 37.7963991373929 | -122.405076175742 | (37.7963991373929, -122.405076175742) | 3 | 1 | 10 | 308 | 4 | |||
76001 | 115985 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 900 Kearny St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6011253.148 | 2118063.4049 | 37.7964322821358 | -122.405085093558 | (37.7964322821358, -122.405085093558) | 3 | 1 | 10 | 308 | 4 | |||
22448 | 143498 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 857 Kearny St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6011217.724 | 2117930.0991 | 37.7960642762572 | -122.405198277055 | (37.7960642762572, -122.405198277055) | 3 | 1 | 10 | 28857 | 4 | |||
39600 | 143497 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 867 Kearny St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6011217.2579 | 2117938.9551 | 37.7960885666374 | -122.40520051379 | (37.7960885666374, -122.40520051379) | 3 | 1 | 10 | 28857 | 4 | |||
170680 | 143496 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 877 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6011215.3935 | 2117948.7433 | 37.7961153384403 | -122.405207654625 | (37.7961153384403, -122.405207654625) | 3 | 1 | 10 | 28857 | 4 | |||
41482 | 142934 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1201 KEARNY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6011088.1877 | 2119032.3 | 37.7990834099948 | -122.405724174807 | (37.7990834099948, -122.405724174807) | 3 | 1 | 10 | 308 | 23 | |||
48538 | 142516 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1205 KEARNY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6011083.7416 | 2119059.5323 | 37.7991579346332 | -122.405741479105 | (37.7991579346332, -122.405741479105) | 3 | 1 | 10 | 308 | 23 | |||
17669 | 64062 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1205 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/18/1990 12:00:00 AM | 7 | Permit Number 29268 | 6011082.0743 | 2119072.3147 | 37.799192938755 | -122.405748149412 | (37.799192938755, -122.405748149412) | 3 | 1 | 10 | 308 | 23 | |
67040 | 142933 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 502 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6011075.0739 | 2119008.1155 | 37.7990162718949 | -122.405767848781 | (37.7990162718949, -122.405767848781) | 3 | 1 | 10 | 308 | 23 | |||
77347 | 142506 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1223 KEARNY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6011074.9884 | 2119120.527 | 37.7993249217375 | -122.405776067035 | (37.7993249217375, -122.405776067035) | 3 | 1 | 10 | 308 | 23 | |||
49360 | 142923 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1249 KEARNY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6011057.7598 | 2119245.0173 | 37.7996657782982 | -122.405844458331 | (37.7996657782982, -122.405844458331) | 3 | 1 | 10 | 308 | 23 | |||
161089 | 98347 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1331 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 6011023.1341 | 2119487.8255 | 37.8003305339083 | -122.40598139082 | (37.8003305339083, -122.40598139082) | 3 | 1 | 10 | 308 | 23 | |||
128165 | 142920 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1339 KEARNY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6011019.5196 | 2119515.0732 | 37.800405147287 | -122.405995819069 | (37.800405147287, -122.405995819069) | 3 | 1 | 10 | 308 | 23 | |||
116619 | 142466 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1454 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6010993.6362 | 2119929.285 | 37.8015410239646 | -122.406114584446 | (37.8015410239646, -122.406114584446) | 3 | 1 | 10 | 308 | 23 | |||
184353 | 142464 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1456 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6010990.4041 | 2119956.0656 | 37.8016143761567 | -122.406127656852 | (37.8016143761567, -122.406127656852) | 3 | 1 | 10 | 308 | 23 | |||
83261 | 142473 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1429 Kearny St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6010981.054 | 2119812.8124 | 37.8012205149436 | -122.406149914275 | (37.8012205149436, -122.406149914275) | 3 | 1 | 10 | 308 | 23 | |||
50609 | 142472 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1429 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6010978.9762 | 2119829.6657 | 37.8012666737636 | -122.406158292447 | (37.8012666737636, -122.406158292447) | 3 | 1 | 10 | 308 | 23 | |||
102869 | 142471 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1439 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6010974.128 | 2119867.5279 | 37.8013703629213 | -122.406177738482 | (37.8013703629213, -122.406177738482) | 3 | 1 | 10 | 308 | 23 | |||
7583 | 142470 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1443 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6010970.8958 | 2119887.8443 | 37.8014259659921 | -122.406190355577 | (37.8014259659921, -122.406190355577) | 3 | 1 | 10 | 308 | 23 | |||
8143 | 142468 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1455 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6010964.6624 | 2119932.1708 | 37.8015473270449 | -122.406215050843 | (37.8015473270449, -122.406215050843) | 3 | 1 | 10 | 308 | 23 | |||
173263 | 142465 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1457 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6010961.892 | 2119955.2575 | 37.8016105625065 | -122.406226265244 | (37.8016105625065, -122.406226265244) | 3 | 1 | 10 | 308 | 23 | |||
38413 | 4600 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 256 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 45 | 3X3 | 6010961.6739 | 2118493.2807 | 37.7975963184564 | -122.406123962239 | (37.7975963184564, -122.406123962239) | 3 | 1 | 10 | 308 | 23 | |||
191040 | 254075 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 901 Brannan St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6010957 | 2108832 | 37.7710684598289 | -122.405459366064 | (37.7710684598289, -122.405459366064) | 14 | 2 | 9 | 28853 | 34 | ||||
125469 | 143491 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 270 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6010925.3503 | 2118525.7809 | 37.7976835243641 | -122.40625194332 | (37.7976835243641, -122.40625194332) | 3 | 1 | 10 | 308 | 23 | |||
89471 | 143492 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 270 COLUMBUS AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6010909.4189 | 2118541.7123 | 37.7977263769575 | -122.406308193671 | (37.7977263769575, -122.406308193671) | 3 | 1 | 10 | 308 | 23 | |||
89354 | 143480 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 626 PINE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6010907.473 | 2116280.5305 | 37.7915176085666 | -122.406155537422 | (37.7915176085666, -122.406155537422) | 5 | 1 | 10 | 28857 | 6 | |||
164628 | 4605 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 270 Columbus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 6010895.3992 | 2118554.4574 | 37.7977605876582 | -122.406357604418 | (37.7977605876582, -122.406357604418) | 3 | 1 | 10 | 308 | 23 | |||
55085 | 143481 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 626 PINE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6010890.3641 | 2116278.8196 | 37.7915119538645 | -122.40621461367 | (37.7915119538645, -122.40621461367) | 5 | 1 | 10 | 28857 | 6 | |||
5424 | 113149 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1035X Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3x3 | 6010826.0688 | 2111360.9298 | 37.7780049945656 | -122.406090456701 | (37.7780049945656, -122.406090456701) | 14 | 2 | 9 | 28853 | 34 | |||
191640 | 12985 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 306 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | 3X3 | 6010818.9339 | 2120706.9936 | 37.8036666476299 | -122.406773977327 | (37.8036666476299, -122.406773977327) | 3 | 1 | 10 | 308 | 23 | |||
79570 | 7389 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1035X Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6010809.9838 | 2111345.3995 | 37.7779614523005 | -122.406145006296 | (37.7779614523005, -122.406145006296) | 14 | 2 | 9 | 28853 | 34 | |||
95032 | 7388 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1035X Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6010798.3361 | 2111334.861 | 37.7779318645299 | -122.406184557349 | (37.7779318645299, -122.406184557349) | 14 | 2 | 9 | 28853 | 34 | |||
70476 | 7391 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1035X Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/28/1992 12:00:00 AM | 30 | 3x3 | 6010784.4697 | 2111320.9947 | 37.7778930152772 | -122.40623154915 | (37.7778930152772, -122.40623154915) | 14 | 2 | 9 | 28853 | 34 | ||
148626 | 7390 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1035X Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6010768.3847 | 2111305.4643 | 37.7778494726714 | -122.406286098573 | (37.7778494726714, -122.406286098573) | 14 | 2 | 9 | 28853 | 34 | |||
125485 | 7384 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1026 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6010763.6701 | 2111388.108 | 37.7780761292824 | -122.406308232523 | (37.7780761292824, -122.406308232523) | 14 | 2 | 9 | 28853 | 34 |
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) );