trees
858 rows where qSpecies_id = 85 sorted by qLegalStatus_id
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id ▼ | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 53030 | 60578 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 801 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1982 12:00:00 AM | 10 | Permit Number 20192 | 6015478.27896 | 2103906.06329 | 37.7577946687129 | -122.389475912095 | (37.7577946687129, -122.389475912095) | 10 | 3 | 8 | 28856 | 29 | ||
| 53402 | 113232 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1001 Polk St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | 3x3 | 6006901.77113 | 2114384.86271 | 37.7860877036192 | -122.419880660363 | (37.7860877036192, -122.419880660363) | 13 | 9 | 9 | 28858 | 36 | |||
| 53442 | 136553 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 900 Eddy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6006040.70209 | 2113171.61603 | 37.7827078795925 | -122.422773479935 | (37.7827078795925, -122.422773479935) | 7 | 9 | 11 | 28858 | 41 | |||
| 53573 | 93802 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 21 Bishop St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 6010948.90983 | 2089721.21702 | 37.7185939356312 | -122.404142145962 | (37.7185939356312, -122.404142145962) | 10 | 7 | 8 | 309 | 39 | ||||
| 53722 | 240870 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1720 Dolores St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6005279.68731 | 2098305.03098 | 37.7418447893069 | -122.424348545374 | (37.7418447893069, -122.424348545374) | 2 | 7 | 5 | 63 | 7 | |||
| 53726 | 197790 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 340 Arkansas St | 1 | : | Tree | Private 2 | 14 | Width 3ft | 6012898.48867 | 2105422.76056 | 37.7618158127736 | -122.398504382391 | (37.7618158127736, -122.398504382391) | 10 | 3 | 8 | 28856 | 29 | |||
| 53857 | 197776 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1555 Mariposa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6012588.49637 | 2106082.79155 | 37.7636108370988 | -122.399622872805 | (37.7636108370988, -122.399622872805) | 14 | 3 | 8 | 28856 | 29 | |||
| 53922 | 215171 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 101 Stanford Heights Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5997803.80598 | 2096370.84816 | 37.7361090059307 | -122.450058203043 | (37.7361090059307, -122.450058203043) | 9 | 7 | 4 | 59 | 40 | |||
| 53928 | 136555 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 100 Cedar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6006874.57787 | 2114487.03447 | 37.7863667101899 | -122.419981995093 | (37.7863667101899, -122.419981995093) | 13 | 9 | 10 | 28858 | 36 | |||
| 54197 | 51828 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 75 Dore St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 11 | Permit Number 48062 | 6008816.98399 | 2109909.48162 | 37.7739070834758 | -122.412937972431 | (37.7739070834758, -122.412937972431) | 8 | 2 | 9 | 28853 | 34 | ||
| 54305 | 240872 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2913 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007128.77683 | 2101405.53479 | 37.7504623161928 | -122.41817474897 | (37.7504623161928, -122.41817474897) | 2 | 4 | 7 | 28859 | 19 | |||
| 54508 | 197773 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1601 Mariposa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6012487.36348 | 2106076.40737 | 37.7635876696487 | -122.399972213573 | (37.7635876696487, -122.399972213573) | 14 | 3 | 8 | 28856 | 29 | |||
| 54659 | 245258 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 268 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6004814.12133 | 2099029.08337 | 37.7438065713099 | -122.426009852177 | (37.7438065713099, -122.426009852177) | 2 | 7 | 5 | 63 | 22 | |||
| 54708 | 45779 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1033 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2005 12:00:00 AM | 13 | Permit Number 48205 | 6006884.42122 | 2114521.64488 | 37.7864622964456 | -122.419950396487 | (37.7864622964456, -122.419950396487) | 13 | 9 | 10 | 28858 | 36 | |
| 55216 | 245272 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 59 Bradford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6009614.82012 | 2098366.49718 | 37.7422574054489 | -122.409363346253 | (37.7422574054489, -122.409363346253) | 10 | 7 | 7 | 28859 | 2 | |||
| 55489 | 215151 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 748 Lakeview Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 4ft | 5994563.14295 | 2089947.14984 | 37.7182851165506 | -122.460797016589 | (37.7182851165506, -122.460797016589) | 9 | 8 | 6 | 28861 | 24 | |||
| 55640 | 31053 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 40 South Hill Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 10 | Permit Number 34806 | 6002711.16213 | 2087562.81668 | 37.7122037138071 | -122.432462573298 | (37.7122037138071, -122.432462573298) | 9 | 7 | 6 | 28861 | 5 | |
| 56442 | 197808 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 41 Dore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6008660.65845 | 2110075.31719 | 37.7743536526336 | -122.413490461037 | (37.7743536526336, -122.413490461037) | 8 | 2 | 9 | 28853 | 34 | |||
| 56629 | 136558 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 945 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007692.42532 | 2115699.65568 | 37.7897423145977 | -122.417238404529 | (37.7897423145977, -122.417238404529) | 13 | 1 | 10 | 28858 | 21 | |||
| 56716 | 179573 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 205 Seneca Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 5999821.83375 | 2090347.39989 | 37.7196852827387 | -122.442648723777 | (37.7196852827387, -122.442648723777) | 9 | 7 | 6 | 28861 | 25 | |||
| 56900 | 614 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 3130 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6008131.4648 | 2102133.22317 | 37.7525167715542 | -122.414758862149 | (37.7525167715542, -122.414758862149) | 2 | 4 | 7 | 28859 | 19 | |||
| 56933 | 245294 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 525 Day St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 4ft | 6002498.65421 | 2098563.13018 | 37.7423960377374 | -122.433982882617 | (37.7423960377374, -122.433982882617) | 2 | 7 | 5 | 63 | 7 | |||
| 57224 | 197782 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1950 18th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 6011843.38352 | 2105630.34808 | 37.7623269658286 | -122.402168188035 | (37.7623269658286, -122.402168188035) | 8 | 3 | 8 | 28856 | 29 | |||
| 57294 | 87534 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2515 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 6010931.8007 | 2093898.1841 | 37.7300620671282 | -122.404495148402 | (37.7300620671282, -122.404495148402) | 10 | 3 | 7 | 309 | 28 | ||||
| 57296 | 179565 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 190 Foote Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 8ft | 5998669.51427 | 2088341.14104 | 37.7141107999422 | -122.446487604047 | (37.7141107999422, -122.446487604047) | 9 | 7 | 6 | 28861 | 25 | |||
| 57412 | 240958 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 67 Seward St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 6000728.97807 | 2104436.75815 | 37.7584230187284 | -122.440523052908 | (37.7584230187284, -122.440523052908) | 2 | 4 | 5 | 28862 | 38 | |||
| 57890 | 240993 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 5 Beaver St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 6002842.00094 | 2106779.76706 | 37.7649764495406 | -122.433382715554 | (37.7649764495406, -122.433382715554) | 15 | 5 | 5 | 28862 | 3 | |||
| 58437 | 50007 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 400 Pennsylvania Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | 12 | 3x3 | Permit Number 46740 | 6014312.7489 | 2105179.47261 | 37.7612264834299 | -122.393595952812 | (37.7612264834299, -122.393595952812) | 10 | 3 | 8 | 28856 | 29 |
| 58591 | 240869 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1720 Dolores St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 6ft | 6005279.8956 | 2098315.15915 | 37.7418726107263 | -122.424348545375 | (37.7418726107263, -122.424348545375) | 2 | 7 | 5 | 63 | 7 | |||
| 58647 | 103856 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1489 Polk St | 2 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006726.68698 | 2115849.48669 | 37.7900993346467 | -122.420590411881 | (37.7900993346467, -122.420590411881) | 13 | 9 | 10 | 28858 | 21 | ||
| 58750 | 245241 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 882 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009904.02898 | 2104112.5978 | 37.7580511265686 | -122.408768638979 | (37.7580511265686, -122.408768638979) | 2 | 4 | 7 | 28859 | 19 | |||
| 58846 | 51534 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 772 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2005 12:00:00 AM | 10 | Permit Number 47835 | 6012007.91318 | 2110835.16017 | 37.7766273842858 | -122.401965041949 | (37.7766273842858, -122.401965041949) | 14 | 2 | 9 | 28856 | 34 | ||
| 58863 | 141710 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 449 PARKER AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5997093.6346 | 2111819.5126 | 37.7784864897369 | -122.453628701289 | (37.7784864897369, -122.453628701289) | 15 | 6 | 2 | 54 | 16 | |||
| 59220 | 142862 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1203 POLK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6006813.0104 | 2115061.2984 | 37.7879400288134 | -122.420235775611 | (37.7879400288134, -122.420235775611) | 13 | 9 | 10 | 28858 | 21 | |||
| 59253 | 215159 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 18 Sargent St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 5993985.26424 | 2089201.78141 | 37.7162052463581 | -122.462740441625 | (37.7162052463581, -122.462740441625) | 9 | 8 | 6 | 64 | 24 | |||
| 59274 | 85361 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 30 Dore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/2007 12:00:00 AM | 12 | Permit Number 49638 | 6008746.14707 | 2109938.9547 | 37.7739840330773 | -122.413185094432 | (37.7739840330773, -122.413185094432) | 8 | 2 | 9 | 28853 | 34 | ||
| 59554 | 136565 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1218 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6007807.75264 | 2118217.01551 | 37.7966608503694 | -122.41701782152 | (37.7966608503694, -122.41701782152) | 5 | 1 | 10 | 28858 | 32 | |||
| 59868 | 184889 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1201 Sunset Blvd | 78 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5984679.4382 | 2106701.786 | 37.7637151826251 | -122.496195774698 | (37.7637151826251, -122.496195774698) | 1 | 8 | 3 | 56 | 35 | |||
| 60324 | 245238 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 3690 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6005055.83253 | 2105475.95262 | 37.761521833391 | -122.425632817714 | (37.761521833391, -122.425632817714) | 8 | 4 | 5 | 28859 | 19 | |||
| 60388 | 246751 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 178 Ripley St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 14 | Width 6ft | 6009186.70786 | 2099095.44284 | 37.7442349346055 | -122.410895104844 | (37.7442349346055, -122.410895104844) | 2 | 7 | 7 | 28859 | 2 | |||
| 60581 | 240981 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 333 Cumberland St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 6003429.53189 | 2104455.91516 | 37.7586290255213 | -122.431184709504 | (37.7586290255213, -122.431184709504) | 2 | 4 | 5 | 28862 | 3 | |||
| 61453 | 142883 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1001 POLK ST | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 0ft | 6006904.8517 | 2114389.9348 | 37.7861018038827 | -122.419870362438 | (37.7861018038827, -122.419870362438) | 13 | 9 | 9 | 28858 | 36 | |||
| 61496 | 245274 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 211 Montcalm St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 2ft | 6009969.56038 | 2099653.89134 | 37.7458121781913 | -122.408227536697 | (37.7458121781913, -122.408227536697) | 2 | 7 | 7 | 28859 | 2 | |||
| 61511 | 28704 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 3004 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2008 12:00:00 AM | 16 | 3x3 | 6011587.3423 | 2091581.4466 | 37.7237373984555 | -122.402066038858 | (37.7237373984555, -122.402066038858) | 10 | 3 | 7 | 309 | 28 | ||
| 61876 | 179578 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 334 Prague St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6003779.11215 | 2089222.99439 | 37.7168227028799 | -122.428889707996 | (37.7168227028799, -122.428889707996) | 9 | 7 | 6 | 28861 | 5 | |||
| 62041 | 245323 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1145 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6009489.63091 | 2102518.12221 | 37.7536498354966 | -122.410089244835 | (37.7536498354966, -122.410089244835) | 2 | 4 | 7 | 28859 | 19 | |||
| 62198 | 142865 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1000 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6006959.584 | 2114368.3394 | 37.7860455914687 | -122.419679470083 | (37.7860455914687, -122.419679470083) | 13 | 9 | 9 | 28858 | 36 | |||
| 62227 | 5732 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1706 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 6 | 6005259.19448 | 2098408.80899 | 37.7421285829626 | -122.424426782768 | (37.7421285829626, -122.424426782768) | 2 | 7 | 5 | 63 | 7 | |||
| 62516 | 179588 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 71 South Hill Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 4ft | 6002920.32073 | 2087190.64044 | 37.7111936573252 | -122.431713104392 | (37.7111936573252, -122.431713104392) | 9 | 7 | 6 | 28861 | 5 | |||
| 63202 | 245364 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 508 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002316.12303 | 2105190.5394 | 37.7605829681381 | -122.435087919184 | (37.7605829681381, -122.435087919184) | 2 | 4 | 5 | 28862 | 3 | |||
| 63418 | 43902 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1938 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2000 12:00:00 AM | 11 | Permit Number 43504 | 6013487.64027 | 2095982.13361 | 37.735926667475 | -122.395805194058 | (37.735926667475, -122.395805194058) | 10 | 3 | 8 | 58 | 1 | ||
| 64041 | 179615 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 30 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6009248.62763 | 2094075.24291 | 37.7304540239162 | -122.410326608297 | (37.7304540239162, -122.410326608297) | 9 | 3 | 7 | 309 | 28 | |||
| 64188 | 40003 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 881 Innes Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | 8 | Permit Number 41257 | 6019368.47353 | 2094309.06128 | 37.7316581360927 | -122.375356645916 | (37.7316581360927, -122.375356645916) | 10 | 3 | 8 | 58 | 1 | |
| 64373 | 103872 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1401 Polk St | 2 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006693.3 | 2115724.1 | 37.7897531721897 | -122.420697023404 | (37.7897531721897, -122.420697023404) | 13 | 9 | 10 | 28858 | 21 | ||
| 64630 | 197753 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 477 Morris St | 3 | : | Tree | Private 2 | 14 | Width 3ft | 6011938.94359 | 2110826.29932 | 37.7765992049252 | -122.402203006171 | (37.7765992049252, -122.402203006171) | 14 | 2 | 9 | 28856 | 34 | |||
| 65482 | 197777 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1555 Mariposa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6012626.2473 | 2106084.84783 | 37.7636185874431 | -122.399492447726 | (37.7636185874431, -122.399492447726) | 14 | 3 | 8 | 28856 | 29 | |||
| 66111 | 215135 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 151 Garcia Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994656.8422 | 2099309.30963 | 37.7439967122691 | -122.461151386338 | (37.7439967122691, -122.461151386338) | 1 | 8 | 4 | 59 | 40 | |||
| 66206 | 215177 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 115 Bella Vista Way | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 3ft | 5998455.14668 | 2097038.32931 | 37.7379789995273 | -122.44785430284 | (37.7379789995273, -122.44785430284) | 9 | 7 | 4 | 59 | 40 | |||
| 68335 | 245338 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 86 Milton St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 3ft | 6003724.51998 | 2095305.98199 | 37.7335221447376 | -122.429511974121 | (37.7335221447376, -122.429511974121) | 2 | 7 | 5 | 28861 | 25 | |||
| 68536 | 197793 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 66 Ceres St | 1 | : | Tree | Private 2 | 16 | Width 3ft | 6013832.07065 | 2093815.87712 | 37.7299977259065 | -122.394462716674 | (37.7299977259065, -122.394462716674) | 10 | 3 | 8 | 58 | 1 | |||
| 69360 | 254892 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 4199 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6003642.63298 | 2094097.24722 | 37.7301985948914 | -122.429708899543 | (37.7301985948914, -122.429708899543) | 9 | 7 | 6 | 28861 | 5 | ||||
| 69487 | 215176 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 115 Bella Vista Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 5998441.46818 | 2097042.42128 | 37.7379894532555 | -122.447901890481 | (37.7379894532555, -122.447901890481) | 9 | 7 | 4 | 59 | 40 | |||
| 69879 | 136542 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1234 Polk St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 4ft | 6006831.91851 | 2115273.77419 | 37.7885245003562 | -122.4201854424 | (37.7885245003562, -122.4201854424) | 13 | 9 | 10 | 28858 | 21 | |||
| 70125 | 136575 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 145 Jefferson St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6008547.84348 | 2122425.87999 | 37.8082589427652 | -122.414754947386 | (37.8082589427652, -122.414754947386) | 3 | 1 | 10 | 308 | 23 | |||
| 70130 | 241003 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 81 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6004313.09984 | 2097732.41335 | 37.7402178833574 | -122.427649901744 | (37.7402178833574, -122.427649901744) | 2 | 7 | 5 | 63 | 7 | |||
| 70601 | 240996 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 48 Landers St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6004451.21845 | 2107497.54881 | 37.7670384699769 | -122.42786798372 | (37.7670384699769, -122.42786798372) | 8 | 4 | 5 | 28862 | 3 | |||
| 70636 | 33147 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2301 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | 1 | Permit Number 37372 | 5987301.0757 | 2099570.9968 | 37.7442891825609 | -122.486604840877 | (37.7442891825609, -122.486604840877) | 1 | 8 | 3 | 29491 | 35 | |
| 70738 | 197763 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1405 Minnesota St | 1 | Back Yard : Yard | Tree | Private 2 | 3 | 6015410.29997 | 2101920.42662 | 37.7523387624307 | -122.389572339186 | (37.7523387624307, -122.389572339186) | 10 | 3 | 8 | 28856 | 1 | ||||
| 70886 | 246457 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 405 Duncan St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 4ft | 6003845.17231 | 2099806.01088 | 37.7458850250928 | -122.429415642312 | (37.7458850250928, -122.429415642312) | 2 | 7 | 5 | 63 | 22 | |||
| 71102 | 179603 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 901 Delano Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 5998658.1578 | 2089592.85208 | 37.7175470636356 | -122.446616859994 | (37.7175470636356, -122.446616859994) | 9 | 7 | 6 | 28861 | 25 | |||
| 71261 | 249429 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 601 Eddy St | 2 | : | Tree | Private 2 | 11 | Width 4ft | 6007371.4377 | 2113305.12395 | 37.7831494521267 | -122.418179157466 | (37.7831494521267, -122.418179157466) | 7 | 9 | 9 | 28852 | 36 | |||
| 72093 | 96663 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1400X Mendell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6014978.6151 | 2095394.6292 | 37.7343963311622 | -122.390609217071 | (37.7343963311622, -122.390609217071) | 10 | 3 | 8 | 58 | 1 | |||
| 72361 | 215174 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 120 Bella Vista Way | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 5998431.33624 | 2097088.3182 | 37.7381148960726 | -122.447940224956 | (37.7381148960726, -122.447940224956) | 9 | 7 | 4 | 59 | 40 | |||
| 72707 | 20138 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1000 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6002950.7346 | 2111726.0933 | 37.7785640114636 | -122.433360117142 | (37.7785640114636, -122.433360117142) | 15 | 9 | 11 | 29490 | 41 | |||
| 72962 | 245352 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 87 Ford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6003112.84952 | 2105613.26721 | 37.7617888852692 | -122.432362599251 | (37.7617888852692, -122.432362599251) | 15 | 4 | 5 | 28862 | 3 | |||
| 74081 | 240978 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 352 Cumberland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6003317.42286 | 2104496.26502 | 37.7587334629054 | -122.431575313857 | (37.7587334629054, -122.431575313857) | 2 | 4 | 5 | 28862 | 3 | |||
| 74104 | 40001 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 881 Innes Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | 12 | Permit Number 41257 | 6019355.96693 | 2094318.55144 | 37.7316835059849 | -122.375400541805 | (37.7316835059849, -122.375400541805) | 10 | 3 | 8 | 58 | 1 | |
| 74181 | 40602 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1745 Alameda St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/2003 12:00:00 AM | 15 | Permit Number 47084 | 6011826.18199 | 2107919.61674 | 37.7686118231125 | -122.40238865592 | (37.7686118231125, -122.40238865592) | 8 | 2 | 8 | 28853 | 20 | |
| 74461 | 245302 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 379 Laidley St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003842.11696 | 2096596.26066 | 37.7370716150486 | -122.429197378665 | (37.7370716150486, -122.429197378665) | 2 | 7 | 5 | 63 | 7 | |||
| 74823 | 245345 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 466 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6003300.1227 | 2103327.97061 | 37.7555246242634 | -122.431551739942 | (37.7555246242634, -122.431551739942) | 2 | 4 | 5 | 28862 | 22 | |||
| 74830 | 245337 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 17 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6005775.45761 | 2099622.83441 | 37.7454911615972 | -122.422727959852 | (37.7454911615972, -122.422727959852) | 2 | 7 | 5 | 28859 | 22 | |||
| 74885 | 103854 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1507 Polk St | 3 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006614.6 | 2116113.6 | 37.7908182067111 | -122.420996984718 | (37.7908182067111, -122.420996984718) | 13 | 9 | 10 | 28858 | 21 | ||
| 74963 | 240980 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 339 Cumberland St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6003419.01975 | 2104457.1157 | 37.7586317262048 | -122.431221150932 | (37.7586317262048, -122.431221150932) | 2 | 4 | 5 | 28862 | 3 | |||
| 75608 | 241001 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 244 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6004097.47892 | 2108736.71295 | 37.7704208966318 | -122.429179880544 | (37.7704208966318, -122.429179880544) | 7 | 9 | 11 | 29492 | 10 | |||
| 75783 | 14834 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1288 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6003007.4145 | 2111705.9811 | 37.7785120037891 | -122.433162602474 | (37.7785120037891, -122.433162602474) | 15 | 9 | 11 | 29490 | 41 | |||
| 76130 | 245281 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 3057 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008365.23947 | 2106190.88278 | 37.7636713111025 | -122.414237487376 | (37.7636713111025, -122.414237487376) | 8 | 4 | 7 | 28859 | 19 | |||
| 76285 | 240860 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 99 Albion St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6005814.59305 | 2106796.61369 | 37.7651909018693 | -122.423102448325 | (37.7651909018693, -122.423102448325) | 8 | 4 | 5 | 28853 | 19 | |||
| 76442 | 240866 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1706 Dolores St | 14 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 6ft | 6005278.92879 | 2098349.0004 | 37.7419654765287 | -122.424354294708 | (37.7419654765287, -122.424354294708) | 2 | 7 | 5 | 63 | 7 | |||
| 76791 | 240868 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1720 Dolores St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6005263.31949 | 2098343.70068 | 37.7419500432577 | -122.424407889836 | (37.7419500432577, -122.424407889836) | 2 | 7 | 5 | 63 | 7 | |||
| 77264 | 240970 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 4210 21st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 6001417.45353 | 2103381.77195 | 37.7555654615786 | -122.438066433315 | (37.7555654615786, -122.438066433315) | 2 | 4 | 5 | 28862 | 3 | |||
| 78069 | 245349 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 100 Jersey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004386.74931 | 2101635.76059 | 37.7509397410815 | -122.427673286801 | (37.7509397410815, -122.427673286801) | 2 | 4 | 5 | 28862 | 22 | |||
| 78070 | 215167 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 616 Los Palmos Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5996095.52716 | 2095987.52181 | 37.734958585052 | -122.455936678249 | (37.734958585052, -122.455936678249) | 9 | 7 | 4 | 59 | 40 | |||
| 78679 | 197783 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1695 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6012618.01326 | 2105616.47326 | 37.7623320757988 | -122.399488041942 | (37.7623320757988, -122.399488041942) | 10 | 3 | 8 | 28856 | 29 | |||
| 78817 | 179571 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 190 Foote Ave | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 8ft | 5998627.15829 | 2088384.36554 | 37.7142270651918 | -122.446637110039 | (37.7142270651918, -122.446637110039) | 9 | 7 | 6 | 28861 | 25 | |||
| 78859 | 53588 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1409 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/1969 12:00:00 AM | 9 | Permit Number 6517 | 6006718.9791 | 2115736.7746 | 37.7897894207569 | -122.420609076139 | (37.7897894207569, -122.420609076139) | 13 | 9 | 10 | 28858 | 21 | ||
| 78863 | 179572 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 205 Seneca Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 6ft | 5999817.08218 | 2090385.88306 | 37.7197906778859 | -122.442667909917 | (37.7197906778859, -122.442667909917) | 9 | 7 | 6 | 28861 | 25 | |||
| 79080 | 64359 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 369 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1988 12:00:00 AM | 11 | Permit Number 25197 | 6011195.22959 | 2119324.38957 | 37.7998914022152 | -122.405374352958 | (37.7998914022152, -122.405374352958) | 3 | 1 | 10 | 308 | 23 | |
| 79374 | 52363 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1030@ CEDAR Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2005 12:00:00 AM | 11 | Permit Number 48499 | 6006937.73357 | 2114525.88261 | 37.7864769356114 | -122.41976624951 | (37.7864769356114, -122.41976624951) | 13 | 9 | 9 | 28858 | 36 | |
| 79577 | 87802 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1955 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 10 | 3x3 | Permit Number 50568 | 6004850.71473 | 2117064.80885 | 37.7933303991208 | -122.427167730233 | (37.7933303991208, -122.427167730233) | 13 | 9 | 1 | 28858 | 27 | |
| 79604 | 179610 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 801 Excelsior Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 5ft | 6004355.20316 | 2091529.34744 | 37.723188035096 | -122.427062621069 | (37.723188035096, -122.427062621069) | 9 | 7 | 6 | 28861 | 5 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );