Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, DBH
| 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) | |||
| 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) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) |
| 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) | |
| 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) | ||
| 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) | |
| 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) | ||
| 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) |
| 25972 | 25972 | 40007 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 939 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 19 | Permit Number 41260 | 6019022.80772 | 2094568.6170400002 | 37.7323517975898 | -122.37656969105 | (37.7323517975898, -122.37656969105) | |
| 26069 | 26069 | 51827 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 75 Dore St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2005 12:00:00 AM | 14 | Permit Number 48062 | 6008827.588169999 | 2109898.7255599997 | 37.7738781451019 | -122.412900530062 | (37.7738781451019, -122.412900530062) | ||
| 27320 | 27320 | 51823 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 75 Dore St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2005 12:00:00 AM | 13 | Permit Number 48062 | 6008893.049459999 | 2109829.84045 | 37.7736926770172 | -122.412669217211 | (37.7736926770172, -122.412669217211) | ||
| 28210 | 28210 | 40630 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 2130 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2005 12:00:00 AM | 16 | Permit Number 48121 | 6012083.9226 | 2102367.98712 | 37.753382664887795 | -122.40110700419599 | (37.7533826648878, -122.401107004196) | |
| 30703 | 30703 | 38158 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 40 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1998 12:00:00 AM | 8 | Permit Number 40302 | 6009260.79203 | 2094034.01132 | 37.7303414926476 | -122.410281644004 | (37.7303414926476, -122.410281644004) | |
| 33393 | 33393 | 50480 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 2985 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/2003 12:00:00 AM | 10 | Permit Number 47115 | 5999894.80621 | 2116710.11833 | 37.7920750076028 | -122.44428996222601 | (37.7920750076028, -122.444289962226) | ||
| 36321 | 36321 | 31963 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1100 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | 10 | Permit Number 35365 | 6006912.23136 | 2114707.29251 | 37.786973605998 | -122.41986735849702 | (37.786973605998, -122.419867358497) | |
| 39975 | 39975 | 51830 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 75 Dore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2005 12:00:00 AM | 15 | Permit Number 48062 | 6008991.04076 | 2109728.4327599998 | 37.7734197345703 | -122.41232307986 | (37.7734197345703, -122.41232307986) | ||
| 44296 | 44296 | 32270 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1654 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1996 12:00:00 AM | 13 | Permit Number 36856 | 6002284.74056 | 2121254.77264 | 37.8046895029868 | -122.43634617414499 | (37.8046895029868, -122.436346174145) | ||
| 44452 | 44452 | 51833 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 75 Dore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2005 12:00:00 AM | 12 | Permit Number 48062 | 6008964.934219999 | 2109757.47031 | 37.7734979998699 | -122.412415439325 | (37.7734979998699, -122.412415439325) | ||
| 44711 | 44711 | 40581 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1745 Alameda St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/2003 12:00:00 AM | 18 | Permit Number 47084 | 6011805.12388 | 2107918.92734 | 37.768608754615705 | -122.40246144615101 | (37.7686087546157, -122.402461446151) | |
| 46322 | 46322 | 37940 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 728 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/2003 12:00:00 AM | 12 | Permit Number 46514 | 6015675.91863 | 2103966.98263 | 37.7579728963479 | -122.388796638862 | (37.7579728963479, -122.388796638862) | |
| 47088 | 47088 | 51713 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 175@ 6th ST Bluxome St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2005 12:00:00 AM | 11 | Permit Number 47987 | 6012693.61148 | 2110101.74925 | 37.77465185073721 | -122.399541492249 | (37.7746518507372, -122.399541492249) | ||
| 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) | |
| 48520 | 48520 | 43208 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 33 University St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 9 | Permit Number 43000 | 6007763.045469999 | 2093934.70612 | 37.7299847513771 | -122.41545254790701 | (37.7299847513771, -122.415452547907) | |
| 50464 | 50464 | 51825 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 75 Dore St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2005 12:00:00 AM | 9 | Permit Number 48062 | 6008869.298780001 | 2109856.43438 | 37.773764364664295 | -122.41275325526699 | (37.7737643646643, -122.412753255267) | ||
| 51634 | 51634 | 59235 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 730 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/1992 12:00:00 AM | 16 | Permit Number 31141 | 6015660.35324 | 2103965.97001 | 37.757969253187596 | -122.388850400349 | (37.7579692531876, -122.388850400349) | |
| 54016 | 54016 | 52363 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1030@ CEDAR Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | 11 | Permit Number 48499 | 6006937.73357 | 2114525.8826099997 | 37.786476935611404 | -122.41976624951 | (37.7864769356114, -122.41976624951) | |
| 54828 | 54828 | 51822 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 75 Dore St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2005 12:00:00 AM | 11 | Permit Number 48062 | 6008911.92726 | 2109811.9687 | 37.7736446648878 | -122.41260265211099 | (37.7736446648878, -122.412602652111) | ||
| 55358 | 55358 | 51710 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 175@ 6th ST Bluxome St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2005 12:00:00 AM | 11 | Permit Number 47987 | 6012671.60652 | 2110080.29176 | 37.774591706771204 | -122.399616105424 | (37.7745917067712, -122.399616105424) | ||
| 55914 | 55914 | 62128 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 669 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/2011 12:00:00 AM | 14 | Permit Number 767154 | 6001650.6947800005 | 2093159.72475 | 37.727511376537706 | -122.436528202327 | (37.7275113765377, -122.436528202327) | |
| 56545 | 56545 | 45779 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1033 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2005 12:00:00 AM | 13 | Permit Number 48205 | 6006884.42122 | 2114521.64488 | 37.786462296445606 | -122.41995039648701 | (37.7864622964456, -122.419950396487) | |
| 57769 | 57769 | 53594 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1498 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/1969 12:00:00 AM | 8 | Permit Number 6523 | 6006733.5016 | 2115973.7954 | 37.790441039619296 | -122.420575661635 | (37.7904410396193, -122.420575661635) | ||
| 58475 | 58475 | 35885 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 65 Elmira St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1998 12:00:00 AM | 3 | Permit Number 39085 | 6011186.47786 | 2096510.21791 | 37.737248391196395 | -122.40379841878901 | (37.7372483911964, -122.403798418789) | |
| 59835 | 59835 | 42664 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 780 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/2011 12:00:00 AM | 6 | Permit Number 768090 | 6007065.0631800005 | 2121240.35517 | 37.8049203715397 | -122.419802335728 | (37.8049203715397, -122.419802335728) | ||
| 61105 | 61105 | 60578 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 801 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1982 12:00:00 AM | 10 | Permit Number 20192 | 6015478.27896 | 2103906.06329 | 37.7577946687129 | -122.389475912095 | (37.7577946687129, -122.389475912095) | ||
| 62034 | 62034 | 51821 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 75 Dore St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2005 12:00:00 AM | 15 | Permit Number 48062 | 6008924.411069999 | 2109799.01878 | 37.77360980807 | -122.412558552943 | (37.77360980807, -122.412558552943) | ||
| 62386 | 62386 | 51829 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 75 Dore St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2005 12:00:00 AM | 10 | Permit Number 48062 | 6008854.22415 | 2109872.0726 | 37.7738064574284 | -122.412806506809 | (37.7738064574284, -122.412806506809) | ||
| 62938 | 62938 | 40600 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1745 Alameda St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/2003 12:00:00 AM | 16 | Permit Number 47084 | 6011742.75079 | 2107914.88662 | 37.768594177497 | -122.402676906637 | (37.768594177497, -122.402676906637) | |
| 63190 | 63190 | 54823 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1438 Underwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1972 12:00:00 AM | 7 | Permit Number 10677 | 6015466.1212 | 2093109.3415 | 37.728148423872206 | -122.388764251275 | (37.7281484238722, -122.388764251275) | ||
| 64975 | 64975 | 35347 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1141 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2014 12:00:00 AM | 10 | Permit Number 773064 | 6012246.4084 | 2103087.65437 | 37.755367777115104 | -122.40059564158899 | (37.7553677771151, -122.400595641589) | |
| 65542 | 65542 | 38160 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 48 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | Permit Number 773760 | 6009245.10254035 | 2094077.23333811 | 37.7304592916016 | -122.41033893557 | (37.7304592916016, -122.41033893557) | |
| 66016 | 66016 | 49150 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 4199 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/23/2003 12:00:00 AM | Permit Number 46273 | 6003544.55958588 | 2093981.972593 | 37.7298765227481 | -122.430039732071 | (37.7298765227481, -122.430039732071) | |||
| 66044 | 66044 | 95103 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 2200@Broderick Beach St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/08/2008 12:00:00 AM | 12 | 5999638.348569999 | 2120885.83168 | 37.8035257685578 | -122.445477697742 | (37.8035257685578, -122.445477697742) | |||
| 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) | |
| 68460 | 68460 | 52364 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1030@ CEDAR Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | 8 | Permit Number 48499 | 6006935.6459800005 | 2114546.93824 | 37.7865346316038 | -122.419774966644 | (37.7865346316038, -122.419774966644) | |
| 70276 | 70276 | 42979 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 308 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2000 12:00:00 AM | 10 | Permit Number 42863 | 6006597.58462 | 2092494.33475 | 37.725964228751295 | -122.419379553644 | (37.7259642287513, -122.419379553644) | |
| 71936 | 71936 | 49744 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 27 Bishop St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 12 | Permit Number 46543 | 6010938.20638 | 2089696.59945 | 37.7185257427455 | -122.404177411982 | (37.7185257427455, -122.404177411982) | |
| 72300 | 72300 | 61919 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 2960 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/11/1985 12:00:00 AM | 10 | Permit Number 21972 | 5999445.537280001 | 2117038.34051 | 37.7929505767659 | -122.44586804847602 | (37.7929505767659, -122.445868048476) | ||
| 73966 | 73966 | 51824 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 75 Dore St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2005 12:00:00 AM | 12 | Permit Number 48062 | 6008839.3407 | 2109885.3113700002 | 37.7738419725734 | -122.412858927409 | (37.7738419725734, -122.412858927409) |
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");