Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo, qCaretaker
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) | |||
5604 | 5604 | 19964 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 100 STAIRWAY41 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
8096 | 8096 | 19962 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 100 STAIRWAY41 | -2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
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) | |||
9264 | 9264 | 19963 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 100 STAIRWAY41 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
10717 | 10717 | 25296 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 158 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6000552.574130001 | 2091731.5353 | 37.723527432941204 | -122.44022202823 | (37.7235274329412, -122.44022202823) | |||
11045 | 11045 | 27100 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 675 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6005860.0759 | 2093589.7540900002 | 37.728930444682206 | -122.422006859139 | (37.7289304446822, -122.422006859139) | |||
11331 | 11331 | 1100 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 2328 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 5999423.31284 | 2089282.1433599999 | 37.71673760544579 | -122.44394976577298 | (37.7167376054458, -122.443949765773) | |||
11566 | 11566 | 16410 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1186X Munich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | TR | 6001066.26402 | 2087197.59203 | 37.7111074743937 | -122.43812166787501 | (37.7111074743937, -122.438121667875) | |||
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) | |||
14648 | 14648 | 19819 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 100 STAIRWAY25 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 100ST | ||||||||
15377 | 15377 | 25938 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 2000 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 12 | 3x3 | 6012867.3394 | 2097145.5573099998 | 37.739086658519895 | -122.39803142710899 | (37.7390866585199, -122.398031427109) | ||
15925 | 15925 | 25939 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 2000 Oakdale Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 10 | 3x3 | 6012857.31615 | 2097153.53613 | 37.7391080084261 | -122.39806664277201 | (37.7391080084261, -122.398066642772) | ||
16907 | 16907 | 16140 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 370 Monterey Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5999741.99698 | 2094725.2386 | 37.7317012657937 | -122.44323895423099 | (37.7317012657937, -122.443238954231) | |||
16920 | 16920 | 19979 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 100 STAIRWAY45 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 30ST | ||||||||
17854 | 17854 | 4283 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 4301 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/07/1995 12:00:00 AM | 3 | 3X3 | 6001860.11761 | 2100274.84005 | 37.7470597321331 | -122.436313221179 | (37.7470597321331, -122.436313221179) | ||
17954 | 17954 | 16098 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 300 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/17/1997 12:00:00 AM | 6 | 2X3 | 6000050.52204 | 2094718.8331 | 37.7317012658005 | -122.442171864536 | (37.7317012658005, -122.442171864536) | ||
18293 | 18293 | 4370 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 998 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/1992 12:00:00 AM | 12 | 3X3 | 6001204.190330001 | 2096097.5771700002 | 37.7355526592134 | -122.438282146497 | (37.7355526592134, -122.438282146497) | ||
18654 | 18654 | 16099 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 300 Monterey Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000036.69943 | 2094718.89433 | 37.7317006461483 | -122.442219656332 | (37.7317006461483, -122.442219656332) | |||
18666 | 18666 | 19313 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 21 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 5993901.63447 | 2089816.98545 | 37.7178896324771 | -122.463074115289 | (37.7178896324771, -122.463074115289) | |||
19631 | 19631 | 16102 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 300 Monterey Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000017.68556 | 2094719.9660099999 | 37.7317025050652 | -122.442285467815 | (37.7317025050652, -122.442285467815) | |||
21152 | 21152 | 4284 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 4301 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/07/1995 12:00:00 AM | 3 | 3X3 | 6001863.40945 | 2100279.02786 | 37.747071417908 | -122.43630213795299 | (37.747071417908, -122.436302137953) | ||
21395 | 21395 | 16100 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 300 Monterey Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000028.57256 | 2094720.41703 | 37.7317043639536 | -122.442247861742 | (37.7317043639536, -122.442247861742) | |||
21593 | 21593 | 16127 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 330 Monterey Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 5999874.93833 | 2094721.1240700001 | 37.7316975479954 | -122.442779055318 | (37.7316975479954, -122.442779055318) | |||
22554 | 22554 | 17779 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1777 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6005479.2802 | 2115475.38688 | 37.789001770571296 | -122.424879716433 | (37.7890017705713, -122.424879716433) | |||
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) | ||
26965 | 26965 | 66051 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1632 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/1990 12:00:00 AM | 12 | Permit Number 29090 | 6002925.71156 | 2121006.29112 | 37.8040436368686 | -122.434110258988 | (37.8040436368686, -122.434110258988) | ||
27010 | 27010 | 61931 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1407 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/11/1985 12:00:00 AM | 11 | Permit Number 21986 | 6011381.98525 | 2120211.6051 | 37.8023379197065 | -122.404790601229 | (37.8023379197065, -122.404790601229) | ||
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) | |||
28089 | 28089 | 94904 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 3701 Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 5997050.00292 | 2115323.90542 | 37.788106124051 | -122.454032799976 | (37.788106124051, -122.454032799976) | |||
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) | |||
30510 | 30510 | 30812 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 100 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1995 12:00:00 AM | 5 | Permit Number 34674 | 6001381.93618 | 2094967.05294 | 37.7324586091634 | -122.43758667648001 | (37.7324586091634, -122.43758667648) | |
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) | |||
32407 | 32407 | 866 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 600X Alemany Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 1X1 | 6007241.9784 | 2095034.8696299999 | 37.7329762592527 | -122.41733187808398 | (37.7329762592527, -122.417331878084) | |||
33037 | 33037 | 60417 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1409 Keith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1982 12:00:00 AM | 8 | Permit Number 19998 | 6016082.74679 | 2094573.4644900002 | 37.732202770925205 | -122.386734593253 | (37.7322027709252, -122.386734593253) | ||
35096 | 35096 | 103483 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 116 Merrill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/2013 12:00:00 AM | 2 | 3x3 | Permit Number 770307 | 6009546.84586 | 2094694.0586599999 | 37.73216987282029 | -122.409339274108 | (37.7321698728203, -122.409339274108) | |
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) | |||
35180 | 35180 | 68976 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 2550 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1994 12:00:00 AM | 7 | Permit Number 32966 | 5999654.77227 | 2119511.53893 | 37.7997532672523 | -122.44532199182301 | (37.7997532672523, -122.445321991823) | |
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) | |||
38700 | 38700 | 64762 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 648 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/09/1988 12:00:00 AM | 8 | Permit Number 25739 | 5991956.18292 | 2111010.7557900003 | 37.7759700106605 | -122.471341981082 | (37.7759700106605, -122.471341981082) | ||
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) | |||
39860 | 39860 | 42981 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 387 Princeton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2000 12:00:00 AM | 9 | Permit Number 42865 | 6007925.78486 | 2092082.5600700001 | 37.7249083014575 | -122.414758909799 | (37.7249083014575, -122.414758909799) | |
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) | |||
44115 | 44115 | 31115 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 450 Edna St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 5 | Permit Number 34839 | 5998792.06252 | 2094332.58617 | 37.7305689213091 | -122.44649481749201 | (37.7305689213091, -122.446494817492) | |
44382 | 44382 | 54527 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 4550 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/1972 12:00:00 AM | 8 | 3x5 | Permit Number 10322 | 5981462.67511 | 2111006.65453 | 37.775346149152 | -122.507640822085 | (37.775346149152, -122.507640822085) | |
44824 | 44824 | 68547 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 526 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/1993 12:00:00 AM | 9 | Permit Number 32434 | 5982567.23967 | 2112157.10709 | 37.7785699651083 | -122.50390516811599 | (37.7785699651083, -122.503905168116) | ||
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) | |||
46668 | 46668 | 32026 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 910 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/2005 12:00:00 AM | 2 | Permit Number 48084 | 6011942.61594 | 2111635.52885 | 37.7788213676447 | -122.40224721144399 | (37.7788213676447, -122.402247211444) | ||
46998 | 46998 | 44750 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 524 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/06/2001 12:00:00 AM | 3 | Permit Number 43866 | 5987216.13778 | 2112350.62215 | 37.779373569745104 | -122.487837284703 | (37.7793735697451, -122.487837284703) | ||
48359 | 48359 | 66778 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1335 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/20/1991 12:00:00 AM | 5 | Permit Number 30043 | 6006555.48078 | 2119018.76457 | 37.798791728305396 | -122.42140793763001 | (37.7987917283054, -122.42140793763) | |
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) | |||
49793 | 49793 | 53948 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 106 Gaven St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/2012 12:00:00 AM | 10 | Permit Number 769123 | 6009998.5111 | 2095243.6282 | 37.733704169294 | -122.407816497929 | (37.733704169294, -122.407816497929) | ||
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) | |||
56672 | 56672 | 96034 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1075 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767673 | 6008986.730930001 | 2117980.65751 | 37.7960781193685 | -122.41292155709999 | (37.7960781193685, -122.4129215571) |
56837 | 56837 | 65503 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 2727 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1989 12:00:00 AM | 5 | Permit Number 28387 | 6000480.85647 | 2117478.59942 | 37.7942184733604 | -122.442317420725 | (37.7942184733604, -122.442317420725) | ||
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) | ||
61110 | 61110 | 92458 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 3319 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52848 | 5983933.4582 | 2104246.8072 | 37.756930776386795 | -122.498594490514 | (37.7569307763868, -122.498594490514) |
61376 | 61376 | 43140 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1 Gambier St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/2000 12:00:00 AM | 3 | Permit Number 42953 | 6005716.6320400005 | 2093488.3927799999 | 37.7286440375939 | -122.42249555614299 | (37.7286440375939, -122.422495556143) | ||
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) | |||
64687 | 64687 | 31118 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 450 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 7 | Permit Number 34839 | 5998792.48559 | 2094316.2837 | 37.730524182724 | -122.446492182475 | (37.730524182724, -122.446492182475) | |
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) | |||
69062 | 69062 | 35257 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 2363 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | 2 | Permit Number 43818 | 6006687.16748 | 2119377.40243 | 37.799783881083606 | -122.420977735243 | (37.7997838810836, -122.420977735243) | |
70097 | 70097 | 58139 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 378 Gaven St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/1978 12:00:00 AM | 7 | Permit Number 17123 | 6008540.16815 | 2094753.5725900002 | 37.7322768319131 | -122.412823801697 | (37.7322768319131, -122.412823801697) | ||
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) | |||
75317 | 75317 | 34709 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 727 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 25 | Permit Number 38365 | 5981632.43118 | 2110780.81019 | 37.7747360459971 | -122.50703684968501 | (37.7747360459971, -122.507036849685) | |
76264 | 76264 | 44486 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 390 Harvard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | 16 | Permit Number 43792 | 6006402.34332 | 2092081.2102700002 | 37.724818880074395 | -122.420025186814 | (37.7248188800744, -122.420025186814) |
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");