Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5604 | 5604 | 19964 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 100 STAIRWAY41 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
| 8096 | 8096 | 19962 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 100 STAIRWAY41 | -2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
| 9264 | 9264 | 19963 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 100 STAIRWAY41 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
| 14648 | 14648 | 19819 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 100 STAIRWAY25 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 100ST | ||||||||
| 16920 | 16920 | 19979 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 100 STAIRWAY45 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 30ST | ||||||||
| 24631 | 24631 | 176638 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 65 Santa Barbara Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 8ft | 5993323.454919999 | 2086371.47099 | 37.7083957495352 | -122.46482253315399 | (37.7083957495352, -122.464822533154) | |||
| 82512 | 82512 | 176641 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 89 Belle Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 2ft | 5991622.07464 | 2086489.1085299999 | 37.708620512601705 | -122.47071121118 | (37.7086205126017, -122.47071121118) | |||
| 134907 | 134907 | 176619 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 375 Hanover St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 3ft | 5999272.06122 | 2086368.18274 | 37.7087278988324 | -122.444263284724 | (37.7087278988324, -122.444263284724) | |||
| 99448 | 99448 | 116072 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 388 POLARIS WAY | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6000586.0 | 2086414.0 | 37.70892857908329 | -122.439725431133 | (37.7089285790833, -122.439725431133) | ||||
| 59244 | 59244 | 71583 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 266 Flournoy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 7 | 5993925.4185 | 2086705.1573599998 | 37.7093466620935 | -122.462766282735 | (37.7093466620935, -122.462766282735) | ||
| 156857 | 156857 | 176639 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 19 Rhine St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994551.36715 | 2086753.98013 | 37.7095167499667 | -122.460606453835 | (37.7095167499667, -122.460606453835) | |||
| 68529 | 68529 | 176622 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 28 Tomaso Ct | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6009222.269090001 | 2086479.6741900002 | 37.7095966978914 | -122.409881764928 | (37.7095966978914, -122.409881764928) | |||
| 145739 | 145739 | 176592 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2249 Cayuga Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 10ft | 5996118.04902 | 2086754.98706 | 37.70960952494271 | -122.455191839948 | (37.7096095249427, -122.455191839948) | |||
| 76107 | 76107 | 187484 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 701 Velasco Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 3ft | 6006683.55132 | 2086560.9884900001 | 37.7096773634854 | -122.418661795732 | (37.7096773634854, -122.418661795732) | |||
| 136796 | 136796 | 176621 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 20 Tomaso Ct | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6009241.33314 | 2086520.9311099998 | 37.7097110493951 | -122.40981878630801 | (37.7097110493951, -122.409818786308) | |||
| 37590 | 37590 | 176608 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 245 Chicago Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6002866.9269 | 2086792.03649 | 37.710096150800794 | -122.431869203328 | (37.7100961508008, -122.431869203328) | |||
| 92201 | 92201 | 176628 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3067 Alemany Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 1ft | 5996456.31752 | 2087068.2457400002 | 37.7104890628041 | -122.454045341035 | (37.7104890628041, -122.454045341035) | |||
| 132689 | 132689 | 176620 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 114 Desmond St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6010562.66148 | 2086802.426 | 37.710557939180795 | -122.405271825739 | (37.7105579391808, -122.405271825739) | |||
| 60393 | 60393 | 176642 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 450 Palmetto Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5993005.954030001 | 2087230.75027 | 37.7107368152174 | -122.465982240383 | (37.7107368152174, -122.465982240383) | |||
| 130769 | 130769 | 176644 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 450 Palmetto Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5992981.09091 | 2087231.27267 | 37.7107368152211 | -122.466068210177 | (37.7107368152211, -122.466068210177) | |||
| 153643 | 153643 | 176643 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 450 Palmetto Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5992994.85836 | 2087232.28697 | 37.7107403945151 | -122.46602070080401 | (37.7107403945151, -122.466020700804) | |||
| 46536 | 46536 | 176864 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1142 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6001508.44833 | 2087074.49051 | 37.710794602952106 | -122.436584568222 | (37.7107946029521, -122.436584568222) | |||
| 38642 | 38642 | 176865 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1142 Munich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6001491.17517 | 2087075.7451099998 | 37.7107970662038 | -122.436644357861 | (37.7107970662038, -122.436644357861) | |||
| 180106 | 180106 | 176853 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 44 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 6ft | 6002702.22859 | 2087060.99975 | 37.7108253274008 | -122.43245763061 | (37.7108253274008, -122.43245763061) | |||
| 72240 | 72240 | 176634 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 600 Blanken Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 5ft | 6013132.57563 | 2086873.0357 | 37.7108951651419 | -122.396394525203 | (37.7108951651419, -122.396394525203) | |||
| 177708 | 177708 | 176591 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 170 Lawrence Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 5996818.41137 | 2087266.2974900003 | 37.711053623008 | -122.45280815898501 | (37.711053623008, -122.452808158985) | |||
| 11566 | 11566 | 16410 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1186X Munich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | TR | 6001066.26402 | 2087197.59203 | 37.7111074743937 | -122.43812166787501 | (37.7111074743937, -122.438121667875) | |||
| 167059 | 167059 | 176607 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1186 Munich St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 6001048.8202 | 2087208.00194 | 37.7111350656127 | -122.438182703088 | (37.7111350656127, -122.438182703088) | |||
| 147284 | 147284 | 176635 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 280 Tocoloma Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6012623.11061 | 2087166.05245 | 37.7116713673138 | -122.398175911295 | (37.7116713673138, -122.398175911295) | |||
| 130260 | 130260 | 54791 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 280 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/02/1972 12:00:00 AM | 18 | Permit Number 10640 | 6012628.37407 | 2087183.5823 | 37.711719793993204 | -122.39815894829901 | (37.7117197939932, -122.398158948299) | ||
| 66575 | 66575 | 176855 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 699 Prague St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6002700.83355 | 2087431.53609 | 37.711842660275394 | -122.43248890094499 | (37.7118426602754, -122.432488900945) | |||
| 61753 | 61753 | 176856 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 699 Prague St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 2ft | 6002702.07598 | 2087433.5886 | 37.7118483664744 | -122.43248475327499 | (37.7118483664744, -122.432484753275) | |||
| 157915 | 157915 | 176857 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 699 Prague St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6002703.472569999 | 2087435.53377 | 37.711853786683 | -122.432480065122 | (37.711853786683, -122.432480065122) | |||
| 176436 | 176436 | 176858 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 699 Prague St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6002704.995180001 | 2087438.5155900002 | 37.711862060452205 | -122.432475015405 | (37.7118620604522, -122.432475015405) | |||
| 47827 | 47827 | 176859 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 699 Prague St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 2ft | 6002706.29177 | 2087440.6711400002 | 37.7118680526473 | -122.432470687896 | (37.7118680526473, -122.432470687896) | |||
| 52511 | 52511 | 176860 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 699 Prague St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6002707.3669 | 2087442.2073099997 | 37.711872331601704 | -122.432467081601 | (37.7118723316017, -122.432467081601) | |||
| 149485 | 149485 | 176861 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 699 Prague St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6002708.23559 | 2087443.8519099997 | 37.7118768965747 | -122.43246419656 | (37.7118768965747, -122.43246419656) | |||
| 185500 | 185500 | 176862 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 699 Prague St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 2ft | 6002709.09569 | 2087445.08105 | 37.711880320298 | -122.43246131155199 | (37.711880320298, -122.432461311552) | |||
| 161312 | 161312 | 176863 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 699 Prague St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6002709.8582 | 2087446.62401 | 37.7118846001685 | -122.43245878624201 | (37.7118846001685, -122.432458786242) | |||
| 39238 | 39238 | 176826 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 635 Prague St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 6002712.89216 | 2087452.0684200001 | 37.711899721374 | -122.432448688654 | (37.711899721374, -122.432448688654) | |||
| 149343 | 149343 | 176640 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 47 Payson St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5991761.59345 | 2087760.80597 | 37.7121203547524 | -122.47032156819401 | (37.7121203547524, -122.470321568194) | |||
| 60604 | 60604 | 176825 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 23 Seville St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6002184.50257 | 2087581.6181299998 | 37.7122254594191 | -122.434284204968 | (37.7122254594191, -122.434284204968) | |||
| 25117 | 25117 | 219340 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 217 Orizaba Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 5993976.2548 | 2087899.9330400003 | 37.7126301615391 | -122.462677198595 | (37.7126301615391, -122.462677198595) | |||
| 46662 | 46662 | 219339 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 217 Orizaba Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 4ft | 5993976.06053 | 2087910.0728799999 | 37.712657991947 | -122.46267860514999 | (37.712657991947, -122.46267860515) | |||
| 130317 | 130317 | 219338 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 217 Orizaba Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 5993976.25604 | 2087919.3939099999 | 37.7126835965453 | -122.462678605151 | (37.7126835965453, -122.462678605151) | |||
| 52462 | 52462 | 219337 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 217 Orizaba Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 4ft | 5993976.47705 | 2087929.93053 | 37.712712540334 | -122.462678605144 | (37.712712540334, -122.462678605144) | |||
| 167871 | 167871 | 219336 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 217 Orizaba Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 5993977.06233 | 2087938.43241 | 37.7127359181885 | -122.462677198601 | (37.7127359181885, -122.462677198601) | |||
| 183956 | 183956 | 176627 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 332 Ellington Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 5998745.61831 | 2087840.43325 | 37.712740316791795 | -122.44618856505699 | (37.7127403167918, -122.446188565057) | |||
| 57570 | 57570 | 176626 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 332 Ellington Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 4ft | 5998755.95892 | 2087850.85961 | 37.712769535747206 | -122.446153574254 | (37.7127695357472, -122.446153574254) | |||
| 125302 | 125302 | 176625 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 332 Ellington Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 4ft | 5998763.992880001 | 2087858.5335799998 | 37.712791065527796 | -122.446126358062 | (37.7127910655278, -122.446126358062) | |||
| 183779 | 183779 | 176633 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 110 Newton St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 3ft | 6000954.59421 | 2087879.4605599998 | 37.7129733823892 | -122.43855644963399 | (37.7129733823892, -122.438556449634) | |||
| 130697 | 130697 | 176632 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 110 Newton St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 6000949.95305 | 2087893.72595 | 37.713012287961604 | -122.43857351247499 | (37.7130122879616, -122.438573512475) | |||
| 148159 | 148159 | 176631 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 110 Newton St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 6000945.59643 | 2087907.6965599998 | 37.7130504003174 | -122.438589570763 | (37.7130504003174, -122.438589570763) | |||
| 68329 | 68329 | 176623 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 256 Ellington Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 1ft | 5999086.11922 | 2088154.6418400002 | 37.713622502239794 | -122.445034263618 | (37.7136225022398, -122.445034263618) | |||
| 181201 | 181201 | 219362 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 81 Vernon St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 5992423.9143900005 | 2088481.1554 | 37.7141365322476 | -122.468084780709 | (37.7141365322476, -122.468084780709) | |||
| 184432 | 184432 | 219244 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 4 Farallones St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 2ft | 5996960.480830001 | 2088401.3270400001 | 37.7141782922784 | -122.452398988125 | (37.7141782922784, -122.452398988125) | |||
| 32661 | 32661 | 176624 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 190 Foote Ave | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 5998633.901980001 | 2088379.60151 | 37.714214369464 | -122.446613458762 | (37.714214369464, -122.446613458762) | |||
| 164120 | 164120 | 176827 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1791 Cayuga Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 5997883.80423 | 2088433.1189700002 | 37.7143184408223 | -122.44920992919799 | (37.7143184408223, -122.449209929198) | |||
| 53053 | 53053 | 219245 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 16 Lobos St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 2ft | 5996729.7413 | 2088712.5742099998 | 37.7150196826824 | -122.45321896478501 | (37.7150196826824, -122.453218964785) | |||
| 27887 | 27887 | 176613 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 263 Rome St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 0ft | 5998491.328480001 | 2088788.6230099997 | 37.7153293039925 | -122.447135664507 | (37.7153293039925, -122.447135664507) | |||
| 168891 | 168891 | 176612 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 275 Rome St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5998463.137019999 | 2088828.41793 | 37.715436960924 | -122.44723596859 | (37.715436960924, -122.44723596859) | |||
| 162215 | 162215 | 176611 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 275 Rome St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5998451.26815 | 2088839.7013700001 | 37.7154672644752 | -122.447277804138 | (37.7154672644752, -122.447277804138) | |||
| 175687 | 175687 | 176609 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1659 Cayuga Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 8ft | 5998355.24802 | 2088872.09815 | 37.7155507314505 | -122.447612021886 | (37.7155507314505, -122.447612021886) | |||
| 161661 | 161661 | 176610 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1659 Cayuga Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5998366.15646 | 2088880.1893799999 | 37.7155735715352 | -122.447574899658 | (37.7155735715352, -122.447574899658) | |||
| 134236 | 134236 | 176680 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 301 Rome St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 5998334.393730001 | 2088961.07404 | 37.715793846985996 | -122.44769050482701 | (37.715793846986, -122.447690504827) | |||
| 175110 | 175110 | 219346 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 81 Byxbee St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 10ft | 5991911.85592 | 2089125.7971700002 | 37.7158769767191 | -122.46990154251999 | (37.7158769767191, -122.46990154252) | |||
| 75947 | 75947 | 219345 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 81 Byxbee St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 5991911.8899300005 | 2089150.8332900002 | 37.7159457217874 | -122.469903246754 | (37.7159457217874, -122.469903246754) | |||
| 28406 | 28406 | 219344 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 81 Byxbee St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 5991912.69269 | 2089165.54418 | 37.71598616072 | -122.469901542523 | (37.71598616072, -122.469901542523) | |||
| 152524 | 152524 | 219341 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 176 Margaret Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 10ft | 5996604.57651 | 2089160.1054 | 37.7162413244539 | -122.45368388192101 | (37.7162413244539, -122.453683881921) | |||
| 172743 | 172743 | 176828 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1581 Cayuga Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 1ft | 5998637.772919999 | 2089144.8759400002 | 37.7163158593728 | -122.446655107259 | (37.7163158593728, -122.446655107259) | |||
| 129593 | 129593 | 176829 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1581 Cayuga Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 1ft | 5998649.34679 | 2089153.88395 | 37.7163412544316 | -122.446615750237 | (37.7163412544316, -122.446615750237) | |||
| 68468 | 68468 | 219360 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 313 Bright St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 5993732.0948 | 2089263.8820200001 | 37.7163611752992 | -122.46362001454901 | (37.7163611752992, -122.463620014549) | |||
| 55295 | 55295 | 176830 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1581 Cayuga Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 1ft | 5998657.8361599995 | 2089162.37902 | 37.7163650648728 | -122.44658701780001 | (37.7163650648728, -122.4465870178) | |||
| 180880 | 180880 | 219359 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 313 Bright St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 6ft | 5993732.18416 | 2089268.1403400002 | 37.7163728727759 | -122.46362001455601 | (37.7163728727759, -122.463620014556) | |||
| 48887 | 48887 | 219358 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 313 Bright St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 5993732.273519999 | 2089272.39867 | 37.71638457028 | -122.463620014563 | (37.71638457028, -122.463620014563) | |||
| 36980 | 36980 | 219357 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 313 Bright St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 5993732.37033 | 2089277.01188 | 37.7163972426289 | -122.463620014561 | (37.7163972426289, -122.463620014561) | |||
| 181470 | 181470 | 219356 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 313 Bright St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 5993733.55118 | 2089282.3121 | 37.7164118638057 | -122.46361631744699 | (37.7164118638057, -122.463616317447) | |||
| 178346 | 178346 | 176831 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1567 Cayuga Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 8ft | 5998676.7168 | 2089183.1568 | 37.7164231943611 | -122.446523251341 | (37.7164231943611, -122.446523251341) | |||
| 151196 | 151196 | 176832 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1555 Cayuga Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 1ft | 5998713.68097 | 2089214.6780599998 | 37.7165118558136 | -122.446397751868 | (37.7165118558136, -122.446397751868) | |||
| 160805 | 160805 | 176833 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1555 Cayuga Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 1ft | 5998716.673690001 | 2089217.8714599998 | 37.7165207950888 | -122.446387637188 | (37.7165207950888, -122.446387637188) | |||
| 165769 | 165769 | 176683 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2328 Alemany Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 2ft | 5999409.94736 | 2089269.75185 | 37.7167028187559 | -122.443995073633 | (37.7167028187559, -122.443995073633) | |||
| 62081 | 62081 | 176614 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1531 Cayuga Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5998790.48593 | 2089284.65203 | 37.7167083747673 | -122.44613730731301 | (37.7167083747673, -122.446137307313) | |||
| 11331 | 11331 | 1100 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 2328 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 5999423.31284 | 2089282.1433599999 | 37.71673760544579 | -122.44394976577298 | (37.7167376054458, -122.443949765773) | |||
| 61598 | 61598 | 176615 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 73 Rome St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5999173.59476 | 2089300.0418599998 | 37.716772502713596 | -122.44481420042801 | (37.7167725027136, -122.444814200428) | |||
| 43812 | 43812 | 176599 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 255 Ottawa Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 8ft | 5998280.541680001 | 2089346.8494799999 | 37.716850019794606 | -122.44790439957899 | (37.7168500197946, -122.447904399579) | |||
| 151929 | 151929 | 219350 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 350 Victoria St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5993263.513069999 | 2089526.9590200002 | 37.717056510421 | -122.465258746617 | (37.717056510421, -122.465258746617) | |||
| 49144 | 49144 | 219352 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 350 Victoria St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5993266.488919999 | 2089531.0532200001 | 37.71706792372179 | -122.465248757836 | (37.7170679237218, -122.465248757836) | |||
| 44302 | 44302 | 219351 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 350 Victoria St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5993263.35325 | 2089534.6361099998 | 37.7170775806463 | -122.46525985636002 | (37.7170775806463, -122.46525985636) | |||
| 169737 | 169737 | 176835 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 114 Niagara Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 0ft | 5999510.24603 | 2089471.7936200001 | 37.717263300525396 | -122.443662898245 | (37.7172633005254, -122.443662898245) | |||
| 152831 | 152831 | 176834 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1457 Cayuga Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 0ft | 5999029.42353 | 2089515.22336 | 37.7173551132383 | -122.445327990315 | (37.7173551132383, -122.445327990315) | |||
| 72856 | 72856 | 219335 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 261 Thrift St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5994423.037830001 | 2089616.126 | 37.7173681417119 | -122.461257314797 | (37.7173681417119, -122.461257314797) | |||
| 182517 | 182517 | 190822 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 13 Jennings Ct | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6012854.0546699995 | 2089293.52608 | 37.7175258486306 | -122.397526813914 | (37.7175258486306, -122.397526813914) | |||
| 163530 | 163530 | 190821 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 13 Jennings Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6012858.0659300005 | 2089298.3166900002 | 37.7175392260401 | -122.39751328452499 | (37.7175392260401, -122.397513284525) | |||
| 147731 | 147731 | 219334 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 800 Capitol Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 5995082.86973 | 2089689.0619599998 | 37.717606358621104 | -122.45898187623001 | (37.7176063586211, -122.45898187623) | |||
| 166819 | 166819 | 176630 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 271 Prague St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 6004066.09018 | 2089571.2619999999 | 37.7177952090644 | -122.427922568075 | (37.7177952090644, -122.427922568075) | |||
| 51153 | 51153 | 176836 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 182 Niagara Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 0ft | 5999285.39372 | 2089701.94289 | 37.7178824109155 | -122.444456635388 | (37.7178824109155, -122.444456635388) | |||
| 18666 | 18666 | 19313 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 21 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 5993901.63447 | 2089816.98545 | 37.7178896324771 | -122.463074115289 | (37.7178896324771, -122.463074115289) | |||
| 69555 | 69555 | 176837 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 182 Niagara Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 0ft | 5999279.6106900005 | 2089709.20322 | 37.717902016153204 | -122.444477146204 | (37.7179020161532, -122.444477146204) | |||
| 170662 | 170662 | 176838 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 182 Niagara Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 0ft | 5999273.76628 | 2089713.5101700001 | 37.7179135085776 | -122.44449765705299 | (37.7179135085776, -122.444497657053) | |||
| 58589 | 58589 | 176839 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 182 Niagara Ave | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 0ft | 5999268.4674 | 2089720.26783 | 37.717931761216605 | -122.444516458293 | (37.7179317612166, -122.444516458293) |
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");