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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6149 | 6149 | 14526 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 637 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 5999136.9105 | 2110609.5392 | 37.775281136182606 | -122.446473192139 | (37.7752811361826, -122.446473192139) | |||
| 20186 | 20186 | 5718 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1651 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 3X3 | 6005348.2159400005 | 2098686.18257 | 37.742895214531295 | -122.424138695771 | (37.7428952145313, -122.424138695771) | |||
| 21504 | 21504 | 5727 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1677X Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6005353.56233 | 2098539.50836 | 37.742492782318 | -122.424109780756 | (37.742492782318, -122.424109780756) | |||
| 20833 | 20833 | 5722 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1671 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X3 | 6005350.93061 | 2098594.52424 | 37.74264369484639 | -122.424122792155 | (37.7426436948464, -122.424122792155) | |||
| 22036 | 22036 | 5724 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1673 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6005351.61965 | 2098567.02903 | 37.7425682381455 | -122.424118454716 | (37.7425682381455, -122.424118454716) | |||
| 5292 | 5292 | 14530 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 700 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 5999227.9935 | 2110423.9359 | 37.774776718941105 | -122.44614476286999 | (37.7747767189411, -122.44614476287) | |||
| 5767 | 5767 | 14527 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 644 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 5999201.3001 | 2110597.4992 | 37.7752517549466 | -122.44624958831801 | (37.7752517549466, -122.446249588318) | |||
| 7974 | 7974 | 14529 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 650 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 5999204.1149 | 2110576.3883 | 37.775193950570795 | -122.446238332395 | (37.7751939505708, -122.446238332395) | |||
| 9021 | 9021 | 14488 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 303 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 5998978.3148 | 2111745.3393 | 37.778390691402 | -122.447103565775 | (37.778390691402, -122.447103565775) | |||
| 20853 | 20853 | 5720 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1661 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6005349.21876 | 2098633.28229 | 37.742750018997896 | -122.424131466995 | (37.7427500189979, -122.424131466995) | |||
| 98899 | 98899 | 14494 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 331 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 5998922.83591 | 2111648.48667 | 37.7781215891061 | -122.447288514652 | (37.7781215891061, -122.447288514652) | |||
| 142657 | 142657 | 14520 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 608 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 5999209.18442 | 2110749.22895 | 37.7756688162726 | -122.446233231658 | (37.7756688162726, -122.446233231658) | |||
| 143937 | 143937 | 17725 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1300X Pierce St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/28/2013 12:00:00 AM | 60 | 3X3 | Permit Number 768629 | 6002290.5602400005 | 2112983.34935 | 37.7819786446445 | -122.435733884321 | (37.7819786446445, -122.435733884321) | |
| 21709 | 21709 | 26474 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 110 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 55 | 3x3 | 6001315.30926 | 2098781.76662 | 37.742929135180795 | -122.438090182611 | (37.7429291351808, -122.438090182611) | |||
| 1354 | 1354 | 14491 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 320 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 5999051.991 | 2111710.9656 | 37.77830051932229 | -122.446846219186 | (37.7783005193223, -122.446846219186) | |||
| 7514 | 7514 | 14490 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 303 Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 5998985.0486 | 2111710.2278 | 37.7782946690144 | -122.44707774367399 | (37.7782946690144, -122.447077743674) | |||
| 86386 | 86386 | 22799 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 300X Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 5999029.37493 | 2111788.901 | 37.7785132178028 | -122.44693006588699 | (37.7785132178028, -122.446930065887) | |||
| 115550 | 115550 | 8206 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 600X Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 5999170.406219999 | 2110772.7313599996 | 37.7757311331763 | -122.446369065645 | (37.7757311331763, -122.446369065645) | |||
| 7435 | 7435 | 14489 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 303 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5998982.1627 | 2111728.505 | 37.7783446886067 | -122.447089042698 | (37.7783446886067, -122.447089042698) | |||
| 79656 | 79656 | 28130 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1449 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3 | 5990902.20899 | 2114729.2647700002 | 37.7861189831627 | -122.475259452268 | (37.7861189831627, -122.475259452268) | |||
| 80199 | 80199 | 12768 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1818 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 5989756.31056 | 2114744.53545 | 37.7860944276934 | -122.47922502916599 | (37.7860944276934, -122.479225029166) | |||
| 104781 | 104781 | 12609 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 712 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 5993249.71085 | 2114871.74554 | 37.7866459809645 | -122.467148152148 | (37.7866459809645, -122.467148152148) | |||
| 117096 | 117096 | 12872 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2545 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 5987501.82373 | 2114606.0345099997 | 37.7855829503971 | -122.487014674935 | (37.7855829503971, -122.487014674935) | |||
| 140953 | 140953 | 12869 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2539 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 5987520.78762 | 2114606.7100299997 | 37.785585910876605 | -122.48694911586901 | (37.7855859108766, -122.486949115869) | |||
| 19878 | 19878 | 5726 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1682 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6005266.70473 | 2098545.04181 | 37.742503071459204 | -122.424410502341 | (37.7425030714592, -122.424410502341) | |||
| 48375 | 48375 | 17720 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1300X Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/28/2013 12:00:00 AM | 35 | 3X3 | Permit Number 768629 | 6002290.5602400005 | 2112983.34935 | 37.7819786446445 | -122.435733884321 | (37.7819786446445, -122.435733884321) | |
| 84716 | 84716 | 12871 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2550 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/1990 12:00:00 AM | 35 | 3X3 | 5987471.3442 | 2114662.21357 | 37.785735424822505 | -122.48712425141899 | (37.7857354248225, -122.487124251419) | ||
| 3432 | 3432 | 180655 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 128 South Hill Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 31 | Width 6ft | 6003064.16129 | 2086909.24662 | 37.7104291634552 | -122.431195883608 | (37.7104291634552, -122.431195883608) | |||
| 1325 | 1325 | 141834 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1131 TURK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | Width 0ft | 6004558.497 | 2112571.6053 | 37.7809766592124 | -122.427858513843 | (37.7809766592124, -122.427858513843) | |||
| 5443 | 5443 | 23446 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2100X Van Ness Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6005973.04919 | 2117793.46515 | 37.7953945104887 | -122.423336192033 | (37.7953945104887, -122.423336192033) | |||
| 7861 | 7861 | 8161 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1102 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6002408.427999999 | 2111279.278 | 37.7773063874437 | -122.43520419289699 | (37.7773063874437, -122.435204192897) | |||
| 87616 | 87616 | 12773 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1836 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 5989683.26895 | 2114740.78981 | 37.786079900862106 | -122.479477456642 | (37.7860799008621, -122.479477456642) | |||
| 108367 | 108367 | 14552 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 861 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 5999149.64714 | 2109912.56691 | 37.773368155847 | -122.446378982691 | (37.773368155847, -122.446378982691) | |||
| 120750 | 120750 | 26256 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1512 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6005844.96192 | 2100139.60783 | 37.746914024965704 | -122.42252433860399 | (37.7469140249657, -122.422524338604) | |||
| 122619 | 122619 | 478 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2300X Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 5988301.98955 | 2114692.83548 | 37.7858679033343 | -122.484252736316 | (37.7858679033343, -122.484252736316) | |||
| 124196 | 124196 | 14524 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 633 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 5999110.06323 | 2110621.57238 | 37.775312642744005 | -122.446566928571 | (37.775312642744, -122.446566928571) | |||
| 10581 | 10581 | 1040 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2003X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 4X4 | 6000664.666119999 | 2090352.04738 | 37.7197460535115 | -122.439735693745 | (37.7197460535115, -122.439735693745) | |||
| 78617 | 78617 | 16586 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 731X Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 5993243.81381 | 2114817.74498 | 37.7864973698403 | -122.467164626609 | (37.7864973698403, -122.467164626609) | |||
| 78936 | 78936 | 12864 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2518 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/30/1998 12:00:00 AM | 25 | 3X3 | 5987668.19554 | 2114660.48898 | 37.7857421659188 | -122.486443083732 | (37.7857421659188, -122.486443083732) | ||
| 86118 | 86118 | 20106 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1875X Haight St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 5997178.90707 | 2108418.4655400002 | 37.7691529849708 | -122.453088136651 | (37.7691529849708, -122.453088136651) | |||
| 115580 | 115580 | 347 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3590X 19th Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/24/2008 12:00:00 AM | 25 | 2 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | ||
| 3757 | 3757 | 6923 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 436 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6005320.8239 | 2110648.3853 | 37.775739063409794 | -122.425084363796 | (37.7757390634098, -122.425084363796) | |||
| 7925 | 7925 | 22616 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1001 Turk St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x5 | 6005581.297 | 2112717.6262 | 37.7814354041528 | -122.424330527926 | (37.7814354041528, -122.424330527926) | |||
| 19822 | 19822 | 24560 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 432 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/16/1996 12:00:00 AM | 24 | 3X3 | 6007387.76503 | 2097243.55046 | 37.739049012887705 | -122.416984291216 | (37.7390490128877, -122.416984291216) | ||
| 21703 | 21703 | 10122 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 862 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/1997 12:00:00 AM | 24 | 3X4 | 6005637.76588 | 2103917.84087 | 37.7572764892318 | -122.423509370882 | (37.7572764892318, -122.423509370882) | ||
| 22038 | 22038 | 354 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3690X 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/10/1995 12:00:00 AM | 24 | 2 | 5990504.49839 | 2091477.17058 | 37.722251813860204 | -122.474937513077 | (37.7222518138602, -122.474937513077) | ||
| 76350 | 76350 | 24722 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 7328 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/14/2008 12:00:00 AM | 24 | 5 | 5984267.75782 | 2112498.96385 | 37.7796084515897 | -122.49804776887501 | (37.7796084515897, -122.498047768875) | ||
| 114529 | 114529 | 96358 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 261 Bradford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/2011 12:00:00 AM | 24 | 3x3 | Permit Number 767870 | 6009536.0 | 2097078.0 | 37.738715055700496 | -122.409544964001 | (37.7387150557005, -122.409544964001) | |
| 53016 | 53016 | 180001 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 62 Tomaso Ct | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | Width 8ft | 6009181.15123 | 2086279.38185 | 37.709044431429604 | -122.41000974567899 | (37.7090444314296, -122.410009745679) | |||
| 65830 | 65830 | 198227 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1195 La Salle Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6017315.6556400005 | 2094453.93145 | 37.7319427391711 | -122.38246379378401 | (37.7319427391711, -122.382463793784) | |||
| 9394 | 9394 | 19116 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 507X Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/2001 12:00:00 AM | 20 | 3X3 | 6003392.0492998 | 2108320.088346 | 37.769236987964604 | -122.431590213757 | (37.7692369879646, -122.431590213757) | ||
| 12019 | 12019 | 1187 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3022 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/18/1998 12:00:00 AM | 20 | 3X3 | 5996561.5746 | 2087275.10705 | 37.7110630910694 | -122.45369647960399 | (37.7110630910694, -122.453696479604) | ||
| 17298 | 17298 | 10449 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1530 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2011 12:00:00 AM | 20 | 3x3 | Permit Number 768237 | 5998780.3696 | 2108692.1816 | 37.7699961910817 | -122.44756849597401 | (37.7699961910817, -122.447568495974) | |
| 20559 | 20559 | 10046 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 380 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6005478.637490001 | 2106816.50174 | 37.765226545592604 | -122.424265853604 | (37.7652265455926, -122.424265853604) | |||
| 21804 | 21804 | 5119 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2723 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/1997 12:00:00 AM | 20 | 3X3 | 6002440.86448 | 2096077.55845 | 37.7355679530939 | -122.43400506798001 | (37.7355679530939, -122.43400506798) | ||
| 85652 | 85652 | 12770 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1830 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/1991 12:00:00 AM | 20 | 3X3 | 5989705.6696 | 2114744.9010400004 | 37.786092490260295 | -122.479400258148 | (37.7860924902603, -122.479400258148) | ||
| 89264 | 89264 | 12542 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 239 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1993 12:00:00 AM | 20 | 3X3 | 5994654.471609999 | 2114868.80417 | 37.78671889211729 | -122.46228784155399 | (37.7867188921173, -122.462287841554) | ||
| 89669 | 89669 | 12767 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1815 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/14/1992 12:00:00 AM | 20 | 4X4 | 5989790.21677 | 2114688.0089 | 37.7859411908304 | -122.47910358770099 | (37.7859411908304, -122.479103587701) | ||
| 95645 | 95645 | 17724 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1300X Pierce St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/28/2013 12:00:00 AM | 20 | 3X3 | Permit Number 768629 | 6002290.5602400005 | 2112983.34935 | 37.7819786446445 | -122.435733884321 | (37.7819786446445, -122.435733884321) | |
| 127984 | 127984 | 12780 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1908 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/23/1991 12:00:00 AM | 20 | 3X3 | 5989502.50585 | 2114734.73885 | 37.7860527853316 | -122.480102398429 | (37.7860527853316, -122.480102398429) | ||
| 155631 | 155631 | 241538 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 210 Mateo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 4ft | 6003955.81733 | 2096251.4490900002 | 37.73613127674471 | -122.42877969123 | (37.7361312767447, -122.42877969123) | |||
| 58819 | 58819 | 241539 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 251 Mateo St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 3ft | 6004097.41418 | 2096123.31258 | 37.735787456011295 | -122.428281003662 | (37.7357874560113, -122.428281003662) | |||
| 155724 | 155724 | 241572 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 160 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 5ft | 5997589.92507 | 2107138.86061 | 37.765663063919604 | -122.45157414343399 | (37.7656630639196, -122.451574143434) | |||
| 1482 | 1482 | 140438 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1100 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6003482.3387 | 2112124.8891 | 37.779689150174704 | -122.43154957445299 | (37.7796891501747, -122.431549574453) | |||
| 2301 | 2301 | 22734 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1560 Turk St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/1990 12:00:00 AM | 18 | 3X3 | 6002510.1745 | 2112337.5363 | 37.780217876703794 | -122.434927920426 | (37.7802178767038, -122.434927920426) | ||
| 6895 | 6895 | 6225 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1220 Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X4 | 6005060.4446 | 2113384.1056 | 37.783235967029206 | -122.426179889067 | (37.7832359670292, -122.426179889067) | |||
| 7575 | 7575 | 14521 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 610 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5999188.9854 | 2110718.1832 | 37.7755824190107 | -122.446300870977 | (37.7755824190107, -122.446300870977) | |||
| 8980 | 8980 | 17002 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2028 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5999484.07976 | 2121214.10704 | 37.8044183160192 | -122.446035175776 | (37.8044183160192, -122.446035175776) | |||
| 16849 | 16849 | 22416 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5800 03rd St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 6013664.2375 | 2091773.8949 | 37.724381524856206 | -122.39489998248001 | (37.7243815248562, -122.39489998248) | ||||
| 17170 | 17170 | 24535 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 212 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/11/1996 12:00:00 AM | 18 | 3X3 | 6006739.63242 | 2097415.81702 | 37.7394855384388 | -122.419237458951 | (37.7394855384388, -122.419237458951) | ||
| 18476 | 18476 | 24485 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 633 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/24/1995 12:00:00 AM | 18 | 3x3 | 6003947.557 | 2110053.0346 | 37.7740267060282 | -122.4297923636 | (37.7740267060282, -122.4297923636) | ||
| 18646 | 18646 | 5581 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1061 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6005153.1959 | 2102184.2823799998 | 37.752489179437205 | -122.425061862427 | (37.7524891794372, -122.425061862427) | |||
| 21813 | 21813 | 851 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 362 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/1992 12:00:00 AM | 18 | 3X3 | 6008418.030180001 | 2095243.6630400002 | 37.7336156580305 | -122.413280706764 | (37.7336156580305, -122.413280706764) | ||
| 21932 | 21932 | 23051 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1062 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/1991 12:00:00 AM | 18 | 3x3 | 6006317.26236 | 2103381.75726 | 37.755842857466504 | -122.421121338081 | (37.7558428574665, -122.421121338081) | ||
| 66457 | 66457 | 248340 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 712 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 5999056.5813 | 2108183.8739 | 37.7686162882269 | -122.44657651166 | (37.7686162882269, -122.44657651166) | |||
| 102543 | 102543 | 21639 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1641 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 10/14/2010 12:00:00 AM | 18 | 4X4 | Permit Number 53778 | 6004750.8195846 | 2114677.2774985 | 37.7867691895303 | -122.42734321826401 | (37.7867691895303, -122.427343218264) |
| 105254 | 105254 | 20129 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 999X Hayes St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/09/2008 12:00:00 AM | 18 | 3X3 | 6003226.6736 | 2110648.3783 | 37.7756205244718 | -122.432328548686 | (37.7756205244718, -122.432328548686) | ||
| 110642 | 110642 | 102285 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 106 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4x4 | 6000567.8 | 2102477.2 | 37.7530333697051 | -122.44093990264099 | (37.7530333697051, -122.440939902641) | |||
| 168842 | 168842 | 248456 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 738 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 5999090.801 | 2107937.9767 | 37.7679430712087 | -122.44644045643801 | (37.7679430712087, -122.446440456438) | |||
| 19285 | 19285 | 10094 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 718 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 2X3 | 6005593.36455 | 2104752.70261 | 37.759566317848 | -122.423722287162 | (37.759566317848, -122.423722287162) | |||
| 21071 | 21071 | 10051 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 398 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/11/2009 12:00:00 AM | 16 | 3X3 | 6005480.85974 | 2106714.7911 | 37.7649473978257 | -122.42425093294399 | (37.7649473978257, -122.424250932944) | ||
| 73314 | 73314 | 241577 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 175 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5998915.93827 | 2107135.99958 | 37.7657310553579 | -122.446987565935 | (37.7657310553579, -122.446987565935) | |||
| 84476 | 84476 | 28493 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1550 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2004 12:00:00 AM | 16 | 3X3 | 6005878.3965356 | 2099932.1533401003 | 37.746346288340995 | -122.42239398674299 | (37.746346288341, -122.422393986743) | ||
| 88952 | 88952 | 26262 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1600 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/09/2003 12:00:00 AM | 16 | 3X3 | 6005898.4261087 | 2099645.3628371996 | 37.7455599567156 | -122.42230435386001 | (37.7455599567156, -122.42230435386) | ||
| 110755 | 110755 | 12865 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2523 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/09/2001 12:00:00 AM | 16 | 3X3 | 5987615.33062 | 2114609.82453 | 37.785599974214705 | -122.486622257562 | (37.7855999742147, -122.486622257562) | ||
| 117390 | 117390 | 7480 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2650X Folsom St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/28/1992 12:00:00 AM | 16 | 3x3 | 6008254.1361302 | 2102990.9843832003 | 37.7548788814664 | -122.414395330099 | (37.7548788814664, -122.414395330099) | ||
| 126517 | 126517 | 26260 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1550 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/09/2003 12:00:00 AM | 16 | 3X3 | 6005878.3965356 | 2099932.1533401003 | 37.746346288340995 | -122.42239398674299 | (37.746346288341, -122.422393986743) | ||
| 126857 | 126857 | 10052 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 394 Guerrero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/02/2005 12:00:00 AM | 16 | 3X3 | 6005485.0846607005 | 2106684.1712003 | 37.7648635614138 | -122.424234142103 | (37.7648635614138, -122.424234142103) | ||
| 136829 | 136829 | 241537 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 210 Mateo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6003916.461069999 | 2096303.8204 | 37.7362728489052 | -122.428919494459 | (37.7362728489052, -122.428919494459) | |||
| 151863 | 151863 | 241826 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 144 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5997687.44505 | 2107150.20494 | 37.7656997967239 | -122.451237663011 | (37.7656997967239, -122.451237663011) | |||
| 20090 | 20090 | 26095 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/1997 12:00:00 AM | 15 | 3X3 | 5996463.561430001 | 2088032.82115 | 37.7131379789998 | -122.454089924914 | (37.7131379789998, -122.454089924914) | ||
| 28632 | 28632 | 198138 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 134 Bridgeview Dr | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6013340.1556400005 | 2095686.7025099997 | 37.7351072690864 | -122.396294410852 | (37.7351072690864, -122.396294410852) | |||
| 125751 | 125751 | 1231 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3601X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1992 12:00:00 AM | 15 | 3X3 | 5993438.31243 | 2087500.5986099998 | 37.71150268788671 | -122.464507504506 | (37.7115026878867, -122.464507504506) | ||
| 134389 | 134389 | 242048 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 166 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6005474.26503 | 2099944.29048 | 37.7463568085305 | -122.423792290409 | (37.7463568085305, -122.423792290409) | |||
| 136066 | 136066 | 218513 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 234 Ralston St | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 5992216.02262 | 2089433.0746400002 | 37.71673826375 | -122.46887255801701 | (37.71673826375, -122.468872558017) | |||
| 139038 | 139038 | 1224 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3600X Alemany Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/02/1998 12:00:00 AM | 15 | 3X5 | 5993524.054670201 | 2087589.4711722 | 37.7117516532039 | -122.46421760708901 | (37.7117516532039, -122.464217607089) | ||
| 156121 | 156121 | 241516 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 109 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6000619.16522 | 2102442.54897 | 37.7529411517191 | -122.440759786856 | (37.7529411517191, -122.440759786856) | |||
| 168162 | 168162 | 241782 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 209 Day St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6004251.25881 | 2098661.7812200002 | 37.7427662166839 | -122.42792993083201 | (37.7427662166839, -122.427929930832) | |||
| 173593 | 173593 | 62254 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 443 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/03/1985 12:00:00 AM | 15 | Permit Number 22380 | 6000907.57208 | 2092218.0446799998 | 37.7248834819716 | -122.43902971697099 | (37.7248834819716, -122.439029716971) | |
| 178123 | 178123 | 241550 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 137 Mateo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6003890.49811 | 2096382.4809400002 | 37.7364873632872 | -122.42901486574199 | (37.7364873632872, -122.429014865742) |
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");