Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▼ | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | ||
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) | |||
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) | |||
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) | |||
179080 | 179080 | 118669 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 4550 Balboa St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 50 | 5981412.61192 | 2111005.49415 | 37.7753400136649 | -122.507813913091 | (37.7753400136649, -122.507813913091) | ||||
67844 | 67844 | 119114 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 727 46th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 5ft | 5981633.48884 | 2110754.76442 | 37.7746645942414 | -122.50703125858601 | (37.7746645942414, -122.507031258586) | |||
174258 | 174258 | 119070 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 601 45th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 5981915.41012 | 2111609.48599 | 37.7770280083436 | -122.506119441606 | (37.7770280083436, -122.506119441606) | |||
41354 | 41354 | 184569 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3943 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5981967.8868 | 2103494.6521 | 37.7547501020315 | -122.505336310147 | (37.7547501020315, -122.505336310147) | |||
62290 | 62290 | 184570 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3941 Moraga St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5981986.5378 | 2103495.1429 | 37.754752547113206 | -122.505271847368 | (37.7547525471132, -122.505271847368) | |||
157951 | 157951 | 118705 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 4225 Balboa St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 5982441.7055 | 2110968.62548 | 37.7752993599927 | -122.504251368027 | (37.7752993599927, -122.504251368027) | |||
75381 | 75381 | 118704 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 4225 Balboa St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 5982455.1363 | 2110968.5092599997 | 37.775299830770294 | -122.504204899972 | (37.7752998307703, -122.504204899972) | |||
51821 | 51821 | 185254 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2551 44th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 0ft | 5982701.1675 | 2097764.3628 | 37.7390594386794 | -122.502376400061 | (37.7390594386794, -122.502376400061) | |||
52317 | 52317 | 185256 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2551 44th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5982701.6583 | 2097746.6934 | 37.7390109521784 | -122.502373395791 | (37.7390109521784, -122.502373395791) | |||
91705 | 91705 | 185255 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2551 44th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5982702.6399 | 2097754.5465 | 37.739032572319104 | -122.502370582964 | (37.7390325723191, -122.502370582964) | |||
29129 | 29129 | 117930 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 593 42nd Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 4ft | 5982838.9134599995 | 2111805.09577 | 37.7776194161311 | -122.502939294109 | (37.7776194161311, -122.502939294109) | |||
37574 | 37574 | 117932 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 599 42nd Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 2ft | 5982840.28847 | 2111742.07201 | 37.77744645210971 | -122.502929870802 | (37.7774464521097, -122.502929870802) | |||
31654 | 31654 | 117698 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 4049 Clement St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 7ft | 5982870.28986 | 2113072.50922 | 37.7811012062077 | -122.502924603076 | (37.7811012062077, -122.502924603076) | |||
168266 | 168266 | 184451 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2150 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5982967.4153 | 2100488.966 | 37.7465560908843 | -122.50165736947099 | (37.7465560908843, -122.501657369471) | |||
76179 | 76179 | 117700 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 4027 Clement St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 7ft | 5982971.473069999 | 2113077.09614 | 37.7811197468717 | -122.502574905114 | (37.7811197468717, -122.502574905114) | |||
135274 | 135274 | 117699 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 4027 Clement St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 7ft | 5982983.94909 | 2113077.92837 | 37.781122765049 | -122.50253180663601 | (37.781122765049, -122.502531806636) | |||
75864 | 75864 | 117818 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3936 Balboa St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 1ft | 5983313.54909 | 2111075.82361 | 37.775644931310396 | -122.501243440143 | (37.7756449313104, -122.501243440143) | |||
27504 | 27504 | 117817 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3900 Balboa St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 6ft | 5983396.39556 | 2111078.07387 | 37.7756559745836 | -122.50095702488899 | (37.7756559745836, -122.500957024889) | |||
149616 | 149616 | 117816 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3900 Balboa St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 6ft | 5983419.54459 | 2111079.81342 | 37.775662110061 | -122.50087707664801 | (37.775662110061, -122.500877076648) | |||
179349 | 179349 | 117815 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3900 Balboa St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 6ft | 5983440.2073 | 2111080.71217 | 37.7756657909172 | -122.50080566686 | (37.7756657909172, -122.50080566686) | |||
166581 | 166581 | 117814 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3900 Balboa St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5983453.00574 | 2111081.1088 | 37.7756676313487 | -122.500761423942 | (37.7756676313487, -122.500761423942) | |||
44550 | 44550 | 117813 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3900 Balboa St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5983481.12715 | 2111084.52953 | 37.775678674640396 | -122.500664399599 | (37.7756786746404, -122.500664399599) | |||
36733 | 36733 | 117761 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 450 39th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 6ft | 5983797.475319999 | 2112772.58996 | 37.7803321653034 | -122.499694882039 | (37.7803321653034, -122.499694882039) | |||
63477 | 63477 | 184595 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1738 38th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5984423.6443 | 2103335.7702 | 37.7544580572925 | -122.496832032885 | (37.7544580572925, -122.496832032885) | |||
54634 | 54634 | 184594 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1738 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5984424.6596 | 2103325.6175 | 37.754430240283796 | -122.496827772507 | (37.7544302402838, -122.496827772507) | |||
73223 | 73223 | 118055 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 499 36th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 8ft | 5984683.022969999 | 2112541.9282299997 | 37.7797507575988 | -122.496614381059 | (37.7797507575988, -122.496614381059) | |||
43211 | 43211 | 118078 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 7150 Geary Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 7ft | 5984743.66491 | 2112532.51161 | 37.7797284549829 | -122.496403902204 | (37.7797284549829, -122.496403902204) | |||
65282 | 65282 | 118037 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3421 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 5984874.28781 | 2113152.5227900003 | 37.7814384776062 | -122.49599778017401 | (37.7814384776062, -122.495997780174) | |||
171608 | 171608 | 118088 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 7101 Geary Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5984949.57327 | 2112422.00658 | 37.7794371003845 | -122.495683432703 | (37.7794371003845, -122.495683432703) | |||
76845 | 76845 | 118087 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 7101 Geary Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5984956.11601 | 2112422.0770099997 | 37.7794376769099 | -122.495660804133 | (37.7794376769099, -122.495660804133) | |||
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) | |||
147263 | 147263 | 118085 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 7101 Geary Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5984968.995209999 | 2112422.4327599998 | 37.779439407894 | -122.495616276446 | (37.779439407894, -122.495616276446) | |||
39296 | 39296 | 118084 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 7101 Geary Blvd | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 5984977.6516 | 2112422.66835 | 37.7794405616591 | -122.49558634816002 | (37.7794405616591, -122.49558634816) | |||
77219 | 77219 | 118070 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 422 35th Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 2ft | 5985031.51413 | 2113017.90855 | 37.7810780733056 | -122.49544393016599 | (37.7810780733056, -122.495443930166) | |||
158745 | 158745 | 118071 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 422 35th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 2ft | 5985031.745180001 | 2113002.45389 | 37.7810356528066 | -122.49544199070401 | (37.7810356528066, -122.495441990704) | |||
132494 | 132494 | 185500 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2400 Sunset Blvd | 54 | unknown : Yard 19 | Tree 1 | Private 1 | 6 | Width 0ft | 5985111.7766 | 2098706.9627 | 37.7417889108579 | -122.49411119019399 | (37.7417889108579, -122.494111190194) | |||
178055 | 178055 | 118281 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3245 Cabrillo St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 8ft | 5985519.75315 | 2110399.45496 | 37.7739171254243 | -122.493561899449 | (37.7739171254243, -122.493561899449) | |||
178370 | 178370 | 118280 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3245 Cabrillo St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 5985532.1252 | 2110400.01193 | 37.7739193784435 | -122.493519144142 | (37.7739193784435, -122.493519144142) | |||
160189 | 160189 | 185221 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2507 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5985796.5284 | 2098145.3036 | 37.740286789775 | -122.491702240957 | (37.740286789775, -122.491702240957) | |||
163948 | 163948 | 185240 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2538 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5985848.3989 | 2097948.0365 | 37.7397481784215 | -122.491508379416 | (37.7397481784215, -122.491508379416) | |||
66797 | 66797 | 120004 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 530 29th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 5986920.19544 | 2112296.72927 | 37.779208328318795 | -122.48885709710599 | (37.7792083283188, -122.488857097106) | |||
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) | |||
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) | |||
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) | |||
133819 | 133819 | 120070 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 101 26th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 2ft | 5987678.122930001 | 2115272.13774 | 37.7874221569894 | -122.48645366177401 | (37.7874221569894, -122.486453661774) | |||
112041 | 112041 | 121326 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 19 25th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5987896.0 | 2115988.0 | 37.7894004070969 | -122.48575242171101 | (37.7894004070969, -122.485752421711) | ||||
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) | |||
174872 | 174872 | 183003 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2570 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5988097.5458 | 2098263.8729 | 37.740746562571005 | -122.48375503089301 | (37.740746562571, -122.483755030893) | |||
54348 | 54348 | 183004 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2550 Ulloa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5988132.401000001 | 2098265.1638 | 37.7407521359399 | -122.483634610884 | (37.7407521359399, -122.483634610884) | |||
168701 | 168701 | 182592 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2489 26th Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5988273.3615 | 2098387.8742 | 37.7410972704537 | -122.483156220906 | (37.7410972704537, -122.483156220906) | |||
50099 | 50099 | 108350 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1501x RIVERA ST | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5988383.0 | 2100343.0 | 37.746471910315705 | -122.482920391178 | (37.7464719103157, -122.482920391178) | ||||
94535 | 94535 | 108345 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1501x RIVERA ST | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5988383.0 | 2100343.0 | 37.746471910315705 | -122.482920391178 | (37.7464719103157, -122.482920391178) | ||||
99148 | 99148 | 108346 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1501x RIVERA ST | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5988383.0 | 2100343.0 | 37.746471910315705 | -122.482920391178 | (37.7464719103157, -122.482920391178) | ||||
99222 | 99222 | 108353 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1501x RIVERA ST | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5988383.0 | 2100343.0 | 37.746471910315705 | -122.482920391178 | (37.7464719103157, -122.482920391178) | ||||
124192 | 124192 | 108351 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1501x RIVERA ST | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5988383.0 | 2100343.0 | 37.746471910315705 | -122.482920391178 | (37.7464719103157, -122.482920391178) | ||||
124212 | 124212 | 108347 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1501x RIVERA ST | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5988383.0 | 2100343.0 | 37.746471910315705 | -122.482920391178 | (37.7464719103157, -122.482920391178) | ||||
129230 | 129230 | 108349 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1501x RIVERA ST | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5988383.0 | 2100343.0 | 37.746471910315705 | -122.482920391178 | (37.7464719103157, -122.482920391178) | ||||
120444 | 120444 | 120172 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2300 Balboa St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 5988392.10695 | 2111261.25032 | 37.7764509846763 | -122.483689270751 | (37.7764509846763, -122.483689270751) | |||
63662 | 63662 | 120171 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2300 Balboa St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 5988414.35774 | 2111262.94747 | 37.7764569397419 | -122.48361242435 | (37.7764569397419, -122.48361242435) | |||
81185 | 81185 | 108348 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1501x RIVERA ST | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 3x3 | 5988501.0 | 2100296.0 | 37.746349726050894 | -122.48250892192699 | (37.7463497260509, -122.482508921927) | |||
158597 | 158597 | 120329 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 22nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5988944.22714 | 2115048.40717 | 37.7868815758996 | -122.48205685669 | (37.7868815758996, -122.48205685669) | |||
108530 | 108530 | 110402 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 419X 18TH AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | MTA 10 | 3x3 | 5990240.0 | 2112557.0 | 37.7801161452828 | -122.477391675869 | (37.7801161452828, -122.477391675869) | |||
115819 | 115819 | 110406 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 419X 18TH AVE | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | MTA 10 | 3x3 | 5990240.0 | 2112557.0 | 37.7801161452828 | -122.477391675869 | (37.7801161452828, -122.477391675869) | |||
144668 | 144668 | 110414 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 419X 18TH AVE | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | MTA 10 | 3x3 | 5990240.0 | 2112557.0 | 37.7801161452828 | -122.477391675869 | (37.7801161452828, -122.477391675869) | |||
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) | |||
43911 | 43911 | 219267 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1486 19th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5990295.40982 | 2105284.56966 | 37.7601512467979 | -122.476668525453 | (37.7601512467979, -122.476668525453) | |||
49550 | 49550 | 219265 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1586 19th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 5990318.67489 | 2104606.71448 | 37.758291386764604 | -122.47653854281401 | (37.7582913867646, -122.476538542814) | |||
40450 | 40450 | 219269 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1330 Kirkham St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 2ft | 5990592.20952 | 2105220.86504 | 37.7599935416893 | -122.47563739517099 | (37.7599935416893, -122.475637395171) | |||
172366 | 172366 | 219268 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1330 Kirkham St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 2ft | 5990642.8904800005 | 2105223.71561 | 37.760004306576704 | -122.47546232413299 | (37.7600043065767, -122.475462324133) | |||
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) | |||
178909 | 178909 | 219365 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 57 Lagunitas Dr | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 5990937.49847 | 2095339.3344400001 | 37.7328814326142 | -122.473722354509 | (37.7328814326142, -122.473722354509) | |||
76628 | 76628 | 219364 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 57 Lagunitas Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 5990943.63906 | 2095348.36175 | 37.732906574966 | -122.473701783431 | (37.732906574966, -122.473701783431) | |||
40056 | 40056 | 219363 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 57 Lagunitas Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 3ft | 5990950.29751 | 2095356.30121 | 37.7329287603452 | -122.47367934265199 | (37.7329287603452, -122.473679342652) | |||
84330 | 84330 | 111073 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1450 IRVING ST | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Fire Dept 11 | 3x3 | 5991201.0 | 2106639.0 | 37.7639226370674 | -122.473635352969 | (37.7639226370674, -122.473635352969) | ||||
173591 | 173591 | 219330 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1025 Junipero Serra Blvd | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5991259.76279 | 2090425.50198 | 37.7194079318084 | -122.472250145444 | (37.7194079318084, -122.472250145444) | |||
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) | |||
24248 | 24248 | 219332 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1025 Junipero Serra Blvd | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 5991262.77441 | 2090479.13965 | 37.719555381949206 | -122.47224364333 | (37.7195553819492, -122.47224364333) | |||
145895 | 145895 | 111072 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1450 IRVING ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Fire Dept 11 | 3x3 | 5991277.0 | 2106586.0 | 37.7637815143869 | -122.473368628437 | (37.7637815143869, -122.473368628437) | ||||
167004 | 167004 | 219256 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1948 16th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 5ft | 5991302.1918 | 2102132.80922 | 37.751555686753704 | -122.47295674457199 | (37.7515556867537, -122.472956744572) | |||
52693 | 52693 | 219257 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1948 16th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 1ft | 5991302.37835 | 2102159.67648 | 37.7516294680371 | -122.47295805847 | (37.7516294680371, -122.47295805847) | |||
30448 | 30448 | 122000 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3848 Fulton St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5991408.48983 | 2110002.47291 | 37.773169842884 | -122.473163026058 | (37.773169842884, -122.473163026058) | |||
157567 | 157567 | 122301 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1301 Balboa St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 5991504.38073 | 2111297.95565 | 37.77673243758429 | -122.47292581513099 | (37.7767324375843, -122.472925815131) | |||
151023 | 151023 | 122300 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1301 Balboa St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 5991520.86035 | 2111297.3922599996 | 37.7767318447096 | -122.47286876669901 | (37.7767318447096, -122.472868766699) | |||
53699 | 53699 | 122299 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1301 Balboa St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 5991529.77112 | 2111298.06861 | 37.7767342176341 | -122.472837991331 | (37.7767342176341, -122.472837991331) | |||
179668 | 179668 | 122298 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1301 Balboa St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 5991539.76663 | 2111298.7220900003 | 37.7767365905508 | -122.472803461891 | (37.7767365905508, -122.472803461891) | |||
178759 | 178759 | 122297 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1301 Balboa St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 5991554.96298 | 2111299.05 | 37.7767383705979 | -122.472750917629 | (37.7767383705979, -122.472750917629) | |||
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) | |||
96170 | 96170 | 113366 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 799X ORTEGA WAY | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5991631.0 | 2102457.0 | 37.7524648607614 | -122.47184332039 | (37.7524648607614, -122.47184332039) | ||||
67530 | 67530 | 219258 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1383 14th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 5ft | 5991755.50234 | 2106034.38103 | 37.7622946118155 | -122.471673449788 | (37.7622946118155, -122.471673449788) | |||
52597 | 52597 | 219259 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1383 14th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 5ft | 5991755.795469999 | 2106024.31497 | 37.762266990044296 | -122.47167170238501 | (37.7622669900443, -122.471671702385) | |||
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) | |||
52562 | 52562 | 219270 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1220 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5991777.52525 | 2107074.159 | 37.7651508397576 | -122.47167305767701 | (37.7651508397576, -122.471673057677) | |||
133076 | 133076 | 219260 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1474 14th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 5991838.53608 | 2105394.78009 | 37.76054324059329 | -122.47133966548999 | (37.7605432405933, -122.47133966549) | |||
155438 | 155438 | 219261 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1474 14th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 5991838.80839 | 2105407.70573 | 37.7605787467375 | -122.47133966550699 | (37.7605787467375, -122.471339665507) |
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");