Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2322 | 2322 | 103821 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1032 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006936.4893 | 2114526.0013 | 37.786477191411294 | -122.419770562808 | (37.7864771914113, -122.419770562808) | ||
| 3520 | 3520 | 103828 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 999 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006926.6281 | 2114230.9021 | 37.785666365842296 | -122.419783733241 | (37.7856663658423, -122.419783733241) | ||
| 4713 | 4713 | 103826 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1000 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006957.18445 | 2114384.03926 | 37.786088564267395 | -122.41968888625401 | (37.7860885642674, -122.419688886254) | ||
| 5179 | 5179 | 253770 | Significant Tree 6 | Syagrus romanzoffianum :: Queen Palm 142 | 234 Carl St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | Permit Number 770677 | 5997066.0 | 2107091.0 | 37.7655016335596 | -122.453382820195 | (37.7655016335596, -122.453382820195) | |||
| 5370 | 5370 | 103797 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1201 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006813.15784 | 2115040.73173 | 37.78788356611221 | -122.42023380524599 | (37.7878835661122, -122.420233805246) | ||
| 6052 | 6052 | 103780 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1245 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006784.96564 | 2115238.8671 | 37.7884260084052 | -122.420345413822 | (37.7884260084052, -122.420345413822) | ||
| 6196 | 6196 | 103853 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1507 Polk St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006668.0099 | 2116095.4388 | 37.790771351094605 | -122.420810898748 | (37.7907713510946, -122.420810898748) | ||
| 6945 | 6945 | 103827 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1000 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006958.82902 | 2114372.08795 | 37.7860558415396 | -122.419682348183 | (37.7860558415396, -122.419682348183) | ||
| 6969 | 6969 | 103818 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1100 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006909.68769 | 2114740.53907 | 37.787064749582 | -122.4198785191 | (37.787064749582, -122.4198785191) | ||
| 7052 | 7052 | 103779 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1245 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006784.20926 | 2115254.40862 | 37.7884686389629 | -122.42034913431499 | (37.7884686389629, -122.420349134315) | ||
| 7313 | 7313 | 103796 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1201 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006810.240669999 | 2115055.78241 | 37.7879247271976 | -122.420244966752 | (37.7879247271976, -122.420244966752) | ||
| 7733 | 7733 | 103820 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1033 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006885.572000001 | 2114524.1828 | 37.786469329784204 | -122.41994659523199 | (37.7864693297842, -122.419946595232) | ||
| 7969 | 7969 | 114847 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 2200 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6002442.62774 | 2118155.32308 | 37.7961881963905 | -122.435577919296 | (37.7961881963905, -122.435577919296) | |||
| 8870 | 8870 | 103858 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1475 Polk St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006691.391 | 2115929.0779 | 37.790315883136 | -122.42071818597401 | (37.790315883136, -122.420718185974) | ||
| 8938 | 8938 | 103857 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1475 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006690.1878 | 2115953.9432 | 37.7903840892726 | -122.42072411493 | (37.7903840892726, -122.42072411493) | ||
| 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) |
| 10414 | 10414 | 28700 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 2593 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2008 12:00:00 AM | 16 | 3x3 | 6011048.2422 | 2093513.6383 | 37.729012691472896 | -122.40406554132299 | (37.7290126914729, -122.404065541323) | ||
| 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) | ||
| 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) |
| 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) | ||
| 13196 | 13196 | 24855 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 2450 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/1996 12:00:00 AM | 15 | 3x3 | 6010769.7667 | 2094249.4065 | 37.731017393341 | -122.40508004410401 | (37.731017393341, -122.405080044104) | ||
| 13435 | 13435 | 50002 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1101X 19th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2003 12:00:00 AM | 12 | 3x3 | Permit Number 46740 | 6014257.86563 | 2105244.06654 | 37.761400794530296 | -122.393790293612 | (37.7614007945303, -122.393790293612) |
| 14419 | 14419 | 96663 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1400X Mendell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6014978.6151 | 2095394.6292 | 37.7343963311622 | -122.390609217071 | (37.7343963311622, -122.390609217071) | |||
| 14509 | 14509 | 49999 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1101X 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2003 12:00:00 AM | 12 | 3x3 | Permit Number 46740 | 6014232.027000001 | 2105242.2535599996 | 37.76139438056129 | -122.39387953243299 | (37.7613943805613, -122.393879532433) |
| 14671 | 14671 | 50007 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 400 Pennsylvania Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2003 12:00:00 AM | 12 | 3x3 | Permit Number 46740 | 6014312.7489 | 2105179.47261 | 37.7612264834299 | -122.393595952812 | (37.7612264834299, -122.393595952812) |
| 14782 | 14782 | 50009 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 400 Pennsylvania Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2003 12:00:00 AM | 12 | 3x3 | Permit Number 46740 | 6014312.76129 | 2105171.60414 | 37.7612048790107 | -122.393595359241 | (37.7612048790107, -122.393595359241) |
| 14993 | 14993 | 49997 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 400 Pennsylvania Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2003 12:00:00 AM | 12 | 3x3 | Permit Number 46740 | 6014312.2211 | 2105187.35151 | 37.7612480878485 | -122.393598329713 | (37.7612480878485, -122.393598329713) |
| 15032 | 15032 | 51370 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 39 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2016 12:00:00 AM | 3 | 3x3 | Permit Number 47705 | 6013932.28471 | 2095479.4437400002 | 37.7345711103726 | -122.394232686294 | (37.7345711103726, -122.394232686294) |
| 15349 | 15349 | 50008 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 400 Pennsylvania Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2003 12:00:00 AM | 12 | 3x3 | Permit Number 46740 | 6014311.55635 | 2105196.94353 | 37.7612743885122 | -122.39360130017401 | (37.7612743885122, -122.393601300174) |
| 15521 | 15521 | 96662 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1400X Mendell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6015000.5996 | 2095419.9114 | 37.734466970583206 | -122.390534974863 | (37.7344669705832, -122.390534974863) | |||
| 16212 | 16212 | 96661 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1400X Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/26/2012 12:00:00 AM | 6 | 3x3 | 6015012.1415 | 2095435.3006 | 37.7345098664919 | -122.390496145326 | (37.7345098664919, -122.390496145326) | ||
| 16715 | 16715 | 104026 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 782 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6012702.6895 | 2103864.8187599997 | 37.7575271374861 | -122.399072220626 | (37.7575271374861, -122.399072220626) | |||
| 17184 | 17184 | 28714 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 495 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/07/2004 12:00:00 AM | 3 | 3x3 | Permit Number 772904 | 6002370.93683 | 2105344.55131 | 37.7610089599056 | -122.434909357897 | (37.7610089599056, -122.434909357897) | |
| 19464 | 19464 | 26857 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 586 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/1998 12:00:00 AM | 2 | 3x3 | Permit Number 772904 | 6002335.9416 | 2104815.18897 | 37.7595534719369 | -122.43499253079901 | (37.7595534719369, -122.434992530799) | |
| 20387 | 20387 | 121368 | Significant Tree 6 | Syagrus romanzoffianum :: Queen Palm 142 | 245 Mallorca Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Permit Number 778992 | 6001431.0 | 2120732.0 | 37.8032055622797 | -122.439263127997 | (37.8032055622797, -122.439263127997) | ||
| 21058 | 21058 | 26183 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 490 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | Permit Number 772904 | 6002306.71976 | 2105368.32437 | 37.7610705886585 | -122.435133156875 | (37.7610705886585, -122.435133156875) | ||
| 37006 | 37006 | 113232 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1001 Polk St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | 3x3 | 6006901.77113 | 2114384.86271 | 37.7860877036192 | -122.419880660363 | (37.7860877036192, -122.419880660363) | |||
| 47867 | 47867 | 67482 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1698 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/1992 12:00:00 AM | 3 | 3x3 | Permit Number 51741 | 6001051.5462 | 2111435.0038 | 37.7776568254321 | -122.439909243136 | (37.7776568254321, -122.439909243136) | |
| 67994 | 67994 | 83577 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 124 Peru Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 13 | 3x3 | Permit Number 52313 | 6003965.91077 | 2093279.8075700002 | 37.7279723888056 | -122.42853304139 | (37.7279723888056, -122.42853304139) | |
| 73092 | 73092 | 117576 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 100 Waverly Pl | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | 3x3 | 6010746.80079 | 2117296.5570099996 | 37.794298384417296 | -122.40678310046499 | (37.7942983844173, -122.406783100465) | |||
| 75155 | 75155 | 83343 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1327 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50763 | 6011023.37395305 | 2119422.18641329 | 37.8001503184077 | -122.405975934235 | (37.8001503184077, -122.405975934235) | ||
| 77346 | 77346 | 36048 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 3057 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/1998 12:00:00 AM | 3x3 | Permit Number 49634 | 6008358.98035191 | 2106192.95330852 | 37.763676644711396 | -122.414259282291 | (37.7636766447114, -122.414259282291) | ||
| 78041 | 78041 | 86802 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 3057 17th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/2007 12:00:00 AM | 3x3 | Permit Number 49634 | 6008359.0 | 2106197.0 | 37.7636877570953 | -122.414259500664 | (37.7636877570953, -122.414259500664) | |||
| 81462 | 81462 | 47535 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1242 Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51815 | 6004449.94033609 | 2101659.83008367 | 37.7510094045374 | -122.427456480608 | (37.7510094045374, -122.427456480608) | ||
| 82525 | 82525 | 87854 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 330 Prospect Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50765 | 6006363.5 | 2097928.1 | 37.7408709626282 | -122.42057431814 | (37.7408709626282, -122.42057431814) | ||
| 83298 | 83298 | 36047 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 3057 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/1998 12:00:00 AM | 3x3 | Permit Number 49634 | 6008358.98035191 | 2106192.95330852 | 37.763676644711396 | -122.414259282291 | (37.7636766447114, -122.414259282291) | ||
| 83672 | 83672 | 93672 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 80 Missouri St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 53291 | 6013405.0 | 2106710.0 | 37.7653784929972 | -122.39684279882299 | (37.7653784929972, -122.396842798823) | |||
| 83915 | 83915 | 103772 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1288 Polk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006856.2 | 2115250.5 | 37.7884619632914 | -122.420099779635 | (37.7884619632914, -122.420099779635) | ||
| 84119 | 84119 | 108284 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1 HENRY ADAMS ST | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 16 | 3x3 | 6011517.4 | 2108140.5 | 37.769201076268395 | -122.40347225564399 | (37.7692010762684, -122.403472255644) | |||
| 84192 | 84192 | 113229 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1150 Polk St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6006889.32859586 | 2114873.18984569 | 37.7874278290173 | -122.419958374025 | (37.7874278290173, -122.419958374025) | ||||
| 85533 | 85533 | 103798 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1157 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006858.38304 | 2114906.78358 | 37.787518325661296 | -122.42006782447201 | (37.7875183256613, -122.420067824472) | ||
| 86304 | 86304 | 103872 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1401 Polk St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006693.3 | 2115724.1 | 37.789753172189705 | -122.420697023404 | (37.7897531721897, -122.420697023404) | ||
| 86655 | 86655 | 103856 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1489 Polk St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006726.686980001 | 2115849.48669 | 37.790099334646705 | -122.42059041188101 | (37.7900993346467, -122.420590411881) | ||
| 86770 | 86770 | 104335 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1X Beaver St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6002844.0 | 2106791.0 | 37.765007405875295 | -122.43337660406901 | (37.7650074058753, -122.433376604069) | ||||
| 86873 | 86873 | 103854 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1507 Polk St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006614.6 | 2116113.6 | 37.7908182067111 | -122.420996984718 | (37.7908182067111, -122.420996984718) | ||
| 90590 | 90590 | 99310 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 601 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007548.2 | 2113343.2 | 37.7832639475046 | -122.417570329335 | (37.7832639475046, -122.417570329335) | ||||
| 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) | ||
| 94879 | 94879 | 112395 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 574 VALLEY ST | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 32 | 3x3 | 6002248.0 | 2099192.0 | 37.7441085392299 | -122.434894531673 | (37.7441085392299, -122.434894531673) | |||
| 96093 | 96093 | 98227 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 207 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Planted without permit; 2' away from sewer line. | 6007132.0 | 2097003.0 | 37.7383741239705 | -122.41785156508499 | (37.7383741239705, -122.417851565085) | |||
| 96544 | 96544 | 103840 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1546 Polk St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006695.0 | 2116184.4 | 37.7910171377023 | -122.420723832321 | (37.7910171377023, -122.420723832321) | ||
| 96602 | 96602 | 103819 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1100 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006925.9 | 2114751.5 | 37.787095758933894 | -122.41982320605 | (37.7870957589339, -122.41982320605) | ||
| 96932 | 96932 | 104334 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1X Beaver St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6002844.0 | 2106791.0 | 37.765007405875295 | -122.43337660406901 | (37.7650074058753, -122.433376604069) | ||||
| 97017 | 97017 | 83705 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 358 San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50603 | 6006700.55316292 | 2104029.56637849 | 37.7576431915581 | -122.41984175716298 | (37.7576431915581, -122.419841757163) | ||
| 100498 | 100498 | 100791 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1221 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/10/2012 12:00:00 AM | 2 | 3x3 | Permit Number 769131 | 6009961.0 | 2109679.0 | 37.773338385175 | -122.408964349313 | (37.773338385175, -122.408964349313) | |
| 101707 | 101707 | 58887 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 970 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50451 | 6003109.65492005 | 2102587.69576047 | 37.753481207856204 | -122.43215757272301 | (37.7534812078562, -122.432157572723) | ||
| 102834 | 102834 | 69866 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 42 Harbor Rd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52372 | 6018792.25966014 | 2094248.90737336 | 37.7314612388187 | -122.37734458188801 | (37.7314612388187, -122.377344581888) | ||
| 103261 | 103261 | 98582 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1X Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/29/2012 12:00:00 AM | 12 | 3x3 | Permit Number 768693 | 5995844.3953599995 | 2114458.7379099997 | 37.7856614051555 | -122.458141326017 | (37.7856614051555, -122.458141326017) | |
| 104033 | 104033 | 64083 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 180 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/03/1988 12:00:00 AM | 3x3 | Permit Number 25061 | 6004796.0 | 2098747.0 | 37.74303101067029 | -122.426052434635 | (37.7430310106703, -122.426052434635) | |
| 104116 | 104116 | 59216 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 42 Landers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/1983 12:00:00 AM | 16 | 3x3 | Permit Number 20726 | 6004445.43179676 | 2107524.22878238 | 37.7671113993979 | -122.42788990017799 | (37.7671113993979, -122.427889900178) | |
| 106075 | 106075 | 45711 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1202X Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2004 12:00:00 AM | 14 | 3x3 | Permit Number 47519 | 6008066.0 | 2116562.0 | 37.79213111040679 | -122.416006962529 | (37.7921311104068, -122.416006962529) | |
| 106282 | 106282 | 103871 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1401 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006693.3 | 2115724.1 | 37.789753172189705 | -122.420697023404 | (37.7897531721897, -122.420697023404) | ||
| 107241 | 107241 | 103870 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1406 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006667.3 | 2115718.8 | 37.789737154295395 | -122.420786604632 | (37.7897371542954, -122.420786604632) | ||
| 108247 | 108247 | 104848 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 395X Laidley St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6003932.8304 | 2096688.9511799999 | 37.7373312570435 | -122.428890347629 | (37.7373312570435, -122.428890347629) | |||
| 109303 | 109303 | 93030 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 45 Jersey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | undocumented | 6004830.0 | 2101620.0 | 37.7509215289079 | -122.42613936044901 | (37.7509215289079, -122.426139360449) | ||
| 110547 | 110547 | 103812 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1101 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006831.1 | 2114737.7 | 37.787052526526 | -122.42015021403401 | (37.787052526526, -122.420150214034) | ||
| 112635 | 112635 | 64644 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 365 Gaven St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2009 12:00:00 AM | 12 | 3x3 | Permit Number 52474 | 6008639.47010763 | 2094730.52839265 | 37.7322191308306 | -122.412478862636 | (37.7322191308306, -122.412478862636) | |
| 112865 | 112865 | 112455 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 4299X 17TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000874.0 | 2105811.0 | 37.7622046070719 | -122.44012004716801 | (37.7622046070719, -122.440120047168) | ||||
| 113333 | 113333 | 103770 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1301 Polk St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006734.9 | 2115426.6 | 37.788938655258704 | -122.42053196465099 | (37.7889386552587, -122.420531964651) | ||
| 113799 | 113799 | 103807 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1145 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006819.8 | 2114898.5 | 37.7874934070669 | -122.42020072617599 | (37.7874934070669, -122.420200726176) | ||
| 115173 | 115173 | 103799 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1157 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006858.38304 | 2114906.78358 | 37.787518325661296 | -122.42006782447201 | (37.7875183256613, -122.420067824472) | ||
| 116016 | 116016 | 47534 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1242 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51815 | 6004449.94033609 | 2101659.83008367 | 37.7510094045374 | -122.427456480608 | (37.7510094045374, -122.427456480608) | ||
| 116023 | 116023 | 103842 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1545 Polk St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006617.6 | 2116265.9 | 37.791236553790895 | -122.420997422968 | (37.7912365537909, -122.420997422968) | ||
| 118049 | 118049 | 103813 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1101 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006831.1 | 2114737.7 | 37.787052526526 | -122.42015021403401 | (37.787052526526, -122.420150214034) | ||
| 118652 | 118652 | 104333 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1X Beaver St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6002844.0 | 2106791.0 | 37.765007405875295 | -122.43337660406901 | (37.7650074058753, -122.433376604069) | ||||
| 119348 | 119348 | 120539 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 32 Landers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004448.25188 | 2107581.7846 | 37.767269593348 | -122.427884247566 | (37.767269593348, -122.427884247566) | ||||
| 120074 | 120074 | 100792 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1221 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/10/2012 12:00:00 AM | 2 | 3x3 | Permit Number 769131 | 6009961.0 | 2109679.0 | 37.773338385175 | -122.408964349313 | (37.773338385175, -122.408964349313) | |
| 120477 | 120477 | 103808 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1145 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006819.8 | 2114898.5 | 37.7874934070669 | -122.42020072617599 | (37.7874934070669, -122.420200726176) | ||
| 121589 | 121589 | 86801 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 3057 17th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/2007 12:00:00 AM | 3x3 | Permit Number 49634 | 6008359.0 | 2106197.0 | 37.7636877570953 | -122.414259500664 | (37.7636877570953, -122.414259500664) | |||
| 122460 | 122460 | 33564 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 330 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50765 | 6006381.57970099 | 2097942.21736521 | 37.740910744657704 | -122.42051280700399 | (37.7409107446577, -122.420512807004) | ||
| 125049 | 125049 | 103822 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1030 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006951.7 | 2114566.7 | 37.7865897969129 | -122.419720826278 | (37.7865897969129, -122.419720826278) | ||
| 126066 | 126066 | 103841 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1545 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006617.6 | 2116265.9 | 37.791236553790895 | -122.420997422968 | (37.7912365537909, -122.420997422968) | ||
| 129036 | 129036 | 109139 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 741 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773383 | 5985366.92656 | 2110801.55292 | 37.7750122304906 | -122.494120186238 | (37.7750122304906, -122.494120186238) |
| 129225 | 129225 | 103855 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1489 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006726.686980001 | 2115849.48669 | 37.790099334646705 | -122.42059041188101 | (37.7900993346467, -122.420590411881) | ||
| 136291 | 136291 | 89357 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 228 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/2008 12:00:00 AM | 15 | 3x3 | Permit Number 51938 | 6013147.53737 | 2105984.72439 | 37.7633727127903 | -122.397682433524 | (37.7633727127903, -122.397682433524) | |
| 138274 | 138274 | 103769 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1301 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006734.9 | 2115426.6 | 37.788938655258704 | -122.42053196465099 | (37.7889386552587, -122.420531964651) | ||
| 138352 | 138352 | 99311 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 601 Eddy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007548.2 | 2113343.2 | 37.7832639475046 | -122.417570329335 | (37.7832639475046, -122.417570329335) | ||||
| 138753 | 138753 | 95627 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 3271# A 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767394 | 6008383.0 | 2104448.0 | 37.7588867529802 | -122.414052751679 | (37.7588867529802, -122.414052751679) | |
| 138787 | 138787 | 113230 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1150 Polk St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6006889.32859586 | 2114873.18984569 | 37.7874278290173 | -122.419958374025 | (37.7874278290173, -122.419958374025) | ||||
| 139723 | 139723 | 45710 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1202X Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2004 12:00:00 AM | 14 | 3x3 | Permit Number 47519 | 6008066.0 | 2116562.0 | 37.79213111040679 | -122.416006962529 | (37.7921311104068, -122.416006962529) | |
| 140907 | 140907 | 98583 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 3X Palm Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/29/2012 12:00:00 AM | 12 | 3x3 | Permit Number 768693 | 5995785.9 | 2114444.5 | 37.7856189504109 | -122.458342670912 | (37.7856189504109, -122.458342670912) |
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");