trees

11,761 rows where qSpecies_id = 17 sorted by TreeID

✎ View and edit SQL

This data as json, CSV (advanced)

rowid TreeID ▼ qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
167918 100783 Permitted Site 7 Tree(s) :: 17 2101X Washington St 5 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6004647.8 2116722.2 37.7923782050701 -122.42784540593 (37.7923782050701, -122.42784540593) 13 9 1 28858 27
41196 100784 Permitted Site 7 Tree(s) :: 17 2101 Washington St 6 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6004647.8 2116722.2 37.7923782050701 -122.42784540593 (37.7923782050701, -122.42784540593) 13 9 1 28858 27
136224 100785 Permitted Site 7 Tree(s) :: 17 2101 Washington St 8 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6004647.8 2116722.2 37.7923782050701 -122.42784540593 (37.7923782050701, -122.42784540593) 13 9 1 28858 27
168525 100786 Permitted Site 7 Tree(s) :: 17 2101 Washington St 9 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6004647.8 2116722.2 37.7923782050701 -122.42784540593 (37.7923782050701, -122.42784540593) 13 9 1 28858 27
140698 100787 Permitted Site 7 Tree(s) :: 17 2001 Washington St 11 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6005125.9 2116783.4 37.792573279433 -122.426195525639 (37.792573279433, -122.426195525639) 13 9 1 28858 27
75759 100809 Undocumented 4 Tree(s) :: 17 494X Clementina St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x4   6010843.5 2111760.1 37.7791019977843 -122.406058284082 (37.7791019977843, -122.406058284082) 14 2 9 28853 34
157595 100811 Undocumented 4 Tree(s) :: 17 494X Clementina St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 3x4   6010843.5 2111760.1 37.7791019977843 -122.406058284082 (37.7791019977843, -122.406058284082) 14 2 9 28853 34
89559 100812 Undocumented 4 Tree(s) :: 17 488X Clementina St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x4   6010881.6 2111796.1 37.7792029762807 -122.405929016686 (37.7792029762807, -122.405929016686) 14 2 9 28853 34
23284 100840 Permitted Site 7 Tree(s) :: 17 55 Merced Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   11/12/2009 12:00:00 AM     Permit Number 53028 5995112.6 2099949.4 37.74578045796 -122.459621841542 (37.74578045796, -122.459621841542) 1 8 4 59 40
65619 100841 Undocumented 4 Tree(s) :: 17 139 Stillman St   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014008 2112974 37.782611576233 -122.39519596309 (37.782611576233, -122.39519596309) 6 2 9 28856 6
168482 100855 Undocumented 4 Tree(s) :: 17 477 29th St 2 Sidewalk: Curb side : Cutout Tree Private 2       4x3   6003495.6 2098911.2 37.7434082840478 -122.43056057664 (37.7434082840478, -122.43056057664) 2 7 5 63 22
59800 100857 Permitted Site 7 Tree(s) :: 17 70 07th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   09/18/2012 12:00:00 AM   3x3 Permit Number 769158 5993689.8 2115051.7 37.7871654802842 -122.465638641068 (37.7871654802842, -122.465638641068) 11 6 1 54 11
173006 100859 Undocumented 4 Tree(s) :: 17 665 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6014545 2111762 37.7793135483428 -122.393253321297 (37.7793135483428, -122.393253321297) 6 2 9 28856 6
71086 100862 Undocumented 4 Tree(s) :: 17 655 Market St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011836.4 2114966.7 37.7879620558848 -122.402849002098 (37.7879620558848, -122.402849002098) 12 2 9 28855 6
130088 100868 Undocumented 4 Tree(s) :: 17 655 03rd St   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014591.2 2111956.1 37.7798490696224 -122.393107079978 (37.7798490696224, -122.393107079978) 6 2 9 28856 6
82382 100966 Undocumented 4 Tree(s) :: 17 498X 06th St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011828 2110616 37.7760155781 -122.402572002689 (37.7760155781, -122.402572002689) 14 2 9 28853 34
119881 100968 Undocumented 4 Tree(s) :: 17 1680 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6006808.6 2108780.2 37.7706934041213 -122.419805171919 (37.7706934041213, -122.419805171919) 8 2 9 28853 19
81005 100989 Undocumented 4 Tree(s) :: 17 1675 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009464 2106858 37.7655647195855 -122.410484311247 (37.7655647195855, -122.410484311247) 8 4 7 28853 19
5249 100990 Undocumented 4 Tree(s) :: 17 1675 Bryant St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009464 2106858 37.7655647195855 -122.410484311247 (37.7655647195855, -122.410484311247) 8 4 7 28853 19
137157 100991 Undocumented 4 Tree(s) :: 17 1675 Bryant St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009464 2106858 37.7655647195855 -122.410484311247 (37.7655647195855, -122.410484311247) 8 4 7 28853 19
19485 100992 Undocumented 4 Tree(s) :: 17 1675 Bryant St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009464 2106858 37.7655647195855 -122.410484311247 (37.7655647195855, -122.410484311247) 8 4 7 28853 19
15091 100993 Undocumented 4 Tree(s) :: 17 1675 Bryant St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009464 2106858 37.7655647195855 -122.410484311247 (37.7655647195855, -122.410484311247) 8 4 7 28853 19
7623 100994 Undocumented 4 Tree(s) :: 17 1675 Bryant St 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009464 2106858 37.7655647195855 -122.410484311247 (37.7655647195855, -122.410484311247) 8 4 7 28853 19
21419 100996 Undocumented 4 Tree(s) :: 17 1675 Bryant St 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009464 2106858 37.7655647195855 -122.410484311247 (37.7655647195855, -122.410484311247) 8 4 7 28853 19
68588 101001 Undocumented 4 Tree(s) :: 17 500X Ogden Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/30/2012 12:00:00 AM     Permit Number 769389 6008398.5 2096033.1 37.7357821841588 -122.413404038925 (37.7357821841588, -122.413404038925) 10 7 7 28859 2
138241 101025 Undocumented 4 Tree(s) :: 17 512X Powhattan Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008343.2 2098096.8 37.7414455475543 -122.41374115961 (37.7414455475543, -122.41374115961) 2 7 7 28859 2
42117 101026 Undocumented 4 Tree(s) :: 17 512X Powhattan Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008343.2 2098096.8 37.7414455475543 -122.41374115961 (37.7414455475543, -122.41374115961) 2 7 7 28859 2
37736 101041 Significant Tree 6 Tree(s) :: 17 3750 18th St 1 Front Yard : Yard Tree SFUSD 4   03/15/2012 12:00:00 AM 30   Permit Number 769376 6005230 2105481 37.7615455321967 -122.425030802687 (37.7615455321967, -122.425030802687) 8 4 5 28859 19
329 101063 Undocumented 4 Tree(s) :: 17 710 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001857 2102025 37.7518650783703 -122.436449244442 (37.7518650783703, -122.436449244442) 2 4 5 28862 22
95349 101079 Undocumented 4 Tree(s) :: 17 2619 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 769685 5999618 2117805 37.7950654667929 -122.445326468891 (37.7950654667929, -122.445326468891) 13 9 1 57 17
108851 101096 DPW Maintained 1 Tree(s) :: 17 1390 Noriega St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/02/2015 12:00:00 AM 7 3x3 Permit Number 776812 5989713 2103139 37.7542262869634 -122.478525879994 (37.7542262869634, -122.478525879994) 1 8 3 56 35
75425 101133 Permitted Site 7 Tree(s) :: 17 1477 Grove St 4 Sidewalk: Curb side : Cutout Tree Private 2   12/16/2015 12:00:00 AM   3x3 Permit Number 769344 6000788.3 2110635.6 37.7754468763902 -122.44076254186 (37.7754468763902, -122.44076254186) 15 5 11 29492 10
81611 101140 Permitted Site 7 Tree(s) :: 17 169 Buena Vista Ter 3 Sidewalk: Curb side : Cutout Tree Private 2   11/07/2012 12:00:00 AM   3x3 Permit Number 769500 6001425 2107346.2 37.7664512423305 -122.438324340152 (37.7664512423305, -122.438324340152) 15 5 5 28862 3
151798 101166 Undocumented 4 Tree(s) :: 17 325 Surrey St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001445 2096200 37.7358475821287 -122.437456909606 (37.7358475821287, -122.437456909606) 2 7 5 63 7
176324 101187 Permitted Site 7 Tree(s) :: 17 329 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/06/2015 12:00:00 AM 3 4x4 Permit Number 773613 5994778 2106658 37.7641813150476 -122.461265047591 (37.7641813150476, -122.461265047591) 15 5 11 56 12
119552 101202 Significant Tree 6 Tree(s) :: 17 7070 California St 1 Front Yard : Tree Private 2   10/03/2012 12:00:00 AM     Permit Number 769231 5985659.5 2114437.4 37.7850123376907 -122.493376058427 (37.7850123376907, -122.493376058427) 11 6 1 55 33
162612 101203 Significant Tree 6 Tree(s) :: 17 7070 California St 2 Front Yard : Tree Private 2   10/03/2012 12:00:00 AM     Permit Number 769231 5985659.5 2114437.4 37.7850123376907 -122.493376058427 (37.7850123376907, -122.493376058427) 11 6 1 55 33
63103 101204 Significant Tree 6 Tree(s) :: 17 1290 Stanyan St 1 Front Yard : Yard Tree Private 2   10/03/2012 12:00:00 AM     Permit Number 769288 5997580.9 2104992.4 37.7597689094704 -122.451450528065 (37.7597689094704, -122.451450528065) 15 5 11 29492 12
190196 101232 Undocumented 4 Tree(s) :: 17 3575 Sacramento St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/28/2016 12:00:00 AM 3 3x3 Permit Number 779254 5997770 2115107 37.7875518165957 -122.451526095937 (37.7875518165957, -122.451526095937) 11 6 1 54 31
192074 101233 Significant Tree 6 Tree(s) :: 17 3740 25th St 1 Front Yard : Yard Tree Private 2   10/04/2012 12:00:00 AM     Permit Number 769197 6005584 2101403 37.7503682845448 -122.423516527668 (37.7503682845448, -122.423516527668) 2 4 5 28859 19
113829 101236 Significant Tree 6 Tree(s) :: 17 895X Church St 1 Back Yard : Yard Tree Private 2   10/05/2012 12:00:00 AM 13   Permit Number 769299 6004383.5 2103691.7 37.7565846850157 -122.427831000859 (37.7565846850157, -122.427831000859) 2 4 5 28862 3
46094 101330 Undocumented 4 Tree(s) :: 17 15X Kittredge Ter 1 Sidewalk: Curb side : Cutout Tree Private 2     16 3x3   5997920.7 2111591.6 37.7779080793099 -122.450751145765 (37.7779080793099, -122.450751145765) 15 6 2 54 16
78234 101358 DPW Maintained 1 Tree(s) :: 17 2201X Mason St 3 Sidewalk: Curb side : Cutout Tree Private 2   11/07/2016 12:00:00 AM 3 5x5 Permit Number 769392 6008936.1 2120783.7 37.803771736238 -122.413295071436 (37.803771736238, -122.413295071436) 3 1 10 308 23
71661 101471 Permitted Site 7 Tree(s) :: 17 1X Melrose Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   05/07/2015 12:00:00 AM 3   Permit Number 775316 6000100 2095441 37.7336869872758 -122.442052627426 (37.7336869872758, -122.442052627426) 9 7 4 63 40
136500 101477 Permitted Site 7 Tree(s) :: 17 1 Oak Park Dr 1 Sidewalk: Property side : Yard Tree Private 2   12/07/2012 12:00:00 AM     Permit Number 769453 5996419.1 2103319 37.7551075796122 -122.455347659049 (37.7551075796122, -122.455347659049) 1 5 4 63 12
102637 101518 DPW Maintained 1 Tree(s) :: 17 170 Pfeiffer St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/21/2012 12:00:00 AM   3x3 Permit Number 769472 6010021.5 2121128.5 37.8047793494283 -122.409563317566 (37.8047793494283, -122.409563317566) 3 1 10 308 23
5100 101532 Undocumented 4 Tree(s) :: 17 11323 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3                      
54298 101533 Permitted Site 7 Tree(s) :: 17 1X Main St 14 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46305 6014036.2 2116698.9 37.7928408582284 -122.395359428861 (37.7928408582284, -122.395359428861) 12 2 9 28855 6
64649 101534 Permitted Site 7 Tree(s) :: 17 1X Main St 13 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46305 6014036.2 2116698.9 37.7928408582284 -122.395359428861 (37.7928408582284, -122.395359428861) 12 2 9 28855 6
195 101535 Permitted Site 7 Tree(s) :: 17 1X Main St 12 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46305 6014036.2 2116698.9 37.7928408582284 -122.395359428861 (37.7928408582284, -122.395359428861) 12 2 9 28855 6
167943 101536 Permitted Site 7 Tree(s) :: 17 1X Main St 11 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46305 6014036.2 2116698.9 37.7928408582284 -122.395359428861 (37.7928408582284, -122.395359428861) 12 2 9 28855 6
171846 101537 Permitted Site 7 Tree(s) :: 17 1X Main St 10 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46305 6014036.2 2116698.9 37.7928408582284 -122.395359428861 (37.7928408582284, -122.395359428861) 12 2 9 28855 6
118762 101538 Permitted Site 7 Tree(s) :: 17 1X Main St 15 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46305 6014036.2 2116698.9 37.7928408582284 -122.395359428861 (37.7928408582284, -122.395359428861) 12 2 9 28855 6
143513 101539 Permitted Site 7 Tree(s) :: 17 1X Main St 5 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46305 6014036.2 2116698.9 37.7928408582284 -122.395359428861 (37.7928408582284, -122.395359428861) 12 2 9 28855 6
31312 101540 Permitted Site 7 Tree(s) :: 17 1X Main St 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46305 6014036.2 2116698.9 37.7928408582284 -122.395359428861 (37.7928408582284, -122.395359428861) 12 2 9 28855 6
162485 101541 Permitted Site 7 Tree(s) :: 17 1X Main St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46305 6014036.2 2116698.9 37.7928408582284 -122.395359428861 (37.7928408582284, -122.395359428861) 12 2 9 28855 6
20525 101542 Permitted Site 7 Tree(s) :: 17 1X Main St 3 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46305 6014036.2 2116698.9 37.7928408582284 -122.395359428861 (37.7928408582284, -122.395359428861) 12 2 9 28855 6
94826 101543 Permitted Site 7 Tree(s) :: 17 1X Main St 4 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46305 6014036.2 2116698.9 37.7928408582284 -122.395359428861 (37.7928408582284, -122.395359428861) 12 2 9 28855 6
76180 101544 Permitted Site 7 Tree(s) :: 17 1X Main St 8 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46305 6014036.2 2116698.9 37.7928408582284 -122.395359428861 (37.7928408582284, -122.395359428861) 12 2 9 28855 6
105364 101545 Permitted Site 7 Tree(s) :: 17 1X Main St 6 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46305 6014036.2 2116698.9 37.7928408582284 -122.395359428861 (37.7928408582284, -122.395359428861) 12 2 9 28855 6
31633 101546 Permitted Site 7 Tree(s) :: 17 1X Main St 7 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46305 6014036.2 2116698.9 37.7928408582284 -122.395359428861 (37.7928408582284, -122.395359428861) 12 2 9 28855 6
95075 101547 Permitted Site 7 Tree(s) :: 17 1X Main St 9 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46305 6014036.2 2116698.9 37.7928408582284 -122.395359428861 (37.7928408582284, -122.395359428861) 12 2 9 28855 6
62870 101616 DPW Maintained 1 Tree(s) :: 17 1363 37th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/18/2014 12:00:00 AM 8 3x3 Permit Number 773459 5984583.1 2105910.8 37.7615377136722 -122.496470602828 (37.7615377136722, -122.496470602828) 1 8 3 56 35
146720 101622 Undocumented 4 Tree(s) :: 17 386X Funston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 3x4   5991883.3 2112830.4 37.7809620404697 -122.471726738415 (37.7809620404697, -122.471726738415) 11 6 2 54 11
55606 101624 Undocumented 4 Tree(s) :: 17 386X Funston Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     5 3x4   5991883.3 2112830.4 37.7809620404697 -122.471726738415 (37.7809620404697, -122.471726738415) 11 6 2 54 11
71221 101638 Undocumented 4 Tree(s) :: 17 10X Walter St 4 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6003101.5 2108239.9 37.769000337681 -122.432589479219 (37.769000337681, -122.432589479219) 15 5 5 28862 3
147190 101648 Undocumented 4 Tree(s) :: 17 2X Masonic Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   5998908.8 2114163.6 37.7850266350664 -122.447518157614 (37.7850266350664, -122.447518157614) 15 6 1 54 31
39951 101658 Permitted Site 7 Tree(s) :: 17 100X South Van Ness Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   11/08/2012 12:00:00 AM 12 3x3 Permit Number 768331 6007216.2 2109320.1 37.7721987949754 -122.418433562325 (37.7721987949754, -122.418433562325) 8 2 9 28853 19
126581 101677 Undocumented 4 Tree(s) :: 17 257 Central Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999766.4 2109434.7 37.7720912604321 -122.444211209505 (37.7720912604321, -122.444211209505) 15 5 11 29492 9
100064 101678 Undocumented 4 Tree(s) :: 17 257 Central Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999766.4 2109434.7 37.7720912604321 -122.444211209505 (37.7720912604321, -122.444211209505) 15 5 11 29492 9
63535 101699 Undocumented 4 Tree(s) :: 17 2700 18th St 3 Sidewalk: Property side : Cutout Tree Private 2   11/13/2012 12:00:00 AM   2x3 Permit Number 769052 6009810.4 2105505.4 37.7618702017999 -122.409190731152 (37.7618702017999, -122.409190731152) 8 4 8 28859 19
192531 101702 Undocumented 4 Tree(s) :: 17 2700 18th St 6 Sidewalk: Property side : Cutout Tree Private 2   11/13/2012 12:00:00 AM   2x3 Permit Number 769052 6009810.4 2105505.4 37.7618702017999 -122.409190731152 (37.7618702017999, -122.409190731152) 8 4 8 28859 19
69406 101705 DPW Maintained 1 Tree(s) :: 17 1482 39th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/13/2012 12:00:00 AM   3x3 Permit Number 769223 5984077.3 2105088.4 37.7592499895256 -122.498159191601 (37.7592499895256, -122.498159191601) 1 8 3 56 35
30891 101708 Undocumented 4 Tree(s) :: 17 240 Bosworth St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 769047 6003787.9 2095308.3 37.7335320978203 -122.429293016532 (37.7335320978203, -122.429293016532) 2 7 5 28861 25
97322 101711 Permitted Site 7 Tree(s) :: 17 95X Milton St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/13/2012 12:00:00 AM   3x3 Permit Number 769047 6003767.7 2095277.7 37.7334469335284 -122.429360672359 (37.7334469335284, -122.429360672359) 2 7 5 28861 25
154093 101723 Permitted Site 7 Tree(s) :: 17 560 Wisconsin St 9 Sidewalk: Curb side : Cutout Tree Private 2   11/14/2012 12:00:00 AM     Permit Number 769391 6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
57766 101731 DPW Maintained 1 Tree(s) :: 17 1300X Lyon St 1 Sidewalk: Property side : Cutout Tree Private 2   06/25/2013 12:00:00 AM   3x3 Permit Number 770262 5999795.2 2113332.1 37.7827941670798 -122.444391727519 (37.7827941670798, -122.444391727519) 15 5 1 29490 31
53665 101733 Permitted Site 7 Tree(s) :: 17 330 Dwight St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 769719 6010615 2091420 37.7232397808052 -122.405415914327 (37.7232397808052, -122.405415914327) 10 3 7 309 28
172328 101741 Significant Tree 6 Tree(s) :: 17 1590 Broadway 1 Front Yard : Yard Tree Private 2   12/21/2012 12:00:00 AM     Permit Number 769428 6006147.8 2117991.4 37.7959478507639 -122.422745597666 (37.7959478507639, -122.422745597666) 13 9 10 28858 32
29577 101809 Undocumented 4 Tree(s) :: 17 370 Hermann St 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   6003497 2108649 37.7701460471638 -122.43125067595 (37.7701460471638, -122.43125067595) 15 9 11 29492 10
126350 101810 Significant Tree 6 Tree(s) :: 17 38 Nebraska St 1 Front Yard : Tree Private 2   11/22/2012 12:00:00 AM     Permit Number 769374 6009268.6 2097830.3 37.740765720819 -122.41052261909 (37.740765720819, -122.41052261909) 10 7 7 28859 2
23548 101834 Permitted Site 7 Tree(s) :: 17 178 Precita Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/26/2012 12:00:00 AM   3x3 Permit Number 769564 6007595.3 2100188.6 37.7471471355217 -122.41647528229 (37.7471471355217, -122.41647528229) 2 7 7 28859 2
62207 101873 DPW Maintained 1 Tree(s) :: 17 737 Folsom St 7 Sidewalk: Curb side : Cutout Tree Private 2   08/26/2015 12:00:00 AM 11 3x3 Permit Number 776173 6012702 2113175 37.7830907593936 -122.399728309071 (37.7830907593936, -122.399728309071) 6 2 9 28856 34
109903 101917 Undocumented 4 Tree(s) :: 17 210 Laidley St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004158 2097133 37.7385632565115 -122.42814346801 (37.7385632565115, -122.42814346801) 2 7 5 63 7
189640 101941 Permitted Site 7 Tree(s) :: 17 902X Treat Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   01/07/2012 12:00:00 AM     Permit Number 769220 6008542.3 2103225.4 37.7555387173329 -122.413415352708 (37.7555387173329, -122.413415352708) 2 4 7 28859 19
27177 101951 Property Tree 8 Tree(s) :: 17 21 Lyell St   unknown : Yard Tree Private 2           6003106 2094969 37.7325618289587 -122.43162632292 (37.7325618289587, -122.43162632292) 9 7 5 28861 25
11148 101952 Undocumented 4 Tree(s) :: 17 55 Bemis St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6003780.5 2096861.5 37.7377964134917 -122.429429325656 (37.7377964134917, -122.429429325656) 2 7 5 63 7
125299 101953 Undocumented 4 Tree(s) :: 17 57 Bemis St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6003774 2096860 37.7377919268198 -122.429451692363 (37.7377919268198, -122.429451692363) 2 7 5 63 7
141389 101954 Undocumented 4 Tree(s) :: 17 510X Berry St 1 Sidewalk: Curb side : Cutout Tree Private 2     20 8x15 Permit Number 769505 6012441.7 2108540.8 37.7703517934984 -122.400303251175 (37.7703517934984, -122.400303251175) 14 2 8 28856 20
35286 101960 Permitted Site 7 Tree(s) :: 17 896 De Haro St 1 Sidewalk: Property side : Cutout Tree Private 2   12/11/2012 12:00:00 AM     Permit Number 769432 6012145.1 2104124 37.7582077038957 -122.401018811941 (37.7582077038957, -122.401018811941) 10 3 8 28856 29
81800 101961 Permitted Site 7 Tree(s) :: 17 896 De Haro St 2 Sidewalk: Property side : Cutout Tree Private 2   12/11/2012 12:00:00 AM     Permit Number 769432 6012145.1 2104124 37.7582077038957 -122.401018811941 (37.7582077038957, -122.401018811941) 10 3 8 28856 29
150235 101962 Permitted Site 7 Tree(s) :: 17 896 De Haro St 3 Sidewalk: Property side : Cutout Tree Private 2   12/11/2012 12:00:00 AM     Permit Number 769432 6012145.1 2104124 37.7582077038957 -122.401018811941 (37.7582077038957, -122.401018811941) 10 3 8 28856 29
82614 101963 Permitted Site 7 Tree(s) :: 17 896 De Haro St 4 Sidewalk: Property side : Cutout Tree Private 2   12/11/2012 12:00:00 AM     Permit Number 769432 6012145.1 2104124 37.7582077038957 -122.401018811941 (37.7582077038957, -122.401018811941) 10 3 8 28856 29
57078 101964 Permitted Site 7 Tree(s) :: 17 896 De Haro St 5 Sidewalk: Property side : Cutout Tree Private 2   12/11/2012 12:00:00 AM     Permit Number 769432 6012145.1 2104124 37.7582077038957 -122.401018811941 (37.7582077038957, -122.401018811941) 10 3 8 28856 29
40219 101965 Permitted Site 7 Tree(s) :: 17 896 De Haro St 6 Sidewalk: Property side : Cutout Tree Private 2   12/11/2012 12:00:00 AM     Permit Number 769432 6012145.1 2104124 37.7582077038957 -122.401018811941 (37.7582077038957, -122.401018811941) 10 3 8 28856 29
42283 101966 Permitted Site 7 Tree(s) :: 17 896 De Haro St 7 Sidewalk: Property side : Cutout Tree Private 2   12/11/2012 12:00:00 AM     Permit Number 769432 6012145.1 2104124 37.7582077038957 -122.401018811941 (37.7582077038957, -122.401018811941) 10 3 8 28856 29
105443 101967 Permitted Site 7 Tree(s) :: 17 896 De Haro St 8 Sidewalk: Property side : Cutout Tree Private 2   12/11/2012 12:00:00 AM     Permit Number 769432 6012145.1 2104124 37.7582077038957 -122.401018811941 (37.7582077038957, -122.401018811941) 10 3 8 28856 29
51726 101968 Undocumented 4 Tree(s) :: 17 149 Winfield St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6007013 2098598 37.742746941229 -122.41837607104 (37.742746941229, -122.41837607104) 2 7 7 28859 2
61287 101982 Undocumented 4 Tree(s) :: 17 205X Rose St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005538.6 2109749.6 37.7732835163003 -122.424267082997 (37.7732835163003, -122.424267082997) 7 9 11 28852 10
36522 101983 Undocumented 4 Tree(s) :: 17 205X Rose St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005538.6 2109749.6 37.7732835163003 -122.424267082997 (37.7732835163003, -122.424267082997) 7 9 11 28852 10

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);