Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 94141 | 94141 | 179594 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 2115 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006118.53039 | 2086176.0114900002 | 37.7085884697411 | -122.420587301759 | (37.7085884697411, -122.420587301759) | |||
| 175340 | 175340 | 179595 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 2109 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006095.08243 | 2086183.72557 | 37.7086083294779 | -122.420668888264 | (37.7086083294779, -122.420668888264) | |||
| 71336 | 71336 | 179596 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 2101 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006079.302180001 | 2086189.0223299998 | 37.7086219838753 | -122.42072380268299 | (37.7086219838753, -122.420723802683) | |||
| 154569 | 154569 | 179582 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 299 Lathrop Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6012218.08468 | 2086837.71527 | 37.7107472500657 | -122.399552761654 | (37.7107472500657, -122.399552761654) | |||
| 42955 | 42955 | 179583 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 299 Lathrop Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6012138.538380001 | 2086862.1031 | 37.71080977991289 | -122.399829404828 | (37.7108097799129, -122.399829404828) | |||
| 76054 | 76054 | 179588 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 71 South Hill Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 6002920.320730001 | 2087190.6404400002 | 37.711193657325204 | -122.43171310439199 | (37.7111936573252, -122.431713104392) | |||
| 10376 | 10376 | 108848 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 285 Allison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/07/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772784 | 6000194.12477 | 2087314.03499 | 37.711377561484106 | -122.441144334244 | (37.7113775614841, -122.441144334244) |
| 12491 | 12491 | 108849 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 285 Allison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/07/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772784 | 6000190.55201 | 2087326.30532 | 37.711411049560205 | -122.441157562371 | (37.7114110495602, -122.441157562371) |
| 180027 | 180027 | 179629 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 49 Seville St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6002062.61368 | 2087462.58557 | 37.711891703015795 | -122.43469698207599 | (37.7118917030158, -122.434696982076) | |||
| 184397 | 184397 | 31051 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 40 South Hill Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 10 | Permit Number 34806 | 6002706.14254 | 2087539.54135 | 37.7121395201911 | -122.43247826105801 | (37.7121395201911, -122.432478261058) | |
| 52444 | 52444 | 179581 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 238 Tocoloma Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6012679.41908 | 2087343.6153900002 | 37.7121620563027 | -122.397993741039 | (37.7121620563027, -122.397993741039) | |||
| 183207 | 183207 | 31053 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 40 South Hill Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 10 | Permit Number 34806 | 6002711.16213 | 2087562.81668 | 37.7122037138071 | -122.432462573298 | (37.7122037138071, -122.432462573298) | |
| 179693 | 179693 | 54942 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 238 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/1972 12:00:00 AM | 12 | Permit Number 10820 | 6012686.68001 | 2087364.92959 | 37.7122209852769 | -122.397970139226 | (37.7122209852769, -122.397970139226) | ||
| 134031 | 134031 | 31052 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 40 South Hill Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 12 | Permit Number 34806 | 6002702.91806 | 2087603.1989400003 | 37.7123141271746 | -122.432493949742 | (37.7123141271746, -122.432493949742) | |
| 38857 | 38857 | 179580 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 210 Tocoloma Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6012727.00999 | 2087491.1806 | 37.7125698916572 | -122.397839596325 | (37.7125698916572, -122.397839596325) | |||
| 69535 | 69535 | 179579 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 210 Tocoloma Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6012735.13686 | 2087513.11495 | 37.71263057163 | -122.397813044753 | (37.71263057163, -122.397813044753) | |||
| 45663 | 45663 | 215160 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 125 Arch St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 5992679.1263 | 2088076.57107 | 37.713040376475504 | -122.467173279126 | (37.7130403764755, -122.467173279126) | |||
| 56775 | 56775 | 179563 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 190 Foote Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 8ft | 5998684.14155 | 2088327.6956200001 | 37.71407471735 | -122.44643608006099 | (37.71407471735, -122.446436080061) | |||
| 72075 | 72075 | 179564 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 190 Foote Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 8ft | 5998675.98821 | 2088335.1658599998 | 37.7140947632347 | -122.446464798107 | (37.7140947632347, -122.446464798107) | |||
| 67537 | 67537 | 179565 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 190 Foote Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | 5998669.51427 | 2088341.1410400001 | 37.714110799942205 | -122.446487604047 | (37.7141107999422, -122.446487604047) | |||
| 60757 | 60757 | 179566 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 190 Foote Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | 5998660.62804 | 2088348.62653 | 37.7141308458255 | -122.446518856356 | (37.7141308458255, -122.446518856356) | |||
| 172965 | 172965 | 179567 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 190 Foote Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 8ft | 5998654.86652 | 2088353.6134799998 | 37.7141442097611 | -122.446539128875 | (37.7141442097611, -122.446539128875) | |||
| 41702 | 41702 | 179568 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 190 Foote Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 8ft | 5998649.6038 | 2088359.07643 | 37.7141589091721 | -122.446557711588 | (37.7141589091721, -122.446557711588) | |||
| 148626 | 148626 | 179569 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 190 Foote Ave | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 5998642.9362699995 | 2088367.48919 | 37.7141816278426 | -122.446581361956 | (37.7141816278426, -122.446581361956) | |||
| 174824 | 174824 | 179570 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 190 Foote Ave | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 5998636.2181400005 | 2088373.4694599998 | 37.714197664554796 | -122.44660501232599 | (37.7141976645548, -122.446605012326) | |||
| 177307 | 177307 | 179571 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 190 Foote Ave | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 8ft | 5998627.15829 | 2088384.3655400001 | 37.7142270651918 | -122.446637110039 | (37.7142270651918, -122.446637110039) | |||
| 66047 | 66047 | 179593 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 78 Tucker Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6010613.232999999 | 2088708.1848 | 37.715793594276704 | -122.40523115211 | (37.7157935942767, -122.40523115211) | |||
| 163727 | 163727 | 215159 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 18 Sargent St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 5993985.26424 | 2089201.7814099998 | 37.7162052463581 | -122.462740441625 | (37.7162052463581, -122.462740441625) | |||
| 52931 | 52931 | 179578 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 334 Prague St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6003779.11215 | 2089222.9943900001 | 37.716822702879895 | -122.428889707996 | (37.7168227028799, -122.428889707996) | |||
| 183148 | 183148 | 66354 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 334 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1990 12:00:00 AM | 13 | Permit Number 29475 | 6003787.88189 | 2089236.55246 | 37.7168604267574 | -122.428860361341 | (37.7168604267574, -122.428860361341) | ||
| 171299 | 171299 | 215155 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 201 Thrift St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5994990.6689 | 2089608.53553 | 37.717379951595504 | -122.45929474225599 | (37.7173799515955, -122.459294742256) | |||
| 54492 | 54492 | 215153 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 201 Thrift St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5994954.26021 | 2089609.71028 | 37.7173810838456 | -122.459420674348 | (37.7173810838456, -122.459420674348) | |||
| 151118 | 151118 | 215154 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 201 Thrift St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5994969.58923 | 2089610.2136799998 | 37.717383347428296 | -122.459367725845 | (37.7173833474283, -122.459367725845) | |||
| 36771 | 36771 | 179599 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 901 Delano Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 5998631.90027 | 2089544.4113200002 | 37.717412556513295 | -122.44670413648399 | (37.7174125565133, -122.446704136484) | |||
| 158634 | 158634 | 179600 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 901 Delano Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 5998640.25719 | 2089558.9766400002 | 37.71745302692 | -122.446676297989 | (37.71745302692, -122.446676297989) | |||
| 27640 | 27640 | 179601 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 901 Delano Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 5998646.13957 | 2089569.69223 | 37.717482785492 | -122.446656735947 | (37.717482785492, -122.446656735947) | |||
| 57755 | 57755 | 179607 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 247 Mount Vernon Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 5998695.31967 | 2089579.5071 | 37.7175125440582 | -122.44648744934999 | (37.7175125440582, -122.44648744935) | ||||
| 34719 | 34719 | 179602 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 901 Delano Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 5998651.59561 | 2089580.85001 | 37.7175137338593 | -122.446638679342 | (37.7175137338593, -122.446638679342) | |||
| 185769 | 185769 | 215156 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 218 Thrift St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 5994824.146269999 | 2089663.55723 | 37.7175214527221 | -122.459874313044 | (37.7175214527221, -122.459874313044) | |||
| 137121 | 137121 | 179606 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 247 Mount Vernon Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 5998687.8621 | 2089587.2484799998 | 37.717533374149205 | -122.44651378328501 | (37.7175333741492, -122.446513783285) | ||||
| 168554 | 168554 | 179603 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 901 Delano Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 5998658.1578 | 2089592.8520799999 | 37.7175470636356 | -122.446616859994 | (37.7175470636356, -122.446616859994) | |||
| 61435 | 61435 | 179605 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 247 Mount Vernon Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 5998680.84891 | 2089595.4146 | 37.7175553958555 | -122.446538611763 | (37.7175553958555, -122.446538611763) | ||||
| 38103 | 38103 | 179604 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 901 Delano Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 5998666.20237 | 2089602.87221 | 37.7175750361301 | -122.44658977421801 | (37.7175750361301, -122.446589774218) | |||
| 188923 | 188923 | 179577 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 700 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6001127.46159 | 2089574.9646 | 37.7176386901633 | -122.438080342229 | (37.7176386901633, -122.438080342229) | |||
| 171721 | 171721 | 179574 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 150 Italy Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6001107.65338 | 2089620.96663 | 37.7177638748828 | -122.438152103634 | (37.7177638748828, -122.438152103634) | |||
| 74706 | 74706 | 179575 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 150 Italy Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6001094.37871 | 2089628.06075 | 37.717782598761396 | -122.438198496058 | (37.7177825987614, -122.438198496058) | |||
| 23581 | 23581 | 179576 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 150 Italy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6001080.83583 | 2089635.4329400002 | 37.717802070884794 | -122.438245835497 | (37.7178020708848, -122.438245835497) | |||
| 178231 | 178231 | 197812 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 958 Le Conte Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6013362.4474599995 | 2089433.04688 | 37.7179372398964 | -122.39577929089899 | (37.7179372398964, -122.395779290899) | |||
| 32135 | 32135 | 215152 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 739 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5994637.17315 | 2089906.08202 | 37.71817661334929 | -122.460538153038 | (37.7181766133493, -122.460538153038) | |||
| 40513 | 40513 | 215151 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 748 Lakeview Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 5994563.14295 | 2089947.14984 | 37.718285116550604 | -122.460797016589 | (37.7182851165506, -122.460797016589) | |||
| 136444 | 136444 | 179591 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 46 Bishop St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010887.64563 | 2089644.57166 | 37.718380059775896 | -122.404348520588 | (37.7183800597759, -122.404348520588) | |||
| 40883 | 40883 | 179592 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 33 Bishop St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6010924.14414 | 2089655.49375 | 37.7184120891289 | -122.40422312811899 | (37.7184120891289, -122.404223128119) | |||
| 135253 | 135253 | 179590 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 40 Bishop St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6010898.94901 | 2089680.08922 | 37.7184782153849 | -122.404311947847 | (37.7184782153849, -122.404311947847) | |||
| 37442 | 37442 | 179589 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 40 Bishop St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6010901.30709 | 2089684.5565099998 | 37.718490613421004 | -122.404304111153 | (37.718490613421, -122.404304111153) | |||
| 71936 | 71936 | 49744 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 27 Bishop St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 12 | Permit Number 46543 | 6010938.20638 | 2089696.59945 | 37.7185257427455 | -122.404177411982 | (37.7185257427455, -122.404177411982) | |
| 146990 | 146990 | 93802 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 21 Bishop St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 6010948.90983 | 2089721.21702 | 37.718593935631205 | -122.40414214596201 | (37.7185939356312, -122.404142145962) | ||||
| 47901 | 47901 | 215157 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 494 Victoria St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 5993275.20314 | 2090415.1347 | 37.7194959008046 | -122.46528281875601 | (37.7194959008046, -122.465282818756) | |||
| 183115 | 183115 | 215158 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 494 Victoria St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5993274.39312 | 2090442.4694700001 | 37.7195709087624 | -122.465287603165 | (37.7195709087624, -122.465287603165) | |||
| 72247 | 72247 | 179573 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 205 Seneca Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 6ft | 5999821.83375 | 2090347.3998900002 | 37.7196852827387 | -122.44264872377701 | (37.7196852827387, -122.442648723777) | |||
| 53416 | 53416 | 179572 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 205 Seneca Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 5999817.08218 | 2090385.88306 | 37.7197906778859 | -122.44266790991699 | (37.7197906778859, -122.442667909917) | |||
| 135693 | 135693 | 187427 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 3199 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6011854.6582 | 2090886.7407 | 37.721844794431895 | -122.40109317658 | (37.7218447944319, -122.40109317658) | |||
| 11421 | 11421 | 24893 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 3195 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/14/1996 12:00:00 AM | 18 | 2X3 | 6011845.1957 | 2090907.7685 | 37.7219020046048 | -122.401127363027 | (37.7219020046048, -122.401127363027) | ||
| 11954 | 11954 | 24916 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 3180 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/14/1996 12:00:00 AM | 16 | 2X3 | 6011786.8435 | 2090915.654 | 37.7219204011149 | -122.401329626814 | (37.7219204011149, -122.401329626814) | ||
| 185861 | 185861 | 179587 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 320 Olmstead St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 1ft | 6010760.46271 | 2090986.07392 | 37.7220564415258 | -122.404882538894 | (37.7220564415258, -122.404882538894) | |||
| 58613 | 58613 | 179586 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 320 Olmstead St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 1ft | 6010772.40184 | 2090990.4201900002 | 37.7220690428431 | -122.40484157390199 | (37.7220690428431, -122.404841573902) | |||
| 38870 | 38870 | 179585 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 320 Olmstead St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 1ft | 6010784.99943 | 2090994.75272 | 37.7220816432233 | -122.40479833178301 | (37.7220816432233, -122.404798331783) | |||
| 70633 | 70633 | 179584 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 320 Olmstead St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 1ft | 6010797.22777 | 2090997.12631 | 37.7220888441036 | -122.40475622821998 | (37.7220888441036, -122.40475622822) | |||
| 11695 | 11695 | 24912 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 3106 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/14/1996 12:00:00 AM | 16 | 2X3 | 6011710.6178 | 2091173.2445 | 37.722623438850604 | -122.401611216966 | (37.7226234388506, -122.401611216966) | ||
| 12652 | 12652 | 28672 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 3100 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2008 12:00:00 AM | 16 | 3x3 | 6011704.8351 | 2091194.7980000002 | 37.7226822976708 | -122.401632720761 | (37.7226822976708, -122.401632720761) | ||
| 73969 | 73969 | 179609 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 801 Excelsior Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 6004359.1035400005 | 2091527.3039 | 37.723182644542206 | -122.427048992729 | (37.7231826445422, -122.427048992729) | |||
| 187552 | 187552 | 179610 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 801 Excelsior Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 5ft | 6004355.20316 | 2091529.3474400002 | 37.723188035096 | -122.427062621069 | (37.723188035096, -122.427062621069) | |||
| 134101 | 134101 | 179611 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 801 Excelsior Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 5ft | 6004351.48931 | 2091531.74381 | 37.723194404989705 | -122.427075629732 | (37.7231944049897, -122.427075629732) | |||
| 161362 | 161362 | 179612 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 801 Excelsior Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 5ft | 6004345.82316 | 2091535.07257 | 37.7232032246197 | -122.4270954535 | (37.7232032246197, -122.4270954535) | |||
| 12462 | 12462 | 115357 | Planning Code 138.1 required 4 | Syagrus romanzoffianum :: Queen Palm 142 | 270 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2016 12:00:00 AM | 3 | 3x6 | 5999894.51999 | 2091641.8812799999 | 37.723243775973394 | -122.442490363056 | (37.7232437759734, -122.442490363056) | ||
| 156614 | 156614 | 215149 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 484 Faxon Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5994795.247219999 | 2091767.07997 | 37.7232955616276 | -122.460126512638 | (37.7232955616276, -122.460126512638) | |||
| 56994 | 56994 | 215147 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 484 Faxon Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5994798.24088 | 2091767.0172599999 | 37.7232955616299 | -122.460116159654 | (37.7232955616299, -122.460116159654) | |||
| 67303 | 67303 | 215148 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 484 Faxon Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5994798.31225 | 2091770.42438 | 37.723304920868 | -122.46011615966002 | (37.723304920868, -122.46011615966) | |||
| 133244 | 133244 | 215150 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 484 Faxon Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5994798.27726 | 2091789.1713599998 | 37.7233563935592 | -122.460117638123 | (37.7233563935592, -122.460117638123) | |||
| 156429 | 156429 | 179620 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 602 Somerset St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 5ft | 6010330.793980001 | 2091554.32638 | 37.723592718304296 | -122.40640782506 | (37.7235927183043, -122.40640782506) | |||
| 42647 | 42647 | 215146 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 143 De Montfort Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5994847.73331 | 2091874.74645 | 37.723594206678 | -122.459952875147 | (37.723594206678, -122.459952875147) | |||
| 94192 | 94192 | 28703 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 3004 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2008 12:00:00 AM | 16 | 3x3 | 6011599.0463446 | 2091533.0938880001 | 37.7236052850781 | -122.40202218213498 | (37.7236052850781, -122.402022182135) | ||
| 12100 | 12100 | 28704 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 3004 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2008 12:00:00 AM | 16 | 3x3 | 6011587.3423 | 2091581.4466 | 37.7237373984555 | -122.402066038858 | (37.7237373984555, -122.402066038858) | ||
| 35690 | 35690 | 179621 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 599 Somerset St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 6010365.10231 | 2091621.9745099999 | 37.7237803852281 | -122.406293990689 | (37.7237803852281, -122.406293990689) | |||
| 173297 | 173297 | 187410 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 3004 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 0ft | 6011579.9826 | 2091598.2688 | 37.723783177982995 | -122.40209266232901 | (37.723783177983, -122.402092662329) | |||
| 33691 | 33691 | 179622 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 599 Somerset St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 6010361.21232 | 2091638.8627900002 | 37.7238265393343 | -122.406308627159 | (37.7238265393343, -122.406308627159) | |||
| 132068 | 132068 | 179623 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 599 Somerset St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 6010356.36169 | 2091656.0500299998 | 37.723873460582794 | -122.40632660549299 | (37.7238734605828, -122.406326605493) | |||
| 146342 | 146342 | 179624 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 599 Somerset St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 6010352.888119999 | 2091667.1741900002 | 37.7239038109035 | -122.406339396551 | (37.7239038109035, -122.406339396551) | |||
| 53556 | 53556 | 179625 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 599 Somerset St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 6010348.90515 | 2091680.5192099998 | 37.72394023074661 | -122.406354104951 | (37.7239402307466, -122.406354104951) | |||
| 169076 | 169076 | 179626 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 599 Somerset St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 6ft | 6010345.77162 | 2091690.1629 | 37.7239665350232 | -122.406365616296 | (37.7239665350232, -122.406365616296) | |||
| 69826 | 69826 | 179627 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 599 Somerset St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 6010336.72583 | 2091718.34914 | 37.7240434225456 | -122.406398871428 | (37.7240434225456, -122.406398871428) | |||
| 30015 | 30015 | 179628 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 599 Somerset St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 6010332.78013 | 2091733.53575 | 37.7240849010885 | -122.40641358074801 | (37.7240849010885, -122.406413580748) | |||
| 136385 | 136385 | 179608 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 239 Naples St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6004077.01735 | 2092129.7221099997 | 37.7248207965363 | -122.428067019004 | (37.7248207965363, -122.428067019004) | ||||
| 154472 | 154472 | 62260 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 126 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1985 12:00:00 AM | 12 | Permit Number 22386 | 6000410.66201 | 2092263.48087 | 37.7249799531412 | -122.440750730657 | (37.7249799531412, -122.440750730657) | |
| 2974 | 2974 | 68083 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 406 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/24/1994 12:00:00 AM | 14 | Permit Number 780238 | 6000946.91691 | 2092398.9049099998 | 37.725382321520705 | -122.438906661816 | (37.7253823215207, -122.438906661816) | |
| 48456 | 48456 | 187424 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 2895 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6011445.1418 | 2092205.1836 | 37.725442113938996 | -122.40260144602199 | (37.725442113939, -122.402601446022) | |||
| 11766 | 11766 | 24901 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 2895 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/19/2015 12:00:00 AM | 16 | 3X9 | 6011438.8335 | 2092223.5829 | 37.725492282424604 | -122.40262454667 | (37.7254922824246, -122.40262454667) | ||
| 70276 | 70276 | 42979 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 308 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2000 12:00:00 AM | 10 | Permit Number 42863 | 6006597.58462 | 2092494.33475 | 37.725964228751295 | -122.419379553644 | (37.7259642287513, -122.419379553644) | |
| 13136 | 13136 | 24892 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 2780 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 2X2 | 6011265.8799 | 2092627.3166 | 37.726591193941104 | -122.403250823482 | (37.7265911939411, -122.403250823482) | |||
| 11693 | 11693 | 24891 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 2780 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 2X2 | 6011255.8917 | 2092657.8069999998 | 37.726674356421704 | -122.403287496484 | (37.7266743564217, -122.403287496484) | |||
| 37049 | 37049 | 179597 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 25 Otsego Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6000936.4483 | 2092902.2626599998 | 37.726763831262204 | -122.438978907964 | (37.7267638312622, -122.438978907964) |
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");