trees
309 rows where Supervisor Districts = 7 and qSpecies_id = 97 sorted by Location
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
154134 | 13369 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 900 Mansell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3X50 | 6009189.31279 | 2090017.34286 | 37.7193085603337 | -122.410245275395 | (37.7193085603337, -122.410245275395) | 9 | 3 | 7 | 309 | 28 | |||
23581 | 31969 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 470 Hamilton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/1995 12:00:00 AM | Permit Number 35370 | 6009517.59351868 | 2092163.53246737 | 37.7252199449059 | -122.409261897755 | (37.7252199449059, -122.409261897755) | 9 | 3 | 7 | 309 | 28 | |||
103250 | 111889 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 142 Wayland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6011076.19973 | 2092521.56402 | 37.7262902239912 | -122.403899105983 | (37.7262902239912, -122.403899105983) | 10 | 3 | 7 | 309 | 28 | |||
102851 | 176422 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 538 Bacon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009782.31983 | 2092607.20943 | 37.7264530165924 | -122.408378041837 | (37.7264530165924, -122.408378041837) | 10 | 3 | 7 | 309 | 28 | |||
99319 | 176423 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 538 Bacon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009799.11271 | 2092612.10018 | 37.726467385945 | -122.408320334118 | (37.726467385945, -122.408320334118) | 10 | 3 | 7 | 309 | 28 | |||
155644 | 176424 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 538 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009812.17284 | 2092615.83589 | 37.7264783747515 | -122.408275448966 | (37.7264783747515, -122.408275448966) | 10 | 3 | 7 | 309 | 28 | |||
104440 | 224498 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 834 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6007554.05965 | 2095454.27722 | 37.7341454144668 | -122.416282623937 | (37.7341454144668, -122.416282623937) | 2 | 7 | 7 | 28859 | 2 | |||
93830 | 63410 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 834 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1987 12:00:00 AM | Permit Number 23993 | 6007543.2306715 | 2095481.74721631 | 37.7342202321398 | -122.416322008236 | (37.7342202321398, -122.416322008236) | 2 | 7 | 7 | 28859 | 2 | ||
46673 | 63412 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 832 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1987 12:00:00 AM | Permit Number 23995 | 6007544.46590294 | 2095494.67209225 | 37.7342557904854 | -122.416318652779 | (37.7342557904854, -122.416318652779) | 2 | 7 | 7 | 28859 | 2 | ||
135750 | 224497 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 826 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6007559.62386 | 2095519.19474 | 37.7343239766775 | -122.416267983001 | (37.7343239766775, -122.416267983001) | 2 | 7 | 7 | 28859 | 2 | |||
74854 | 224496 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 822 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007561.99234 | 2095547.7778 | 37.7344025926964 | -122.416261818137 | (37.7344025926964, -122.416261818137) | 2 | 7 | 7 | 28859 | 2 | |||
189791 | 224495 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 142 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6005480.01407 | 2096145.74782 | 37.7359271935727 | -122.423502403815 | (37.7359271935727, -122.423502403815) | 2 | 7 | 7 | 28859 | 2 | |||
194157 | 224494 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 140 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6005454.36959 | 2096149.25289 | 37.7359353702183 | -122.423591316208 | (37.7359353702183, -122.423591316208) | 2 | 7 | 7 | 28859 | 2 | |||
127165 | 224632 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 667 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007654.90569 | 2096244.9671 | 37.7363221461401 | -122.415989941386 | (37.7363221461401, -122.415989941386) | 2 | 7 | 7 | 28859 | 2 | |||
107337 | 224631 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 667 Moultrie St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007655.79797 | 2096256.88725 | 37.7363549264252 | -122.415987700275 | (37.7363549264252, -122.415987700275) | 2 | 7 | 7 | 28859 | 2 | |||
73278 | 224630 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 661 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6007657.44331 | 2096273.95417 | 37.7364018809509 | -122.415983219874 | (37.7364018809509, -122.415983219874) | 2 | 7 | 7 | 28859 | 2 | |||
24474 | 62335 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 88 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/11/1985 12:00:00 AM | Permit Number 22477 | 6005278.45102522 | 2096412.38253023 | 37.7366479337699 | -122.424218245392 | (37.7366479337699, -122.424218245392) | 2 | 7 | 7 | 28859 | 2 | ||
71345 | 224503 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 111 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6006785.20384 | 2096905.74889 | 37.7380875710875 | -122.419043723383 | (37.7380875710875, -122.419043723383) | 2 | 7 | 7 | 28859 | 2 | |||
158783 | 24602 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 419 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6007254.49022 | 2097303.30919 | 37.7392055992492 | -122.417449329724 | (37.7392055992492, -122.417449329724) | 2 | 7 | 7 | 28859 | 2 | |||
102347 | 24603 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 407 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X2 | 6007220.87336 | 2097309.53692 | 37.7392208076833 | -122.417566003264 | (37.7392208076833, -122.417566003264) | 2 | 7 | 7 | 28859 | 2 | |||
130048 | 224633 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 196 Wool St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6007335.08307 | 2097320.51793 | 37.7392573849237 | -122.417171894266 | (37.7392573849237, -122.417171894266) | 2 | 7 | 7 | 28859 | 2 | |||
82624 | 224655 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 144 Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6006439.43826 | 2097444.91016 | 37.7395485107564 | -122.42027746554 | (37.7395485107564, -122.42027746554) | 2 | 7 | 7 | 28859 | 2 | |||
185465 | 224629 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 329 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007740.48208 | 2097528.6384 | 37.7398516362417 | -122.415784934638 | (37.7398516362417, -122.415784934638) | 2 | 7 | 7 | 28859 | 2 | |||
11588 | 224634 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 248 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 3x3 | 6006846.03495 | 2097621.06949 | 37.740055107862 | -122.418884118001 | (37.740055107862, -122.418884118001) | 2 | 7 | 7 | 28859 | 2 | |||
13648 | 224656 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 998X Eugenia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6007860.71313 | 2097707.80133 | 37.7403503364023 | -122.415381905247 | (37.7403503364023, -122.415381905247) | 2 | 7 | 7 | 28859 | 2 | |||
5854 | 224657 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 900X Eugenia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007803.71411 | 2097712.06394 | 37.7403588367925 | -122.415579287554 | (37.7403588367925, -122.415579287554) | 2 | 7 | 7 | 28859 | 2 | |||
3598 | 224504 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 995x Eugenia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6007856.89018 | 2097735.38644 | 37.7404258641556 | -122.41539707591 | (37.7404258641556, -122.41539707591) | 2 | 7 | 7 | 28859 | 2 | |||
126873 | 33585 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 220 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/1996 12:00:00 AM | Permit Number 37693 | 6006929.36931778 | 2097797.05936052 | 37.7405430288873 | -122.418608458082 | (37.7405430288873, -122.418608458082) | 2 | 7 | 7 | 28859 | 2 | |||
115554 | 33588 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 184 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/1996 12:00:00 AM | Permit Number 37695 | 6007041.74280393 | 2097976.42291715 | 37.741041847234 | -122.418232626766 | (37.741041847234, -122.418232626766) | 2 | 7 | 7 | 28859 | 2 | |||
26097 | 53744 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 180 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/1996 12:00:00 AM | Permit Number 37696 | 6007052.84530249 | 2097996.95756942 | 37.7410988557538 | -122.41819569379 | (37.7410988557538, -122.41819569379) | 2 | 7 | 7 | 28859 | 2 | |||
165400 | 33589 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 180 Bonview St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/1996 12:00:00 AM | Permit Number 37696 | 6007052.84530249 | 2097996.95756942 | 37.7410988557538 | -122.41819569379 | (37.7410988557538, -122.41819569379) | 2 | 7 | 7 | 28859 | 2 | |||
22962 | 224637 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 343 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006160.37028 | 2098038.58649 | 37.741162883772 | -122.421284510199 | (37.741162883772, -122.421284510199) | 2 | 7 | 7 | 28859 | 2 | |||
143559 | 33576 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 170 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/1996 12:00:00 AM | 18 | 2.5x4 | Permit Number 37684 | 6007080.60152815 | 2098048.2941617 | 37.7412413768938 | -122.41810336117 | (37.7412413768938, -122.41810336117) | 2 | 7 | 7 | 28859 | 2 | |
42809 | 33580 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 161 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/1996 12:00:00 AM | Permit Number 37688 | 6007154.09999929 | 2098074.89925627 | 37.7413185651373 | -122.417851114389 | (37.7413185651373, -122.417851114389) | 2 | 7 | 7 | 28859 | 2 | |||
82623 | 224638 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 150 Kingston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6006127.41253 | 2098099.44281 | 37.7413281233964 | -122.421402787214 | (37.7413281233964, -122.421402787214) | 2 | 7 | 7 | 28859 | 2 | |||
129041 | 33581 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 159 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/1996 12:00:00 AM | Permit Number 37689 | 6007159.65124857 | 2098085.1665824 | 37.7413470693377 | -122.417832647693 | (37.7413470693377, -122.417832647693) | 2 | 7 | 7 | 28859 | 2 | |||
161072 | 224639 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 150 Kingston St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6006112.4253 | 2098109.96948 | 37.7413561822494 | -122.421455355286 | (37.7413561822494, -122.421455355286) | 2 | 7 | 7 | 28859 | 2 | |||
33103 | 224636 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 161 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007205.3997 | 2098201.35341 | 37.7416686669758 | -122.417682698402 | (37.7416686669758, -122.417682698402) | 2 | 7 | 7 | 28859 | 2 | |||
67398 | 224635 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 159 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6007212.97385 | 2098214.14312 | 37.7417042108849 | -122.417657415761 | (37.7417042108849, -122.417657415761) | 2 | 7 | 7 | 28859 | 2 | |||
156936 | 224648 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 26 Heyman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6006463.11483 | 2098326.07704 | 37.7419693319081 | -122.420258125606 | (37.7419693319081, -122.420258125606) | 2 | 7 | 7 | 28859 | 2 | |||
158180 | 224647 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 11 Heyman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6006471.9777 | 2098350.49655 | 37.7420368818048 | -122.420229213316 | (37.7420368818048, -122.420229213316) | 2 | 7 | 7 | 28859 | 2 | |||
29906 | 224646 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 9 Heyman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6006447.48473 | 2098360.83948 | 37.7420639010279 | -122.420314636308 | (37.7420639010279, -122.420314636308) | 2 | 7 | 7 | 28859 | 2 | |||
28430 | 224645 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 7 Heyman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6006421.94544 | 2098375.74609 | 37.742103392067 | -122.420404001067 | (37.742103392067, -122.420404001067) | 2 | 7 | 7 | 28859 | 2 | |||
108034 | 224502 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 203 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6006664.46693 | 2098372.33412 | 37.7421076872335 | -122.419565194404 | (37.7421076872335, -122.419565194404) | 2 | 7 | 7 | 28859 | 2 | |||
166115 | 224644 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 7 Heyman Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6006402.40696 | 2098386.74463 | 37.7421324905292 | -122.420472339621 | (37.7421324905292, -122.420472339621) | 2 | 7 | 7 | 28859 | 2 | |||
71622 | 224643 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 7 Heyman Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6006383.19422 | 2098395.08711 | 37.742154314365 | -122.420539363423 | (37.742154314365, -122.420539363423) | 2 | 7 | 7 | 28859 | 2 | |||
47723 | 224642 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 235 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6006381.67631 | 2098450.75503 | 37.742307080422 | -122.420548562565 | (37.742307080422, -122.420548562565) | 2 | 7 | 7 | 28859 | 2 | |||
92219 | 33508 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 235 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | Permit Number 37603 | 6006396.09682229 | 2098460.33665401 | 37.7423342020889 | -122.420499380726 | (37.7423342020889, -122.420499380726) | 2 | 7 | 7 | 28859 | 2 | |||
50729 | 67095 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 432 Franconia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1992 12:00:00 AM | Permit Number 30500 | 6009952.08043631 | 2098577.67814271 | 37.7428561528472 | -122.408212089588 | (37.7428561528472, -122.408212089588) | 10 | 7 | 7 | 28859 | 2 | ||
164535 | 67096 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 431 Franconia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1992 12:00:00 AM | Permit Number 30501 | 6010004.32773544 | 2098578.96669132 | 37.7428626163512 | -122.408031523079 | (37.7428626163512, -122.408031523079) | 10 | 7 | 7 | 28859 | 2 | ||
5744 | 26220 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 765X San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6005701.2867 | 2098677.11468 | 37.7428902448864 | -122.422917229343 | (37.7428902448864, -122.422917229343) | 2 | 7 | 7 | 28859 | 2 | |||
193808 | 67150 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 427 Franconia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/1992 12:00:00 AM | Permit Number 30582 | 6010005.12050673 | 2098589.41341875 | 37.7428913451797 | -122.40802951845 | (37.7428913451797, -122.40802951845) | 10 | 7 | 7 | 28859 | 2 | ||
42609 | 67152 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 412 Franconia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/1992 12:00:00 AM | Permit Number 30584 | 6009956.04429273 | 2098629.91177988 | 37.7429997970033 | -122.408202066775 | (37.7429997970033, -122.408202066775) | 10 | 7 | 7 | 28859 | 2 | ||
23053 | 48044 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3350 Mission St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2002 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | 2 | 7 | 7 | 28859 | 2 | |||
26673 | 48040 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3350 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2002 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | 2 | 7 | 7 | 28859 | 2 | |||
36236 | 48046 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3350 Mission St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2002 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | 2 | 7 | 7 | 28859 | 2 | |||
76052 | 48037 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3350 Mission St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2002 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | 2 | 7 | 7 | 28859 | 2 | |||
82252 | 48042 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3350 Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2002 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | 2 | 7 | 7 | 28859 | 2 | |||
97902 | 48043 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3350 Mission St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2002 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | 2 | 7 | 7 | 28859 | 2 | |||
109507 | 48038 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3350 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2005 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | 2 | 7 | 7 | 28859 | 2 | ||
126375 | 48039 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3350 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2002 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | 2 | 7 | 7 | 28859 | 2 | |||
140651 | 48045 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3350 Mission St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2002 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | 2 | 7 | 7 | 28859 | 2 | |||
170827 | 48041 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3350 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2002 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | 2 | 7 | 7 | 28859 | 2 | |||
16426 | 224652 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 50 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 6007400.92537 | 2098998.39155 | 37.7438681568958 | -122.417063096086 | (37.7438681568958, -122.417063096086) | 2 | 7 | 7 | 28859 | 2 | |||
8296 | 94021 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 67 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/12/2010 12:00:00 AM | 3x3 | Permit Number 53440 | 6007432 | 2099002 | 37.7438798129267 | -122.416955902584 | (37.7438798129267, -122.416955902584) | 2 | 7 | 7 | 28859 | 2 | ||
67261 | 224653 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 44 Elsie St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 6007416.47838 | 2099024.91557 | 37.7439418608428 | -122.417011196208 | (37.7439418608428, -122.417011196208) | 2 | 7 | 7 | 28859 | 2 | |||
94197 | 224654 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 38 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6007453.75758 | 2099095.22372 | 37.7441370083106 | -122.416887273228 | (37.7441370083106, -122.416887273228) | 2 | 7 | 7 | 28859 | 2 | |||
131252 | 224501 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 41 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6007129.62294 | 2099203.46046 | 37.7444159645172 | -122.418015733552 | (37.7444159645172, -122.418015733552) | 2 | 7 | 7 | 28859 | 2 | |||
91862 | 58807 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 40 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/11/1986 12:00:00 AM | Permit Number 23661 | 6007506.51736783 | 2099215.13200372 | 37.744469217231 | -122.416713333977 | (37.744469217231, -122.416713333977) | 2 | 7 | 7 | 28859 | 2 | ||
9437 | 224500 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 39 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6007142.18582 | 2099226.02061 | 37.7444786166914 | -122.417973892579 | (37.7444786166914, -122.417973892579) | 2 | 7 | 7 | 28859 | 2 | |||
60878 | 224499 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 35 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 6007169.2602 | 2099278.27912 | 37.744623630583 | -122.417883978366 | (37.744623630583, -122.417883978366) | 2 | 7 | 7 | 28859 | 2 | |||
152514 | 224650 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 24 Prospect Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6007190.04837 | 2099393.66184 | 37.7449416155647 | -122.417820274 | (37.7449416155647, -122.417820274) | 2 | 7 | 7 | 28859 | 2 | |||
39589 | 224649 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 24 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6007194.88444 | 2099407.51056 | 37.7449799131997 | -122.41780453317 | (37.7449799131997, -122.41780453317) | 2 | 7 | 7 | 28859 | 2 | |||
173711 | 173681 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 125 Rutledge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010317 | 2099454 | 37.7452827689443 | -122.407012047483 | (37.7452827689443, -122.407012047483) | 2 | 7 | 7 | 28859 | 2 | ||||
111571 | 224487 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 14 Lundys Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 1ft | 6007167.09986 | 2099582.88965 | 37.7454599011682 | -122.41791303725 | (37.7454599011682, -122.41791303725) | 2 | 7 | 7 | 28859 | 2 | |||
107742 | 121142 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 100x Rutledge St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 9x6 | 6010389 | 2099533 | 37.7455037145463 | -122.406768648836 | (37.7455037145463, -122.406768648836) | 2 | 7 | 7 | 28859 | 2 | |||
165184 | 121141 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 100x Rutledge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 9x6 | 6010389 | 2099533 | 37.7455037145463 | -122.406768648836 | (37.7455037145463, -122.406768648836) | 2 | 7 | 7 | 28859 | 2 | |||
74599 | 224486 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 12 Lundys Ln | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 22 | Width 2ft | 6007182.48369 | 2099609.18315 | 37.7455329629926 | -122.417861705765 | (37.7455329629926, -122.417861705765) | 2 | 7 | 7 | 28859 | 2 | |||
174424 | 224640 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 14 Powers Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006790.58194 | 2099800.70275 | 37.7460367694939 | -122.41923042716 | (37.7460367694939, -122.41923042716) | 2 | 7 | 7 | 28859 | 2 | |||
170253 | 224641 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 14 Powers Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006763.87284 | 2099814.11824 | 37.7460721011655 | -122.419323735419 | (37.7460721011655, -122.419323735419) | 2 | 7 | 7 | 28859 | 2 | |||
45268 | 59350 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 97 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/29/1987 12:00:00 AM | Permit Number 23892 | 6007961.12301785 | 2099994.21526918 | 37.7466339645312 | -122.415196534166 | (37.7466339645312, -122.415196534166) | 2 | 7 | 7 | 28859 | 2 | ||
55334 | 224658 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 127 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007231.85422 | 2100130.75523 | 37.7469678609981 | -122.41772795229 | (37.7469678609981, -122.41772795229) | 2 | 7 | 7 | 28859 | 2 | |||
59992 | 224513 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1115 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6008070.04378 | 2101397.41005 | 37.7504929435022 | -122.41491919326 | (37.7504929435022, -122.41491919326) | 2 | 4 | 7 | 28859 | 19 | |||
190230 | 26514 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2880 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6008952.92902 | 2101706.37447 | 37.7513908617048 | -122.411887928494 | (37.7513908617048, -122.411887928494) | 2 | 4 | 7 | 28859 | 19 | |||
9506 | 26517 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2883 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6009010.68122 | 2101716.60139 | 37.7514221824079 | -122.411688936397 | (37.7514221824079, -122.411688936397) | 2 | 4 | 7 | 28859 | 19 | |||
122395 | 224578 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2881 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009009.60186 | 2101733.0677 | 37.7514673346644 | -122.411693832315 | (37.7514673346644, -122.411693832315) | 2 | 4 | 7 | 28859 | 19 | |||
10134 | 224679 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 904 Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 3ft | 6007366.73942 | 2101988.35955 | 37.7520760119996 | -122.417393153575 | (37.7520760119996, -122.417393153575) | 2 | 4 | 7 | 28859 | 19 | |||
1525 | 224536 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3283 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | Width 3ft | 6007118.3907 | 2102031.54495 | 37.7521806130667 | -122.418255044036 | (37.7521806130667, -122.418255044036) | 2 | 4 | 7 | 28859 | 19 | |||
9589 | 243519 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3283 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6007186.6119 | 2102035.21074 | 37.7521945183717 | -122.418019383909 | (37.7521945183717, -122.418019383909) | 2 | 4 | 7 | 28859 | 19 | |||
79503 | 656 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3255X 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 12 | 4x4 | 6007336.00672 | 2102041.77073 | 37.7522209377618 | -122.417503217111 | (37.7522209377618, -122.417503217111) | 2 | 4 | 7 | 28859 | 19 | |||
80081 | 655 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3255X 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 06/02/1992 12:00:00 AM | 12 | 3x4 | 6007319.73993 | 2102042.10408 | 37.7522209377659 | -122.417559493969 | (37.7522209377659, -122.417559493969) | 2 | 4 | 7 | 28859 | 19 | ||
108091 | 644 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3245 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6007452.42683 | 2102052.29911 | 37.75225639624 | -122.417101363131 | (37.75225639624, -122.417101363131) | 2 | 4 | 7 | 28859 | 19 | |||
26012 | 642 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3225 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4x4 | 6007512.22413 | 2102054.36572 | 37.7522654344184 | -122.416894720512 | (37.7522654344184, -122.416894720512) | 2 | 4 | 7 | 28859 | 19 | |||
4358 | 224705 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3282X 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | Width 3ft | 6007157.84145 | 2102080.74215 | 37.7523179179397 | -122.418122104462 | (37.7523179179397, -122.418122104462) | 2 | 4 | 7 | 28859 | 19 | |||
16785 | 224704 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3282 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | Width 3ft | 6007185.41243 | 2102081.52674 | 37.7523216240474 | -122.418026814981 | (37.7523216240474, -122.418026814981) | 2 | 4 | 7 | 28859 | 19 | |||
15856 | 224535 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3195 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | Width 3ft | 6007823.33257 | 2102073.06201 | 37.7523342649139 | -122.415820179079 | (37.7523342649139, -122.415820179079) | 2 | 4 | 7 | 28859 | 19 | |||
11585 | 224534 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3175 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | Width 3ft | 6007849.05039 | 2102074.8141 | 37.752340521521 | -122.415731366506 | (37.752340521521, -122.415731366506) | 2 | 4 | 7 | 28859 | 19 | |||
5652 | 657 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3262 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6007285.35691 | 2102087.12511 | 37.7523426205157 | -122.417681586846 | (37.7523426205157, -122.417681586846) | 2 | 4 | 7 | 28859 | 19 | |||
136983 | 626 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3155 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6007952.38293 | 2102079.53558 | 37.7523592939498 | -122.415374359065 | (37.7523592939498, -122.415374359065) | 2 | 4 | 7 | 28859 | 19 | |||
186316 | 224703 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3236 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | Width 3ft | 6007440.93162 | 2102096.08231 | 37.7523759682811 | -122.417144217627 | (37.7523759682811, -122.417144217627) | 2 | 4 | 7 | 28859 | 19 |
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) );