Data source: data.sfgov.org
This data as json, CSV (advanced)
These facets timed out: PlantType
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker ▲ | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 140647 | 140647 | 105160 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 1600X OAKDALE AVE | 1 | Front Yard : Yard 7 | Tree 1 | Arts Commission 19 | 13 | Permit Number 770204 | 6015006.0 | 2095503.0 | 37.734695414582795 | -122.390522107646 | (37.7346954145828, -122.390522107646) | |||
| 143331 | 143331 | 22279 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 4755X 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Arts Commission 19 | 6 | 3X3 | 6015037.5047362 | 2095657.5026115002 | 37.7351213950345 | -122.390423975921 | (37.7351213950345, -122.390423975921) | |||
| 3328 | 3328 | 140422 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1499 TURK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 14 | Width 0ft | 6002931.6326 | 2112346.6107 | 37.7802667133087 | -122.43347055342699 | (37.7802667133087, -122.433470553427) | |||
| 3331 | 3331 | 140432 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1499 Turk St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 13 | Width 0ft | 6003204.3695 | 2112383.9326 | 37.7803846599605 | -122.432529697936 | (37.7803846599605, -122.432529697936) | |||
| 3334 | 3334 | 140424 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1499 TURK ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 13 | Width 0ft | 6002981.8736 | 2112352.3525 | 37.7802853291655 | -122.43329715719 | (37.7802853291655, -122.43329715719) | |||
| 3335 | 3335 | 140428 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1499 TURK ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 14 | Width 0ft | 6003076.6138 | 2112365.9894 | 37.7803281468599 | -122.43297038187401 | (37.7803281468599, -122.432970381874) | |||
| 3337 | 3337 | 140433 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1499 Turk St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 15 | Width 0ft | 6003251.7396 | 2112391.1099 | 37.7804070531695 | -122.432366335522 | (37.7804070531695, -122.432366335522) | |||
| 3339 | 3339 | 140429 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1499 TURK ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 15 | Width 0ft | 6003096.7102 | 2112369.578 | 37.7803391401181 | -122.432901115602 | (37.7803391401181, -122.432901115602) | |||
| 3342 | 3342 | 140426 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1499 TURK ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 12 | Width 0ft | 6003027.0905 | 2112359.5298 | 37.7803076012967 | -122.43314124413601 | (37.7803076012967, -122.433141244136) | |||
| 3343 | 3343 | 140423 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1499 TURK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 13 | Width 0ft | 6002956.7531 | 2112350.9171 | 37.7802799627924 | -122.43338395792802 | (37.7802799627924, -122.433383957928) | |||
| 3344 | 3344 | 140425 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1499 TURK ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 12 | Width 0ft | 6003006.2764 | 2112357.3766 | 37.780300508432795 | -122.43321309578998 | (37.7803005084328, -122.43321309579) | |||
| 3347 | 3347 | 140434 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1499 Turk St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 14 | Width 0ft | 6003279.731000001 | 2112394.6985 | 37.780418493723204 | -122.43226975660299 | (37.7804184937232, -122.432269756603) | |||
| 3348 | 3348 | 140430 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1499 TURK ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 05/18/1992 12:00:00 AM | 5 | Width 0ft | 6003115.3712 | 2112373.8844 | 37.7803520228236 | -122.432836866316 | (37.7803520228236, -122.432836866316) | ||
| 3349 | 3349 | 140427 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1499 TURK ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 14 | Width 0ft | 6003052.211 | 2112362.4007 | 37.7803169090148 | -122.43305454594 | (37.7803169090148, -122.43305454594) | |||
| 3351 | 3351 | 140431 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1499 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 14 | Width 0ft | 6003184.2731 | 2112381.0617 | 37.7803756375453 | -122.432599015585 | (37.7803756375453, -122.432599015585) | |||
| 17096 | 17096 | 22978 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 630 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 03/14/1995 12:00:00 AM | 18 | 3X3 | 6006171.13469 | 2105920.83028 | 37.762806320675104 | -122.421807041478 | (37.7628063206751, -122.421807041478) | ||
| 19046 | 19046 | 22977 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 630 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 03/14/1995 12:00:00 AM | 20 | 3X3 | 6006170.03999 | 2105955.48094 | 37.7629014015073 | -122.421813289079 | (37.7629014015073, -122.421813289079) | ||
| 77683 | 77683 | 22980 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 630 Valencia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 09/30/2006 12:00:00 AM | 6 | 3X3 | 6006179.6291421 | 2105955.3041542 | 37.762901456856206 | -122.42178011092 | (37.7629014568562, -122.42178011092) | ||
| 78686 | 78686 | 22716 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1401X Turk St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 18 | 4x4 | 6003306.8488585 | 2112395.4775226 | 37.7804221702729 | -122.43217599894 | (37.7804221702729, -122.43217599894) | |||
| 79478 | 79478 | 22719 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1401X Turk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 18 | 4x4 | 6003306.8488585 | 2112395.4775226 | 37.7804221702729 | -122.43217599894 | (37.7804221702729, -122.43217599894) | |||
| 80929 | 80929 | 115946 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3403x 17TH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 3x3 | 6006158.0 | 2105944.0 | 37.7628691985612 | -122.42185411572201 | (37.7628691985612, -122.421854115722) | ||||
| 83157 | 83157 | 22713 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1401X Turk St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 18 | 4x4 | 6003306.8488585 | 2112395.4775226 | 37.7804221702729 | -122.43217599894 | (37.7804221702729, -122.43217599894) | |||
| 83367 | 83367 | 115940 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 3401x 17TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 20 | 3x3 | 6006069.0 | 2106010.0 | 37.7630453994978 | -122.42216662533801 | (37.7630453994978, -122.422166625338) | |||
| 86610 | 86610 | 20161 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1150X Steiner St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 18 | 4X4 | 6002889.1141449995 | 2112192.1807580004 | 37.779840274990796 | -122.433606604391 | (37.7798402749908, -122.433606604391) | |||
| 87132 | 87132 | 20160 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1150X Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 18 | 4X4 | 6002889.1141449995 | 2112192.1807580004 | 37.779840274990796 | -122.433606604391 | (37.7798402749908, -122.433606604391) | |||
| 87612 | 87612 | 22982 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 630 Valencia St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 11/30/1994 12:00:00 AM | 20 | 3X3 | 6006179.6291421 | 2105955.3041542 | 37.762901456856206 | -122.42178011092 | (37.7629014568562, -122.42178011092) | ||
| 87696 | 87696 | 22711 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1401X Turk St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 12 | 4x4 | 6003306.8488585 | 2112395.4775226 | 37.7804221702729 | -122.43217599894 | (37.7804221702729, -122.43217599894) | |||
| 88203 | 88203 | 115945 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3403x 17TH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 3x3 | 6006158.0 | 2105944.0 | 37.7628691985612 | -122.42185411572201 | (37.7628691985612, -122.421854115722) | ||||
| 88384 | 88384 | 22722 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1401X Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 18 | 4x4 | 6003306.8488585 | 2112395.4775226 | 37.7804221702729 | -122.43217599894 | (37.7804221702729, -122.43217599894) | |||
| 91993 | 91993 | 20162 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1150X Steiner St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 18 | 4X4 | 6002889.1141449995 | 2112192.1807580004 | 37.779840274990796 | -122.433606604391 | (37.7798402749908, -122.433606604391) | |||
| 95968 | 95968 | 22983 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 630 Valencia St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 01/25/1995 12:00:00 AM | 18 | 3X3 | 6006179.6291421 | 2105955.3041542 | 37.762901456856206 | -122.42178011092 | (37.7629014568562, -122.42178011092) | ||
| 97147 | 97147 | 22721 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1401X Turk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 18 | 4x4 | 6003306.8488585 | 2112395.4775226 | 37.7804221702729 | -122.43217599894 | (37.7804221702729, -122.43217599894) | |||
| 103172 | 103172 | 22985 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 630 Valencia St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 11/29/1994 12:00:00 AM | 20 | 3X3 | 6006179.6291421 | 2105955.3041542 | 37.762901456856206 | -122.42178011092 | (37.7629014568562, -122.42178011092) | ||
| 103307 | 103307 | 115942 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 3401x 17TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 3x3 | 6006069.0 | 2106010.0 | 37.7630453994978 | -122.42216662533801 | (37.7630453994978, -122.422166625338) | ||||
| 103423 | 103423 | 22714 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1401X Turk St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 18 | 4x4 | 6003306.8488585 | 2112395.4775226 | 37.7804221702729 | -122.43217599894 | (37.7804221702729, -122.43217599894) | |||
| 106335 | 106335 | 115943 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3403x 17TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 3x3 | 6006158.0 | 2105944.0 | 37.7628691985612 | -122.42185411572201 | (37.7628691985612, -122.421854115722) | ||||
| 107178 | 107178 | 22981 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 630 Valencia St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 01/25/1995 12:00:00 AM | 18 | 3X3 | 6006179.6291421 | 2105955.3041542 | 37.762901456856206 | -122.42178011092 | (37.7629014568562, -122.42178011092) | ||
| 108132 | 108132 | 115944 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3403x 17TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 3x3 | 6006158.0 | 2105944.0 | 37.7628691985612 | -122.42185411572201 | (37.7628691985612, -122.421854115722) | ||||
| 113530 | 113530 | 20158 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1150X Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 18 | 4X4 | 6002889.1141449995 | 2112192.1807580004 | 37.779840274990796 | -122.433606604391 | (37.7798402749908, -122.433606604391) | |||
| 113939 | 113939 | 22979 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 630 Valencia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 11/29/1994 12:00:00 AM | 20 | 3X3 | 6006179.6291421 | 2105955.3041542 | 37.762901456856206 | -122.42178011092 | (37.7629014568562, -122.42178011092) | ||
| 114591 | 114591 | 22984 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 630 Valencia St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 11/29/1994 12:00:00 AM | 20 | 3X3 | 6006179.6291421 | 2105955.3041542 | 37.762901456856206 | -122.42178011092 | (37.7629014568562, -122.42178011092) | ||
| 116022 | 116022 | 22717 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1401X Turk St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 18 | 4x4 | 6003306.8488585 | 2112395.4775226 | 37.7804221702729 | -122.43217599894 | (37.7804221702729, -122.43217599894) | |||
| 116875 | 116875 | 22715 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1401X Turk St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 05/18/1992 12:00:00 AM | 12 | 4x4 | 6003306.8488585 | 2112395.4775226 | 37.7804221702729 | -122.43217599894 | (37.7804221702729, -122.43217599894) | ||
| 120820 | 120820 | 115941 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 3401x 17TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 3x3 | 6006069.0 | 2106010.0 | 37.7630453994978 | -122.42216662533801 | (37.7630453994978, -122.422166625338) | ||||
| 127525 | 127525 | 22720 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1401X Turk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 18 | 4x4 | 6003306.8488585 | 2112395.4775226 | 37.7804221702729 | -122.43217599894 | (37.7804221702729, -122.43217599894) | |||
| 128640 | 128640 | 22723 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1401X Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 3 | 4x4 | 6003306.8488585 | 2112395.4775226 | 37.7804221702729 | -122.43217599894 | (37.7804221702729, -122.43217599894) | |||
| 138285 | 138285 | 22712 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1401X Turk St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 18 | 4x4 | 6003306.8488585 | 2112395.4775226 | 37.7804221702729 | -122.43217599894 | (37.7804221702729, -122.43217599894) | |||
| 138793 | 138793 | 22718 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1401X Turk St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 18 | 4x4 | 6003306.8488585 | 2112395.4775226 | 37.7804221702729 | -122.43217599894 | (37.7804221702729, -122.43217599894) | |||
| 141413 | 141413 | 20159 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1150X Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 05/26/1997 12:00:00 AM | 3 | 4X4 | 6002889.1141449995 | 2112192.1807580004 | 37.779840274990796 | -122.433606604391 | (37.7798402749908, -122.433606604391) | ||
| 143607 | 143607 | 115947 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3403x 17TH ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 3x3 | 6006158.0 | 2105944.0 | 37.7628691985612 | -122.42185411572201 | (37.7628691985612, -122.421854115722) | ||||
| 144325 | 144325 | 82224 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3403x 17TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 02/26/2005 12:00:00 AM | 12 | 3x3 | 6006158.0 | 2105944.0 | 37.7628691985612 | -122.42185411572201 | (37.7628691985612, -122.421854115722) | ||
| 147023 | 147023 | 109910 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 425 07th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | Private 3 | 9 | 3x3 | 6011008.58026 | 2110233.67588 | 37.774920023185295 | -122.40537967513 | (37.7749200231853, -122.40537967513) | ||
| 3001 | 3001 | 7734 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 300 Franklin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | War Memorial 17 | 12 | 3x3 | 6006417.36011 | 2111247.6082200003 | 37.777446266458 | -122.42133372647699 | (37.777446266458, -122.421333726477) | |||
| 4310 | 4310 | 7733 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 300 Franklin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | War Memorial 17 | 12 | 3x3 | 6006420.56293 | 2111227.36292 | 37.7773908583325 | -122.42132120880501 | (37.7773908583325, -122.421321208805) | |||
| 7493 | 7493 | 7730 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 300 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | War Memorial 17 | 12 | 3x3 | 6006431.70019 | 2111170.5594099998 | 37.7772355175274 | -122.421278646599 | (37.7772355175274, -122.421278646599) | |||
| 8044 | 8044 | 7732 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 300 Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | War Memorial 17 | 12 | 3x3 | 6006424.96145 | 2111194.8411 | 37.7773018092612 | -122.42130368282801 | (37.7773018092612, -122.421303682828) | |||
| 8922 | 8922 | 7731 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 300 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | War Memorial 17 | 12 | 3x3 | 6006429.42696 | 2111183.21834 | 37.7772701477293 | -122.4212874096 | (37.7772701477293, -122.4212874096) | |||
| 53593 | 53593 | 7769 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 490X Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | War Memorial 17 | 12 | 3X3 | 6006335.7213615 | 2111871.61132 | 37.7791550246023 | -122.421660473625 | (37.7791550246023, -122.421660473625) | |||
| 80195 | 80195 | 7773 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 490X Franklin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | War Memorial 17 | 12 | 3X3 | 6006335.7213615 | 2111871.61132 | 37.7791550246023 | -122.421660473625 | (37.7791550246023, -122.421660473625) | |||
| 87779 | 87779 | 27372 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 251 Van Ness Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | War Memorial 17 | 12 | 3X3 | 6006819.3487219 | 2111354.6736121 | 37.7777628978385 | -122.419950711926 | (37.7777628978385, -122.419950711926) | |||
| 90444 | 90444 | 7774 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 490X Franklin St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | War Memorial 17 | 12 | 3X3 | 6006335.7213615 | 2111871.61132 | 37.7791550246023 | -122.421660473625 | (37.7791550246023, -122.421660473625) | |||
| 95316 | 95316 | 7776 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 490X Franklin St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | War Memorial 17 | 04/16/1990 12:00:00 AM | 6 | 3X3 | 6006335.7213615 | 2111871.61132 | 37.7791550246023 | -122.421660473625 | (37.7791550246023, -122.421660473625) | ||
| 113707 | 113707 | 7771 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 490X Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | War Memorial 17 | 12 | 3X3 | 6006335.7213615 | 2111871.61132 | 37.7791550246023 | -122.421660473625 | (37.7791550246023, -122.421660473625) | |||
| 114296 | 114296 | 7777 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 490X Franklin St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | War Memorial 17 | 12 | 3X3 | 6006335.7213615 | 2111871.61132 | 37.7791550246023 | -122.421660473625 | (37.7791550246023, -122.421660473625) | |||
| 117559 | 117559 | 27373 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 251 Van Ness Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | War Memorial 17 | 12 | 3X3 | 6006819.3487219 | 2111354.6736121 | 37.7777628978385 | -122.419950711926 | (37.7777628978385, -122.419950711926) | |||
| 123968 | 123968 | 27369 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 251 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | War Memorial 17 | 12 | 3X3 | 6006819.3487219 | 2111354.6736121 | 37.7777628978385 | -122.419950711926 | (37.7777628978385, -122.419950711926) | |||
| 126356 | 126356 | 27368 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 251 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | War Memorial 17 | 12 | 3X3 | 6006819.3487219 | 2111354.6736121 | 37.7777628978385 | -122.419950711926 | (37.7777628978385, -122.419950711926) | |||
| 128516 | 128516 | 27367 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 251 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | War Memorial 17 | 12 | 3X3 | 6006819.3487219 | 2111354.6736121 | 37.7777628978385 | -122.419950711926 | (37.7777628978385, -122.419950711926) | |||
| 141572 | 141572 | 7770 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 490X Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | War Memorial 17 | 12 | 3X3 | 6006335.7213615 | 2111871.61132 | 37.7791550246023 | -122.421660473625 | (37.7791550246023, -122.421660473625) | |||
| 142719 | 142719 | 27371 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 251 Van Ness Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | War Memorial 17 | 18 | 3X3 | 6006819.3487219 | 2111354.6736121 | 37.7777628978385 | -122.419950711926 | (37.7777628978385, -122.419950711926) | |||
| 142971 | 142971 | 27370 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 251 Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | War Memorial 17 | 12 | 3X3 | 6006819.3487219 | 2111354.6736121 | 37.7777628978385 | -122.419950711926 | (37.7777628978385, -122.419950711926) | |||
| 145246 | 145246 | 7775 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 490X Franklin St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | War Memorial 17 | 12 | 3X3 | 6006335.7213615 | 2111871.61132 | 37.7791550246023 | -122.421660473625 | (37.7791550246023, -122.421660473625) | |||
| 2388 | 2388 | 12913 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 200 Larkin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Asian Arts Commission 16 | 50 | 3X3 | 6007759.03449 | 2112296.07509 | 37.7804006563122 | -122.416766716427 | (37.7804006563122, -122.416766716427) | |||
| 5731 | 5731 | 12910 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 200 Larkin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Asian Arts Commission 16 | 60 | 3X3 | 6007779.43261 | 2112129.0051 | 37.779943069560105 | -122.416684310636 | (37.7799430695601, -122.416684310636) | |||
| 7907 | 7907 | 12911 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 200 Larkin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Asian Arts Commission 16 | 60 | 3X3 | 6007775.55734 | 2112148.5476900004 | 37.779996510859 | -122.416699101796 | (37.779996510859, -122.416699101796) | |||
| 8088 | 8088 | 12909 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 200 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Asian Arts Commission 16 | 50 | 3X3 | 6007780.304959999 | 2112111.9572400004 | 37.779896309296 | -122.41668008474 | (37.779896309296, -122.41668008474) | |||
| 8315 | 8315 | 12912 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 200 Larkin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Asian Arts Commission 16 | 50 | 3X3 | 6007764.05578 | 2112272.8599900003 | 37.7803371956541 | -122.41674770026 | (37.7803371956541, -122.41674770026) | |||
| 111940 | 111940 | 105173 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1601X NEWCOMB AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Asian Arts Commission 16 | Arts Commission 14 | 13 | 4x4 | Permit Number 770204 | 6015135.0 | 2095759.0 | 37.735405494081505 | -122.390093985074 | (37.7354054940815, -122.390093985074) | |
| 2250 | 2250 | 200335 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 750 Phelps St | 7 | : 4 | Tree 1 | Purchasing Dept 15 | 4 | Width 2ft | 6015505.4551 | 2098329.2709 | 37.7424834725483 | -122.388992567847 | (37.7424834725483, -122.388992567847) | |||
| 2256 | 2256 | 200334 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 750 Phelps St | 4 | : 4 | Tree 1 | Purchasing Dept 15 | 11/15/1992 12:00:00 AM | 8 | Width 3ft | 6015528.91481 | 2098358.82009 | 37.742565908900204 | -122.388913512973 | (37.7425659089002, -122.388913512973) | ||
| 14404 | 14404 | 86625 | Permitted Site 1 | Acer rubrum 'October Glory' :: Red October Glory Maple 275 | 950 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6010895.2675 | 2109773.10415 | 37.7736490634866 | -122.405739201611 | (37.7736490634866, -122.405739201611) | ||
| 15080 | 15080 | 86626 | Permitted Site 1 | Acer rubrum 'October Glory' :: Red October Glory Maple 275 | 950 Bryant St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6010925.67942 | 2109801.58517 | 37.7737289664413 | -122.40563600799601 | (37.7737289664413, -122.405636007996) | ||
| 15088 | 15088 | 86623 | Permitted Site 1 | Acer rubrum 'October Glory' :: Red October Glory Maple 275 | 950 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6010870.621730001 | 2109748.7492 | 37.7735808121462 | -122.405822739627 | (37.7735808121462, -122.405822739627) | ||
| 15321 | 15321 | 86624 | Permitted Site 1 | Acer rubrum 'October Glory' :: Red October Glory Maple 275 | 950 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6010883.02334 | 2109759.81343 | 37.7736118855124 | -122.405780619884 | (37.7736118855124, -122.405780619884) | ||
| 75743 | 75743 | 17631 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 420X Phelps St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 11/15/1992 12:00:00 AM | 6 | 3X3 | 6015607.4628299 | 2098472.4768112 | 37.7428823403387 | -122.38864984673799 | (37.7428823403387, -122.388649846738) | ||
| 77164 | 77164 | 17646 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 650X Phelps St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 9 | 2x2 | 6015137.8127243 | 2097842.4274143996 | 37.7411263152677 | -122.39022977121401 | (37.7411263152677, -122.390229771214) | |||
| 78818 | 78818 | 86805 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 650X Phelps St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 10/01/2007 12:00:00 AM | 3 | 2x2 | 6015141.822176 | 2097839.440048 | 37.7411183349667 | -122.3902156992 | (37.7411183349667, -122.3902156992) | ||
| 80580 | 80580 | 29808 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1695X Evans Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.74391708243721 | -122.39024991836901 | (37.7439170824372, -122.390249918369) | ||
| 80702 | 80702 | 29817 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1695X Evans Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.74391708243721 | -122.39024991836901 | (37.7439170824372, -122.390249918369) | ||
| 81183 | 81183 | 28729 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1795X Evans Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 12 | 3X3 | 6014623.837937901 | 2099253.7018787 | 37.7449728593106 | -122.39210559674801 | (37.7449728593106, -122.392105596748) | |||
| 82001 | 82001 | 29823 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1695X Evans Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.74391708243721 | -122.39024991836901 | (37.7439170824372, -122.390249918369) | ||
| 82046 | 82046 | 86813 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 700X Phelps St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 3 | 2x2 | 6015141.822176 | 2097839.440048 | 37.7411183349667 | -122.3902156992 | (37.7411183349667, -122.3902156992) | |||
| 82764 | 82764 | 86803 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 650X Phelps St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 10/01/2007 12:00:00 AM | 3 | 2x2 | 6015141.822176 | 2097839.440048 | 37.7411183349667 | -122.3902156992 | (37.7411183349667, -122.3902156992) | ||
| 83164 | 83164 | 17638 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 420X Phelps St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 12 | 3X3 | 6015607.4628299 | 2098472.4768112 | 37.7428823403387 | -122.38864984673799 | (37.7428823403387, -122.388649846738) | |||
| 83605 | 83605 | 29810 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1695X Evans Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.74391708243721 | -122.39024991836901 | (37.7439170824372, -122.390249918369) | ||
| 84061 | 84061 | 29827 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1695X Evans Ave | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.74391708243721 | -122.39024991836901 | (37.7439170824372, -122.390249918369) | ||
| 85032 | 85032 | 17636 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 420X Phelps St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 12 | 3X3 | 6015607.4628299 | 2098472.4768112 | 37.7428823403387 | -122.38864984673799 | (37.7428823403387, -122.388649846738) | |||
| 85626 | 85626 | 17642 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 600X Phelps St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 6 | 2x2 | 6015304.738625 | 2098066.4602575 | 37.74175072080671 | -122.38966824014999 | (37.7417507208067, -122.38966824015) | |||
| 87460 | 87460 | 17649 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 650X Phelps St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 12 | 2x2 | 6015137.8127243 | 2097842.4274143996 | 37.7411263152677 | -122.39022977121401 | (37.7411263152677, -122.390229771214) | |||
| 87950 | 87950 | 29812 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1695X Evans Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 12 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.74391708243721 | -122.39024991836901 | (37.7439170824372, -122.390249918369) |
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");