Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▲ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 85354 | 85354 | 116746 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 9x BLANKEN AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011671.0 | 2087411.0 | 37.71229086541071 | -122.40148388608 | (37.7122908654107, -122.40148388608) | ||||
| 88764 | 88764 | 116749 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 9x BLANKEN AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011671.0 | 2087411.0 | 37.71229086541071 | -122.40148388608 | (37.7122908654107, -122.40148388608) | ||||
| 108617 | 108617 | 116747 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 9x BLANKEN AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011671.0 | 2087411.0 | 37.71229086541071 | -122.40148388608 | (37.7122908654107, -122.40148388608) | ||||
| 120023 | 120023 | 116748 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 9x BLANKEN AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011671.0 | 2087411.0 | 37.71229086541071 | -122.40148388608 | (37.7122908654107, -122.40148388608) | ||||
| 41263 | 41263 | 218719 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 99x San Marcos Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 5ft | 5993701.46816 | 2100309.93296 | 37.7466891448909 | -122.464527467374 | (37.7466891448909, -122.464527467374) | |||
| 74481 | 74481 | 218721 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 99x San Marcos Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 5ft | 5993716.07745 | 2100297.78462 | 37.746656630797794 | -122.464476068412 | (37.7466566307978, -122.464476068412) | |||
| 147824 | 147824 | 218720 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 99x San Marcos Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 5ft | 5993709.38363 | 2100297.55504 | 37.746655614559295 | -122.464499198102 | (37.7466556145593, -122.464499198102) | |||
| 144546 | 144546 | 33745 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 99x SAN JOSE AVE | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/1996 12:00:00 AM | 10 | 4x4 | Permit Number 37802 | 6006338.0 | 2102697.0 | 37.7539638411405 | -122.421001003808 | (37.7539638411405, -122.421001003808) | |
| 105254 | 105254 | 20129 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 999X Hayes St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/09/2008 12:00:00 AM | 18 | 3X3 | 6003226.6736 | 2110648.3783 | 37.7756205244718 | -122.432328548686 | (37.7756205244718, -122.432328548686) | ||
| 4844 | 4844 | 253688 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 999 Natoma St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6007970.79373767 | 2109754.69864739 | 37.7734345505501 | -122.415854130267 | (37.7734345505501, -122.415854130267) | ||||
| 4848 | 4848 | 31890 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 999 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/2006 12:00:00 AM | Permit Number 35322 | 6007970.79373767 | 2109754.69864739 | 37.7734345505501 | -122.415854130267 | (37.7734345505501, -122.415854130267) | ||
| 24404 | 24404 | 246777 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 999 Esmeralda Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6009797.217759999 | 2098767.51115 | 37.743368720206206 | -122.408760953364 | (37.7433687202062, -122.408760953364) | |||
| 67586 | 67586 | 241911 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 996 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007559.6207 | 2103883.79865 | 37.7572913055712 | -122.416860415884 | (37.7572913055712, -122.416860415884) | |||
| 82931 | 82931 | 42950 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 996 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | Permit Number 42843 | 6007571.84518521 | 2103864.78808287 | 37.7572397945138 | -122.416816791906 | (37.7572397945138, -122.416816791906) | |||
| 125267 | 125267 | 42949 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 996 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | Permit Number 42843 | 6007571.84518521 | 2103864.78808287 | 37.7572397945138 | -122.416816791906 | (37.7572397945138, -122.416816791906) | |||
| 135700 | 135700 | 241910 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 996 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007560.04138 | 2103904.33435 | 37.7573477155531 | -122.41686041589199 | (37.7573477155531, -122.416860415892) | |||
| 127318 | 127318 | 105924 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 995 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2014 12:00:00 AM | 3x3 | Permit Number 769111 | 6007873.5 | 2115092.6 | 37.7880856736468 | -122.41656888184099 | (37.7880856736468, -122.416568881841) | ||
| 165404 | 165404 | 198191 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 994 Le Conte Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6013245.776869999 | 2089519.2766200001 | 37.7181675184984 | -122.39618861282 | (37.7181675184984, -122.39618861282) | |||
| 184113 | 184113 | 198192 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 994 Le Conte Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6013231.441819999 | 2089529.73255 | 37.7181954307556 | -122.39623889571699 | (37.7181954307556, -122.396238895717) | |||
| 112018 | 112018 | 20131 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 990X Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2007 12:00:00 AM | 3 | 3X3 | 6003129.07268 | 2110685.22533 | 37.7757161626447 | -122.43266880658399 | (37.7757161626447, -122.432668806584) | ||
| 27492 | 27492 | 242247 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 99 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003349.42995 | 2108514.94087 | 37.7697695896261 | -122.43175154590901 | (37.7697695896261, -122.431751545909) | |||
| 52830 | 52830 | 242248 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 99 Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003353.64 | 2108490.0509599997 | 37.7697014866621 | -122.43173520612 | (37.7697014866621, -122.43173520612) | |||
| 54709 | 54709 | 242249 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 99 Steiner St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003360.64283 | 2108454.84052 | 37.7696052043469 | -122.431708469274 | (37.7696052043469, -122.431708469274) | |||
| 76942 | 76942 | 242246 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 99 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003347.84858 | 2108542.3420700002 | 37.7698447369831 | -122.43175897252199 | (37.7698447369831, -122.431758972522) | |||
| 159316 | 159316 | 242250 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 99 Steiner St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003364.83525 | 2108429.09579 | 37.7695347532487 | -122.431692129502 | (37.7695347532487, -122.431692129502) | |||
| 72052 | 72052 | 214980 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 99 Chaves Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996774.676 | 2098563.58789 | 37.742070792541796 | -122.453774598332 | (37.7420707925418, -122.453774598332) | |||
| 164384 | 164384 | 242200 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 99 Belcher St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6003829.67017 | 2107803.36453 | 37.767842984589706 | -122.430039640543 | (37.7678429845897, -122.430039640543) | |||
| 180442 | 180442 | 242199 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 99 Belcher St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6003832.05636 | 2107789.0762099996 | 37.767803887468204 | -122.43003036761299 | (37.7678038874682, -122.430030367613) | |||
| 96885 | 96885 | 36396 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 98X COLON AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39329 | 5996199.0 | 2093723.0 | 37.728746692627205 | -122.45541532696501 | (37.7287466926272, -122.455415326965) | ||
| 113250 | 113250 | 36399 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 98X COLON AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39329 | 5996199.0 | 2093723.0 | 37.728746692627205 | -122.45541532696501 | (37.7287466926272, -122.455415326965) | ||
| 119812 | 119812 | 36397 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 98X COLON AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39329 | 5996199.0 | 2093723.0 | 37.728746692627205 | -122.45541532696501 | (37.7287466926272, -122.455415326965) | ||
| 126810 | 126810 | 36401 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 98X COLON AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39329 | 5996199.0 | 2093723.0 | 37.728746692627205 | -122.45541532696501 | (37.7287466926272, -122.455415326965) | ||
| 8334 | 8334 | 103272 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 989 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770109 | 6007882.34676 | 2115110.89774 | 37.7881364123041 | -122.416539570166 | (37.7881364123041, -122.416539570166) | |
| 113948 | 113948 | 17005 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 988 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/05/2015 11:46:00 AM | 3 | 3X3 | 6002274.9132 | 2109899.1296 | 37.7735092615764 | -122.435567303378 | (37.7735092615764, -122.435567303378) | ||
| 160259 | 160259 | 198077 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 987 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6012517.13544 | 2103383.6869 | 37.756195712775295 | -122.399680164128 | (37.7561957127753, -122.399680164128) | |||
| 121806 | 121806 | 241694 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 986 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6005675.10731 | 2103244.45106 | 37.7554296252817 | -122.423332360924 | (37.7554296252817, -122.423332360924) | |||
| 18553 | 18553 | 17006 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 985 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/2007 12:00:00 AM | 3 | 3X3 | 6002267.7577 | 2109821.1715 | 37.773294801594 | -122.435586477022 | (37.773294801594, -122.435586477022) | ||
| 148121 | 148121 | 247459 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 985 Oak St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 6002326.2969 | 2109831.4554 | 37.7733263633354 | -122.435384717986 | (37.7733263633354, -122.435384717986) | |||
| 58028 | 58028 | 242103 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 980 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003749.00596 | 2102595.91053 | 37.753539992281 | -122.429947146145 | (37.753539992281, -122.429947146145) | |||
| 66444 | 66444 | 242104 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 980 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003750.427 | 2102580.67234 | 37.7534982322778 | -122.42994114499399 | (37.7534982322778, -122.429941144994) | |||
| 118102 | 118102 | 139648 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 98 Saint Joseph's Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6000741.7514 | 2112361.7335 | 37.780183749624904 | -122.441047428154 | (37.7801837496249, -122.441047428154) | |||
| 118447 | 118447 | 19510 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 98 Saint Joseph's Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | 4x4 | 6000739.4662845 | 2112395.3462739 | 37.78027591157 | -122.44105774554899 | (37.78027591157, -122.441057745549) | |||
| 27314 | 27314 | 218570 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 98 Rossmoor Dr | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5990761.96187 | 2094481.85885 | 37.7305168532543 | -122.47426667546002 | (37.7305168532543, -122.47426667546) | |||
| 65372 | 65372 | 218572 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 98 Rossmoor Dr | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5990712.738919999 | 2094463.91628 | 37.7304647357382 | -122.47443553578199 | (37.7304647357382, -122.474435535782) | |||
| 165562 | 165562 | 218571 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 98 Rossmoor Dr | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5990740.2773400005 | 2094470.45315 | 37.7304842798098 | -122.474340809303 | (37.7304842798098, -122.474340809303) | |||
| 39247 | 39247 | 242861 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 98 McCoppin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6005943.144090001 | 2109153.03232 | 37.771668319273296 | -122.422825302451 | (37.7716683192733, -122.422825302451) | |||
| 67698 | 67698 | 242862 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 98 McCoppin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6005927.34644 | 2109152.65833 | 37.7716664010214 | -122.42287992097602 | (37.7716664010214, -122.422879920976) | |||
| 175985 | 175985 | 241241 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 98 McCoppin St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6006130.56818 | 2109161.24748 | 37.771701449400396 | -122.42217757385299 | (37.7717014494004, -122.422177573853) | |||
| 153711 | 153711 | 241659 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 98 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6005992.80292 | 2099970.75678 | 37.7464587376849 | -122.422001124173 | (37.7464587376849, -122.422001124173) | |||
| 76871 | 76871 | 136856 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 98 Cedar St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6006975.39457 | 2114504.09716 | 37.7864192396018 | -122.4196344053 | (37.7864192396018, -122.4196344053) | |||
| 153020 | 153020 | 136857 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 98 Cedar St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6006964.61401 | 2114500.55499 | 37.786408906404205 | -122.41967145198 | (37.7864089064042, -122.41967145198) | |||
| 9660 | 9660 | 87030 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 98 Brady St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2007 12:00:00 AM | 2 | 3x3 | Permit Number 49973 | 6006766.5 | 2109389.9 | 37.7723651233427 | -122.419994070446 | (37.7723651233427, -122.419994070446) | |
| 18148 | 18148 | 87029 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 98 Brady St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/10/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775743 | 6006766.5 | 2109389.9 | 37.7723651233427 | -122.419994070446 | (37.7723651233427, -122.419994070446) | |
| 68150 | 68150 | 138991 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 979 Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6003203.9527 | 2110647.2389 | 37.7756161076176 | -122.432407064392 | (37.7756161076176, -122.432407064392) | |||
| 17302 | 17302 | 10349 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 978 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/14/2012 12:00:00 AM | 3 | 4x6 | 6001439.9402 | 2109063.1942 | 37.7711665324235 | -122.438395689895 | (37.7711665324235, -122.438395689895) | ||
| 64648 | 64648 | 242279 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 97 Surrey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002424.06039 | 2096223.2373799998 | 37.7359670002736 | -122.43407357655799 | (37.7359670002736, -122.434073576558) | |||
| 66789 | 66789 | 242281 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 97 Surrey St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002436.28815 | 2096209.43112 | 37.7359297854187 | -122.434030313749 | (37.7359297854187, -122.434030313749) | |||
| 76258 | 76258 | 242278 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 97 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002416.5475 | 2096231.48102 | 37.7359892090275 | -122.434100140709 | (37.7359892090275, -122.434100140709) | |||
| 174891 | 174891 | 242280 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 97 Surrey St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002430.06906 | 2096216.55505 | 37.735948993143204 | -122.43405232467899 | (37.7359489931432, -122.434052324679) | |||
| 40461 | 40461 | 35361 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 969 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2006 12:00:00 AM | 4 | Permit Number 38823 | 6011919.411119999 | 2103909.48398 | 37.7576060979734 | -122.40178426833401 | (37.7576060979734, -122.401784268334) | |
| 134083 | 134083 | 198041 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 966 Natoma St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6007944.08688 | 2109820.93616 | 37.773614921623704 | -122.415951204886 | (37.7736149216237, -122.415951204886) | |||
| 157397 | 157397 | 198042 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 966 Natoma St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6007955.48118 | 2109829.7754599997 | 37.773639832845795 | -122.415912416224 | (37.7736398328458, -122.415912416224) | |||
| 6659 | 6659 | 10663 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 963 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1992 12:00:00 AM | 3 | 3x3 | 6003244.5235 | 2110652.1051 | 37.77563176944871 | -122.432267067771 | (37.7756317694487, -122.432267067771) | ||
| 99409 | 99409 | 32152 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 963 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | 3x3 | Permit Number 35503 | 6003262.9720017 | 2110652.44096654 | 37.775633737669395 | -122.432203273909 | (37.7756337376694, -122.432203273909) | |
| 167515 | 167515 | 242001 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 960 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009389.49526 | 2103586.96463 | 37.756579023626706 | -122.41051100710101 | (37.7565790236267, -122.410511007101) | |||
| 75199 | 75199 | 214961 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 96 San Andreas Way | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993562.89782 | 2095215.2180400002 | 37.7326923447694 | -122.46463673950399 | (37.7326923447694, -122.464636739504) | |||
| 170486 | 170486 | 214960 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 96 San Andreas Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993567.2652 | 2095228.36715 | 37.7327287007546 | -122.464622594975 | (37.7327287007546, -122.464622594975) | |||
| 186356 | 186356 | 214959 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 96 San Andreas Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993574.3517 | 2095241.11953 | 37.7327641241706 | -122.46459902103099 | (37.7327641241706, -122.464599021031) | |||
| 105729 | 105729 | 19509 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 95X Saint Joseph's Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6000691.8143212 | 2112375.2561029 | 37.780218034815704 | -122.44122115340001 | (37.7802180348157, -122.4412211534) | |||
| 142393 | 142393 | 19508 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 95X Saint Joseph's Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6000691.8143212 | 2112375.2561029 | 37.780218034815704 | -122.44122115340001 | (37.7802180348157, -122.4412211534) | |||
| 51265 | 51265 | 101709 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 95X Milton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003767.7 | 2095277.7 | 37.7334469335284 | -122.42936067235901 | (37.7334469335284, -122.429360672359) | ||||
| 76292 | 76292 | 242102 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 958 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003747.21802 | 2102677.52154 | 37.753763975626505 | -122.429959150315 | (37.7537639756265, -122.429959150315) | |||
| 114100 | 114100 | 39509 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 958 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | Permit Number 40961 | 6003748.292270401 | 2102673.97071857 | 37.7537542867453 | -122.429955182043 | (37.7537542867453, -122.429955182043) | ||
| 36767 | 36767 | 247411 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 955 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6002024.0271 | 2109445.0372 | 37.7722481840495 | -122.436402647798 | (37.7722481840495, -122.436402647798) | |||
| 75628 | 75628 | 247412 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 955 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6002000.2833 | 2109442.3236 | 37.7722393839925 | -122.436484585301 | (37.7722393839925, -122.436484585301) | |||
| 53958 | 53958 | 89348 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 954 Ingerson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/14/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51932 | 6014423.4461 | 2089689.5134 | 37.7187004128037 | -122.39212978087 | (37.7187004128037, -122.39212978087) | |
| 4503 | 4503 | 162771 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 954 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2017 10:37:00 AM | 3 | Width 0ft | 5995054.32818 | 2090275.3089700001 | 37.7192144129887 | -122.45912295737301 | (37.7192144129887, -122.459122957373) | ||
| 47322 | 47322 | 242314 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 953 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6005731.3896699995 | 2103485.55664 | 37.756094821447796 | -122.423154856305 | (37.7560948214478, -122.423154856305) | |||
| 118927 | 118927 | 69090 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 952 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1994 12:00:00 AM | Permit Number 33102 | 5992844.10994008 | 2106645.81494842 | 37.764036371078795 | -122.467952872913 | (37.7640363710788, -122.467952872913) | ||
| 132518 | 132518 | 214855 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 952 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 5992759.79285 | 2106648.41249 | 37.7640386338056 | -122.468244687344 | (37.7640386338056, -122.468244687344) | |||
| 152206 | 152206 | 180359 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 952 Delano Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5998466.40456 | 2089317.7071099998 | 37.7167806236002 | -122.447259868958 | (37.7167806236002, -122.447259868958) | |||
| 175610 | 175610 | 180360 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 952 Delano Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5998452.56484 | 2089292.31285 | 37.716710105970606 | -122.447305879179 | (37.7167101059706, -122.447305879179) | |||
| 182854 | 182854 | 180358 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 952 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5998479.18294 | 2089342.08749 | 37.716848296685 | -122.44721745423901 | (37.716848296685, -122.447217454239) | |||
| 147768 | 147768 | 247491 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 950 Page St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 0ft | 6001998.5873 | 2109485.4017 | 37.7723575693759 | -122.436493535723 | (37.7723575693759, -122.436493535723) | |||
| 35926 | 35926 | 198013 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 950 Clara St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6011579.13499 | 2111530.21874 | 37.778511914541895 | -122.403497231313 | (37.7785119145419, -122.403497231313) | |||
| 61188 | 61188 | 198016 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 950 Clara St | 5 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6011600.73372 | 2111552.6255799998 | 37.7785746449277 | -122.40342408946199 | (37.7785746449277, -122.403424089462) | |||
| 133169 | 133169 | 198018 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 950 Clara St | 7 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6011626.45256 | 2111578.53248 | 37.7786472157356 | -122.403336940648 | (37.7786472157356, -122.403336940648) | |||
| 152698 | 152698 | 198015 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 950 Clara St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 10ft | 6011592.4393 | 2111542.93925 | 37.778547585231294 | -122.403452101555 | (37.7785475852313, -122.403452101555) | |||
| 154197 | 154197 | 198014 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 950 Clara St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 10ft | 6011583.34597 | 2111538.1965400004 | 37.778534054939705 | -122.40348322527099 | (37.7785340549397, -122.403483225271) | |||
| 174149 | 174149 | 198017 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 950 Clara St | 6 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6011612.66203 | 2111564.03025 | 37.7786066257438 | -122.403383627176 | (37.7786066257438, -122.403383627176) | |||
| 176487 | 176487 | 198012 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 950 Clara St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6011569.50985 | 2111521.45528 | 37.778487314485105 | -122.403529911791 | (37.7784873144851, -122.403529911791) | |||
| 78578 | 78578 | 95716 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 950 Avalon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767471 | 6005194.4 | 2092000.5 | 37.7245291361369 | -122.424195170047 | (37.7245291361369, -122.424195170047) | |
| 90566 | 90566 | 95717 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 950 Avalon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767471 | 6005194.4 | 2092000.5 | 37.7245291361369 | -122.424195170047 | (37.7245291361369, -122.424195170047) | |
| 38237 | 38237 | 218573 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 95 Rossmoor Dr | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5990744.9353 | 2094437.13782 | 37.73039307417179 | -122.474322276075 | (37.7303930741718, -122.474322276075) | |||
| 54848 | 54848 | 218569 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 95 Rossmoor Dr | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5990765.45397 | 2094449.75445 | 37.7304289049727 | -122.474252261144 | (37.7304289049727, -122.474252261144) | |||
| 151908 | 151908 | 218574 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 95 Rossmoor Dr | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5990724.629290001 | 2094434.6004700002 | 37.730384930811 | -122.474392290997 | (37.730384930811, -122.474392290997) | |||
| 174878 | 174878 | 187409 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 95 Leland Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 6010493.4269 | 2087269.1415 | 37.711835574702 | -122.40554396620199 | (37.711835574702, -122.405543966202) | |||
| 26783 | 26783 | 218679 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 95 Greenwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5996192.05574 | 2093743.9973400002 | 37.72880394782629 | -122.45544085051901 | (37.7288039478263, -122.455440850519) | |||
| 78793 | 78793 | 36400 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 95 Greenwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39329 | 5996171.38037302 | 2093732.38222171 | 37.7287708691135 | -122.45551148705098 | (37.7287708691135, -122.455511487051) | ||
| 141789 | 141789 | 36398 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 95 Greenwood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39329 | 5996171.38037302 | 2093732.38222171 | 37.7287708691135 | -122.45551148705098 | (37.7287708691135, -122.455511487051) |
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");