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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | |||
| 26088 | 26088 | 184889 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1201 Sunset Blvd | 78 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984679.4382 | 2106701.786 | 37.763715182625106 | -122.49619577469801 | (37.7637151826251, -122.496195774698) | |||
| 26192 | 26192 | 136529 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 3601 Broderick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5999666.6912 | 2120931.30198 | 37.8036522357126 | -122.44538288853501 | (37.8036522357126, -122.445382888535) | |||
| 26301 | 26301 | 245318 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 45 Mirabel Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6007552.12465 | 2099948.94937 | 37.7464866805288 | -122.41660760567301 | (37.7464866805288, -122.416607605673) | |||
| 26394 | 26394 | 245339 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 4230 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001657.3727 | 2101778.0038900003 | 37.751175540640205 | -122.437121899671 | (37.7511755406402, -122.437121899671) | |||
| 26574 | 26574 | 245297 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1536 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6003292.09068 | 2099305.46316 | 37.7444793082671 | -122.431292397034 | (37.7444793082671, -122.431292397034) | |||
| 26971 | 26971 | 142866 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1010 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6006958.8566 | 2114380.7051 | 37.7860795036749 | -122.419682864396 | (37.7860795036749, -122.419682864396) | |||
| 27268 | 27268 | 197791 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 340 Arkansas St | 2 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6012898.99071 | 2105404.50767 | 37.7617657223333 | -122.39850136517 | (37.7617657223333, -122.39850136517) | |||
| 27439 | 27439 | 199676 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1438 Underwood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6015463.3731 | 2093112.0896 | 37.7281558172955 | -122.388773943405 | (37.7281558172955, -122.388773943405) | |||
| 27523 | 27523 | 197764 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1150x Tennessee St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | Width 8ft | 6015565.1078 | 2103547.1261299998 | 37.7568139175333 | -122.389150557161 | (37.7568139175333, -122.389150557161) | |||
| 27640 | 27640 | 179601 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 901 Delano Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 5998646.13957 | 2089569.69223 | 37.717482785492 | -122.446656735947 | (37.717482785492, -122.446656735947) | |||
| 27780 | 27780 | 245345 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 466 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6003300.1227 | 2103327.9706099997 | 37.755524624263394 | -122.431551739942 | (37.7555246242634, -122.431551739942) | |||
| 28304 | 28304 | 240881 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 2318 22nd St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 6011232.67405 | 2103729.80119 | 37.7570743809943 | -122.404146651544 | (37.7570743809943, -122.404146651544) | |||
| 29624 | 29624 | 240962 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 95 Eagle St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5999817.7202 | 2104451.34743 | 37.75841114588761 | -122.443675625443 | (37.7584111458876, -122.443675625443) | |||
| 29638 | 29638 | 197767 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1150x Tennessee St | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | Width 8ft | 6015569.446690001 | 2103464.9174599997 | 37.756588430534 | -122.38912981161002 | (37.756588430534, -122.38912981161) | |||
| 29925 | 29925 | 136559 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1200 Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009435.38581 | 2117472.07438 | 37.794706848389 | -122.41133317000099 | (37.794706848389, -122.411333170001) | |||
| 30015 | 30015 | 179628 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 599 Somerset St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 6010332.78013 | 2091733.53575 | 37.7240849010885 | -122.40641358074801 | (37.7240849010885, -122.406413580748) | |||
| 30616 | 30616 | 246455 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 405 Duncan St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 6003830.51573 | 2099804.43405 | 37.7458798656648 | -122.42946621029199 | (37.7458798656648, -122.429466210292) | |||
| 30892 | 30892 | 245269 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 207 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007122.3181 | 2096929.8532099999 | 37.7381727341921 | -122.41787985679701 | (37.7381727341921, -122.417879856797) | |||
| 31566 | 31566 | 179618 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 104 Burrows St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6011168.50385 | 2093508.14959 | 37.729004339277395 | -122.403649399324 | (37.7290043392774, -122.403649399324) | ||||
| 31871 | 31871 | 136566 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1218 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6007796.91649 | 2118215.26217 | 37.796655426567995 | -122.41705519283998 | (37.796655426568, -122.41705519284) | |||
| 32135 | 32135 | 215152 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 739 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5994637.17315 | 2089906.08202 | 37.71817661334929 | -122.460538153038 | (37.7181766133493, -122.460538153038) | |||
| 32166 | 32166 | 240984 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 426 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002286.66719 | 2105716.35154 | 37.7620250481505 | -122.43522740403499 | (37.7620250481505, -122.435227404035) | |||
| 32426 | 32426 | 240875 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 3498 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 6ft | 6006590.994390001 | 2100878.65509 | 37.7489853398132 | -122.419997058715 | (37.7489853398132, -122.419997058715) | |||
| 32897 | 32897 | 245304 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 371 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 3ft | 6003869.89796 | 2096618.9998400002 | 37.737135624318 | -122.429102948069 | (37.737135624318, -122.429102948069) | |||
| 32915 | 32915 | 197811 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 41 Dore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6008628.59591 | 2110107.11154 | 37.7744391520861 | -122.413603620921 | (37.7744391520861, -122.413603620921) | |||
| 33031 | 33031 | 240871 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 2913 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6007129.38723 | 2101389.6911299997 | 37.750418847457205 | -122.418171515021 | (37.7504188474572, -122.418171515021) | |||
| 33150 | 33150 | 247208 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 800 Duboce Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 6ft | 6001877.88305 | 2108298.3747 | 37.7690914279487 | -122.43682607218 | (37.7690914279487, -122.43682607218) | |||
| 33275 | 33275 | 240861 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1706 Dolores St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 6ft | 6005275.96554 | 2098387.85198 | 37.7420719868226 | -122.424367303401 | (37.7420719868226, -122.424367303401) | |||
| 33691 | 33691 | 179622 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 599 Somerset St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 6010361.21232 | 2091638.8627900002 | 37.7238265393343 | -122.406308627159 | (37.7238265393343, -122.406308627159) | |||
| 33713 | 33713 | 71641 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1327 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 9 | 6011027.0266 | 2119468.0848 | 37.800276548465 | -122.405966529737 | (37.800276548465, -122.405966529737) | ||
| 34314 | 34314 | 245253 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1090 Hampshire St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6010233.17575 | 2102878.70236 | 37.754681555732496 | -122.40754330998001 | (37.7546815557325, -122.40754330998) |
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");