Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo, PlantType, qCaretaker, qCareAssistant
qLegalStatus ✖
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▲ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4549 | 4549 | 226945 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 998 Chenery St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 1ft | 6001140.61217 | 2096125.6115299999 | 37.735626018710896 | -122.438503967885 | (37.7356260187109, -122.438503967885) | |||
| 18293 | 18293 | 4370 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 998 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/1992 12:00:00 AM | 12 | 3X3 | 6001204.190330001 | 2096097.5771700002 | 37.7355526592134 | -122.438282146497 | (37.7355526592134, -122.438282146497) | ||
| 65449 | 65449 | 226944 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 998 Chenery St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 1ft | 6001147.55227 | 2096122.75745 | 37.735618576845205 | -122.43847976892401 | (37.7356185768452, -122.438479768924) | |||
| 23847 | 23847 | 226860 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 99 Elk St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 2ft | 6000812.22961 | 2096323.57705 | 37.7361509008315 | -122.43965349751801 | (37.7361509008315, -122.439653497518) | |||
| 50650 | 50650 | 226858 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 99 Elk St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 2ft | 6000811.86786 | 2096313.4540400002 | 37.736123084819496 | -122.43965402273001 | (37.7361230848195, -122.43965402273) | |||
| 70212 | 70212 | 226857 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 99 Elk St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 2ft | 6000811.73315 | 2096306.95535 | 37.7361052332666 | -122.439654022723 | (37.7361052332666, -122.439654022723) | |||
| 158588 | 158588 | 226859 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 99 Elk St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 2ft | 6000812.12935 | 2096318.74052 | 37.7361376151427 | -122.439653497529 | (37.7361376151427, -122.439653497529) | |||
| 168169 | 168169 | 226862 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 99 Elk St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6000812.75868 | 2096333.6910299999 | 37.7361787015724 | -122.439652393167 | (37.7361787015724, -122.439652393167) | |||
| 169062 | 169062 | 226863 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 99 Elk St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 2ft | 6000813.02064 | 2096338.5481200002 | 37.7361920529176 | -122.43965183556699 | (37.7361920529176, -122.439651835567) | |||
| 182231 | 182231 | 226861 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 99 Elk St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 2ft | 6000812.78199 | 2096328.25256 | 37.7361637701303 | -122.439651922807 | (37.7361637701303, -122.439651922807) | |||
| 50164 | 50164 | 107054 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 98X ROTTECK ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 6003385.0 | 2094496.0 | 37.731278888142704 | -122.43062801306999 | (37.7312788881427, -122.43062801307) | |||
| 75189 | 75189 | 176701 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 985 Avalon Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6005395.13627 | 2092229.7099400002 | 37.7251698288036 | -122.42351753851601 | (37.7251698288036, -122.423517538516) | |||
| 72917 | 72917 | 219419 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 979 Teresita Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 2ft | 5998332.28309 | 2095661.19123 | 37.734190683652 | -122.44817996714599 | (37.734190683652, -122.448179967146) | |||
| 146396 | 146396 | 206912 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 979 Teresita Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 2ft | 5998337.2254099995 | 2095660.3163400001 | 37.734188563950205 | -122.448162817076 | (37.7341885639502, -122.448162817076) | |||
| 182044 | 182044 | 129244 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 977 Pacific Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6009468.5777900005 | 2118046.06464 | 37.796284746692294 | -122.41125888781201 | (37.7962847466923, -122.411258887812) | |||
| 147658 | 147658 | 190758 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 971 Kansas St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 5ft | 6011634.85015 | 2103871.82945 | 37.757486822672895 | -122.402765753358 | (37.7574868226729, -122.402765753358) | |||
| 25301 | 25301 | 190759 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 960 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6011851.68946 | 2103937.20655 | 37.757678438529894 | -122.40202042759701 | (37.7576784385299, -122.402020427597) | |||
| 159125 | 159125 | 190803 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 960 Rhode Island St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6011852.27614 | 2103926.33475 | 37.757648619711496 | -122.402017634333 | (37.7576486197115, -122.402017634333) | |||
| 160956 | 160956 | 190804 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 960 Rhode Island St | 4 | : 4 | Tree 1 | Private 1 | 9 | Width 2ft | 6011852.706069999 | 2103917.67826 | 37.7576248748965 | -122.402015538912 | (37.7576248748965, -122.402015538912) | |||
| 23542 | 23542 | 176768 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 955 Silver Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 4ft | 6007502.25565 | 2093569.5745700002 | 37.7289675174267 | -122.416328280725 | (37.7289675174267, -122.416328280725) | |||
| 165451 | 165451 | 176769 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 955 Silver Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 4ft | 6007464.3453 | 2093559.22092 | 37.728936956660796 | -122.416458606878 | (37.7289369566608, -122.416458606878) | |||
| 64892 | 64892 | 176702 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 943 Avalon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 6005153.2895 | 2092105.0699599998 | 37.724813941005394 | -122.42434471783001 | (37.7248139410054, -122.42434471783) | |||
| 23498 | 23498 | 176772 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 937 Silver Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 5ft | 6007351.78047 | 2093548.13266 | 37.72890017978 | -122.41684696742901 | (37.72890017978, -122.416846967429) | |||
| 40515 | 40515 | 176771 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 937 Silver Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 2ft | 6007368.40948 | 2093546.0944400001 | 37.72889551860511 | -122.41678933527001 | (37.7288955186051, -122.41678933527) | |||
| 182283 | 182283 | 176770 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 937 Silver Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6007371.640240001 | 2093546.59423 | 37.7288970726385 | -122.416778201668 | (37.7288970726385, -122.416778201668) | |||
| 101905 | 101905 | 97139 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 937 Goettingen St | Front Yard : 25 | Landscaping 2 | Private 1 | 6011052.0 | 2090410.0 | 37.720490952554606 | -122.40383424464399 | (37.7204909525546, -122.403834244644) | ||||||
| 69391 | 69391 | 129339 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 928 Lombard St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6007894.75128 | 2120315.04124 | 37.802426397722 | -122.416865503351 | (37.802426397722, -122.416865503351) | |||
| 185888 | 185888 | 129338 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 928 Lombard St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6007904.15055 | 2120316.35403 | 37.802430530998 | -122.41683307021098 | (37.802430530998, -122.416833070211) | |||
| 46668 | 46668 | 32026 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 910 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/2005 12:00:00 AM | 2 | Permit Number 48084 | 6011942.61594 | 2111635.52885 | 37.7788213676447 | -122.40224721144399 | (37.7788213676447, -122.402247211444) | ||
| 80360 | 80360 | 110171 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 901 MONTEREY BLVD | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5996075.7 | 2094614.5 | 37.7311874614685 | -122.455906001855 | (37.7311874614685, -122.455906001855) | ||||
| 94629 | 94629 | 110173 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 901 MONTEREY BLVD | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5996075.7 | 2094614.5 | 37.7311874614685 | -122.455906001855 | (37.7311874614685, -122.455906001855) | ||||
| 120525 | 120525 | 110172 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 901 MONTEREY BLVD | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5996075.7 | 2094614.5 | 37.7311874614685 | -122.455906001855 | (37.7311874614685, -122.455906001855) | ||||
| 122726 | 122726 | 110174 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 901 MONTEREY BLVD | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5996075.7 | 2094614.5 | 37.7311874614685 | -122.455906001855 | (37.7311874614685, -122.455906001855) | ||||
| 127293 | 127293 | 110175 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 901 MONTEREY BLVD | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5996075.7 | 2094614.5 | 37.7311874614685 | -122.455906001855 | (37.7311874614685, -122.455906001855) | ||||
| 265 | 265 | 109354 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6 | 5x45 | 6007474.1784 | 2120601.5824599997 | 37.803189502164294 | -122.418341225173 | (37.8031895021643, -122.418341225173) | |||
| 24884 | 24884 | 109356 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11 | 5x45 | 6007464.49344 | 2120601.01033 | 37.8031873860571 | -122.41837469975 | (37.8031873860571, -122.41837469975) | |||
| 48049 | 48049 | 109359 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 8 | 5x45 | 6007452.06537 | 2120598.7604799997 | 37.8031805089269 | -122.41841754792802 | (37.8031805089269, -122.418417547928) | |||
| 70565 | 70565 | 109362 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 7 | 5x45 | 6007443.52896 | 2120597.58705 | 37.8031768064372 | -122.41844700523701 | (37.8031768064372, -122.418447005237) | |||
| 71497 | 71497 | 109357 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 9 | 5x45 | 6007459.04695 | 2120599.58062 | 37.8031831538387 | -122.41839344609801 | (37.8031831538387, -122.418393446098) | |||
| 75911 | 75911 | 109363 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6 | 5x45 | 6007417.13772 | 2120593.69695 | 37.8031646394947 | -122.418538057081 | (37.8031646394947, -122.418538057081) | |||
| 147679 | 147679 | 109360 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6 | 5x45 | 6007448.76613 | 2120598.25036 | 37.803178922540205 | -122.418428928878 | (37.8031789225402, -122.418428928878) | |||
| 155176 | 155176 | 109361 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 8 | 5x45 | 6007445.84949 | 2120597.53947 | 37.803176806427004 | -122.418438971581 | (37.803176806427, -122.418438971581) | |||
| 171997 | 171997 | 109358 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 7 | 5x45 | 6007454.77295 | 2120598.70497 | 37.8031805089291 | -122.41840817430901 | (37.8031805089291, -122.418408174309) | |||
| 173674 | 173674 | 109355 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12 | 5x45 | 6007469.51339 | 2120600.5219 | 37.8031863275346 | -122.41835729337299 | (37.8031863275346, -122.418357293373) | |||
| 36896 | 36896 | 129318 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900 Chestnut St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6007412.87531 | 2120593.39917 | 37.8031635819044 | -122.418552786177 | (37.8031635819044, -122.418552786177) | |||
| 149482 | 149482 | 129320 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900 Chestnut St | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 6007405.89372 | 2120592.57904 | 37.8031609369869 | -122.41857688803002 | (37.8031609369869, -122.41857688803) | |||
| 186852 | 186852 | 129319 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900 Chestnut St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6007409.37859 | 2120592.7001799997 | 37.8031614657978 | -122.41856483710698 | (37.8031614657978, -122.418564837107) | |||
| 53136 | 53136 | 226919 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 90 Fountain St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 26 | Width 8ft | 6000343.27555 | 2101131.8365 | 37.7493265362977 | -122.44161980940001 | (37.7493265362977, -122.4416198094) | |||
| 148744 | 148744 | 226918 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 90 Fountain St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 8ft | 6000342.712069999 | 2101137.2305099997 | 37.749341314846504 | -122.44162214496299 | (37.7493413148465, -122.441622144963) | |||
| 40444 | 40444 | 226940 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 9 Bemis St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 6003929.09347 | 2096974.1924299998 | 37.738114253060395 | -122.428923598041 | (37.7381142530604, -122.428923598041) | |||
| 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) | |||
| 27285 | 27285 | 118936 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 882 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5981106.21349 | 2109713.8297599996 | 37.7717754261179 | -122.508777876355 | (37.7717754261179, -122.508777876355) | |||
| 39031 | 39031 | 118935 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 882 48th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5981106.559230001 | 2109729.9345299997 | 37.7718196654774 | -122.50877787634701 | (37.7718196654774, -122.508777876347) | |||
| 83945 | 83945 | 103563 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 878 14th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | Permit Number 770193 | 6002986.0 | 2107714.0 | 37.767549794195205 | -122.432951409123 | (37.7675497941952, -122.432951409123) | |||
| 84454 | 84454 | 103564 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 878 14th St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | Permit Number 770193 | 6002986.0 | 2107714.0 | 37.767549794195205 | -122.432951409123 | (37.7675497941952, -122.432951409123) | |||
| 93035 | 93035 | 103565 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 878 14th St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | Permit Number 770193 | 6002986.0 | 2107714.0 | 37.767549794195205 | -122.432951409123 | (37.7675497941952, -122.432951409123) | |||
| 43202 | 43202 | 118930 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 875 La Playa | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 5980751.65283 | 2109636.5801 | 37.7715424153171 | -122.509998562861 | (37.7715424153171, -122.509998562861) | |||
| 52600 | 52600 | 190813 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 870 Arkansas St | 2 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6013034.16138 | 2103011.82985 | 37.755203481775105 | -122.39786601663 | (37.7552034817751, -122.39786601663) | |||
| 89880 | 89880 | 99852 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 86 Nordhoff St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6000395.0 | 2095652.0 | 37.734283150969794 | -122.44104786104499 | (37.7342831509698, -122.441047861045) | |||||
| 9867 | 9867 | 118924 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 855 La Playa | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/05/2017 12:00:00 AM | 3 | Width 4ft | 5980738.40206 | 2109808.86226 | 37.772014669966396 | -122.510057198601 | (37.7720146699664, -122.510057198601) | ||
| 172345 | 172345 | 219378 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 85 Martha Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 34 | Width 3ft | 6000398.21075 | 2095772.5501 | 37.734614336269395 | -122.44104540612801 | (37.7346143362694, -122.441045406128) | |||
| 47153 | 47153 | 226952 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 85 Elk St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 2ft | 6000812.334969999 | 2096326.53902 | 37.73615903970639 | -122.439653345527 | (37.7361590397064, -122.439653345527) | |||
| 55959 | 55959 | 226951 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 85 Elk St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 2ft | 6000812.228490001 | 2096321.4026 | 37.7361449302357 | -122.439653345551 | (37.7361449302357, -122.439653345551) | |||
| 61260 | 61260 | 226953 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 85 Elk St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 2ft | 6000812.22641 | 2096331.6795700002 | 37.7361731482776 | -122.439654089279 | (37.7361731482776, -122.439654089279) | |||
| 61727 | 61727 | 226950 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 85 Elk St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 2ft | 6000811.90257 | 2096316.05686 | 37.736130233531206 | -122.439654089264 | (37.7361302335312, -122.439654089264) | |||
| 132777 | 132777 | 226948 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 85 Elk St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 2ft | 6000812.17024 | 2096305.7052799999 | 37.7361018257441 | -122.43965242193899 | (37.7361018257441, -122.439652421939) | |||
| 187008 | 187008 | 226954 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 85 Elk St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 2ft | 6000812.32401 | 2096336.3877599998 | 37.7361860814232 | -122.43965408926701 | (37.7361860814232, -122.439654089267) | |||
| 187612 | 187612 | 226949 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 85 Elk St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 2ft | 6000811.997819999 | 2096310.2743 | 37.7361143613928 | -122.439653345519 | (37.7361143613928, -122.439653345519) | |||
| 38472 | 38472 | 129194 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 85 Cervantes Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 1ft | 6001552.51444 | 2120931.86169 | 37.8037612434571 | -122.438856955397 | (37.8037612434571, -122.438856955397) | |||
| 156042 | 156042 | 129195 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 85 Cervantes Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 1ft | 6001565.25504 | 2120922.94686 | 37.803737490546105 | -122.438812226714 | (37.8037374905461, -122.438812226714) | |||
| 23730 | 23730 | 219413 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 845 Detroit St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 6ft | 5999418.48835 | 2095681.2919599998 | 37.734307911173204 | -122.444426068323 | (37.7343079111732, -122.444426068323) | |||
| 40477 | 40477 | 219411 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 845 Detroit St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 5ft | 5999420.52154 | 2095713.4289400002 | 37.7343962677584 | -122.444421347772 | (37.7343962677584, -122.444421347772) | |||
| 41410 | 41410 | 219410 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 845 Detroit St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 5ft | 5999420.88677 | 2095723.69435 | 37.734424474994995 | -122.444420822556 | (37.734424474995, -122.444420822556) | |||
| 58987 | 58987 | 219415 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 845 Detroit St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 5999418.46421 | 2095650.92611 | 37.734224532323395 | -122.44442397020501 | (37.7342245323234, -122.444423970205) | |||
| 131324 | 131324 | 219414 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 845 Detroit St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 6ft | 5999417.68406 | 2095671.79096 | 37.7342817777744 | -122.44442816642 | (37.7342817777744, -122.44442816642) | |||
| 174657 | 174657 | 219412 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 845 Detroit St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 5ft | 5999419.9485 | 2095700.4483599998 | 37.7343605934475 | -122.44442239638599 | (37.7343605934475, -122.444422396386) | |||
| 185042 | 185042 | 219409 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 845 Detroit St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 5ft | 5999419.94343 | 2095736.70644 | 37.7344601493043 | -122.44442501881201 | (37.7344601493043, -122.444425018812) | |||
| 160273 | 160273 | 219416 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 841 Teresita Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 10ft | 5999120.96279 | 2095590.45112 | 37.734041503201496 | -122.445448176602 | (37.7340415032015, -122.445448176602) | |||
| 89053 | 89053 | 102912 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 84 Vienna St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6004823.0 | 2092922.0 | 37.7270383945734 | -122.42554460371599 | (37.7270383945734, -122.425544603716) | |||||
| 66460 | 66460 | 176844 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 838 Avalon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6004810.4561 | 2091959.39958 | 37.7243945970256 | -122.425519490549 | (37.7243945970256, -122.425519490549) | |||
| 67370 | 67370 | 119159 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 837 47th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 5981353.13131 | 2110018.81201 | 37.7726273695738 | -122.50794642446002 | (37.7726273695738, -122.50794642446) | |||
| 155878 | 155878 | 119158 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 837 47th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5981361.29524 | 2110027.47694 | 37.772651641953395 | -122.507918828236 | (37.7726516419534, -122.507918828236) | |||
| 173736 | 173736 | 57800 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 837 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/1977 12:00:00 AM | 9 | Permit Number 16735 | 5981352.9647 | 2110030.94394 | 37.7726606704836 | -122.50794790130199 | (37.7726606704836, -122.507947901302) | ||
| 62117 | 62117 | 176596 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 83 Lyell St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6003139.12483 | 2094542.11174 | 37.73139156805539 | -122.431481338298 | (37.7313915680554, -122.431481338298) | |||
| 182455 | 182455 | 176597 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 83 Lyell St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6003135.36488 | 2094556.0743099998 | 37.731429693006895 | -122.43149533354601 | (37.7314296930069, -122.431495333546) | |||
| 38280 | 38280 | 176654 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 83 Badger St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 2ft | 6002446.68138 | 2094237.0700599998 | 37.7305147227757 | -122.433853446802 | (37.7305147227757, -122.433853446802) | |||
| 66529 | 66529 | 176653 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 83 Badger St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 2ft | 6002454.85249 | 2094211.40595 | 37.7304447186477 | -122.43382336446699 | (37.7304447186477, -122.433823364467) | |||
| 70073 | 70073 | 176657 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 83 Badger St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 2ft | 6002431.19266 | 2094289.21355 | 37.7306570179873 | -122.433910719218 | (37.7306570179873, -122.433910719218) | |||
| 147562 | 147562 | 176656 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 83 Badger St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 2ft | 6002434.052 | 2094281.82238 | 37.7306368857794 | -122.433900305949 | (37.7306368857794, -122.433900305949) | |||
| 181715 | 181715 | 176655 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 83 Badger St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 2ft | 6002441.41634 | 2094249.50971 | 37.7305485804488 | -122.433872537603 | (37.7305485804488, -122.433872537603) | |||
| 34438 | 34438 | 176721 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 83 Athens St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6005098.35657 | 2092750.06265 | 37.7265818471717 | -122.42458047420799 | (37.7265818471717, -122.424580474208) | ||||
| 149203 | 149203 | 176720 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 83 Athens St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6005093.440280001 | 2092751.8073 | 37.7265863599479 | -122.424597593708 | (37.7265863599479, -122.424597593708) | ||||
| 153922 | 153922 | 176719 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 83 Athens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6005086.02152 | 2092756.70841 | 37.7265993983363 | -122.424623588602 | (37.7265993983363, -122.424623588602) | ||||
| 29615 | 29615 | 219408 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 826 Detroit St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 8ft | 5999474.92133 | 2095660.53825 | 37.7342541461187 | -122.44422947111799 | (37.7342541461187, -122.444229471118) | |||
| 110428 | 110428 | 12623 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 825 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 27 | 3X3 | 5992882.168 | 2114794.01241 | 37.7864113245051 | -122.468414093066 | (37.7864113245051, -122.468414093066) | |||
| 24188 | 24188 | 247556 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 815 Buena Vista Ave West | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 2ft | 6000035.32206 | 2108353.94379 | 37.7691391145131 | -122.443203353661 | (37.7691391145131, -122.443203353661) | |||
| 131660 | 131660 | 247557 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 815 Buena Vista Ave West | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 32 | Width 2ft | 6000027.54626 | 2108348.5362299997 | 37.769123823324 | -122.443229861189 | (37.769123823324, -122.443229861189) | |||
| 154626 | 154626 | 247555 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 815 Buena Vista Ave West | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 2ft | 6000042.91239 | 2108360.38627 | 37.769157236751 | -122.443177561991 | (37.769157236751, -122.443177561991) | |||
| 172615 | 172615 | 247554 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 815 Buena Vista Ave West | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | Width 2ft | 6000050.05446 | 2108365.18828 | 37.769170829105 | -122.44315320297501 | (37.769170829105, -122.443153202975) | |||
| 161682 | 161682 | 176703 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 815 Avalon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | 6004753.02081 | 2092064.15662 | 37.724678991421705 | -122.425725489235 | (37.7246789914217, -122.425725489235) |
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");