Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1159 | 1159 | 112361 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 561X Folsom St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11/16/2015 12:00:00 AM | 3 | 10x30 | Permit Number 775828 | 6013749.7362 | 2114198.9064599997 | 37.785960521430205 | -122.396175324952 | (37.7859605214302, -122.396175324952) | |
10011 | 10011 | 173616 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 1200X JUNIPERO SERRA BLVD | 15 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
23610 | 23610 | 107057 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 601X Davis St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/23/2014 12:00:00 AM | 9 | Permit Number 771755 | 6013145.32204 | 2118507.86888 | 37.7977582696821 | -122.398568926718 | (37.7977582696821, -122.398568926718) | ||
27043 | 27043 | 194682 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1 Jack Balestreri Way | 22 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6012380.91774 | 2104784.0825900002 | 37.760033297111704 | -122.400249606728 | (37.7600332971117, -122.400249606728) | ||||
31877 | 31877 | 194684 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1 Jack Balestreri Way | 28 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6012406.88691 | 2104790.52602 | 37.7600524373766 | -122.40016024382099 | (37.7600524373766, -122.400160243821) | ||||
33297 | 33297 | 133178 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 150 Francisco St | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6010460.26266 | 2121350.57674 | 37.8054136928441 | -122.40806059821199 | (37.8054136928441, -122.408060598212) | ||||
34147 | 34147 | 132748 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2100 Jefferson St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 35 | 5999067.6485 | 2121161.9158799998 | 37.80425122466389 | -122.44747250735901 | (37.8042512246639, -122.447472507359) | ||||
36943 | 36943 | 236176 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 44 Miguel St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6003678.32801 | 2097312.06482 | 37.7390277763068 | -122.429814711994 | (37.7390277763068, -122.429814711994) | ||||
37022 | 37022 | 234105 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1200 San Jose Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6004253.5509 | 2096158.0047 | 37.735891546257 | -122.427743648866 | (37.735891546257, -122.427743648866) | ||||
41671 | 41671 | 132747 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2100 Jefferson St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 5999125.84165 | 2121169.76474 | 37.804276100834606 | -122.44727169143101 | (37.8042761008346, -122.447271691431) | ||||
42553 | 42553 | 133185 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 165 Francisco St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 31 | 6010525.52833 | 2121313.76081 | 37.805316259401295 | -122.407832138939 | (37.8053162594013, -122.407832138939) | ||||
50265 | 50265 | 133184 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 165 Francisco St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 26 | 6010514.4999 | 2121309.14638 | 37.8053029719104 | -122.407869978821 | (37.8053029719104, -122.407869978821) | ||||
52076 | 52076 | 133187 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 165 Francisco St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6010536.300969999 | 2121315.75922 | 37.8053223496175 | -122.407794999663 | (37.8053223496175, -122.407794999663) | ||||
55269 | 55269 | 133182 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 165 Francisco St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6010494.592999999 | 2121305.47712 | 37.8052917825441 | -122.4079386106 | (37.8052917825441, -122.4079386106) | ||||
55415 | 55415 | 133122 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 941 Vallejo St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6008869.28255 | 2118668.2564 | 37.797959502879294 | -122.413376604174 | (37.7979595028793, -122.413376604174) | ||||
56085 | 56085 | 247895 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 350 Mayflower St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 8ft | 6010134.20448 | 2098367.81195 | 37.74229010212029 | -122.407567559293 | (37.7422901021203, -122.407567559293) | |||
56843 | 56843 | 194686 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1 Jack Balestreri Way | 44 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6012432.36762 | 2104808.71902 | 37.760103812064706 | -122.40007339538799 | (37.7601038120647, -122.400073395388) | ||||
59997 | 59997 | 235066 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 596 Dellbrook Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | Width 0ft | 5997010.19872 | 2103808.86003 | 37.7564865103631 | -122.45333884353902 | (37.7564865103631, -122.453338843539) | |||
61068 | 61068 | 133177 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 150 Francisco St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | 6010481.51509 | 2121362.5408 | 37.8054477330788 | -122.40798789525 | (37.8054477330788, -122.40798789525) | ||||
63666 | 63666 | 249900 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 300 Greenwich St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | Width 0ft | 6011328.50093 | 2120408.94667 | 37.802876781803896 | -122.40498958701099 | (37.8028767818039, -122.404989587011) | |||
73120 | 73120 | 194685 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1 Jack Balestreri Way | 43 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6012432.71198 | 2104802.44836 | 37.7600866134166 | -122.40007176402099 | (37.7600866134166, -122.400071764021) | ||||
73388 | 73388 | 249854 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 285 Greenwich St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 43 | Width 0ft | 6011456.47585 | 2120387.94643 | 37.8028262731804 | -122.40454524638099 | (37.8028262731804, -122.404545246381) | |||
77206 | 77206 | 107056 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 601X Davis St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/23/2014 12:00:00 AM | 12 | Permit Number 771755 | 6013142.97136 | 2118525.3196099997 | 37.797806054267895 | -122.39857828598 | (37.7978060542679, -122.39857828598) | ||
78513 | 78513 | 113727 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 1580 Valencia St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006496.0 | 2100402.0 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | |||||
79254 | 79254 | 104682 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 33 08th St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 770764 | 6008457.3 | 2111569.1 | 37.7784438055662 | -122.414299630615 | (37.7784438055662, -122.414299630615) | ||||
79490 | 79490 | 113728 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 1580 Valencia St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006496.0 | 2100402.0 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | |||||
80152 | 80152 | 104683 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 33 08th St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 770764 | 6008457.3 | 2111569.1 | 37.7784438055662 | -122.414299630615 | (37.7784438055662, -122.414299630615) | ||||
80921 | 80921 | 104904 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 417 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) | |||||
83185 | 83185 | 113738 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 1580 Valencia St | 15 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006496.0 | 2100402.0 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | |||||
84846 | 84846 | 107136 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 700X Stevenson St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/31/2014 12:00:00 AM | Permit Number 769156 | 6008444.340419999 | 2111440.4280000003 | 37.778089774899705 | -122.41433535624701 | (37.7780897748997, -122.414335356247) | |||
85678 | 85678 | 115250 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 1404x Mason St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/20/2016 12:00:00 AM | 6009352.6 | 2118074.7 | 37.796356867240206 | -122.41166222086001 | (37.7963568672402, -122.41166222086) | ||||
86298 | 86298 | 105862 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 3615-3623X Cesar Chavez St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005538.0 | 2100417.0 | 37.747658358497404 | -122.423605504909 | (37.7476583584974, -122.423605504909) | |||||
87200 | 87200 | 113739 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 1580 Valencia St | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006496.0 | 2100402.0 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | |||||
89806 | 89806 | 113734 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 1580 Valencia St | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006496.0 | 2100402.0 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | |||||
90287 | 90287 | 104680 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 33 08th St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 770764 | 6008457.3 | 2111569.1 | 37.7784438055662 | -122.414299630615 | (37.7784438055662, -122.414299630615) | ||||
93451 | 93451 | 112482 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 1275 Columbus Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 08/03/2015 12:00:00 AM | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | ||||
94641 | 94641 | 104654 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 352-354 Coleridge St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 768244 | 6006091.8 | 2098091.1 | 37.741303207958204 | -122.421525330669 | (37.7413032079582, -122.421525330669) | ||||
97000 | 97000 | 113736 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 1580 Valencia St | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006496.0 | 2100402.0 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | |||||
97526 | 97526 | 113735 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 1580 Valencia St | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006496.0 | 2100402.0 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | |||||
97768 | 97768 | 104681 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 33 08th St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 770764 | 6008457.3 | 2111569.1 | 37.7784438055662 | -122.414299630615 | (37.7784438055662, -122.414299630615) | ||||
101316 | 101316 | 113733 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 1580 Valencia St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006496.0 | 2100402.0 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | |||||
102204 | 102204 | 107137 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 700X Stevenson St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/31/2014 12:00:00 AM | Permit Number 769156 | 6008444.340419999 | 2111440.4280000003 | 37.778089774899705 | -122.41433535624701 | (37.7780897748997, -122.414335356247) | |||
104018 | 104018 | 104932 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 717 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990427.0 | 2090598.0 | 37.7198333383806 | -122.47514125414499 | (37.7198333383806, -122.475141254145) | |||||
105479 | 105479 | 113740 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 1580 Valencia St | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006496.0 | 2100402.0 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | |||||
105896 | 105896 | 113726 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 1580 Valencia St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006496.0 | 2100402.0 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | |||||
106578 | 106578 | 111276 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 700X BOSWORTH ST | 14 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 5 | 6002150.0 | 2095428.0 | 37.73376790368221 | -122.434964255854 | (37.7337679036822, -122.434964255854) | ||||
106726 | 106726 | 105865 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 3615-3623X Cesar Chavez St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005538.0 | 2100417.0 | 37.747658358497404 | -122.423605504909 | (37.7476583584974, -122.423605504909) | |||||
108305 | 108305 | 107139 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 700X Stevenson St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/31/2014 12:00:00 AM | Permit Number 769156 | 6008444.340419999 | 2111440.4280000003 | 37.778089774899705 | -122.41433535624701 | (37.7780897748997, -122.414335356247) | |||
108788 | 108788 | 112483 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 1275 Columbus Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 08/03/2015 12:00:00 AM | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | ||||
115082 | 115082 | 104684 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 33 08th St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 770764 | 6008457.3 | 2111569.1 | 37.7784438055662 | -122.414299630615 | (37.7784438055662, -122.414299630615) | ||||
116489 | 116489 | 249681 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2400 Baker St | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 5999730.06735 | 2117240.34957 | 37.7935214825788 | -122.444898090975 | (37.7935214825788, -122.444898090975) | ||||
124124 | 124124 | 104679 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 33 08th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 770764 | 6008457.3 | 2111569.1 | 37.7784438055662 | -122.414299630615 | (37.7784438055662, -122.414299630615) | ||||
124356 | 124356 | 105861 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 3615-3623X Cesar Chavez St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005538.0 | 2100417.0 | 37.747658358497404 | -122.423605504909 | (37.7476583584974, -122.423605504909) | |||||
124454 | 124454 | 113730 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 1580 Valencia St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006496.0 | 2100402.0 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | |||||
125113 | 125113 | 122688 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 2590 Pacific Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 3x8 | 6001760.0 | 2117029.0 | 37.7930568116395 | -122.43785923271999 | (37.7930568116395, -122.43785923272) | |||
126769 | 126769 | 104685 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 33 08th St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 770764 | 6008457.3 | 2111569.1 | 37.7784438055662 | -122.414299630615 | (37.7784438055662, -122.414299630615) | ||||
128417 | 128417 | 105864 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 3615-3623X Cesar Chavez St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005538.0 | 2100417.0 | 37.747658358497404 | -122.423605504909 | (37.7476583584974, -122.423605504909) | |||||
128434 | 128434 | 105863 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 3615-3623X Cesar Chavez St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005538.0 | 2100417.0 | 37.747658358497404 | -122.423605504909 | (37.7476583584974, -122.423605504909) | |||||
137333 | 137333 | 249909 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 308 Greenwich St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | Width 0ft | 6011272.62588 | 2120428.81285 | 37.8029282059239 | -122.40518434420099 | (37.8029282059239, -122.405184344201) | |||
142616 | 142616 | 104933 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 755 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990427.0 | 2090598.0 | 37.7198333383806 | -122.47514125414499 | (37.7198333383806, -122.475141254145) | |||||
142822 | 142822 | 107138 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 700X Stevenson St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/31/2014 12:00:00 AM | Permit Number 769156 | 6008444.340419999 | 2111440.4280000003 | 37.778089774899705 | -122.41433535624701 | (37.7780897748997, -122.414335356247) | |||
143000 | 143000 | 105860 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 3615-3623X Cesar Chavez St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005538.0 | 2100417.0 | 37.747658358497404 | -122.423605504909 | (37.7476583584974, -122.423605504909) | |||||
145011 | 145011 | 113731 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 1580 Valencia St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006496.0 | 2100402.0 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | |||||
147172 | 147172 | 133181 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 165 Francisco St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6010456.661040001 | 2121322.6258799997 | 37.805336745057396 | -122.408071089728 | (37.8053367450574, -122.408071089728) | ||||
148136 | 148136 | 194683 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1 Jack Balestreri Way | 27 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6012398.62743 | 2104785.66422 | 37.7600386274099 | -122.400188468119 | (37.7600386274099, -122.400188468119) | ||||
148740 | 148740 | 194781 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 37 Maddux Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | Width 9ft | 6012782.01516 | 2095526.39332 | 37.734636019838 | -122.398212872552 | (37.734636019838, -122.398212872552) | |||
150663 | 150663 | 133180 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 150 Francisco St | 15 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6010437.48919 | 2121349.87905 | 37.80541050205729 | -122.40813935996 | (37.8054105020573, -122.40813935996) | ||||
150800 | 150800 | 194681 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1 Jack Balestreri Way | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6012405.53198 | 2104761.19385 | 37.759971822165 | -122.400162869837 | (37.759971822165, -122.400162869837) | ||||
157739 | 157739 | 235037 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 3944 22nd St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6002200.31935 | 2102977.67205 | 37.7545003908934 | -122.435330138992 | (37.7545003908934, -122.435330138992) | ||||
158580 | 158580 | 133176 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 150 Francisco St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 45 | 6010490.33512 | 2121337.17898 | 37.8053785896135 | -122.407955582591 | (37.8053785896135, -122.407955582591) | ||||
160710 | 160710 | 133179 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 150 Francisco St | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6010446.38311 | 2121337.68774 | 37.8053775257257 | -122.408107720898 | (37.8053775257257, -122.408107720898) | ||||
162241 | 162241 | 133183 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 165 Francisco St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6010500.28668 | 2121307.21814 | 37.8052968817183 | -122.40791902965401 | (37.8052968817183, -122.407919029654) | ||||
163462 | 163462 | 249912 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 356 Greenwich St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 0ft | 6011242.80215 | 2120418.17004 | 37.8028973160279 | -122.405286800351 | (37.8028973160279, -122.405286800351) | |||
163655 | 163655 | 133121 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 941 Vallejo St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6008863.72095 | 2118673.47701 | 37.7979735251223 | -122.41339621836201 | (37.7979735251223, -122.413396218362) | ||||
166784 | 166784 | 236175 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 44 Miguel St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6003673.81626 | 2097313.97042 | 37.73903275315379 | -122.429830447441 | (37.7390327531538, -122.429830447441) | ||||
169373 | 169373 | 249693 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2400 Baker St | 25 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 5999669.5395599995 | 2117354.78581 | 37.7938322397096 | -122.445115752098 | (37.7938322397096, -122.445115752098) | ||||
170191 | 170191 | 249696 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2400 Baker St | 28 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 5999680.27614 | 2117316.2653799998 | 37.7937270855963 | -122.44507583208599 | (37.7937270855963, -122.445075832086) | ||||
173428 | 173428 | 133190 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 165 Francisco St | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6010565.46337 | 2121315.97137 | 37.8053245646485 | -122.407694093918 | (37.8053245646485, -122.407694093918) | ||||
174924 | 174924 | 194782 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1951 Revere Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6013056.99295 | 2095889.1904 | 37.735647498126895 | -122.39728760775499 | (37.7356474981269, -122.397287607755) | ||||
176631 | 176631 | 133188 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 165 Francisco St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6010540.31188 | 2121313.86259 | 37.80531736647829 | -122.407780985508 | (37.8053173664783, -122.407780985508) | ||||
181198 | 181198 | 235053 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 3978 22nd St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6001977.7736 | 2102949.1513099996 | 37.7544094388586 | -122.436097718459 | (37.7544094388586, -122.436097718459) | ||||
183690 | 183690 | 249685 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2400 Baker St | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 5999728.9564 | 2117260.57889 | 37.793576963545796 | -122.444903389791 | (37.7935769635458, -122.444903389791) | ||||
183901 | 183901 | 249915 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 356 Greenwich St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 0ft | 6011213.4228 | 2120410.2337700003 | 37.8028738823843 | -122.405387909344 | (37.8028738823843, -122.405387909344) | |||
185958 | 185958 | 107058 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 600X Front St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/23/2014 12:00:00 AM | 14 | Permit Number 771755 | 6012887.2102 | 2118277.8013400002 | 37.797112176041004 | -122.39944591049601 | (37.797112176041, -122.399445910496) | ||
186379 | 186379 | 249717 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2500 Broderick St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | Width 7ft | 6000147.51069 | 2117427.0095900004 | 37.794057816679995 | -122.44346712302601 | (37.79405781668, -122.443467123026) | |||
188185 | 188185 | 133189 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 165 Francisco St | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6010562.1879199995 | 2121314.22329 | 37.8053195814974 | -122.40770530575399 | (37.8053195814974, -122.407705305754) | ||||
188577 | 188577 | 249695 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2400 Baker St | 27 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 5999678.04202 | 2117322.75965 | 37.7937447896309 | -122.445084029412 | (37.7937447896309, -122.445084029412) | ||||
188585 | 188585 | 133186 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 165 Francisco St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6010537.33866 | 2121307.06763 | 37.80529854275579 | -122.40779079533199 | (37.8052985427558, -122.407790795332) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");