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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 112118 | 112118 | 878 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 600X Alemany Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 1X1 | 6007241.9784 | 2095034.8696299999 | 37.7329762592527 | -122.41733187808398 | (37.7329762592527, -122.417331878084) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 100221 | 100221 | 5821 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1027 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 75 | 3X3 | 5999811.0829915 | 2099731.7400522 | 37.745451872839 | -122.443359584044 | (37.745451872839, -122.443359584044) | |||
| 110428 | 110428 | 12623 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 825 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 27 | 3X3 | 5992882.168 | 2114794.01241 | 37.7864113245051 | -122.468414093066 | (37.7864113245051, -122.468414093066) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 95182 | 95182 | 16377 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1400X Montgomery St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8 | 6011455.2971485 | 2120087.0441833 | 37.8020000032358 | -122.404528131508 | (37.8020000032358, -122.404528131508) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 14648 | 14648 | 19819 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 100 STAIRWAY25 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 100ST | ||||||||
| 8096 | 8096 | 19962 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 100 STAIRWAY41 | -2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
| 9264 | 9264 | 19963 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 100 STAIRWAY41 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
| 5604 | 5604 | 19964 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 100 STAIRWAY41 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
| 16920 | 16920 | 19979 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 100 STAIRWAY45 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 30ST | ||||||||
| 139863 | 139863 | 24744 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 128X Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/1996 12:00:00 AM | 3 | 3x3 | 5982380.471419999 | 2112632.1433099997 | 37.7798632908372 | -122.504586464809 | (37.7798632908372, -122.504586464809) | ||
| 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) | |||
| 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) | ||
| 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) | |||
| 157750 | 157750 | 30806 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 138 Hamerton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1995 12:00:00 AM | 15 | Permit Number 34671 | 6001325.75026 | 2095385.6774799998 | 37.7336048607826 | -122.437810896383 | (37.7336048607826, -122.437810896383) | |
| 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) | |
| 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) | |
| 131920 | 131920 | 31117 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 450 Edna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 3 | Permit Number 34839 | 5998792.33216 | 2094320.7757 | 37.7305365079364 | -122.446493035949 | (37.7305365079364, -122.446493035949) | |
| 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) | |
| 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) | ||
| 159523 | 159523 | 34521 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 306 Harvard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/1997 12:00:00 AM | 11 | Permit Number 38231 | 6006308.04583 | 2092388.1729 | 37.725656419580496 | -122.42037294026301 | (37.7256564195805, -122.420372940263) | ||
| 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) | |
| 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) | |
| 146783 | 146783 | 35594 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1303 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2005 12:00:00 AM | 5 | Permit Number 38957 | 6012015.58746 | 2102213.6753599998 | 37.752955146087295 | -122.401332479509 | (37.7529551460873, -122.401332479509) | |
| 167693 | 167693 | 38364 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 4001 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/2002 12:00:00 AM | 5 | Permit Number 44994 | 5981794.8549 | 2104174.5597 | 37.7566067521127 | -122.50598509825001 | (37.7566067521127, -122.50598509825) | |
| 186712 | 186712 | 38366 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 4001 Lawton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/1998 12:00:00 AM | 6 | Permit Number 40430 | 5981835.1907 | 2104176.6987 | 37.756614999407894 | -122.50584576351999 | (37.7566149994079, -122.50584576352) | ||
| 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) | |
| 183234 | 183234 | 43136 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1730 Burrows St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 7 | Permit Number 42952 | 6006290.853069999 | 2092023.3911599999 | 37.7246538391803 | -122.42040649398199 | (37.7246538391803, -122.420406493982) | |
| 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) | ||
| 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) | |
| 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) | ||
| 136530 | 136530 | 46600 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 2425 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/2002 12:00:00 AM | 5 | Permit Number 44728 | 6001248.41305 | 2117934.15473 | 37.795513025858 | -122.439694270995 | (37.795513025858, -122.439694270995) | ||
| 174140 | 174140 | 49714 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1181@ POLK Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/2003 12:00:00 AM | 5 | Permit Number 46526 | 6006207.33741 | 2120358.03247 | 37.8024493825888 | -122.422707853704 | (37.8024493825888, -122.422707853704) | |
| 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) | ||
| 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) | |
| 130260 | 130260 | 54791 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 280 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/02/1972 12:00:00 AM | 18 | Permit Number 10640 | 6012628.37407 | 2087183.5823 | 37.711719793993204 | -122.39815894829901 | (37.7117197939932, -122.398158948299) | ||
| 173736 | 173736 | 57800 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 837 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/1977 12:00:00 AM | 9 | Permit Number 16735 | 5981352.9647 | 2110030.94394 | 37.7726606704836 | -122.50794790130199 | (37.7726606704836, -122.507947901302) | ||
| 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) | ||
| 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) | ||
| 148745 | 148745 | 61250 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 2033 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/15/1997 12:00:00 AM | 7 | Permit Number 24211 | 6007651.97178 | 2119454.00624 | 37.800048553351296 | -122.41764457883001 | (37.8000485533513, -122.41764457883) | |
| 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) | ||
| 134405 | 134405 | 62997 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 3718 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2015 12:00:00 AM | 6 | Permit Number 776580 | 6000198.89461 | 2121071.17508 | 37.8040666559246 | -122.443551231218 | (37.8040666559246, -122.443551231218) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 133392 | 133392 | 68011 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 2550 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1993 12:00:00 AM | 4 | Permit Number 31741 | 6007478.84194 | 2121154.66744 | 37.8047083959278 | -122.41836432607501 | (37.8047083959278, -122.418364326075) | ||
| 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) | ||
| 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) | |
| 180391 | 180391 | 69013 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 2183 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1994 12:00:00 AM | 4 | Permit Number 33017 | 5982309.8617 | 2100270.0071 | 37.7459162464128 | -122.50391486605301 | (37.7459162464128, -122.503914866053) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 92708 | 92708 | 85104 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1403 11th Ave | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 9 | 2x2 | Tree 1 | 5992673.9 | 2105865.8 | 37.7618848250494 | -122.46848481907499 | (37.7618848250494, -122.468484819075) | ||
| 85124 | 85124 | 85121 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1403 11th Ave | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 02/27/2007 12:00:00 AM | 7 | 2x2 | Tree 2. Permit Number 49495. | 5992673.9 | 2105865.8 | 37.7618848250494 | -122.46848481907499 | (37.7618848250494, -122.468484819075) | |
| 66823 | 66823 | 87246 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 236323 Larkin St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 02/19/2008 12:00:00 AM | 22 | 3x3 | Permit Number 50274 | 6006702.92902 | 2119345.02683 | 37.7996958743116 | -122.420920894495 | (37.7996958743116, -122.420920894495) | |
| 163077 | 163077 | 87247 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 236323 Larkin St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 02/19/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50274 | 6006692.88945 | 2119331.74907 | 37.7996588510331 | -122.42095469191601 | (37.7996588510331, -122.420954691916) | |
| 97319 | 97319 | 88347 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 100x Vienna St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51332 | 6004738.0 | 2092796.0 | 37.7266876232591 | -122.425829482771 | (37.7266876232591, -122.425829482771) | |||
| 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) |
| 139234 | 139234 | 93020 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1403 11th Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 2x2 | Tree 3 | 5992673.9 | 2105865.8 | 37.7618848250494 | -122.46848481907499 | (37.7618848250494, -122.468484819075) | ||
| 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) | |||
| 129210 | 129210 | 95985 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 577 Sanchez St | 1 | Front Yard : 25 | Tree 1 | Private 1 | 6003673.0 | 2104901.0 | 37.7598649162805 | -122.430374442168 | (37.7598649162805, -122.430374442168) | |||||
| 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) |
| 103370 | 103370 | 96098 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1999 Bryant St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | Permit Number 767752 | 6009553.0 | 2105475.0 | 37.7617723065941 | -122.41007883348301 | (37.7617723065941, -122.410078833483) | |||
| 122281 | 122281 | 96103 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2780X 18th St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | Permit Number 767752 | 6009596.8 | 2105493.6 | 37.7618258328219 | -122.40992865921999 | (37.7618258328219, -122.40992865922) | |||
| 77664 | 77664 | 96104 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2780X 18th St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | Permit Number 767752 | 6009596.8 | 2105493.6 | 37.7618258328219 | -122.40992865921999 | (37.7618258328219, -122.40992865922) | |||
| 115013 | 115013 | 96105 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2780X 18th St | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | Permit Number 767752 | 6009596.8 | 2105493.6 | 37.7618258328219 | -122.40992865921999 | (37.7618258328219, -122.40992865922) | |||
| 119866 | 119866 | 96106 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2780X 18th St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | Permit Number 767752 | 6009596.8 | 2105493.6 | 37.7618258328219 | -122.40992865921999 | (37.7618258328219, -122.40992865922) | |||
| 91752 | 91752 | 96831 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 2908 Baker St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5999535.9 | 2118868.1 | 37.797979769659996 | -122.44568703479601 | (37.79797976966, -122.445687034796) | |||||
| 125685 | 125685 | 96832 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 2908 Baker St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5999535.9 | 2118868.1 | 37.797979769659996 | -122.44568703479601 | (37.79797976966, -122.445687034796) | |||||
| 157526 | 157526 | 97087 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 4550 Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x4.5 | 5981444.7277 | 2111006.81618 | 37.7753455356701 | -122.50770291724501 | (37.7753455356701, -122.507702917245) | |||
| 101905 | 101905 | 97139 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 937 Goettingen St | Front Yard : 25 | Landscaping 2 | Private 1 | 6011052.0 | 2090410.0 | 37.720490952554606 | -122.40383424464399 | (37.7204909525546, -122.403834244644) | ||||||
| 90274 | 90274 | 97299 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1051 Portola Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5995688.7 | 2098126.6 | 37.7408086112536 | -122.457497926865 | (37.7408086112536, -122.457497926865) | |||||
| 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) | |||
| 88432 | 88432 | 99828 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 2398 Broadway | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | |||||
| 89880 | 89880 | 99852 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 86 Nordhoff St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6000395.0 | 2095652.0 | 37.734283150969794 | -122.44104786104499 | (37.7342831509698, -122.441047861045) | |||||
| 107724 | 107724 | 99916 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1740 Jones St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6008334.0 | 2118406.0 | 37.7972093435845 | -122.41521026614402 | (37.7972093435845, -122.415210266144) | |||||
| 107709 | 107709 | 99917 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1740 Jones St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6008334.0 | 2118406.0 | 37.7972093435845 | -122.41521026614402 | (37.7972093435845, -122.415210266144) | |||||
| 99837 | 99837 | 99918 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1740 Jones St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6008334.0 | 2118406.0 | 37.7972093435845 | -122.41521026614402 | (37.7972093435845, -122.415210266144) | |||||
| 114105 | 114105 | 99919 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1740 Jones St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6008334.0 | 2118406.0 | 37.7972093435845 | -122.41521026614402 | (37.7972093435845, -122.415210266144) | |||||
| 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) | |||
| 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) | |||
| 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) | |||
| 89053 | 89053 | 102912 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 84 Vienna St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6004823.0 | 2092922.0 | 37.7270383945734 | -122.42554460371599 | (37.7270383945734, -122.425544603716) | |||||
| 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) |
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");