trees
11,761 rows where qSpecies_id = 17 sorted by TreeID
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
190141 | 100043 | Significant Tree 6 | Tree(s) :: 17 | 50 Bronte St | 1 | Front Yard : Yard | Tree | Private 2 | 07/12/2012 12:00:00 AM | Permit Number 769001 | 6009337 | 2097155 | 37.7389153282678 | -122.410238449764 | (37.7389153282678, -122.410238449764) | 10 | 7 | 7 | 28859 | 2 | |||
58309 | 100046 | Property Tree 8 | Tree(s) :: 17 | 562 28th St | Front Yard : Yard | Tree | Private 2 | 11/28/2012 12:00:00 AM | 17 | Permit Number 769057 | 6002262 | 2099459 | 37.7448424535299 | -122.434865213189 | (37.7448424535299, -122.434865213189) | 2 | 7 | 5 | 63 | 22 | |||
26755 | 100057 | Undocumented 4 | Tree(s) :: 17 | 240 05th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/2012 12:00:00 AM | 12 | 3x3 | Permit Number 769058 | 6011351 | 2112431 | 37.7809725048626 | -122.404349860228 | (37.7809725048626, -122.404349860228) | 14 | 2 | 9 | 28853 | 34 | |
133766 | 100058 | Undocumented 4 | Tree(s) :: 17 | 240 05th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/2012 12:00:00 AM | 12 | 3x3 | Permit Number 769058 | 6011351 | 2112431 | 37.7809725048626 | -122.404349860228 | (37.7809725048626, -122.404349860228) | 14 | 2 | 9 | 28853 | 34 | |
120243 | 100061 | Undocumented 4 | Tree(s) :: 17 | 430X Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/2012 12:00:00 AM | 3x3 | Permit Number 768595 | 6011459 | 2112320 | 37.7806737592872 | -122.403968419194 | (37.7806737592872, -122.403968419194) | 14 | 2 | 9 | 28853 | 34 | ||
193832 | 100062 | Undocumented 4 | Tree(s) :: 17 | 430X Clementina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/2012 12:00:00 AM | 3x3 | Permit Number 768595 | 6011459 | 2112320 | 37.7806737592872 | -122.403968419194 | (37.7806737592872, -122.403968419194) | 14 | 2 | 9 | 28853 | 34 | ||
81685 | 100063 | Undocumented 4 | Tree(s) :: 17 | 430X Clementina St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/2012 12:00:00 AM | 3x3 | Permit Number 768595 | 6011459 | 2112320 | 37.7806737592872 | -122.403968419194 | (37.7806737592872, -122.403968419194) | 14 | 2 | 9 | 28853 | 34 | ||
159612 | 100064 | Undocumented 4 | Tree(s) :: 17 | 430X Clementina St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/2012 12:00:00 AM | 3x3 | Permit Number 768595 | 6011459 | 2112320 | 37.7806737592872 | -122.403968419194 | (37.7806737592872, -122.403968419194) | 14 | 2 | 9 | 28853 | 34 | ||
30075 | 100070 | Property Tree 8 | Tree(s) :: 17 | 331 Serrano Dr | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 777990 | 5990400 | 2090718 | 37.7201612636948 | -122.475243338807 | (37.7201612636948, -122.475243338807) | 1 | 8 | 4 | 64 | 40 | ||||
52216 | 100074 | Undocumented 4 | Tree(s) :: 17 | 701 Noe St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003070 | 2104166 | 37.7578126071811 | -122.432407426584 | (37.7578126071811, -122.432407426584) | 2 | 4 | 5 | 28862 | 3 | ||||||
184029 | 100075 | Undocumented 4 | Tree(s) :: 17 | 707-709 Noe St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003067 | 2104139 | 37.7577383015231 | -122.432415873427 | (37.7577383015231, -122.432415873427) | 2 | 4 | 5 | 28862 | 3 | |||||
120574 | 100092 | Undocumented 4 | Tree(s) :: 17 | 11X Shotwell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6007856.7 | 2107724 | 37.7678523153445 | -122.416104954993 | (37.7678523153445, -122.416104954993) | 8 | 4 | 7 | 28853 | 19 | |||
116514 | 100095 | Permitted Site 7 | Tree(s) :: 17 | 4372 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | Private | 07/03/2012 12:00:00 AM | 3x3 | Permit Number 769070 | 6001507 | 2100613.7 | 37.7479700909705 | -122.43755853273 | (37.7479700909705, -122.43755853273) | 2 | 4 | 5 | 28862 | 22 | |
107208 | 100135 | Undocumented 4 | Tree(s) :: 17 | 155 05th St | 1 | Front Yard : Yard | Tree | Private 2 | 11/27/2012 12:00:00 AM | 9 | Permit Number 769351 | 6011029.6 | 2112857.4 | 37.7821253339557 | -122.405491786923 | (37.7821253339557, -122.405491786923) | 12 | 2 | 9 | 28853 | 34 | ||
97699 | 100137 | Undocumented 4 | Tree(s) :: 17 | 155 05th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 769024 | 6011029.6 | 2112857.4 | 37.7821253339557 | -122.405491786923 | (37.7821253339557, -122.405491786923) | 12 | 2 | 9 | 28853 | 34 | |||
39248 | 100138 | Undocumented 4 | Tree(s) :: 17 | 155 05th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 769024 | 6011029.6 | 2112857.4 | 37.7821253339557 | -122.405491786923 | (37.7821253339557, -122.405491786923) | 12 | 2 | 9 | 28853 | 34 | |||
95526 | 100139 | Property Tree 8 | Tree(s) :: 17 | 155 05th St | 2 | Front Yard : Yard | Tree | Private 2 | Permit Number 769024 | 6011029.6 | 2112857.4 | 37.7821253339557 | -122.405491786923 | (37.7821253339557, -122.405491786923) | 12 | 2 | 9 | 28853 | 34 | ||||
26011 | 100148 | Property Tree 8 | Tree(s) :: 17 | 209 Vicksburg St | Back Yard : Yard | Tree | Private 2 | 6004141 | 2102142 | 37.7523158521071 | -122.428559192815 | (37.7523158521071, -122.428559192815) | 2 | 4 | 5 | 28862 | 22 | ||||||
136685 | 100149 | Undocumented 4 | Tree(s) :: 17 | 3975 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6003144 | 2105325 | 37.7609991391758 | -122.432234274425 | (37.7609991391758, -122.432234274425) | 2 | 4 | 5 | 28862 | 3 | |||
171295 | 100170 | DPW Maintained 1 | Tree(s) :: 17 | 2149 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769012 | 5997531 | 2110183 | 37.7740181145799 | -122.451997596236 | (37.7740181145799, -122.451997596236) | 15 | 5 | 11 | 29492 | 16 | |
133313 | 100174 | Undocumented 4 | Tree(s) :: 17 | 50 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2012 12:00:00 AM | 18 | 3x3 | Permit Number 769094 | 6010932.2 | 2114627.3 | 37.7869796149513 | -122.405953468587 | (37.7869796149513, -122.405953468587) | 5 | 10 | 10 | 28857 | 6 | |
38085 | 100183 | Permitted Site 7 | Tree(s) :: 17 | 956 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003075.2 | 2102641.9 | 37.7536280862965 | -122.432280596021 | (37.7536280862965, -122.432280596021) | 2 | 4 | 5 | 28862 | 22 | ||||
34066 | 100190 | Undocumented 4 | Tree(s) :: 17 | 404 Noriega St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/07/2016 12:00:00 AM | Permit Number 776979 | 5992802 | 2103239 | 37.754679716601 | -122.467850713731 | (37.754679716601, -122.467850713731) | 1 | 8 | 4 | 56 | 12 | |||
64294 | 100207 | Permitted Site 7 | Tree(s) :: 17 | 149X Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006751.8 | 2098740.3 | 37.7431229579688 | -122.419289320387 | (37.7431229579688, -122.419289320387) | 2 | 7 | 7 | 28859 | 2 | ||||
65243 | 100210 | Permitted Site 7 | Tree(s) :: 17 | 701 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2012 12:00:00 AM | Permit Number 769013 | 6011921.4 | 2105078.9 | 37.7608171664666 | -122.401859591355 | (37.7608171664666, -122.401859591355) | 10 | 3 | 8 | 28856 | 29 | |||
160532 | 100223 | Permitted Site 7 | Tree(s) :: 17 | 3841 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2012 12:00:00 AM | 3x3 | Permit Number 769110 | 6004154.3 | 2102433.2 | 37.75311617172 | -122.428533954088 | (37.75311617172, -122.428533954088) | 2 | 4 | 5 | 28862 | 22 | |
135684 | 100224 | Permitted Site 7 | Tree(s) :: 17 | 101X Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2012 12:00:00 AM | 3x3 | Permit Number 769110 | 6004128.9 | 2102465.7 | 37.7532039716563 | -122.428624108827 | (37.7532039716563, -122.428624108827) | 2 | 4 | 5 | 28862 | 22 | |
67433 | 100225 | Permitted Site 7 | Tree(s) :: 17 | 101X Vicksburg St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2012 12:00:00 AM | 3x3 | Permit Number 769110 | 6004128.9 | 2102465.7 | 37.7532039716563 | -122.428624108827 | (37.7532039716563, -122.428624108827) | 2 | 4 | 5 | 28862 | 22 | |
88857 | 100242 | DPW Maintained 1 | Tree(s) :: 17 | 76 Linda St | Sidewalk: Curb side : Pot | Landscaping | Private 2 | 6005815 | 2105046 | 37.76038415245 | -122.422976606568 | (37.76038415245, -122.422976606568) | 2 | 4 | 5 | 28859 | 19 | ||||||
86075 | 100243 | Private 9 | Tree(s) :: 17 | 1326-1332 Shotwell St | unknown : Yard | Tree | Private 2 | 6008043 | 2100485 | 37.7479861507453 | -122.414948142067 | (37.7479861507453, -122.414948142067) | 2 | 7 | 7 | 28859 | 2 | ||||||
77007 | 100345 | Permitted Site 7 | Tree(s) :: 17 | 1190 Mission St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2012 12:00:00 AM | 3x3 | Permit Number 767726 | 6008690.2 | 2111553.5 | 37.7784140515871 | -122.413492835489 | (37.7784140515871, -122.413492835489) | 8 | 2 | 9 | 28853 | 34 | ||
32053 | 100346 | Permitted Site 7 | Tree(s) :: 17 | 1190 Mission St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2012 12:00:00 AM | 3x3 | Permit Number 767726 | 6008690.2 | 2111553.5 | 37.7784140515871 | -122.413492835489 | (37.7784140515871, -122.413492835489) | 8 | 2 | 9 | 28853 | 34 | ||
81725 | 100347 | Permitted Site 7 | Tree(s) :: 17 | 1190 Mission St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2012 12:00:00 AM | 3x3 | Permit Number 767726 | 6008690.2 | 2111553.5 | 37.7784140515871 | -122.413492835489 | (37.7784140515871, -122.413492835489) | 8 | 2 | 9 | 28853 | 34 | ||
189527 | 100353 | DPW Maintained 1 | Tree(s) :: 17 | 1433 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2012 12:00:00 AM | 19 | 5.5x5 | Permit Number 769238 | 5982739.2 | 2105368.2 | 37.7599396927354 | -122.502807623041 | (37.7599396927354, -122.502807623041) | 1 | 8 | 3 | 56 | 35 | |
180223 | 100354 | Undocumented 4 | Tree(s) :: 17 | 1242 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5982470.7 | 2106644.2 | 37.7634274417273 | -122.503830723516 | (37.7634274417273, -122.503830723516) | 1 | 8 | 3 | 56 | 35 | |||||
150357 | 100434 | Significant Tree 6 | Tree(s) :: 17 | 2430 Sacramento St | 1 | Front Yard : Yard | Tree | Private 2 | 09/24/2012 12:00:00 AM | Permit Number 769154 | 6003168.3 | 2115899 | 37.7900341016439 | -122.432905672523 | (37.7900341016439, -122.432905672523) | 13 | 9 | 1 | 29490 | 27 | |||
33964 | 100435 | Permitted Site 7 | Tree(s) :: 17 | 2601 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | Permit Number 769212 | 5999189 | 2117684 | 37.7947087350095 | -122.446802156989 | (37.7947087350095, -122.446802156989) | 11 | 1 | 57 | 30 | ||||
128648 | 100443 | DPW Maintained 1 | Tree(s) :: 17 | 1121 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/15/2013 12:00:00 AM | 30 | 3x3 | Permit Number 770213 | 6015052.9 | 2090170.3 | 37.7200554875823 | -122.389987561534 | (37.7200554875823, -122.389987561534) | 10 | 3 | 8 | 58 | 1 | |
75453 | 100529 | Significant Tree 6 | Tree(s) :: 17 | 720 Victoria St | 1 | Front Yard : Yard | Tree | Private 2 | 09/24/2012 12:00:00 AM | Permit Number 769203 | 5993611.6 | 2091925.6 | 37.723662667106 | -122.464229627127 | (37.723662667106, -122.464229627127) | 9 | 8 | 4 | 59 | 40 | |||
84980 | 100553 | Permitted Site 7 | Tree(s) :: 17 | 4443 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6001193.1 | 2104609.9 | 37.7589248414166 | -122.438930324474 | (37.7589248414166, -122.438930324474) | 2 | 4 | 5 | 28862 | 3 | |||||
176029 | 100562 | Undocumented 4 | Tree(s) :: 17 | 54 Lafayette St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6007557 | 2109603 | 37.7729947504972 | -122.417274753769 | (37.7729947504972, -122.417274753769) | 8 | 2 | 9 | 28853 | 19 | |||
35186 | 100579 | Significant Tree 6 | Tree(s) :: 17 | 35 Lloyd St | 2 | Front Yard : Yard | Tree | Private 2 | 6002279.7 | 2108550 | 37.7698051576272 | -122.435454215606 | (37.7698051576272, -122.435454215606) | 15 | 5 | 5 | 29492 | 9 | |||||
145784 | 100586 | Permitted Site 7 | Tree(s) :: 17 | 401x Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
88290 | 100587 | Permitted Site 7 | Tree(s) :: 17 | 401x Clementina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
183977 | 100588 | Permitted Site 7 | Tree(s) :: 17 | 401x Clementina St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
20171 | 100589 | Permitted Site 7 | Tree(s) :: 17 | 401x Clementina St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
66567 | 100590 | Permitted Site 7 | Tree(s) :: 17 | 401x Clementina St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
131160 | 100591 | Permitted Site 7 | Tree(s) :: 17 | 401x Clementina St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
130331 | 100592 | Permitted Site 7 | Tree(s) :: 17 | 401x Clementina St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
193164 | 100593 | Permitted Site 7 | Tree(s) :: 17 | 401x Clementina St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
142915 | 100594 | Permitted Site 7 | Tree(s) :: 17 | 401x Clementina St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
193 | 100595 | Permitted Site 7 | Tree(s) :: 17 | 401x Clementina St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
76152 | 100596 | Permitted Site 7 | Tree(s) :: 17 | 401x Clementina St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
107648 | 100597 | Permitted Site 7 | Tree(s) :: 17 | 401x Clementina St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
7539 | 100598 | Permitted Site 7 | Tree(s) :: 17 | 401x Clementina St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
155891 | 100599 | Permitted Site 7 | Tree(s) :: 17 | 401x Clementina St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
100844 | 100600 | Permitted Site 7 | Tree(s) :: 17 | 401x Clementina St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
92101 | 100601 | Permitted Site 7 | Tree(s) :: 17 | 401x Clementina St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
158 | 100607 | Permitted Site 7 | Tree(s) :: 17 | 270x 05th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011410.5 | 2112131.8 | 37.7801542961347 | -122.404122955966 | (37.7801542961347, -122.404122955966) | 14 | 2 | 9 | 28853 | 34 | |||||
69062 | 100608 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
50451 | 100609 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
80857 | 100610 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
12696 | 100611 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
62153 | 100612 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
134931 | 100613 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
159461 | 100614 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
193030 | 100615 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
42477 | 100616 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
164572 | 100617 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
127147 | 100618 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
176695 | 100619 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
26498 | 100620 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
129355 | 100621 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
137134 | 100622 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
79816 | 100623 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
29190 | 100630 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
172227 | 100631 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
30346 | 100632 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
163585 | 100633 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
43213 | 100634 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
117734 | 100635 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
31002 | 100636 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
521 | 100638 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
70050 | 100639 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
25394 | 100640 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
26937 | 100641 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
139959 | 100642 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
181113 | 100643 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
2153 | 100644 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
132073 | 100645 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
36091 | 100646 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
138176 | 100651 | Permitted Site 7 | Tree(s) :: 17 | 3047 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/28/2012 12:00:00 AM | 0 | 3x3 | Permit Number 769350 | 5999416 | 2119261 | 37.7990517217573 | -122.446130197749 | (37.7990517217573, -122.446130197749) | 13 | 9 | 1 | 57 | 17 | |
115503 | 100654 | Undocumented 4 | Tree(s) :: 17 | 590X Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2017 12:00:00 AM | 3 | Permit Number 778778 | 5992503 | 2104630 | 37.7584817696578 | -122.468985951036 | (37.7584817696578, -122.468985951036) | 1 | 8 | 4 | 56 | 12 | ||
84387 | 100665 | Permitted Site 7 | Tree(s) :: 17 | 63 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/04/2012 12:00:00 AM | 3x3 | Permit Number 769258 | 6003201.8 | 2107946.7 | 37.7682009695292 | -122.432221606092 | (37.7682009695292, -122.432221606092) | 15 | 5 | 5 | 28862 | 3 | |
233 | 100684 | Undocumented 4 | Tree(s) :: 17 | 400 California St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6012367 | 2116823 | 37.7930886299645 | -122.401143699021 | (37.7930886299645, -122.401143699021) | 4 | 1 | 10 | 28854 | 6 | |||||
8218 | 100711 | Significant Tree 6 | Tree(s) :: 17 | 966-968 Guerrero St | 1 | Front Yard : Yard | Tree | Private 2 | 09/27/2012 12:00:00 AM | 14 | Permit Number 769148 | 6005605.8 | 2103343.5 | 37.7556976788024 | -122.423579088745 | (37.7556976788024, -122.423579088745) | 2 | 4 | 5 | 28859 | 19 | ||
118683 | 100743 | Permitted Site 7 | Tree(s) :: 17 | 448 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001794 | 2103231 | 37.7551728852459 | -122.436753428301 | (37.7551728852459, -122.436753428301) | 2 | 4 | 5 | 28862 | 22 | ||||
149709 | 100744 | Permitted Site 7 | Tree(s) :: 17 | 760 Duboce Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2012 12:00:00 AM | 3x3 | Permit Number 769249 | 6002024.1 | 2108325.5 | 37.7691742163209 | -122.436322258742 | (37.7691742163209, -122.436322258742) | 15 | 5 | 5 | 29492 | 9 | ||
23833 | 100765 | Undocumented 4 | Tree(s) :: 17 | 5 Bernice St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6008581 | 2108519.7 | 37.7700778198991 | -122.413655963874 | (37.7700778198991, -122.413655963874) | 8 | 2 | 9 | 28853 | 19 | |||
125152 | 100768 | Undocumented 4 | Tree(s) :: 17 | 5 Bernice St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6008581 | 2108519.7 | 37.7700778198991 | -122.413655963874 | (37.7700778198991, -122.413655963874) | 8 | 2 | 9 | 28853 | 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) );