Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▲ | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
55529 | 55529 | 198315 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 335 Ritch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6014439.67715 | 2111549.1897299998 | 37.778723367631706 | -122.39360278135 | (37.7787233676317, -122.39360278135) | |||
31590 | 31590 | 198270 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 101 Pennsylvania Ave | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6014327.719219999 | 2106393.16587 | 37.764559852075 | -122.39362912521099 | (37.764559852075, -122.393629125211) | ||||
65756 | 65756 | 198271 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 101 Pennsylvania Ave | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6014323.67834 | 2106481.09805 | 37.7648010700346 | -122.393649256519 | (37.7648010700346, -122.393649256519) | ||||
15030 | 15030 | 101775 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1700 Yosemite Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10 | 3x3 | Permit Number 19103 | 6014052.75296 | 2093112.8912 | 37.728079734566606 | -122.393650601914 | (37.7280797345666, -122.393650601914) | |
14258 | 14258 | 100759 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 362 Brannan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6014440.04423 | 2112282.11717 | 37.780735840838396 | -122.39365282322201 | (37.7807358408384, -122.393652823222) | |||
157443 | 157443 | 198316 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 335 Ritch St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6014420.45509 | 2111573.4890400004 | 37.7787890199415 | -122.39367097965099 | (37.7787890199415, -122.393670979651) | |||
51615 | 51615 | 198272 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 101 Pennsylvania Ave | 30 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6014300.74273 | 2106595.72792 | 37.765114544025295 | -122.393736609482 | (37.7651145440253, -122.393736609482) | ||||
24196 | 24196 | 198273 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 101 Pennsylvania Ave | 39 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6014246.68754 | 2106694.7124400004 | 37.7653833298046 | -122.393930504207 | (37.7653833298046, -122.393930504207) | ||||
28936 | 28936 | 49804 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1112SSIPPI 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2003 12:00:00 AM | 5 | Permit Number 46599 | 6014208.95643 | 2105755.12489 | 37.7628013312333 | -122.39399522840799 | (37.7628013312333, -122.393995228408) | |
171220 | 171220 | 198312 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 81 Lansing St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6014325.56305 | 2114147.83058 | 37.7858523015842 | -122.394179529164 | (37.7858523015842, -122.394179529164) | |||
37498 | 37498 | 198311 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 75 Lansing St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6014300.67476 | 2114126.83927 | 37.7857932808859 | -122.394264166169 | (37.7857932808859, -122.394264166169) | |||
55075 | 55075 | 74119 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 164 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/23/1994 12:00:00 AM | 7 | 6014130.8006 | 2112451.57445 | 37.7811839433263 | -122.39473452509199 | (37.7811839433263, -122.394734525092) | ||
173502 | 173502 | 73886 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 164 South Park | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/23/1994 12:00:00 AM | 7 | 6014128.33524 | 2112437.75054 | 37.78114584894679 | -122.39474208568701 | (37.7811458489468, -122.394742085687) | ||
176376 | 176376 | 70562 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 164 South Park | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/23/1994 12:00:00 AM | 8 | 6014127.69322 | 2112419.53716 | 37.7810958034577 | -122.39474303089199 | (37.7810958034577, -122.394743030892) | ||
183240 | 183240 | 198313 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 166 South Park | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6014097.81896 | 2112386.50971 | 37.7810034565764 | -122.39484406791 | (37.7810034565764, -122.39484406791) | |||
59628 | 59628 | 101974 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1230 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769454 | 6013882.9225 | 2105271.9580900003 | 37.7614565354174 | -122.39508902885099 | (37.7614565354174, -122.395089028851) | |
13559 | 13559 | 106005 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 59 Reddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3 | 3x3 | 6013632.51665 | 2093922.487 | 37.7302793593954 | -122.395160068985 | (37.7302793593954, -122.395160068985) | ||
175328 | 175328 | 198323 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1225 Mission Bay Blvd South | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6013802.38344 | 2108531.614 | 37.7704023517081 | -122.39559596947201 | (37.7704023517081, -122.395595969472) | ||||
148832 | 148832 | 198324 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1225 Mission Bay Blvd South | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6013797.10576 | 2108619.17547 | 37.77064248240121 | -122.39562036091101 | (37.7706424824012, -122.395620360911) | ||||
71393 | 71393 | 198322 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1225 Mission Bay Blvd South | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6013789.7693 | 2108510.1655 | 37.7703427572515 | -122.39563809912599 | (37.7703427572515, -122.395638099126) | ||||
49606 | 49606 | 198325 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1225 Mission Bay Blvd South | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6013787.22843 | 2108637.88784 | 37.770693312961996 | -122.39565583825899 | (37.770693312962, -122.395655838259) | ||||
59226 | 59226 | 198321 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1225 Mission Bay Blvd South | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6013777.96356 | 2108496.99922 | 37.7703059488766 | -122.39567801282601 | (37.7703059488766, -122.395678012826) | ||||
158639 | 158639 | 198326 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1225 Mission Bay Blvd South | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6013771.76611 | 2108656.94068 | 37.7707447676885 | -122.39571065823601 | (37.7707447676885, -122.395710658236) | ||||
66247 | 66247 | 198320 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1225 Mission Bay Blvd South | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6013760.20993 | 2108475.0165 | 37.7702446016405 | -122.39573788252 | (37.7702446016405, -122.39573788252) | ||||
91427 | 91427 | 50366 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 650 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | Permit Number 47033 | 6013801.09440663 | 2111163.84907188 | 37.777629805669996 | -122.39578489606001 | (37.77762980567, -122.39578489606) | |||
93182 | 93182 | 50365 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 650 04th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | Permit Number 47033 | 6013801.09440663 | 2111163.84907188 | 37.777629805669996 | -122.39578489606001 | (37.77762980567, -122.39578489606) | |||
107173 | 107173 | 50361 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 650 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | Permit Number 47033 | 6013801.09440663 | 2111163.84907188 | 37.777629805669996 | -122.39578489606001 | (37.77762980567, -122.39578489606) | |||
109247 | 109247 | 50364 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 650 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | Permit Number 47033 | 6013801.09440663 | 2111163.84907188 | 37.777629805669996 | -122.39578489606001 | (37.77762980567, -122.39578489606) | |||
120758 | 120758 | 50362 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 650 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | Permit Number 47033 | 6013801.09440663 | 2111163.84907188 | 37.777629805669996 | -122.39578489606001 | (37.77762980567, -122.39578489606) | |||
128496 | 128496 | 50363 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 650 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | Permit Number 47033 | 6013801.09440663 | 2111163.84907188 | 37.777629805669996 | -122.39578489606001 | (37.77762980567, -122.39578489606) | |||
173800 | 173800 | 198327 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1225 Mission Bay Blvd South | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6013747.40215 | 2108665.50559 | 37.7707669296806 | -122.395795534462 | (37.7707669296806, -122.395795534462) | ||||
75545 | 75545 | 198319 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1225 Mission Bay Blvd South | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6013741.4074800005 | 2108464.54508 | 37.7702148034894 | -122.395802186723 | (37.7702148034894, -122.395802186723) | ||||
67824 | 67824 | 198414 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3310 Jennings St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6013355.178590001 | 2089895.60565 | 37.71920692974621 | -122.39583681063299 | (37.7192069297462, -122.395836810633) | |||
56229 | 56229 | 83159 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 118 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52389 | 6013682.79491 | 2106471.12708 | 37.7647380590444 | -122.395865223811 | (37.7647380590444, -122.395865223811) | |
134417 | 134417 | 198415 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3310 Jennings St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6013330.68803 | 2089861.99882 | 37.7191132896144 | -122.39591911208299 | (37.7191132896144, -122.395919112083) | |||
180988 | 180988 | 198416 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1062 Key Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6013254.09143 | 2089864.5252900003 | 37.7191159651107 | -122.396184055957 | (37.7191159651107, -122.396184055957) | |||
186062 | 186062 | 198417 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1062 Key Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6013234.80615 | 2089878.55725 | 37.719153420980604 | -122.39625170116301 | (37.7191534209806, -122.396251701163) | |||
40939 | 40939 | 198418 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1062 Key Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6013212.31335 | 2089895.25282 | 37.7191980120665 | -122.396330620284 | (37.7191980120665, -122.396330620284) | |||
15863 | 15863 | 100892 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 91 Welsh St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6013627.65977 | 2112013.31498 | 37.7799525960738 | -122.396444426786 | (37.7799525960738, -122.396444426786) | |||
13583 | 13583 | 100891 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 91 Welsh St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6013606.47382 | 2111993.91964 | 37.7798981618967 | -122.396516359044 | (37.7798981618967, -122.396516359044) | |||
15396 | 15396 | 100890 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 91 Welsh St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6013579.59012 | 2111966.26913 | 37.779820743762606 | -122.39660742352 | (37.7798207437626, -122.39660742352) | |||
15713 | 15713 | 100889 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 91 Welsh St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6013566.0867800005 | 2111954.86803 | 37.7797886874229 | -122.396653338395 | (37.7797886874229, -122.396653338395) | |||
14587 | 14587 | 100888 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 91 Welsh St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6013550.27415 | 2111938.66795 | 37.7797433256341 | -122.396706905611 | (37.7797433256341, -122.396706905611) | |||
118685 | 118685 | 47248 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1060 Key Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/2011 12:00:00 AM | Permit Number 767222 | 6013087.98009516 | 2089992.50143255 | 37.7194581178311 | -122.39676721011699 | (37.7194581178311, -122.396767210117) | ||
165814 | 165814 | 198420 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 6500 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6012967.05358 | 2089962.4416099999 | 37.7193688481865 | -122.397183104734 | (37.7193688481865, -122.397183104734) | |||
16098 | 16098 | 100884 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 91 Welsh St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6013403.42787 | 2111798.46493 | 37.7793501860944 | -122.397205080544 | (37.7793501860944, -122.397205080544) | |||
57102 | 57102 | 198419 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 6504 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6012953.87538 | 2089942.68055 | 37.7193138546205 | -122.397227272216 | (37.7193138546205, -122.397227272216) | |||
23058 | 23058 | 37914 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1310 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/1998 12:00:00 AM | 1 | 3x3 | Permit Number 40177 | 6013291.37009 | 2106638.00873 | 37.7651744955273 | -122.397230772395 | (37.7651744955273, -122.397230772395) | |
85940 | 85940 | 37918 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1350X 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2014 12:00:00 AM | 3 | Permit Number 773093 | 6013279.95089898 | 2106637.32404771 | 37.765171979803 | -122.39727022087799 | (37.765171979803, -122.397270220878) | ||
14003 | 14003 | 100882 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 91 Welsh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6013366.225459999 | 2111763.75465 | 37.7792528084154 | -122.397331345366 | (37.7792528084154, -122.397331345366) | |||
169319 | 169319 | 37919 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1350X 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/1998 12:00:00 AM | 1 | Permit Number 40178 | 6013246.0105800005 | 2106636.31412 | 37.7651673171344 | -122.39738754222799 | (37.7651673171344, -122.397387542228) | ||
14801 | 14801 | 22531 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 6619 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/2015 08:00:00 AM | 3 | 3X3 | 6012836.07271 | 2089639.80613 | 37.7184756630977 | -122.397613243265 | (37.7184756630977, -122.397613243265) | ||
15100 | 15100 | 48913 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 77 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/13/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768553 | 6013169.41892 | 2106659.71709 | 37.765227311822294 | -122.397654097675 | (37.7652273118223, -122.397654097675) | |
69832 | 69832 | 48914 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 77 Connecticut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2002 12:00:00 AM | 5 | Permit Number 46108 | 6013168.90129 | 2106679.05343 | 37.7652803762994 | -122.39765724438601 | (37.7652803762994, -122.397657244386) | ||
173373 | 173373 | 48915 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 77 Connecticut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2002 12:00:00 AM | 4 | Permit Number 46108 | 6013168.45099 | 2106701.7102200002 | 37.7653425617443 | -122.397660391133 | (37.7653425617443, -122.397660391133) | ||
39379 | 39379 | 48916 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 77 Connecticut St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2002 12:00:00 AM | 5 | Permit Number 46108 | 6013166.41174 | 2106720.77544 | 37.765394797053496 | -122.39766878180299 | (37.7653947970535, -122.397668781803) | ||
16137 | 16137 | 98076 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 77 Connecticut St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/13/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768553 | 6013166.17293 | 2106738.89821 | 37.7654445448608 | -122.39767087902399 | (37.7654445448608, -122.397670879024) |
118604 | 118604 | 83318 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 451 Thornton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 3x3 | Permit Number 52301 | 6012894.80366142 | 2094333.94760377 | 37.7313680923787 | -122.397739309146 | (37.7313680923787, -122.397739309146) | ||
172207 | 172207 | 202299 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 136 Orsi Cir | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 6012821.534580001 | 2093069.43077 | 37.7278919084741 | -122.397903945525 | (37.7278919084741, -122.397903945525) | |||
81227 | 81227 | 42741 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 295 Tocoloma Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/2002 12:00:00 AM | Permit Number 45864 | 6012649.44440777 | 2087097.71305381 | 37.711485187600495 | -122.39808010272101 | (37.7114851876005, -122.398080102721) | ||
24368 | 24368 | 97053 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 87 Maddux Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/2011 12:00:00 AM | 4 | 2x3 | Permit Number 768205 | 6012721.3609 | 2095242.61214 | 37.7338534369729 | -122.39840267086399 | (37.7338534369729, -122.398402670864) | |
134103 | 134103 | 49502 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1707@ ARKANSAS 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/17/2004 12:00:00 AM | 5 | Permit Number 47606 | 6012899.84586 | 2104702.18795 | 37.7598373546339 | -122.398449125332 | (37.7598373546339, -122.398449125332) | |
77046 | 77046 | 198277 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1850 23rd St | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6012861.27204 | 2102882.9116700003 | 37.754839870590104 | -122.39845487738899 | (37.7548398705901, -122.398454877389) | |||
56163 | 56163 | 116375 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 50x Madera St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6012868.23872 | 2103276.4049 | 37.7559207054891 | -122.39845839373301 | (37.7559207054891, -122.398458393733) | |||
177925 | 177925 | 88053 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2041 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51063 | 6012715.7599599995 | 2096090.00312 | 37.736179884201704 | -122.398481475746 | (37.7361798842017, -122.398481475746) | |
185844 | 185844 | 68890 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 35 Exeter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 8 | Permit Number 32862 | 6012596.9510699995 | 2091063.5496200002 | 37.7223716575091 | -122.398539644797 | (37.7223716575091, -122.398539644797) | |
26251 | 26251 | 116376 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 50x Madera St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6012832.143680001 | 2103274.0879599997 | 37.7559123328161 | -122.39858306046801 | (37.7559123328161, -122.398583060468) | |||
32694 | 32694 | 104489 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 101X Arkansas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6012893.40207 | 2106545.4722700003 | 37.7648982471715 | -122.398600762736 | (37.7648982471715, -122.398600762736) | |||
53925 | 53925 | 68894 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 47 Exeter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 11 | Permit Number 32866 | 6012572.9149400005 | 2090991.6774900001 | 37.722172972090505 | -122.39861769156799 | (37.7221729720905, -122.398617691568) | |
167921 | 167921 | 104000 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 157 Apollo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2013 12:00:00 AM | 3 | 3x3 | Permit Number 58584 | 6012594.010480001 | 2094120.56345 | 37.7307654285701 | -122.39876424420099 | (37.7307654285701, -122.398764244201) | |
14912 | 14912 | 61587 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 835 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/31/2010 12:00:00 AM | 12 | 6x4.5 | Permit Number 53711 | 6012777.55952 | 2103581.4940400003 | 37.7567533616886 | -122.39879340469999 | (37.7567533616886, -122.3987934047) |
180922 | 180922 | 198304 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 199 New Montgomery St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6012859.7617 | 2114427.83429 | 37.7865395445998 | -122.39927048966801 | (37.7865395445998, -122.399270489668) | |||
184538 | 184538 | 100471 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2 Crane St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2012 12:00:00 AM | 2 | 3x3 | Permit Number 769206 | 6012374.98009 | 2091340.69375 | 37.723120270254 | -122.39932639780899 | (37.723120270254, -122.399326397809) | |
176029 | 176029 | 198305 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 199 New Montgomery St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6012839.768519999 | 2114446.84253 | 37.786590622517096 | -122.39934099648501 | (37.7865906225171, -122.399340996485) | |||
83950 | 83950 | 45700 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 399 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2004 12:00:00 AM | Permit Number 47440 | 6012660.71426976 | 2112434.35553992 | 37.7810548194134 | -122.39981911790701 | (37.7810548194134, -122.399819117907) | |||
48703 | 48703 | 136949 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 915 Front St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6012733.733109999 | 2118974.78929 | 37.7990173826009 | -122.400025954359 | (37.7990173826009, -122.400025954359) | |||
155949 | 155949 | 136948 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 915 Front St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6012731.24873 | 2118997.87566 | 37.7990806337212 | -122.400036173353 | (37.7990806337212, -122.400036173353) | |||
35277 | 35277 | 136947 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 915 Front St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6012726.66985 | 2119026.8860400002 | 37.799160033972 | -122.400054056345 | (37.799160033972, -122.400054056345) | |||
57427 | 57427 | 56140 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 788 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53594 | 6012400.21766 | 2104278.3607900003 | 37.7586457727003 | -122.400147339446 | (37.7586457727003, -122.400147339446) | |
48325 | 48325 | 136956 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 225 Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6012358.49357 | 2116085.98474 | 37.7910644861899 | -122.401121320516 | (37.7910644861899, -122.401121320516) | |||
64622 | 64622 | 198302 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2651 Phelps St | 4 | : 4 | Tree 1 | Private 1 | 9 | Width 4ft | 6011892.6623 | 2093405.69149 | 37.7287634360827 | -122.40113871700301 | (37.7287634360827, -122.401138717003) | |||
71676 | 71676 | 198301 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2651 Phelps St | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6011883.57095 | 2093392.9889900002 | 37.728728050461 | -122.401169254354 | (37.728728050461, -122.401169254354) | |||
50074 | 50074 | 198300 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2651 Phelps St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6011874.28273 | 2093380.6999 | 37.7286937889864 | -122.40120050131 | (37.7286937889864, -122.40120050131) | |||
133474 | 133474 | 59489 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1029 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51129 | 6011954.00169 | 2103318.43549 | 37.75598513922839 | -122.401623098137 | (37.7559851392284, -122.401623098137) | |
30973 | 30973 | 198274 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1236 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011932.48905 | 2102621.16084 | 37.7540693755115 | -122.401648489597 | (37.7540693755115, -122.401648489597) | |||
63008 | 63008 | 114541 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1001X Rhode Island St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/24/2015 12:00:00 AM | 1 | Permit Number 774983 | 6011939.68484 | 2103650.19837 | 37.756895288204 | -122.401695928834 | (37.756895288204, -122.401695928834) | ||
34908 | 34908 | 52183 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2230 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/2005 12:00:00 AM | 5 | Permit Number 48373 | 6011742.35118 | 2096927.06221 | 37.738423995777104 | -122.401905791943 | (37.7384239957771, -122.401905791943) | |
150833 | 150833 | 97956 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2280x McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2011 12:00:00 AM | 1 | 3x3 | Permit Number 768057 | 6011739.12667 | 2098678.3172400002 | 37.7432323892731 | -122.40204002115499 | (37.7432323892731, -122.402040021155) | |
93959 | 93959 | 42229 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 21 Merlin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42485 | 6011996.26663606 | 2111495.41936146 | 37.7784396539352 | -122.402051758962 | (37.7784396539352, -122.402051758962) | ||
151131 | 151131 | 97958 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2280X McKinnon Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2011 12:00:00 AM | 2 | 3x3 | Permit Number 768057 | 6011714.55105 | 2098696.24817 | 37.7432802520847 | -122.402126258043 | (37.7432802520847, -122.402126258043) | |
151647 | 151647 | 97959 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2280X McKinnon Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2011 12:00:00 AM | 1 | 3x3 | Permit Number 768057 | 6011701.54939 | 2098706.65667 | 37.743308105886506 | -122.40217194628299 | (37.7433081058865, -122.402171946283) | |
146618 | 146618 | 97960 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2280X McKinnon Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2011 12:00:00 AM | 2 | 3x3 | Permit Number 768057 | 6011686.23984 | 2098718.09501 | 37.7433386585668 | -122.40222568708401 | (37.7433386585668, -122.402225687084) | |
176442 | 176442 | 97961 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2280X McKinnon Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2011 12:00:00 AM | 2 | 3x3 | Permit Number 768057 | 6011645.30787 | 2098748.77937 | 37.743420626377294 | -122.402369377168 | (37.7434206263773, -122.402369377168) | |
16442 | 16442 | 68888 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1958 Donner Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1993 12:00:00 AM | 15 | 3x3 | Permit Number 32860 | 6011521.066430001 | 2093598.7946799998 | 37.7292729200062 | -122.40243692791701 | (37.7292729200062, -122.402436927917) | |
39498 | 39498 | 198275 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1199 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 1ft | 6011697.22277 | 2102839.72016 | 37.754656360309994 | -122.40247746938 | (37.75465636031, -122.40247746938) | |||
114056 | 114056 | 38182 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 50 Dwight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767436 | 6011424.50810189 | 2091670.61137226 | 37.723973136733896 | -122.40263519968501 | (37.7239731367339, -122.402635199685) | |
77493 | 77493 | 50330 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 800 Howard St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | Permit Number 47027 | 6011804.62749252 | 2113253.78285817 | 37.783257013527496 | -122.40283841310101 | (37.7832570135275, -122.402838413101) | |||
78993 | 78993 | 50337 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 800 Howard St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | Permit Number 47027 | 6011804.62749252 | 2113253.78285817 | 37.783257013527496 | -122.40283841310101 | (37.7832570135275, -122.402838413101) | |||
81429 | 81429 | 50329 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 800 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | Permit Number 47027 | 6011804.62749252 | 2113253.78285817 | 37.783257013527496 | -122.40283841310101 | (37.7832570135275, -122.402838413101) | |||
82016 | 82016 | 50342 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 800 Howard St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | Permit Number 47027 | 6011804.62749252 | 2113253.78285817 | 37.783257013527496 | -122.40283841310101 | (37.7832570135275, -122.402838413101) |
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");