Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▲ | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 97339 | 97339 | 85212 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 229 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2007 12:00:00 AM | 3 | 3x3 | maintenance agreement through 7/2/2010 | 5994738.0 | 2088050.0 | 37.7130860517587 | -122.46005525076299 | (37.7130860517587, -122.460055250763) | |
| 31345 | 31345 | 54056 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 839 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1972 12:00:00 AM | 12 | Permit Number 9778 | 5985079.18018 | 2110144.91058 | 37.7731924364746 | -122.495067118327 | (37.7731924364746, -122.495067118327) | ||
| 25717 | 25717 | 53974 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 985 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1995 12:00:00 AM | 4 | Permit Number 9690 | 6009227.8600699995 | 2115996.16493 | 37.790642719446204 | -122.41194689162901 | (37.7906427194462, -122.411946891629) | |
| 10028 | 10028 | 161764 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 142 Newton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/23/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779227 | 6000990.7389 | 2087787.91218 | 37.7127240669257 | -122.43842496696001 | (37.7127240669257, -122.43842496696) | |
| 4434 | 4434 | 253623 | Planning Code 138.1 required 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1331 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778744 | 5983976.422619999 | 2106100.27997 | 37.7620224120695 | -122.498582815109 | (37.7620224120695, -122.498582815109) | |
| 88818 | 88818 | 18610 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 615 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778725 | 5992407.5548851 | 2088503.1314627 | 37.7141959284164 | -122.468142922603 | (37.7141959284164, -122.468142922603) | |
| 82751 | 82751 | 34551 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3662 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1997 12:00:00 AM | 9 | 3x2 | Permit Number 778622 | 6008447.76168785 | 2097836.53869706 | 37.7407367985354 | -122.413361219105 | (37.7407367985354, -122.413361219105) |
| 88120 | 88120 | 117006 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2131x 48TH AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778271 | 5981288.0 | 2100567.0 | 37.7466715647644 | -122.50747029290599 | (37.7466715647644, -122.507470292906) | |
| 108687 | 108687 | 117004 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2131x 48TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778271 | 5981288.0 | 2100567.0 | 37.7466715647644 | -122.50747029290599 | (37.7466715647644, -122.507470292906) | |
| 122779 | 122779 | 117005 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2131x 48TH AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778271 | 5981288.0 | 2100567.0 | 37.7466715647644 | -122.50747029290599 | (37.7466715647644, -122.507470292906) | |
| 83343 | 83343 | 115277 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1909 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2016 12:00:00 AM | Permit Number 777409 | 5988585.4 | 2105743.7 | 37.7613125601848 | -122.48261621096201 | (37.7613125601848, -122.482616210962) | |||
| 9629 | 9629 | 173614 | Planning Code 138.1 required 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2955 20th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x6 | Permit Number 776469 | 5990236.78382 | 2095590.4495400002 | 37.7335303227244 | -122.476163213901 | (37.7335303227244, -122.476163213901) | |
| 9631 | 9631 | 173613 | Planning Code 138.1 required 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2955 20th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x6 | Permit Number 776469 | 5990236.78382 | 2095590.4495400002 | 37.7335303227244 | -122.476163213901 | (37.7335303227244, -122.476163213901) | |
| 84075 | 84075 | 88739 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 271 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/21/2015 12:00:00 AM | 5 | 3x3 | Permit Number 776302 | 6004409.0 | 2109083.0 | 37.7713893469465 | -122.428127009852 | (37.7713893469465, -122.428127009852) | |
| 106958 | 106958 | 111435 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3498x SANTIAGO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2016 12:00:00 AM | 12 | 3x3 | Permit Number 776176 | 5982094.0 | 2099503.0 | 37.7437975622932 | -122.50460445512199 | (37.7437975622932, -122.504604455122) | |
| 109320 | 109320 | 111436 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3498x SANTIAGO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2016 12:00:00 AM | 3x3 | Permit Number 776176 | 5982094.0 | 2099503.0 | 37.7437975622932 | -122.50460445512199 | (37.7437975622932, -122.504604455122) | ||
| 127503 | 127503 | 111437 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3498x SANTIAGO ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2016 12:00:00 AM | 3x3 | Permit Number 776176 | 5982094.0 | 2099503.0 | 37.7437975622932 | -122.50460445512199 | (37.7437975622932, -122.504604455122) | ||
| 120956 | 120956 | 36978 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 154 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/2016 12:00:00 AM | 3 | Permit Number 776042 | 5993376.985780001 | 2114464.02156 | 37.785533828452394 | -122.466678167054 | (37.7855338284524, -122.466678167054) | |
| 50296 | 50296 | 68581 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1526 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2016 12:00:00 AM | 0 | Permit Number 775949 | 5985927.704093 | 2104831.6030171 | 37.7586532178591 | -122.491740786234 | (37.7586532178591, -122.491740786234) | ||
| 13082 | 13082 | 15846 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 5256 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2015 12:00:00 AM | 6 | 3x3 | Permit Number 775938 | 5999899.043409999 | 2088666.4410599999 | 37.7150741519211 | -122.442261231071 | (37.7150741519211, -122.442261231071) | |
| 87987 | 87987 | 90154 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 638 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/01/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775919 | 5993572.64081 | 2111433.85169 | 37.7772250922406 | -122.465781024081 | (37.7772250922406, -122.465781024081) | |
| 85331 | 85331 | 115871 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 84X Cordova St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/29/2016 12:00:00 AM | 3 | Permit Number 775902. On Athens St frontage | 6001679.7 | 2087642.4 | 37.712363687575795 | -122.43603329568501 | (37.7123636875758, -122.436033295685) | ||
| 18403 | 18403 | 115286 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1649 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2016 12:00:00 AM | Permit Number 775796 | 5992740.3 | 2104249.5 | 37.7574507237441 | -122.468137590024 | (37.7574507237441, -122.468137590024) | |||
| 77786 | 77786 | 124717 | Planning Code 138.1 required 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 610 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2016 12:00:00 AM | 3 | 3x3 | Permit Number 775784 | 6007724.21349 | 2097196.46477 | 37.738938646129704 | -122.41581766964899 | (37.7389386461297, -122.415817669649) | |
| 86220 | 86220 | 124718 | Planning Code 138.1 required 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 610 Cortland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2016 12:00:00 AM | 3 | 3x3 | Permit Number 775784 | 6007724.21349 | 2097196.46477 | 37.738938646129704 | -122.41581766964899 | (37.7389386461297, -122.415817669649) | |
| 105363 | 105363 | 59676 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 374 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/2016 12:00:00 AM | Permit Number 775696 | 6005474.06817459 | 2106804.86851966 | 37.7651943455256 | -122.42428083033701 | (37.7651943455256, -122.424280830337) | ||
| 124300 | 124300 | 115233 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 839 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/20/2016 12:00:00 AM | Permit Number 775531 | 5983204.4 | 2110077.1 | 37.772896315318 | -122.501547107446 | (37.772896315318, -122.501547107446) | |||
| 81523 | 81523 | 115220 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 663 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2016 12:00:00 AM | Permit Number 775475 | 5989383.4 | 2110828.4 | 37.775320149744296 | -122.48022845818001 | (37.7753201497443, -122.48022845818) | |||
| 5559 | 5559 | 98004 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1908 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/2015 12:00:00 AM | 14 | 5x5 | Permit Number 775450 | 6003753.55269 | 2119031.9849799997 | 37.79866965343071 | -122.43110445762301 | (37.7986696534307, -122.431104457623) | |
| 98139 | 98139 | 64711 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2609 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2015 12:00:00 AM | Permit Number 775401 | 5987378.59458857 | 2114604.15746818 | 37.7855706107791 | -122.48744086841299 | (37.7855706107791, -122.487440868413) | |||
| 125580 | 125580 | 109829 | Private 5 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 629 TAYLOR ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/01/2015 12:00:00 AM | Permit Number 775362 | 6009246.3 | 2115118.4 | 37.7882336239769 | -122.41182103906 | (37.7882336239769, -122.41182103906) | |||
| 10663 | 10663 | 110033 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 206 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/19/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775206 | 6003103.36951 | 2092214.97197 | 37.724999739126794 | -122.431438884895 | (37.7249997391268, -122.431438884895) |
| 141833 | 141833 | 109934 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1890 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775172 | 5989442.7 | 2102500.8 | 37.7524582627735 | -122.479413946447 | (37.7524582627735, -122.479413946447) |
| 113986 | 113986 | 115182 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 315 Lakeshore Dr | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 01/15/2016 12:00:00 AM | Permit Number 775158 | 5983956.6 | 2095109.9 | 37.7318446842931 | -122.497839799214 | (37.7318446842931, -122.497839799214) | |||
| 78661 | 78661 | 45709 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 196 Graystone Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | Permit Number 775143 | 5999327.035480901 | 2103995.03426473 | 37.757130224218294 | -122.44533981581499 | (37.7571302242183, -122.445339815815) | |||
| 106496 | 106496 | 109917 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1627 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775114 | 5985575.9 | 2104128.7 | 37.7567026728441 | -122.492905692842 | (37.7567026728441, -122.492905692842) |
| 78095 | 78095 | 109876 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1631 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775090 | 5989917.1 | 2104254.5 | 37.7573010006541 | -122.47790160153099 | (37.7573010006541, -122.477901601531) |
| 110103 | 110103 | 115282 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 735 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2016 12:00:00 AM | Permit Number 775036 | 6005694.3 | 2104696.8 | 37.7594185196294 | -122.423369227628 | (37.7594185196294, -122.423369227628) | |||
| 118476 | 118476 | 109665 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 230X Craut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775017 | 6004046.411069999 | 2093890.0445599998 | 37.729652518606 | -122.42829822368 | (37.729652518606, -122.42829822368) |
| 82309 | 82309 | 109567 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 56 Seneca Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775012 | 6000375.8 | 2089821.0 | 37.7182714712375 | -122.440696127295 | (37.7182714712375, -122.440696127295) |
| 139858 | 139858 | 109529 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 33 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/20/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774999 | 5993241.2 | 2093283.4 | 37.7273694976755 | -122.465608622621 | (37.7273694976755, -122.465608622621) |
| 63008 | 63008 | 114541 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1001X Rhode Island St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/24/2015 12:00:00 AM | 1 | Permit Number 774983 | 6011939.68484 | 2103650.19837 | 37.756895288204 | -122.401695928834 | (37.756895288204, -122.401695928834) | ||
| 8949 | 8949 | 38494 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1345 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/11/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774878 | 6006577.84973 | 2118679.48452 | 37.797861412034294 | -122.42130642757401 | (37.7978614120343, -122.421306427574) |
| 5769 | 5769 | 39272 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2740 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/2015 12:00:00 AM | 3 | Permit Number 774808 | 5999918.5789 | 2117802.13868 | 37.7950747637355 | -122.44428621834999 | (37.7950747637355, -122.44428621835) | ||
| 5982 | 5982 | 39271 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2740 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/2015 12:00:00 AM | 3 | Permit Number 774808 | 5999943.4858099995 | 2117805.21945 | 37.7950846436855 | -122.444200258451 | (37.7950846436855, -122.444200258451) | ||
| 22225 | 22225 | 15638 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3620 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | 3 | 3X3 | Permit Number 774763 | 6005333.2664 | 2097101.2564 | 37.7385425216055 | -122.42407769940901 | (37.7385425216055, -122.424077699409) | |
| 94146 | 94146 | 110101 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1348 Douglass St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2016 12:00:00 AM | 3x3 | Permit Number 774671 | 6001379.0 | 2099692.0 | 37.7454320431231 | -122.437935141467 | (37.7454320431231, -122.437935141467) | |||
| 88636 | 88636 | 45708 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 192 Graystone Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | Permit Number 774637 | 5999327.035480901 | 2103995.03426473 | 37.757130224218294 | -122.44533981581499 | (37.7571302242183, -122.445339815815) | |||
| 4984 | 4984 | 44099 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1880 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774618 | 6003969.398019999 | 2119063.44467 | 37.798768262294395 | -122.43035980995701 | (37.7987682622944, -122.430359809957) | |
| 108011 | 108011 | 43019 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 247 Rose St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774594 | 6005406.63271254 | 2109736.62010922 | 37.773240424192 | -122.424722652703 | (37.773240424192, -122.424722652703) | |
| 12132 | 12132 | 99909 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 210 Gaven St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774553 | 6009399.78383 | 2095020.3189400001 | 37.7330574731105 | -122.40987072487499 | (37.7330574731105, -122.409870724875) | |
| 148278 | 148278 | 114811 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2382 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2015 12:00:00 AM | 3 | Permit Number 774444 | 5987696.7 | 2099087.7 | 37.7429852324249 | -122.48520141926501 | (37.7429852324249, -122.485201419265) | ||
| 116647 | 116647 | 81972 | Planning Code 138.1 required 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1822 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/09/2015 12:00:00 AM | 3 | 3x6 | Permit Number 774361 | 5989407.90008391 | 2102936.76390687 | 37.7536532824256 | -122.47956618379699 | (37.7536532824256, -122.479566183797) | |
| 17358 | 17358 | 4165 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3770 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2016 12:00:00 AM | 3 | 3X3 | Permit Number 774303 | 6005421.09901 | 2100523.30385 | 37.747943645176704 | -122.424017300779 | (37.7479436451767, -122.424017300779) | |
| 136348 | 136348 | 37603 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 564 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/2015 12:00:00 AM | 1 | Permit Number 774301 | 5992239.14476 | 2111629.05445 | 37.7776840552126 | -122.47040819043 | (37.7776840552126, -122.47040819043) | |
| 109127 | 109127 | 112841 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 472 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/2015 12:00:00 AM | Permit Number 774271 | 5992233.9 | 2112228.8 | 37.779330489905895 | -122.47047002385901 | (37.7793304899059, -122.470470023859) | |||
| 102445 | 102445 | 112746 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 371 Jules Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/18/2015 12:00:00 AM | Permit Number 774184 | 5994438.7 | 2092245.9 | 37.724589771591 | -122.461393714772 | (37.724589771591, -122.461393714772) | ||
| 128289 | 128289 | 112742 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 156 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/22/2014 12:00:00 AM | Permit Number 774175 | 5995316.4 | 2088116.5 | 37.7133018954425 | -122.45806092895701 | (37.7133018954425, -122.458060928957) | ||
| 82158 | 82158 | 107918 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 495 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774012 | 5993102.18956 | 2112225.85216 | 37.7793725629571 | -122.467466058727 | (37.7793725629571, -122.467466058727) | |
| 97423 | 97423 | 107931 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1800X Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774012 | 5993050.627169999 | 2112098.44273 | 37.779019754209706 | -122.467635164784 | (37.7790197542097, -122.467635164784) | |
| 116554 | 116554 | 107930 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1800X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774012 | 5993080.40868 | 2112098.8542 | 37.7790226034666 | -122.467532169341 | (37.7790226034666, -122.467532169341) | |
| 125147 | 125147 | 107920 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 495 09th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774012 | 5993103.579919999 | 2112156.71992 | 37.7791828248217 | -122.467456220381 | (37.7791828248217, -122.467456220381) | |
| 126152 | 126152 | 107921 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 495 09th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774012 | 5993104.13522 | 2112142.54779 | 37.7791439440497 | -122.46745326853599 | (37.7791439440497, -122.467453268536) | |
| 138933 | 138933 | 107919 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 495 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774012 | 5993102.51842 | 2112200.9229900003 | 37.77930413319589 | -122.46746310776501 | (37.7793041331959, -122.467463107765) | |
| 25281 | 25281 | 115053 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1280 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/2016 12:00:00 AM | 1 | Permit Number 773966 | 6007807.56108 | 2115848.6869799998 | 37.790157994733704 | -122.41685060786699 | (37.7901579947337, -122.416850607867) | ||
| 84938 | 84938 | 102708 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 999X PHELPS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773962 | 6014744.0 | 2097272.0 | 37.7395381878784 | -122.39155157401501 | (37.7395381878784, -122.391551574015) | |
| 114153 | 114153 | 102709 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 999X PHELPS ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773962 | 6014744.0 | 2097272.0 | 37.7395381878784 | -122.39155157401501 | (37.7395381878784, -122.391551574015) | |
| 86589 | 86589 | 109074 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1520 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/23/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773927 | 5992170.3 | 2105104.1 | 37.7597642954434 | -122.470171088863 | (37.7597642954434, -122.470171088863) |
| 42751 | 42751 | 108789 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1100-1198X Schwerin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773823 | 6009097.136580001 | 2087632.54285 | 37.7127552255458 | -122.41039559568199 | (37.7127552255458, -122.410395595682) | |
| 82210 | 82210 | 108786 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1100-1198X Schwerin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773823 | 6009097.136580001 | 2087632.54285 | 37.7127552255458 | -122.41039559568199 | (37.7127552255458, -122.410395595682) | |
| 84872 | 84872 | 108785 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1100-1198X Schwerin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773823 | 6009097.136580001 | 2087632.54285 | 37.7127552255458 | -122.41039559568199 | (37.7127552255458, -122.410395595682) | |
| 99997 | 99997 | 108787 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1100-1198X Schwerin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773823 | 6009097.136580001 | 2087632.54285 | 37.7127552255458 | -122.41039559568199 | (37.7127552255458, -122.410395595682) | |
| 142924 | 142924 | 108788 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1100-1198X Schwerin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773823 | 6009097.136580001 | 2087632.54285 | 37.7127552255458 | -122.41039559568199 | (37.7127552255458, -122.410395595682) | |
| 93952 | 93952 | 108380 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 286 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773804 | 6004439.17229 | 2090775.7474099998 | 37.7211235626427 | -122.426718715963 | (37.7211235626427, -122.426718715963) |
| 111222 | 111222 | 108473 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1608 Anza St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 773791 | 5993717.35879 | 2112110.81995 | 37.7790922117302 | -122.465329589105 | (37.7790922117302, -122.465329589105) | |||
| 116363 | 116363 | 108569 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 586 Somerset St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773764 | 6010254.2951 | 2091832.3673599998 | 37.7243518811862 | -122.40669185444901 | (37.7243518811862, -122.406691854449) |
| 75301 | 75301 | 36083 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 350 Treat Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2014 12:00:00 AM | 3 | Permit Number 773750 | 6008595.45763242 | 2106539.09484621 | 37.7646403500491 | -122.413465859831 | (37.7646403500491, -122.413465859831) | |
| 80638 | 80638 | 36088 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 350 Treat Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2014 12:00:00 AM | 3 | Permit Number 773750 | 6008595.45763242 | 2106539.09484621 | 37.7646403500491 | -122.413465859831 | (37.7646403500491, -122.413465859831) | |
| 85403 | 85403 | 36081 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 350 Treat Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2014 12:00:00 AM | 3 | Permit Number 773750 | 6008595.45763242 | 2106539.09484621 | 37.7646403500491 | -122.413465859831 | (37.7646403500491, -122.413465859831) | |
| 87020 | 87020 | 36087 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 350 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2014 12:00:00 AM | 3 | Permit Number 773750 | 6008595.45763242 | 2106539.09484621 | 37.7646403500491 | -122.413465859831 | (37.7646403500491, -122.413465859831) | |
| 94267 | 94267 | 36085 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 350 Treat Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2014 12:00:00 AM | 3 | Permit Number 773750 | 6008595.45763242 | 2106539.09484621 | 37.7646403500491 | -122.413465859831 | (37.7646403500491, -122.413465859831) | |
| 101572 | 101572 | 36084 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 350 Treat Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2014 12:00:00 AM | 3 | Permit Number 773750 | 6008595.45763242 | 2106539.09484621 | 37.7646403500491 | -122.413465859831 | (37.7646403500491, -122.413465859831) | |
| 128394 | 128394 | 36086 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 350 Treat Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2014 12:00:00 AM | 3 | Permit Number 773750 | 6008595.45763242 | 2106539.09484621 | 37.7646403500491 | -122.413465859831 | (37.7646403500491, -122.413465859831) | |
| 79088 | 79088 | 103640 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3147 20th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773749 | 6008974.4 | 2104483.2 | 37.759016602910705 | -122.412009894818 | (37.7590166029107, -122.412009894818) | |
| 84645 | 84645 | 103639 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3147 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773749 | 6008974.4 | 2104483.2 | 37.759016602910705 | -122.412009894818 | (37.7590166029107, -122.412009894818) | |
| 103502 | 103502 | 103638 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3147 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773749 | 6008974.4 | 2104483.2 | 37.759016602910705 | -122.412009894818 | (37.7590166029107, -122.412009894818) | |
| 99566 | 99566 | 45031 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3310 19TH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773721 | 6007454.2 | 2105037.1 | 37.7604520749855 | -122.41730672958299 | (37.7604520749855, -122.417306729583) | |
| 127179 | 127179 | 45034 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 798 SOUTH VAN NESS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773721 | 6007485.2 | 2105062.7 | 37.7605241107183 | -122.41720132867701 | (37.7605241107183, -122.417201328677) |
| 89000 | 89000 | 108555 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 68X Wanda St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773714 | 6000555.61606 | 2091513.15028 | 37.7229279706553 | -122.440195859767 | (37.7229279706553, -122.440195859767) |
| 140816 | 140816 | 107323 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 752 CAYUGA AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/2014 12:00:00 AM | 3 | 4x2 | Permit Number 773710 | 6001347.5 | 2092637.6 | 37.726060507123705 | -122.43753897171801 | (37.7260605071237, -122.437538971718) | |
| 86622 | 86622 | 108522 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2059 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773673 | 5990965.153 | 2101394.10507 | 37.7495078797857 | -122.474068362776 | (37.7495078797857, -122.474068362776) |
| 116584 | 116584 | 108520 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1831 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773667 | 5990912.6193699995 | 2102936.28032 | 37.7537392459439 | -122.47436254716699 | (37.7537392459439, -122.474362547167) |
| 86334 | 86334 | 108517 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1474 17th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773664 | 5990869.49269 | 2105368.92693 | 37.7604161511877 | -122.474689222748 | (37.7604161511877, -122.474689222748) | |
| 112671 | 112671 | 108503 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1434 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773648 | 5991820.21793 | 2105663.11685 | 37.7612789627151 | -122.47142257169901 | (37.7612789627151, -122.471422571699) |
| 145364 | 145364 | 109041 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1638 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773601 | 5985043.8 | 2104034.4 | 37.7564126199144 | -122.49473890921699 | (37.7564126199144, -122.494738909217) |
| 106461 | 106461 | 106495 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 278 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773493 | 5993716.0557699995 | 2113668.3576599997 | 37.7833687137237 | -122.46544727301 | (37.7833687137237, -122.46544727301) | |
| 124993 | 124993 | 63246 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3670 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/16/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773458 | 6005842.08820606 | 2104350.40307948 | 37.758475734633706 | -122.42283348452699 | (37.7584757346337, -122.422833484527) | |
| 142535 | 142535 | 112886 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 329 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/2015 12:00:00 AM | Permit Number 773449 | 5993982.2 | 2113131.7 | 37.7819105429437 | -122.46448754744101 | (37.7819105429437, -122.464487547441) | |||
| 77650 | 77650 | 108872 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1317 Grove St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773401 | 6001507.20104 | 2110761.06824 | 37.775832295364104 | -122.438284688432 | (37.7758322953641, -122.438284688432) | |
| 92920 | 92920 | 108889 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 534 Mangels Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773372 | 5997888.03427 | 2095280.4903 | 37.7331199631343 | -122.449688444288 | (37.7331199631343, -122.449688444288) |
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");