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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 189128 | 189128 | 176796 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 103 Bowdoin St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6008486.43054 | 2094496.74036 | 37.7315686095034 | -122.41299143261001 | (37.7315686095034, -122.41299143261) | |||
| 189045 | 189045 | 219314 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 322 Havelock St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 2ft | 5998659.44994 | 2092940.88551 | 37.726740062192796 | -122.44685317305 | (37.7267400621928, -122.44685317305) | |||
| 188999 | 188999 | 129349 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1306x Montgomery St | 35 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 8ft | 6011426.64663 | 2120143.89656 | 37.8021545047788 | -122.40463128093398 | (37.8021545047788, -122.404631280934) | |||
| 188976 | 188976 | 219246 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 628 Detroit St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 8ft | 5999461.66823 | 2095170.54845 | 37.732907993207604 | -122.44424009212 | (37.7329079932076, -122.44424009212) | |||
| 188832 | 188832 | 129179 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3298 Lyon St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 5998993.68481 | 2120160.70419 | 37.801497941247895 | -122.44765634587601 | (37.8014979412479, -122.447656345876) | ||||
| 188801 | 188801 | 176786 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 623 Avalon Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6004279.230330001 | 2092361.41636 | 37.725468416325 | -122.427384490226 | (37.725468416325, -122.427384490226) | |||
| 188774 | 188774 | 218226 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 100 Claremont Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 8ft | 5993838.37632 | 2098869.25868 | 37.7427413081634 | -122.46394949738199 | (37.7427413081634, -122.463949497382) | |||
| 188677 | 188677 | 218227 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 100 Claremont Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 5993831.45355 | 2098825.44748 | 37.742620614658 | -122.463970254628 | (37.742620614658, -122.463970254628) | |||
| 188529 | 188529 | 219331 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1025 Junipero Serra Blvd | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5991262.34027 | 2090458.54246 | 37.7194988020073 | -122.472243643342 | (37.7194988020073, -122.472243643342) | |||
| 188429 | 188429 | 176661 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 81 Lamartine St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6002679.168269999 | 2094329.6984400002 | 37.73078224948971 | -122.43305632191002 | (37.7307822494897, -122.43305632191) | |||
| 188348 | 188348 | 218225 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 100 Claremont Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 8ft | 5993843.55646 | 2098914.16079 | 37.7428648966005 | -122.463934844718 | (37.7428648966005, -122.463934844718) | |||
| 188311 | 188311 | 248142 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 280 Rutledge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6009850.53205 | 2099420.75509 | 37.7451653713952 | -122.40862267810499 | (37.7451653713952, -122.408622678105) | |||
| 188290 | 188290 | 176776 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 145 Colby St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6008272.69802 | 2093344.33975 | 37.728392364995706 | -122.413648871198 | (37.7283923649957, -122.413648871198) | |||
| 187969 | 187969 | 129213 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 11 Normandie Ter | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6000915.059280001 | 2117274.38469 | 37.793682490900295 | -122.440800378652 | (37.7936824909003, -122.440800378652) | |||
| 187948 | 187948 | 190769 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1199 Indiana St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6015071.47128 | 2103030.97705 | 37.75536930507379 | -122.39082167827499 | (37.7553693050738, -122.390821678275) | |||
| 187898 | 187898 | 219347 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 513 Ramsell St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 8ft | 5992971.18683 | 2090558.0944400001 | 37.7198708965006 | -122.46634406733999 | (37.7198708965006, -122.46634406734) | |||
| 187761 | 187761 | 226875 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2799 18th St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6009589.19178 | 2105442.78683 | 37.7616858850104 | -122.409951385948 | (37.7616858850104, -122.409951385948) | |||
| 187619 | 187619 | 176803 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 103 Bowdoin St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6008471.3844800005 | 2094562.18285 | 37.731747455866 | -122.41304807552099 | (37.731747455866, -122.413048075521) | |||
| 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) | |||
| 187387 | 187387 | 226842 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 601 Grand View Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6000049.35116 | 2101618.9889599998 | 37.75064738858 | -122.44267117713699 | (37.75064738858, -122.442671177137) | ||||
| 187209 | 187209 | 206920 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 411 Melrose Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 5997366.58572 | 2095512.9448099998 | 37.7337283808453 | -122.45150798300399 | (37.7337283808453, -122.451507983004) | ||||
| 187057 | 187057 | 219326 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 101 Miramar Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 5995302.40607 | 2090624.5686700002 | 37.7201876557032 | -122.45829071756701 | (37.7201876557032, -122.458290717567) | |||
| 187049 | 187049 | 129148 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1800 Jefferson St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6000531.19503 | 2121369.13302 | 37.8049037142981 | -122.442422689958 | (37.8049037142981, -122.442422689958) | |||
| 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) | |||
| 186997 | 186997 | 226845 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 627 Alvarado St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6002315.38206 | 2102640.55606 | 37.7535812846649 | -122.43490811502501 | (37.7535812846649, -122.434908115025) | |||
| 186871 | 186871 | 190764 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2131 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6011336.13604 | 2105543.46577 | 37.762060080324204 | -122.403916462872 | (37.7620600803242, -122.403916462872) | |||
| 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) | |||
| 186808 | 186808 | 249745 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 29 | : 4 | Tree 1 | Private 1 | 10 | Width 1ft | 6000232.829030001 | 2117254.6491400003 | 37.793589425458606 | -122.44315952880899 | (37.7935894254586, -122.443159528809) | |||
| 186803 | 186803 | 226887 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1266 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 5997536.57649 | 2105194.59271 | 37.7603215415281 | -122.451618405363 | (37.7603215415281, -122.451618405363) | |||
| 186712 | 186712 | 38366 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 4001 Lawton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/1998 12:00:00 AM | 6 | Permit Number 40430 | 5981835.1907 | 2104176.6987 | 37.756614999407894 | -122.50584576351999 | (37.7566149994079, -122.50584576352) | ||
| 186709 | 186709 | 176797 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 103 Bowdoin St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6008485.14768 | 2094502.3312900001 | 37.731583888980104 | -122.412996262887 | (37.7315838889801, -122.412996262887) | |||
| 186587 | 186587 | 219250 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 493 Joost Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5998818.91182 | 2094955.14522 | 37.732279855419605 | -122.4464467667 | (37.7322798554196, -122.4464467667) | |||
| 186571 | 186571 | 129120 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3632 Fillmore St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6002190.78069 | 2120762.93266 | 37.803333701254296 | -122.43663610388201 | (37.8033337012543, -122.436636103882) | |||
| 186564 | 186564 | 129261 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1310 Jones St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6008539.52794 | 2117021.7776099998 | 37.7934201586544 | -122.41440109114201 | (37.7934201586544, -122.414401091142) | |||
| 186387 | 186387 | 219389 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 637 Detroit St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 5ft | 5999415.32076 | 2095207.5821200002 | 37.7330070346513 | -122.444402987233 | (37.7330070346513, -122.444402987233) | |||
| 186350 | 186350 | 129169 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2601 Francisco St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 5999095.44123 | 2119716.26222 | 37.800283438275706 | -122.447272218433 | (37.8002834382757, -122.447272218433) | |||
| 186233 | 186233 | 129153 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1900 Beach St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6001047.32787 | 2121030.07538 | 37.8040021574489 | -122.44061222609699 | (37.8040021574489, -122.440612226097) | |||
| 186117 | 186117 | 218231 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 100 Claremont Blvd | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 8ft | 5993773.53157 | 2098636.1244900003 | 37.7420974430581 | -122.464156789307 | (37.7420974430581, -122.464156789307) | |||
| 186072 | 186072 | 129356 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1310 Jones St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6008546.12536 | 2116981.0244299998 | 37.7933086310424 | -122.41437537861499 | (37.7933086310424, -122.414375378615) | |||
| 186059 | 186059 | 176678 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 245 Delano Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6000029.196719999 | 2092216.34356 | 37.7248287932952 | -122.442066027838 | (37.7248287932952, -122.442066027838) | |||
| 186017 | 186017 | 176850 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 364 Hale St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6008720.72022 | 2094322.7825900002 | 37.7311041078727 | -122.41216915460899 | (37.7311041078727, -122.412169154609) | |||
| 185950 | 185950 | 129226 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2711 Vallejo St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6000603.16366 | 2117500.27188 | 37.7942849503531 | -122.44189578167801 | (37.7942849503531, -122.441895781678) | |||
| 185925 | 185925 | 226904 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1334 Douglass St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 2ft | 6001345.2019 | 2099797.64766 | 37.7457202045352 | -122.438059576001 | (37.7457202045352, -122.438059576001) | |||
| 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) | |||
| 185547 | 185547 | 176629 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1111 Cayuga Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 1ft | 6000425.60449 | 2090663.4815 | 37.7205875707281 | -122.440584368684 | (37.7205875707281, -122.440584368684) | |||
| 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) | |||
| 185451 | 185451 | 176846 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 211 Yale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007213.98461 | 2092669.27766 | 37.7264792821724 | -122.417261085441 | (37.7264792821724, -122.417261085441) | |||
| 185418 | 185418 | 226891 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 257 Montcalm St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6009789.62155 | 2099611.54236 | 37.745685819851104 | -122.408846754995 | (37.7456858198511, -122.408846754995) | |||
| 185406 | 185406 | 176659 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 81 Lamartine St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 6002688.08923 | 2094302.8109799998 | 37.7307089286534 | -122.433023560502 | (37.7307089286534, -122.433023560502) | |||
| 185201 | 185201 | 129340 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2550 Leavenworth St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 1ft | 6007472.2942699995 | 2121203.00534 | 37.8048407509518 | -122.418390414501 | (37.8048407509518, -122.418390414501) | |||
| 185058 | 185058 | 226967 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 49 Saturn St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 6000372.571380001 | 2105986.5742900004 | 37.7626581313015 | -122.441866895461 | (37.7626581313015, -122.441866895461) | |||
| 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) | |||
| 185007 | 185007 | 190767 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1400 Minnesota St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6015346.46104 | 2101795.38447 | 37.751991883134295 | -122.38978437325198 | (37.7519918831343, -122.389784373252) | |||
| 184997 | 184997 | 219400 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 434 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 5998549.53071 | 2095273.1110200002 | 37.7331375244767 | -122.447400952815 | (37.7331375244767, -122.447400952815) | ||||
| 184897 | 184897 | 129307 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2363 Larkin St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 2ft | 6006689.73885 | 2119362.09742 | 37.7997420023389 | -122.420967750079 | (37.7997420023389, -122.420967750079) | |||
| 184688 | 184688 | 129265 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1357 Washington St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6008155.330159999 | 2117205.78739 | 37.7939038140682 | -122.415743483075 | (37.7939038140682, -122.415743483075) | |||
| 184651 | 184651 | 129255 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1230 Clay St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6008722.7354 | 2117000.9275700003 | 37.7933731996641 | -122.41376570212799 | (37.7933731996641, -122.413765702128) | |||
| 184505 | 184505 | 249764 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 48 | : 4 | Tree 1 | Private 1 | 23 | Width 1ft | 6000246.04856 | 2117175.67215 | 37.7933733291772 | -122.44310811365101 | (37.7933733291772, -122.443108113651) | |||
| 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) | |||
| 184421 | 184421 | 219266 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1486 19th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5990295.30501 | 2105270.33919 | 37.7601121676522 | -122.47666784826299 | (37.7601121676522, -122.476667848263) | |||
| 184137 | 184137 | 119986 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2512 Cabrillo St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 5ft | 5987630.129509999 | 2110546.4758099997 | 37.774444031255 | -122.48627264673999 | (37.774444031255, -122.48627264674) | |||
| 184130 | 184130 | 219353 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 718 Head St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 5993539.38524 | 2090524.66713 | 37.7198118820929 | -122.46437759357201 | (37.7198118820929, -122.464377593572) | |||
| 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) | |||
| 183940 | 183940 | 226878 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2799 18th St | 4 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6009615.15158 | 2105443.0181400003 | 37.7616879750304 | -122.409861617432 | (37.7616879750304, -122.409861617432) | |||
| 183882 | 183882 | 129112 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 10 Hastings Ter | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6007339.93679 | 2119283.26863 | 37.799562187397704 | -122.41871222699801 | (37.7995621873977, -122.418712226998) | ||||
| 183872 | 183872 | 219255 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1498 17th Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 1ft | 5990885.81695 | 2105244.6208200003 | 37.760075785584 | -122.47462369285 | (37.760075785584, -122.47462369285) | |||
| 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) | |||
| 183710 | 183710 | 129184 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3751 Broderick St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 5999584.03647 | 2121469.20578 | 37.805124455597 | -122.445707624701 | (37.805124455597, -122.445707624701) | |||
| 183528 | 183528 | 219372 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 400x Marietta Dr | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 3ft | 5999397.86314 | 2097051.08053 | 37.7380678498474 | -122.444595794674 | (37.7380678498474, -122.444595794674) | |||
| 183490 | 183490 | 226870 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2001 Bryant St | 3 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6009582.96211 | 2105385.4738 | 37.7615281673157 | -122.409968885865 | (37.7615281673157, -122.409968885865) | |||
| 183464 | 183464 | 226910 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 755 Duncan St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 10ft | 6001658.76556 | 2099678.71822 | 37.745411479858 | -122.436966807986 | (37.745411479858, -122.436966807986) | |||
| 183443 | 183443 | 176685 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 59 Vienna St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6004983.7044 | 2093070.7345599998 | 37.72745586589 | -122.424999628452 | (37.72745586589, -122.424999628452) | |||
| 183430 | 183430 | 227005 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 5501 Diamond Heights Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6001947.460530001 | 2097677.07252 | 37.73993183418 | -122.43582535874901 | (37.73993183418, -122.435825358749) | |||
| 183326 | 183326 | 219281 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 25 Paradise Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 1ft | 6001098.252069999 | 2095886.82506 | 37.7349679568925 | -122.43863331829901 | (37.7349679568925, -122.438633318299) | |||
| 183234 | 183234 | 43136 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1730 Burrows St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 7 | Permit Number 42952 | 6006290.853069999 | 2092023.3911599999 | 37.7246538391803 | -122.42040649398199 | (37.7246538391803, -122.420406493982) | |
| 183016 | 183016 | 190770 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1199 Indiana St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6015070.85795 | 2103044.75282 | 37.7554070963733 | -122.390824762063 | (37.7554070963733, -122.390824762063) | |||
| 182870 | 182870 | 249757 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 41 | : 4 | Tree 1 | Private 1 | 11 | Width 1ft | 6000240.78319 | 2117204.07092 | 37.7934510045092 | -122.443128372672 | (37.7934510045092, -122.443128372672) | |||
| 182841 | 182841 | 206942 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 422 Edna St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 8ft | 5998789.86378 | 2094159.83561 | 37.7300944632801 | -122.446489995331 | (37.7300944632801, -122.446489995331) | |||
| 182813 | 182813 | 176666 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 285 Santa Rosa Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6000725.45534 | 2093598.6986099998 | 37.7286640771825 | -122.439758211891 | (37.7286640771825, -122.439758211891) | |||
| 182712 | 182712 | 183002 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2590 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5988041.6053 | 2098260.4304 | 37.7407338538563 | -122.48394819724399 | (37.7407338538563, -122.483948197244) | |||
| 182656 | 182656 | 227012 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 5545 Diamond Heights Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 5ft | 6001772.913380001 | 2097318.59114 | 37.738937611167394 | -122.43640321903601 | (37.7389376111674, -122.436403219036) | |||
| 182591 | 182591 | 129240 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2792 Fillmore St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 4ft | 6002609.5531 | 2117732.75522 | 37.7950374139978 | -122.434970088208 | (37.7950374139978, -122.434970088208) | |||
| 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) | |||
| 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) | |||
| 182427 | 182427 | 219370 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 145 Castenada Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5994548.062390001 | 2100959.98911 | 37.748522802305004 | -122.461647175376 | (37.748522802305, -122.461647175376) | |||
| 182348 | 182348 | 176744 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1198 Burrows St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 6007607.863919999 | 2092530.8977400002 | 37.7261214725101 | -122.415889662482 | (37.7261214725101, -122.415889662482) | |||
| 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) | |||
| 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) | |||
| 182183 | 182183 | 206926 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 300 Monterey Blvd | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 5999976.02379 | 2094721.7335 | 37.731704983603294 | -122.44242962735201 | (37.7317049836033, -122.442429627352) | |||
| 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) | |||
| 182037 | 182037 | 226956 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 44 Seward St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 6000877.08375 | 2104333.50629 | 37.7581479467004 | -122.44000343541401 | (37.7581479467004, -122.440003435414) | |||
| 181902 | 181902 | 190815 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 390x Hampshire St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 5ft | 6010042.68497 | 2106527.82648 | 37.7646905631515 | -122.408459468238 | (37.7646905631515, -122.408459468238) | |||
| 181861 | 181861 | 176738 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 387 Princeton St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6007923.10392 | 2092090.50279 | 37.7249299598378 | -122.414768739387 | (37.7249299598378, -122.414768739387) | |||
| 181808 | 181808 | 118086 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 7101 Geary Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5984961.82415 | 2112422.5857 | 37.779439407892795 | -122.495641095089 | (37.7794394078928, -122.495641095089) | |||
| 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) | |||
| 181535 | 181535 | 176749 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1100 Felton St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6007680.78535 | 2092930.6972 | 37.7272233353724 | -122.415665871602 | (37.7272233353724, -122.415665871602) | |||
| 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) | |||
| 181444 | 181444 | 190801 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 625 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 1ft | 6011843.82819 | 2105357.07787 | 37.761576651560205 | -122.402147437048 | (37.7615766515602, -122.402147437048) | |||
| 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) | |||
| 181098 | 181098 | 110919 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 77 Federal St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 2x1 | 6014784.35432 | 2113116.8816 | 37.783047040932395 | -122.39252008665001 | (37.7830470409324, -122.39252008665) |
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");