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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4190 | 4190 | 100829 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1601X North Point St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003036.60353 | 2120959.36193 | 37.803921074561295 | -122.43372315391198 | (37.8039210745613, -122.433723153912) | |||
8375 | 8375 | 100825 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3661 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003069.70231 | 2120954.84645 | 37.803910554290795 | -122.43360829069401 | (37.8039105542908, -122.433608290694) | |||
8632 | 8632 | 99720 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2164 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6007185.20399 | 2119756.67852 | 37.8008533386708 | -122.41928126041701 | (37.8008533386708, -122.419281260417) | |||
12269 | 12269 | 106828 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 631 Hamilton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6009794.12958 | 2091448.15219 | 37.7232711495323 | -122.40825550289 | (37.7232711495323, -122.40825550289) | |||
14463 | 14463 | 110915 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 77 Federal St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 2x1 | 6014720.0191 | 2113052.86526 | 37.7828676936327 | -122.39273818212 | (37.7828676936327, -122.39273818212) | |||
23567 | 23567 | 137685 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 720 BAKER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6000552.856000001 | 2111474.7278 | 37.7777374972355 | -122.441637228704 | (37.7777374972355, -122.441637228704) | |||
24920 | 24920 | 226888 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 295 Coso Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6007787.28925 | 2099470.27806 | 37.745185579151396 | -122.415760542322 | (37.7451855791514, -122.415760542322) | |||
25548 | 25548 | 71937 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1053 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1995 12:00:00 AM | 4 | 6011562.24883 | 2118965.23166 | 37.7989257551836 | -122.404079031531 | (37.7989257551836, -122.404079031531) | ||
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) | |||
28070 | 28070 | 190826 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 256 Terry A Francois Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 6ft | 6016386.63874 | 2108737.40916 | 37.771110828636296 | -122.38667129537 | (37.7711108286363, -122.38667129537) | |||
28768 | 28768 | 110918 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 77 Federal St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 2x1 | 6014775.51071 | 2113108.67341 | 37.7830240119856 | -122.392550107818 | (37.7830240119856, -122.392550107818) | |||
30388 | 30388 | 226889 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 21 Bradford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6009640.71829 | 2098586.38073 | 37.7428626087272 | -122.409289311345 | (37.7428626087272, -122.409289311345) | |||
30977 | 30977 | 226957 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 4415 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001675.32551 | 2104070.79205 | 37.75747200635521 | -122.437223965526 | (37.7574720063552, -122.437223965526) | |||
35098 | 35098 | 142469 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 548 VARENNES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6010746.4928 | 2119899.9648 | 37.8014466914345 | -122.40696774883999 | (37.8014466914345, -122.40696774884) | |||
35782 | 35782 | 190765 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1050 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6015259.20985 | 2101616.65669 | 37.751496295539106 | -122.39007361861601 | (37.7514962955391, -122.390073618616) | |||
36439 | 36439 | 226890 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 257 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6009790.06992 | 2099605.20569 | 37.7456684458592 | -122.408844757605 | (37.7456684458592, -122.408844757605) | |||
36482 | 36482 | 226955 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 160 Bradford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6009521.12916 | 2097699.3584 | 37.7404203378164 | -122.409640225031 | (37.7404203378164, -122.409640225031) | |||
37590 | 37590 | 176608 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 245 Chicago Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6002866.9269 | 2086792.03649 | 37.710096150800794 | -122.431869203328 | (37.7100961508008, -122.431869203328) | |||
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) | |||
38642 | 38642 | 176865 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1142 Munich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6001491.17517 | 2087075.7451099998 | 37.7107970662038 | -122.436644357861 | (37.7107970662038, -122.436644357861) | |||
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) | |||
39856 | 39856 | 129108 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 155 Retiro Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001855.64531 | 2121684.5263400003 | 37.805845102121296 | -122.43786189781 | (37.8058451021213, -122.43786189781) | |||
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) | |||
40696 | 40696 | 219275 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1651 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 5993370.433230001 | 2104236.7588299997 | 37.7574521115395 | -122.465957429918 | (37.7574521115395, -122.465957429918) | |||
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) | |||
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) | |||
46536 | 46536 | 176864 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1142 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6001508.44833 | 2087074.49051 | 37.710794602952106 | -122.436584568222 | (37.7107946029521, -122.436584568222) | |||
49176 | 49176 | 190825 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 256 Terry A Francois Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 6ft | 6016379.81466 | 2108741.5288400003 | 37.771121762579604 | -122.38669518764699 | (37.7711217625796, -122.386695187647) | |||
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) | |||
51393 | 51393 | 190771 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 15 Tubbs St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6015464.37774 | 2103329.09363 | 37.7562096621716 | -122.389483695716 | (37.7562096621716, -122.389483695716) | |||
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) | |||
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) | |||
54321 | 54321 | 70512 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 75 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1994 12:00:00 AM | 5 | 6004917.4216 | 2092965.0192099998 | 37.7271618505134 | -122.425221249286 | (37.7271618505134, -122.425221249286) | ||
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) | |||
54473 | 54473 | 103306 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 611 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 6011832.19369 | 2105491.00064 | 37.7619437242424 | -122.402197092231 | (37.7619437242424, -122.402197092231) | ||||
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) | |||
55719 | 55719 | 110572 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 46 COOK ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 5997534.0 | 2113434.0 | 37.782944683725 | -122.45222184269899 | (37.782944683725, -122.452221842699) | ||||
56126 | 56126 | 123951 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 394 08th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 5993436.16113 | 2112921.30545 | 37.7813013648658 | -122.46636127827101 | (37.7813013648658, -122.466361278271) | |||
56417 | 56417 | 190827 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 256 Terry A Francois Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 6ft | 6016391.891340001 | 2108709.42861 | 37.771034290942204 | -122.386651174818 | (37.7710342909422, -122.386651174818) | |||
56530 | 56530 | 129361 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 555 California St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6011684.8742 | 2116686.03693 | 37.7926744848808 | -122.403494267154 | (37.7926744848808, -122.403494267154) | |||
58086 | 58086 | 190766 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1400 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6015346.06271 | 2101819.81527 | 37.752058942870995 | -122.389787457026 | (37.752058942871, -122.389787457026) | |||
58423 | 58423 | 226867 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 23 Juri St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 6005990.48773 | 2101222.9851599997 | 37.7498969403125 | -122.422098075583 | (37.7498969403125, -122.422098075583) | |||
59244 | 59244 | 71583 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 266 Flournoy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 7 | 5993925.4185 | 2086705.1573599998 | 37.7093466620935 | -122.462766282735 | (37.7093466620935, -122.462766282735) | ||
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) | |||
62195 | 62195 | 84689 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3632 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3 | 6002195.05393 | 2120739.39081 | 37.80326930438871 | -122.436619630107 | (37.8032693043887, -122.436619630107) | |||
62256 | 62256 | 226935 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1487 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6003327.81293 | 2099584.98733 | 37.7452488410797 | -122.431188824809 | (37.7452488410797, -122.431188824809) | |||
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) | |||
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) | |||
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) | |||
70285 | 70285 | 190830 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 256 Terry A Francois Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 6ft | 6016394.93406 | 2108680.04428 | 37.770953776427895 | -122.38663860051001 | (37.7709537764279, -122.38663860051) | |||
71205 | 71205 | 190824 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 256 Terry A Francois Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 6ft | 6016384.03812 | 2108752.66613 | 37.7711525769716 | -122.38668135517901 | (37.7711525769716, -122.386681355179) | |||
73520 | 73520 | 226921 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 75 Zircon Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002389.45965 | 2098613.58305 | 37.7425283720786 | -122.434364050378 | (37.7425283720786, -122.434364050378) | |||
78535 | 78535 | 110569 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 46 COOK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 5997534.0 | 2113434.0 | 37.782944683725 | -122.45222184269899 | (37.782944683725, -122.452221842699) | ||||
107354 | 107354 | 110571 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 46 COOK ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 5997534.0 | 2113434.0 | 37.782944683725 | -122.45222184269899 | (37.782944683725, -122.452221842699) | ||||
107819 | 107819 | 114704 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 524 Staples Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5996948.70097149 | 2093858.06219815 | 37.729160530354 | -122.452833321223 | (37.729160530354, -122.452833321223) | |||||
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) | |||
124373 | 124373 | 110570 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 46 COOK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 5997534.0 | 2113434.0 | 37.782944683725 | -122.45222184269899 | (37.782944683725, -122.452221842699) | ||||
132065 | 132065 | 226896 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1243 Valencia St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | Width 3ft | 6006432.373930001 | 2102561.6161 | 37.7535974274886 | -122.420665025691 | (37.7535974274886, -122.420665025691) | |||
132381 | 132381 | 226897 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1035 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 5999804.0569 | 2099745.02655 | 37.745487953702 | -122.443384833249 | (37.745487953702, -122.443384833249) | |||
132689 | 132689 | 176620 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 114 Desmond St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6010562.66148 | 2086802.426 | 37.710557939180795 | -122.405271825739 | (37.7105579391808, -122.405271825739) | |||
132978 | 132978 | 190823 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 184 Hooper St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 8ft | 6012465.245630001 | 2107532.99928 | 37.7675859124819 | -122.400151016782 | (37.7675859124819, -122.400151016782) | |||
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) | |||
134612 | 134612 | 190772 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1099 Tennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 1ft | 6015576.75199 | 2103999.13742 | 37.7580556897494 | -122.389141847222 | (37.7580556897494, -122.389141847222) | |||
134676 | 134676 | 226905 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1334 Douglass St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6001346.10314 | 2099785.59551 | 37.7456871634399 | -122.438055596491 | (37.7456871634399, -122.438055596491) | |||
135527 | 135527 | 226938 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 471 Eureka St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6001539.72825 | 2103087.28578 | 37.754763826593496 | -122.437622481215 | (37.7547638265935, -122.437622481215) | |||
137589 | 137589 | 101799 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 616 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 6x6 | 6012351.43379 | 2105077.38644 | 37.7608370005419 | -122.400372179851 | (37.7608370005419, -122.400372179851) | |||
137719 | 137719 | 190768 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1475 Indiana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6015141.73354 | 2101746.8036700003 | 37.751847135458895 | -122.39048896238998 | (37.7518471354589, -122.39048896239) | |||
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) | |||
147284 | 147284 | 176635 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 280 Tocoloma Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6012623.11061 | 2087166.05245 | 37.7116713673138 | -122.398175911295 | (37.7116713673138, -122.398175911295) | |||
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) | |||
149982 | 149982 | 190828 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 256 Terry A Francois Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 6ft | 6016393.1041 | 2108697.45755 | 37.7710014881618 | -122.386646144905 | (37.7710014881618, -122.386646144905) | |||
151494 | 151494 | 110917 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 77 Federal St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 2x1 | 6014761.22745 | 2113096.50864 | 37.7829898170664 | -122.39259867121001 | (37.7829898170664, -122.39259867121) | |||
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) | |||
151842 | 151842 | 226892 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 533 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6009849.313709999 | 2098992.71311 | 37.743989993451 | -122.408596701189 | (37.743989993451, -122.408596701189) | |||
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) | |||
157403 | 157403 | 226885 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1577 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 5997889.74449 | 2105168.82757 | 37.760271015821296 | -122.450395110664 | (37.7602710158213, -122.450395110664) | |||
159101 | 159101 | 226886 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1577 Shrader St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5997890.66163 | 2105156.29016 | 37.760236643732796 | -122.450391034916 | (37.7602366437328, -122.450391034916) | |||
159879 | 159879 | 176598 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 156 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6000311.35306 | 2092335.41636 | 37.725171815405 | -122.441099188288 | (37.725171815405, -122.441099188288) | |||
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) | |||
164696 | 164696 | 110916 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 77 Federal St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 2x1 | 6014753.14393 | 2113088.0309200003 | 37.7829660902443 | -122.392626043851 | (37.7829660902443, -122.392626043851) | |||
167059 | 167059 | 176607 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1186 Munich St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 6001048.8202 | 2087208.00194 | 37.7111350656127 | -122.438182703088 | (37.7111350656127, -122.438182703088) | |||
167504 | 167504 | 226901 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1322 Douglass St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6001336.59248 | 2099937.64594 | 37.746104117009295 | -122.438099372796 | (37.7461041170093, -122.438099372796) | |||
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) | |||
170147 | 170147 | 190829 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 256 Terry A Francois Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 6ft | 6016399.44084 | 2108687.19343 | 37.770973655936 | -122.386623509886 | (37.770973655936, -122.386623509886) | |||
170907 | 170907 | 129360 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 555 California St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6011669.484759999 | 2116684.16602 | 37.7926684882083 | -122.40354738383002 | (37.7926684882083, -122.40354738383) | |||
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) | |||
175407 | 175407 | 219276 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1607 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 5993358.66826 | 2104530.96639 | 37.75825925039079 | -122.466019495715 | (37.7582592503908, -122.466019495715) | |||
178358 | 178358 | 226936 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1487 Noe St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6003327.22961 | 2099593.7477 | 37.7452728619629 | -122.431191467012 | (37.7452728619629, -122.431191467012) | |||
180106 | 180106 | 176853 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 44 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 6ft | 6002702.22859 | 2087060.99975 | 37.7108253274008 | -122.43245763061 | (37.7108253274008, -122.43245763061) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
26608 | 26608 | 219368 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 151 Elmwood Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5994978.25407 | 2092702.73333 | 37.72587516529521 | -122.45956163048099 | (37.7258751652952, -122.459561630481) | |||
32222 | 32222 | 219278 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 70 Marcela Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5994659.22206 | 2100668.89439 | 37.747729927596396 | -122.46124169176001 | (37.7477299275964, -122.46124169176) |
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");