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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3534 | 3534 | 253482 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 2179 41st Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x5 | 5983532.0 | 2100331.0 | 37.74615550514321 | -122.49969345420799 | (37.7461555051432, -122.499693454208) | ||||
| 3549 | 3549 | 253470 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 3 Valletta Ct | 2 | Side Yard : Cutout 18 | Tree 1 | Private 1 | 6x10 | 5999319.0 | 2096479.0 | 37.736492551957895 | -122.44482735214198 | (37.7364925519579, -122.444827352142) | ||||
| 3709 | 3709 | 253265 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 180 San Aleso Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 09/19/2017 12:00:00 AM | 3 | 3x3 | 5993319.0 | 2094440.0 | 37.730549723890206 | -122.465423653439 | (37.7305497238902, -122.465423653439) | ||
| 49 | 49 | 251186 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3042 Steiner St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6002010.0 | 2118654.0 | 37.7975328515761 | -122.437110618013 | (37.7975328515761, -122.437110618013) | ||||
| 70401 | 70401 | 250324 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 179 27th Ave | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5987396.8518 | 2114775.1083299997 | 37.7860410575969 | -122.487390266267 | (37.7860410575969, -122.487390266267) | |||
| 67422 | 67422 | 250323 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 179 27th Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5987396.03432 | 2114802.15795 | 37.7861152804279 | -122.48739508214399 | (37.7861152804279, -122.487395082144) | |||
| 155003 | 155003 | 250175 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 721 Parker Ave | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 7ft | 5997242.30788 | 2110631.32988 | 37.7752325717698 | -122.453028595406 | (37.7752325717698, -122.453028595406) | |||
| 55652 | 55652 | 250174 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 721 Parker Ave | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 7ft | 5997242.00203 | 2110645.63605 | 37.7752718352644 | -122.45303068632299 | (37.7752718352644, -122.453030686323) | |||
| 42535 | 42535 | 250173 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 721 Parker Ave | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 7ft | 5997239.18442 | 2110648.2538799997 | 37.7752788616692 | -122.453040622039 | (37.7752788616692, -122.453040622039) | |||
| 36832 | 36832 | 250172 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 721 Parker Ave | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 7ft | 5997240.90305 | 2110650.9273599996 | 37.775286300843796 | -122.45303486996401 | (37.7752863008438, -122.453034869964) | |||
| 68885 | 68885 | 250171 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 721 Parker Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 7ft | 5997238.11076 | 2110659.10553 | 37.7753085959468 | -122.45304511956002 | (37.7753085959468, -122.45304511956) | |||
| 169522 | 169522 | 250170 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 721 Parker Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 7ft | 5997240.0055 | 2110662.97968 | 37.7753193419419 | -122.453038844971 | (37.7753193419419, -122.453038844971) | |||
| 39084 | 39084 | 250169 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 721 Parker Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 7ft | 5997237.65706 | 2110666.34039 | 37.7753284349893 | -122.453047211372 | (37.7753284349893, -122.453047211372) | |||
| 166248 | 166248 | 250168 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 721 Parker Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 7ft | 5997236.19535 | 2110687.93342 | 37.775387640062796 | -122.45305382679399 | (37.7753876400628, -122.453053826794) | |||
| 55387 | 55387 | 250167 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 721 Parker Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 7ft | 5997232.75579 | 2110698.69263 | 37.775416984933 | -122.453066501815 | (37.775416984933, -122.453066501815) | |||
| 173752 | 173752 | 250166 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 721 Parker Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 7ft | 5997232.8241 | 2110704.1079599997 | 37.7754318579352 | -122.453066656515 | (37.7754318579352, -122.453066656515) | |||
| 171741 | 171741 | 250165 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 721 Parker Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 7ft | 5997232.24252 | 2110715.01845 | 37.7754617819717 | -122.453069456091 | (37.7754617819717, -122.453069456091) | |||
| 172423 | 172423 | 250164 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 721 Parker Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 7ft | 5997230.43639 | 2110716.53529 | 37.7754658433095 | -122.453075813411 | (37.7754658433095, -122.453075813411) | |||
| 175121 | 175121 | 250163 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 721 Parker Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 7ft | 5997230.95701 | 2110719.49417 | 37.775473997461205 | -122.453074226111 | (37.7754739974612, -122.453074226111) | |||
| 36939 | 36939 | 250162 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 721 Parker Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 7ft | 5997228.928169999 | 2110728.99929 | 37.7754999797735 | -122.45308193061301 | (37.7754999797735, -122.453081930613) | |||
| 159319 | 159319 | 250161 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 721 Parker Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 7ft | 5997228.87455 | 2110733.66678 | 37.7755127924135 | -122.45308245310301 | (37.7755127924135, -122.453082453103) | |||
| 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) | |||
| 174994 | 174994 | 249763 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 47 | : 4 | Tree 1 | Private 1 | 21 | Width 1ft | 6000244.96871 | 2117178.7308099996 | 37.7933816658824 | -122.443112069768 | (37.7933816658824, -122.443112069768) | |||
| 70038 | 70038 | 249762 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 46 | : 4 | Tree 1 | Private 1 | 20 | Width 1ft | 6000243.900669999 | 2117182.35848 | 37.7933915656126 | -122.443116025908 | (37.7933915656126, -122.443116025908) | |||
| 138184 | 138184 | 249761 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 45 | : 4 | Tree 1 | Private 1 | 8 | Width 1ft | 6000243.02333 | 2117185.9818700003 | 37.793401464464395 | -122.443119321906 | (37.7934014644644, -122.443119321906) | |||
| 153878 | 153878 | 249760 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 44 | : 4 | Tree 1 | Private 1 | 12 | Width 1ft | 6000241.7862599995 | 2117189.5298599997 | 37.7934111357761 | -122.44312385717699 | (37.7934111357761, -122.443123857177) | |||
| 65018 | 65018 | 249759 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 43 | : 4 | Tree 1 | Private 1 | 11 | Width 1ft | 6000241.634269999 | 2117194.01368 | 37.7934234385005 | -122.443124705245 | (37.7934234385005, -122.443124705245) | |||
| 67332 | 67332 | 249758 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 42 | : 4 | Tree 1 | Private 1 | 11 | Width 1ft | 6000240.94884 | 2117198.36774 | 37.793435354521996 | -122.44312738972602 | (37.793435354522, -122.443127389726) | |||
| 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) | |||
| 32459 | 32459 | 249756 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 40 | : 4 | Tree 1 | Private 1 | 6 | Width 1ft | 6000240.43697 | 2117209.2145 | 37.7934651076862 | -122.443129940195 | (37.7934651076862, -122.443129940195) | |||
| 52094 | 52094 | 249755 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 39 | : 4 | Tree 1 | Private 1 | 9 | Width 1ft | 6000239.615259999 | 2117214.478 | 37.79347951302 | -122.443133161562 | (37.79347951302, -122.443133161562) | |||
| 173393 | 173393 | 249754 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 38 | : 4 | Tree 1 | Private 1 | 10 | Width 1ft | 6000238.64594 | 2117219.3423599997 | 37.7934928140037 | -122.443136864991 | (37.7934928140037, -122.443136864991) | |||
| 37997 | 37997 | 249753 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 37 | : 4 | Tree 1 | Private 1 | 7 | Width 1ft | 6000238.5689199995 | 2117223.4057 | 37.793503966475 | -122.44313742344801 | (37.793503966475, -122.443137423448) | |||
| 62997 | 62997 | 249752 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 36 | : 4 | Tree 1 | Private 1 | 8 | Width 1ft | 6000236.97181 | 2117227.13869 | 37.7935141252181 | -122.44314321778299 | (37.7935141252181, -122.443143217783) | |||
| 49386 | 49386 | 249751 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 35 | : 4 | Tree 1 | Private 1 | 9 | Width 1ft | 6000236.78022 | 2117230.8297200003 | 37.793524248891295 | -122.443144145909 | (37.7935242488913, -122.443144145909) | |||
| 148834 | 148834 | 249750 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 34 | : 4 | Tree 1 | Private 1 | 11 | Width 1ft | 6000235.93718 | 2117235.57911 | 37.7935372413976 | -122.443147404144 | (37.7935372413976, -122.443147404144) | |||
| 39030 | 39030 | 249749 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 33 | : 4 | Tree 1 | Private 1 | 12 | Width 1ft | 6000235.88036 | 2117238.71283 | 37.7935458425285 | -122.44314782591299 | (37.7935458425285, -122.443147825913) | |||
| 136197 | 136197 | 249748 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 32 | : 4 | Tree 1 | Private 1 | 2 | Width 1ft | 6000234.88856 | 2117241.71857 | 37.7935540389482 | -122.443151473582 | (37.7935540389482, -122.443151473582) | |||
| 40469 | 40469 | 249747 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 31 | : 4 | Tree 1 | Private 1 | 10 | Width 1ft | 6000233.56128 | 2117245.74106 | 37.793565007967 | -122.44315635509399 | (37.793565007967, -122.443156355094) | |||
| 46543 | 46543 | 249746 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 30 | : 4 | Tree 1 | Private 1 | 4 | Width 1ft | 6000233.18821 | 2117249.22853 | 37.7935745623699 | -122.44315789653 | (37.7935745623699, -122.44315789653) | |||
| 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) | |||
| 27573 | 27573 | 249744 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 28 | : 4 | Tree 1 | Private 1 | 10 | Width 1ft | 6000231.5353 | 2117259.0230400003 | 37.793601361269396 | -122.44316431948799 | (37.7936013612694, -122.443164319488) | |||
| 130192 | 130192 | 249743 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 27 | : 4 | Tree 1 | Private 1 | 8 | Width 1ft | 6000230.51867 | 2117262.97292 | 37.793612148632704 | -122.443168120916 | (37.7936121486327, -122.443168120916) | |||
| 66358 | 66358 | 249740 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 1ft | 6000185.11039 | 2117163.8687299998 | 37.7933374453318 | -122.443318115254 | (37.7933374453318, -122.443318115254) | |||
| 59420 | 59420 | 249634 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2550 Golden Gate Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 4ft | 5997294.55506 | 2111271.9763700003 | 37.776994614336 | -122.452894113492 | (37.776994614336, -122.452894113492) | |||
| 43916 | 43916 | 249625 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2450 Golden Gate Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 7ft | 5997639.79528 | 2111322.31201 | 37.777152600940106 | -122.451703458765 | (37.7771526009401, -122.451703458765) | |||
| 153125 | 153125 | 249624 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2450 Golden Gate Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 7ft | 5997651.05189 | 2111322.51448 | 37.777153801533295 | -122.451664533393 | (37.7771538015333, -122.451664533393) | |||
| 130965 | 130965 | 249623 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2450 Golden Gate Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 7ft | 5997659.54255 | 2111324.05825 | 37.7771585265736 | -122.451635273045 | (37.7771585265736, -122.451635273045) | |||
| 149561 | 149561 | 249609 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2310 Golden Gate Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 5998473.33255 | 2111438.47015 | 37.7775192428532 | -122.448828371134 | (37.7775192428532, -122.448828371134) | |||
| 166909 | 166909 | 249604 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2240 Golden Gate Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5998803.94159 | 2111484.14417 | 37.7776635525811 | -122.44768797771799 | (37.7776635525811, -122.447687977718) | |||
| 38948 | 38948 | 249603 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2240 Golden Gate Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5998819.017030001 | 2111486.76835 | 37.77767161949011 | -122.44763601580799 | (37.7776716194901, -122.447636015808) | |||
| 150711 | 150711 | 249602 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2240 Golden Gate Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5998865.56174 | 2111493.54575 | 37.7776928884488 | -122.44747549042 | (37.7776928884488, -122.44747549042) | |||
| 151034 | 151034 | 249495 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1801 California St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 2ft | 6005713.466659999 | 2115852.8179900004 | 37.7900513270512 | -122.42409631339399 | (37.7900513270512, -122.424096313394) | |||
| 27530 | 27530 | 249494 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1801 California St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6005708.87609 | 2115852.08373 | 37.790049051771 | -122.42411214416401 | (37.790049051771, -122.424112144164) | |||
| 174087 | 174087 | 249493 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1801 California St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6005704.27701 | 2115850.9356400003 | 37.790045639734394 | -122.42412797493401 | (37.7900456397344, -122.424127974934) | |||
| 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) | |||
| 45751 | 45751 | 248141 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 274 Rutledge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 2ft | 6009875.37752 | 2099433.39728 | 37.745201475562794 | -122.408537657996 | (37.7452014755628, -122.408537657996) | |||
| 33441 | 33441 | 248140 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 268 Rutledge St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 2ft | 6009882.82604 | 2099441.40705 | 37.7452238857837 | -122.408512467075 | (37.7452238857837, -122.408512467075) | |||
| 150004 | 150004 | 247945 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 15 Joy St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6010344.08085 | 2098894.91993 | 37.743749172086794 | -122.406879009554 | (37.7437491720868, -122.406879009554) | ||||
| 55511 | 55511 | 247671 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 170 Divisadero St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6001937.95373 | 2108623.93042 | 37.7699887373234 | -122.43664159784099 | (37.7699887373234, -122.436641597841) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 57173 | 57173 | 247138 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 500 27th St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6003171.95048 | 2100074.35789 | 37.7465837047841 | -122.43176270469499 | (37.7465837047841, -122.431762704695) | ||||
| 175549 | 175549 | 247137 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 500 27th St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6003179.078430001 | 2100075.39017 | 37.7465869432333 | -122.431738130709 | (37.7465869432333, -122.431738130709) | ||||
| 64677 | 64677 | 247136 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 500 27th St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6003181.95614 | 2100090.46758 | 37.7466285054035 | -122.43172925621501 | (37.7466285054035, -122.431729256215) | ||||
| 62478 | 62478 | 247003 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 401 Valley St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | Width 8ft | 6003236.004319999 | 2099186.05464 | 37.744148261529006 | -122.431477809352 | (37.744148261529, -122.431477809352) | |||
| 60867 | 60867 | 246724 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1501 Shotwell St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6008058.52794 | 2099329.47434 | 37.744814207710796 | -122.41481267936001 | (37.7448142077108, -122.41481267936) | ||||
| 46421 | 46421 | 246622 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 37 Norwich St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6009131.1615699995 | 2099436.16764 | 37.7451673750763 | -122.411111235306 | (37.7451673750763, -122.411111235306) | |||
| 159833 | 159833 | 246621 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 37 Norwich St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 4ft | 6009124.596609999 | 2099436.39802 | 37.745167639486 | -122.41113395216499 | (37.745167639486, -122.411133952165) | |||
| 38511 | 38511 | 245190 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1165 Page St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6000954.6073 | 2109297.4919 | 37.7717822376068 | -122.440091274084 | (37.7717822376068, -122.440091274084) | |||
| 151778 | 151778 | 245189 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1175 Page St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6000936.7356 | 2109295.3643 | 37.77177537830379 | -122.440152940733 | (37.7717753783038, -122.440152940733) | |||
| 149049 | 149049 | 245188 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1185 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6000914.1833 | 2109291.5347 | 37.7717635792199 | -122.440230675759 | (37.7717635792199, -122.440230675759) | |||
| 61910 | 61910 | 245187 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1195 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000895.0351 | 2109289.4071 | 37.7717566471657 | -122.44029675786501 | (37.7717566471657, -122.440296757865) | |||
| 133611 | 133611 | 227022 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 121 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6008279.64625 | 2099237.50243 | 37.7445740950309 | -122.41404158626999 | (37.7445740950309, -122.41404158627) | |||
| 40280 | 40280 | 227021 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 123 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6008281.58077 | 2099209.78469 | 37.7444980969188 | -122.414032936584 | (37.7444980969188, -122.414032936584) | |||
| 150025 | 150025 | 227020 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 31 Poppy Ln | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 3ft | 6002175.423769999 | 2096803.9702599999 | 37.7375474445557 | -122.43497473141501 | (37.7375474445557, -122.434974731415) | |||
| 172565 | 172565 | 227019 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 31 Poppy Ln | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 3ft | 6002163.83641 | 2096804.20988 | 37.737547444561 | -122.435014811479 | (37.737547444561, -122.435014811479) | |||
| 173063 | 173063 | 227018 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 31 Poppy Ln | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 3ft | 6002156.08146 | 2096805.0262900002 | 37.7375492458966 | -122.435041682346 | (37.7375492458966, -122.435041682346) | |||
| 148697 | 148697 | 227017 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 31 Poppy Ln | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | Width 2ft | 6002132.64017 | 2096807.6586799999 | 37.7375551427627 | -122.435122918088 | (37.7375551427627, -122.435122918088) | |||
| 165645 | 165645 | 227016 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 29 Poppy Ln | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 2ft | 6002117.32476 | 2096797.30121 | 37.7375258338607 | -122.43517513003201 | (37.7375258338607, -122.435175130032) | |||
| 160401 | 160401 | 227015 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 29 Poppy Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 1 | Width 2ft | 6002114.09151 | 2096793.82616 | 37.7375161085743 | -122.43518606040399 | (37.7375161085743, -122.435186060404) | |||
| 66666 | 66666 | 227014 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 5557 Diamond Heights Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 3ft | 6001726.69776 | 2097242.18492 | 37.7387251913123 | -122.436557543618 | (37.7387251913123, -122.436557543618) | |||
| 34356 | 34356 | 227013 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 5549 Diamond Heights Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 6001761.53629 | 2097297.86137 | 37.738880045571 | -122.436441072418 | (37.738880045571, -122.436441072418) | |||
| 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) | |||
| 138094 | 138094 | 227011 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 5527 Diamond Heights Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 8ft | 6001841.22055 | 2097455.3401 | 37.7393169730884 | -122.43617682821699 | (37.7393169730884, -122.436176828217) | |||
| 40832 | 40832 | 227010 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 5527 Diamond Heights Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 6001848.80076 | 2097475.72956 | 37.739373388466895 | -122.436152077973 | (37.7393733884669, -122.436152077973) | |||
| 57464 | 57464 | 227009 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 5527 Diamond Heights Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 6001851.51038 | 2097474.41545 | 37.739369934171904 | -122.436142615306 | (37.7393699341719, -122.436142615306) | |||
| 148584 | 148584 | 227008 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 5517 Diamond Heights Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6001879.76581 | 2097537.5656 | 37.7395449350512 | -122.436049438351 | (37.7395449350512, -122.436049438351) | |||
| 129532 | 129532 | 227007 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 5511 Diamond Heights Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 5ft | 6001889.47135 | 2097556.17355 | 37.73959657953029 | -122.436017212027 | (37.7395965795303, -122.436017212027) | |||
| 152023 | 152023 | 227006 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 5501 Diamond Heights Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6001938.1569300005 | 2097660.8911 | 37.739886875275104 | -122.435856369188 | (37.7398868752751, -122.435856369188) | |||
| 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) | |||
| 53708 | 53708 | 227004 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 5501 Diamond Heights Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 6001958.24289 | 2097692.47921 | 37.7399747498475 | -122.43578917992399 | (37.7399747498475, -122.435789179924) | |||
| 41224 | 41224 | 227003 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 5411 Diamond Heights Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 6002088.6819 | 2098074.75757 | 37.741031805779 | -122.435365514706 | (37.741031805779, -122.435365514706) | |||
| 58394 | 58394 | 227002 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 5411 Diamond Heights Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6002089.29593 | 2098063.49977 | 37.7410009293557 | -122.43536258651699 | (37.7410009293557, -122.435362586517) | |||
| 69599 | 69599 | 227001 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 50 Digby St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 5ft | 6002890.91939 | 2097601.24489 | 37.7397771768824 | -122.432557858265 | (37.7397771768824, -122.432557858265) | |||
| 154127 | 154127 | 227000 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 46 Digby St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6002897.856240001 | 2097587.66503 | 37.7397402831 | -122.432532903867 | (37.7397402831, -122.432532903867) | |||
| 163316 | 163316 | 226999 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 4 Digby St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 6003220.31628 | 2097186.1603099997 | 37.7386561242884 | -122.431389320569 | (37.7386561242884, -122.431389320569) | |||
| 176979 | 176979 | 226998 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 80 Everson St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6003360.181480001 | 2097124.70092 | 37.73849529671789 | -122.430901348418 | (37.7384952967179, -122.430901348418) |
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");