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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1317 | 1317 | 14834 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1288 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003007.4145 | 2111705.9811 | 37.7785120037891 | -122.433162602474 | (37.7785120037891, -122.433162602474) | |||
| 1881 | 1881 | 199699 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 2098 Jennings St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6015522.8982 | 2092787.4061 | 37.727267599979704 | -122.388545507017 | (37.7272675999797, -122.388545507017) | |||
| 2226 | 2226 | 61613 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1546 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/1995 12:00:00 AM | 17 | Permit Number 21590 | 6006691.8914 | 2116275.8765 | 37.7912681342545 | -122.42074108486 | (37.7912681342545, -122.42074108486) | |
| 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) | ||
| 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) | |
| 3057 | 3057 | 49572 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1250 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2003 12:00:00 AM | 7 | Permit Number 46457 | 6008112.0 | 2116793.0 | 37.7927679657247 | -122.41586416618999 | (37.7927679657247, -122.41586416619) | ||
| 3088 | 3088 | 245344 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1005 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2002 12:00:00 AM | 16 | Width 3ft | Permit Number 45840 | 6003175.28861 | 2102361.95423 | 37.752865096051394 | -122.431914479684 | (37.7528650960514, -122.431914479684) | |
| 3269 | 3269 | 253386 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 726 El Camino Del Mar | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 5986306.0 | 2114851.0 | 37.7861857583172 | -122.491169854158 | (37.7861857583172, -122.491169854158) | |||||
| 3272 | 3272 | 253387 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 726 El Camino Del Mar | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 5986306.0 | 2114851.0 | 37.7861857583172 | -122.491169854158 | (37.7861857583172, -122.491169854158) | |||||
| 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) | ||
| 4182 | 4182 | 253620 | Significant Tree 6 | Syagrus romanzoffianum :: Queen Palm 142 | 1120 South Van Ness Ave | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | Width 3ft | 6007603.98274 | 2103104.1444200003 | 37.755153048679205 | -122.41665176419201 | (37.7551530486792, -122.416651764192) | ||||
| 4580 | 4580 | 142832 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1553 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 9 | Width 0ft | 6006643.2439 | 2116275.8765 | 37.791265392276 | -122.420909404242 | (37.791265392276, -122.420909404242) | ||
| 4604 | 4604 | 142833 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1549 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 9 | Width 0ft | 6006645.4552 | 2116252.8795 | 37.7912023728705 | -122.42090011974501 | (37.7912023728705, -122.420900119745) | ||
| 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) | ||
| 6353 | 6353 | 20138 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1000 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002950.7346 | 2111726.0933 | 37.7785640114636 | -122.43336011714199 | (37.7785640114636, -122.433360117142) | |||
| 6554 | 6554 | 20146 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1006 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002941.3315 | 2111813.3334 | 37.7788030175273 | -122.43339888180901 | (37.7788030175273, -122.433398881809) | |||
| 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) | ||
| 7183 | 7183 | 20140 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1000 Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | Permit Number 770990 | 6002946.5554 | 2111769.9745 | 37.7786842611853 | -122.433377711101 | (37.7786842611853, -122.433377711101) | ||
| 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) | ||
| 7593 | 7593 | 20139 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1000 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002949.1674 | 2111752.2131 | 37.7786356410017 | -122.433367405651 | (37.7786356410017, -122.433367405651) | |||
| 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) | ||
| 7959 | 7959 | 14833 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1288 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003019.4296 | 2111708.0707 | 37.7785184228745 | -122.43312118705799 | (37.7785184228745, -122.433121187058) | |||
| 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) | |||
| 8779 | 8779 | 20145 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1006 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002942.8987 | 2111794.0047 | 37.778750034657605 | -122.433392078669 | (37.7787500346576, -122.433392078669) | |||
| 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) | ||
| 9917 | 9917 | 63522 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 812 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/10/1987 12:00:00 AM | Permit Number 24132 | 6009881.10701644 | 2104476.66274978 | 37.759049483001 | -122.40887359889999 | (37.759049483001, -122.4088735989) | ||
| 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) | ||
| 10832 | 10832 | 87534 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 2515 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 6010931.8007 | 2093898.1841 | 37.7300620671282 | -122.404495148402 | (37.7300620671282, -122.404495148402) | ||||
| 11194 | 11194 | 15688 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 4199 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/1995 12:00:00 AM | 3 | 3X3 | 6003628.481269999 | 2094078.5751200002 | 37.7301465241442 | -122.429756492581 | (37.7301465241442, -122.429756492581) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 12135 | 12135 | 15689 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 4199 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/1995 12:00:00 AM | 3 | 3X3 | 6003642.63298 | 2094097.24722 | 37.7301985948914 | -122.429708899543 | (37.7301985948914, -122.429708899543) | ||
| 12323 | 12323 | 87525 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 2600 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4x8 | 6011029.3764 | 2093400.1095 | 37.72869991097971 | -122.404122775515 | (37.7286999109797, -122.404122775515) | |||
| 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) | ||
| 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) |
| 12544 | 12544 | 24857 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 2500 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/1996 12:00:00 AM | 20 | 3X3 | 6010898.5282 | 2093826.1579 | 37.7298624387628 | -122.404605107856 | (37.7298624387628, -122.404605107856) | ||
| 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) | ||
| 12960 | 12960 | 87419 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 2488 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 4x8 | 6010849.4762 | 2093988.7302 | 37.730306086621496 | -122.40478612814199 | (37.7303060866215, -122.404786128142) | |||
| 13030 | 13030 | 24858 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 2500 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/16/2001 12:00:00 AM | 20 | 3X4 | 6010904.8349 | 2093807.9386 | 37.7298127648541 | -122.404582022711 | (37.7298127648541, -122.404582022711) | ||
| 13059 | 13059 | 87418 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 2488 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 4x8 | 6010844.0455 | 2094008.351 | 37.730359657675 | -122.40480628373899 | (37.730359657675, -122.404806283739) | |||
| 13074 | 13074 | 24882 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 2350 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 2X2 | 6010484.31378 | 2095044.6297900002 | 37.733184946628 | -122.406122911744 | (37.733184946628, -122.406122911744) | |||
| 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) | |||
| 13150 | 13150 | 87541 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 2603 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 6011083.9894 | 2093392.2028 | 37.728681252168705 | -122.40393341780899 | (37.7286812521687, -122.403933417809) | ||||
| 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) |
| 13936 | 13936 | 73457 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 33 Rausch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2015 12:00:00 AM | 3 | Permit Number 774688 | 6009719.278080001 | 2110896.03825 | 37.7766665443529 | -122.40988643061 | (37.7766665443529, -122.40988643061) | ||
| 14178 | 14178 | 70674 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 33 Rausch St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2015 12:00:00 AM | 3 | Permit Number 774688 | 6009713.37345 | 2110904.2206099997 | 37.7766886802763 | -122.409907434288 | (37.7766886802763, -122.409907434288) | ||
| 14370 | 14370 | 75081 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 172 Russ St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/09/1995 12:00:00 AM | 4 | 8x9 | 6010488.28034 | 2111342.3731400003 | 37.7779351433246 | -122.407257684389 | (37.7779351433246, -122.407257684389) | ||
| 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) | |||
| 14472 | 14472 | 12222 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1543 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/1996 12:00:00 AM | 6 | 3X3 | 6015840.7459 | 2095893.0455 | 37.7358126735457 | -122.387663285334 | (37.7358126735457, -122.387663285334) | ||
| 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) | |||
| 17079 | 17079 | 4224 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 3978 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/1995 12:00:00 AM | 3 | 3X3 | 6004063.19493 | 2100446.35832 | 37.74765561211429 | -122.428707390249 | (37.7476556121143, -122.428707390249) | ||
| 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) | |
| 17568 | 17568 | 26196 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 525 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | Permit Number 772904 | 6002382.350740001 | 2105139.64975 | 37.7604469978531 | -122.434855228598 | (37.7604469978531, -122.434855228598) | ||
| 17612 | 17612 | 28717 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 593 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/07/2004 12:00:00 AM | 3 | 3X3 | Permit Number 772904 | 6002404.32296 | 2104787.5580599997 | 37.759481486596705 | -122.434754058477 | (37.7594814865967, -122.434754058477) | |
| 17760 | 17760 | 614 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 3130 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6008131.4648 | 2102133.22317 | 37.752516771554205 | -122.41475886214899 | (37.7525167715542, -122.414758862149) | |||
| 17920 | 17920 | 26182 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 490 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X3 | Permit Number 772904 | 6002306.27174 | 2105387.0468200003 | 37.7611219705289 | -122.435136045518 | (37.7611219705289, -122.435136045518) | ||
| 18121 | 18121 | 28716 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 588 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2004 12:00:00 AM | 3 | 3X3 | Permit Number 772904 | 6002337.13955 | 2104792.2766299997 | 37.7594906282039 | -122.43498674903499 | (37.7594906282039, -122.434986749035) | |
| 19344 | 19344 | 26197 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 519 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | Permit Number 772904 | 6002381.63954 | 2105165.88105 | 37.76051898227939 | -122.434859564238 | (37.7605189822794, -122.434859564238) | ||
| 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) | |
| 19871 | 19871 | 16685 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 250X Noe St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/25/2010 12:00:00 AM | 3 | 3X3 | 6002901.6582 | 2106832.0518 | 37.7651233950804 | -122.43318011235 | (37.7651233950804, -122.43318011235) | ||
| 20194 | 20194 | 18470 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1221 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/21/2003 12:00:00 AM | 12 | 3X3 | 6010619.64201 | 2102143.08548 | 37.752683339465705 | -122.406154975289 | (37.7526833394657, -122.406154975289) | ||
| 20204 | 20204 | 16686 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 250X Noe St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/06/1998 12:00:00 AM | 3 | 3X3 | 6002901.0969 | 2106818.0205 | 37.7650848366999 | -122.433181051108 | (37.7650848366999, -122.433181051108) | ||
| 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) | ||
| 21065 | 21065 | 28710 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 420 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/07/2004 12:00:00 AM | 6 | 3X3 | Permit Number 772904 | 6002287.50765 | 2105730.51136 | 37.7620639753051 | -122.435225510065 | (37.7620639753051, -122.435225510065) | |
| 21143 | 21143 | 26181 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 480 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/28/2006 12:00:00 AM | 3 | 2x2 | Permit Number 772904 | 6002301.12409 | 2105420.8366099996 | 37.7612144567952 | -122.43515626586999 | (37.7612144567952, -122.43515626587) | |
| 22136 | 22136 | 28718 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 597 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/07/2004 12:00:00 AM | 3 | 3X3 | Permit Number 772904 | 6002404.2246199995 | 2104762.59172 | 37.759412929468496 | -122.434752613241 | (37.7594129294685, -122.434752613241) | |
| 23126 | 23126 | 50003 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1101X 19th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2003 12:00:00 AM | 11 | 0 | Permit Number 46740 | 6014266.61344 | 2105244.3143 | 37.761401960948795 | -122.393760055695 | (37.7614019609488, -122.393760055695) |
| 23543 | 23543 | 245283 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 399 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006236.70804 | 2100879.7389700003 | 37.748968348918794 | -122.42122226179501 | (37.7489683489188, -122.421222261795) | |||
| 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) | |||
| 23646 | 23646 | 197780 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1809 19th St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 6012306.168880001 | 2105129.4527 | 37.760977438687206 | -122.40053238956999 | (37.7609774386872, -122.40053238957) | |||
| 23764 | 23764 | 197793 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 66 Ceres St | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6013832.07065 | 2093815.87712 | 37.7299977259065 | -122.394462716674 | (37.7299977259065, -122.394462716674) | |||
| 23768 | 23768 | 215139 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 810 Darien Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 5993967.99913 | 2094114.77996 | 37.7296941579575 | -122.463156396067 | (37.7296941579575, -122.463156396067) | |||
| 23791 | 23791 | 245271 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 217 Ogden Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 6008459.65813 | 2096082.8630400002 | 37.7359222563084 | -122.41319610842501 | (37.7359222563084, -122.413196108425) | |||
| 23799 | 23799 | 142837 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1409 POLK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6006720.9693 | 2115724.3916 | 37.7897555322672 | -122.420601310832 | (37.7897555322672, -122.420601310832) | |||
| 23877 | 23877 | 215142 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 600 Portola Dr | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5997147.4382 | 2099712.0801 | 37.745245634987995 | -122.452568576882 | (37.745245634988, -122.452568576882) | |||
| 24349 | 24349 | 245242 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 882 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6009904.77367 | 2104105.1123200003 | 37.7580306148353 | -122.40876553542401 | (37.7580306148353, -122.408765535424) | |||
| 24745 | 24745 | 240970 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 4210 21st St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6001417.4535300005 | 2103381.77195 | 37.755565461578605 | -122.43806643331499 | (37.7555654615786, -122.438066433315) | |||
| 25139 | 25139 | 245353 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 40 Pond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003161.02626 | 2106276.4725200003 | 37.7636126186575 | -122.432243341071 | (37.7636126186575, -122.432243341071) |
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");