Street_Tree_List

Data source: data.sfgov.org

818 rows where qSpecies = 30 sorted by qCareAssistant

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlotSize

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant ▼ PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
69 19206 DPW Maintained 3 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 630 Sansome St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6012230.08543 2117977.14861 37.7962500076802 -122.40169859442699 (37.7962500076802, -122.401698594427)
1485 115988 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 499 Jackson St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/09/2016 12:00:00 AM 3 3x3 Permit Number 777967 6011781.45666 2118040.71778 37.7963995082912 -122.40325542520901 (37.7963995082912, -122.403255425209)
2850 27607 DPW Maintained 3 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1377 Fulton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 3X3   6001133.4058 2111053.0447 37.7766127217509 -122.439598674592 (37.7766127217509, -122.439598674592)
3030 224462 Planning Code 138.1 required 4 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 2810 26th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/15/2017 12:00:00 AM 3 3x3 Permit Number 775960 6010311.37562 2101086.64633 37.7497653433983 -122.40714655877301 (37.7497653433983, -122.407146558773)
3035 240686 Planning Code 138.1 required 4 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 2810 26th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/15/2017 12:00:00 AM 3 3x3 Permit Number 775960 6010325.27315 2101087.17666 37.749767577309605 -122.40709853768499 (37.7497675773096, -122.407098537685)
3230 1713 DPW Maintained 3 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 555 Battery St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 5x6   6012507.60717 2118114.90232 37.796643729085005 -122.40074798855 (37.796643729085, -122.40074798855)
3315 20250 DPW Maintained 3 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1880 Steiner St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 3X3   6002537.9918 2114673.3066 37.78663289034311 -122.43499878671301 (37.7866328903431, -122.434998786713)
3485 1714 DPW Maintained 3 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 555 Battery St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 5x9   6012511.35044 2118080.94057 37.796550687018204 -122.400732648813 (37.7965506870182, -122.400732648813)
5667 102263 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 2037 Pierce St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 3x3   6001878.76288 2115606.3786400002 37.78915741351871 -122.437346392945 (37.7891574135187, -122.437346392945)
5858 18862 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 2200 Sacramento St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 3X3PL   6004143.20725 2116038.00121 37.790471010977505 -122.42954249260201 (37.7904710109775, -122.429542492602)
5887 94203 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1000 Green St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/25/2010 12:00:00 AM 6 3x3 Permit Number 53605 6008148.35783 2118956.03523 37.7987091687558 -122.415891605907 (37.7987091687558, -122.415891605907)
6585 44092 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 2200 Sacramento St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/01/2000 12:00:00 AM 8 3x3 Permit Number 43607 6004180.10381 2116042.60341 37.790485736467296 -122.429415161181 (37.7904857364673, -122.429415161181)
6797 27608 DPW Maintained 3 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1377 Fulton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 3X3   6001149.4313 2111053.53 37.776614966343296 -122.439543272646 (37.7766149663433, -122.439543272646)
7288 111098 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 754 Post St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/20/2015 12:00:00 AM 3 3x3   6008536.0762 2114905.536 37.78760928190211 -122.414263235869 (37.7876092819021, -122.414263235869)
7797 6925 DPW Maintained 3 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 460 Fell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3X3   6005200.4571 2110629.3361 37.7756799587692 -122.42549938705099 (37.7756799587692, -122.425499387051)
7798 1716 Landmark tree 9 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 555 Battery St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 5x15   6012528.51285 2117974.4106400004 37.796259138493205 -122.400665775228 (37.7962591384932, -122.400665775228)
7931 1715 DPW Maintained 3 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 555 Battery St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 5x6   6012518.40757 2118034.67495 37.796424046287996 -122.400704977573 (37.796424046288, -122.400704977573)
7985 1718 DPW Maintained 3 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 555 Battery St 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     20 9x6   6012538.2564900005 2117884.3369 37.7960123609319 -122.400625729299 (37.7960123609319, -122.400625729299)
8677 18861 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 2200 Sacramento St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 3X3   6004226.06461 2116051.48796 37.790512733214 -122.42925677349 (37.790512733214, -122.42925677349)
9120 4533 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 45 Cleary Ct 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/02/2016 03:02:00 PM 6 5x5   6005057.0165 2113679.5647 37.7840470307287 -122.42621279071001 (37.7840470307287, -122.42621279071)
9146 4532 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 45 Cleary Ct 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6005027.0371 2113673.2533 37.784028006637996 -122.42631605911998 (37.784028006638, -122.42631605912)
9151 4530 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 45 Cleary Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3X3   6004963.1338 2113665.364 37.7840027322121 -122.426536579485 (37.7840027322121, -122.426536579485)
9193 4549 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 85 Cleary Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6004652.295 2113623.5507 37.7838703460943 -122.427608988739 (37.7838703460943, -122.427608988739)
9249 4552 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 85 Cleary Ct 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6004747.7557 2113637.7514 37.7839147367985 -122.42727974188101 (37.7839147367985, -122.427279741881)
9257 4531 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 45 Cleary Ct 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6004996.2689 2113667.7308 37.7840111039908 -122.426422112629 (37.7840111039908, -122.426422112629)
9465 4553 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 85 Cleary Ct 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3X3   6004771.4236 2113636.9625 37.7839139091534 -122.427197803426 (37.7839139091534, -122.427197803426)
10378 98180 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 622 Cambridge St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/29/2011 12:00:00 AM 3 3x3 Permit Number 768099 6007169.16242 2091641.99398 37.7236560602499 -122.417343266399 (37.7236560602499, -122.417343266399)
14017 104025 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 716 Wisconsin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 3x3   6012687.87968 2104149.7182 37.7583085835989 -122.399143437016 (37.7583085835989, -122.399143437016)
16227 7404 DPW Maintained 3 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1060 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/28/1992 12:00:00 AM 24 3X3   6010543.2443 2111181.3457 37.777496075538004 -122.407056190657 (37.777496075538, -122.407056190657)
16738 28934 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 260 08th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/11/2006 12:00:00 AM 3 3x3   6009412.25627 2110486.9627400003 37.775526107775704 -122.41091961406299 (37.7755261077757, -122.410919614063)
16799 57069 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 920 Minnesota St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/22/1974 12:00:00 AM 27 7x13 Permit Number 14335 6015211.40645 2104319.9485 37.7589163085501 -122.390427794128 (37.7589163085501, -122.390427794128)
17244 25180 DPW Maintained 3 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 3226 Market St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/18/1996 12:00:00 AM 6 3X3   5999422.34121 2104738.79635 37.7591778511874 -122.445063681349 (37.7591778511874, -122.445063681349)
17457 25179 DPW Maintained 3 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 3226 Market St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/18/1996 12:00:00 AM 6 3X3   5999420.685330001 2104753.2461200003 37.7592174321694 -122.445070446966 (37.7592174321694, -122.445070446966)
18345 16909 DPW Maintained 3 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 457 Oak St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/15/2009 12:00:00 AM 18 3X3   6004854.34153 2110178.37501 37.7744221674765 -122.42666456674101 (37.7744221674765, -122.426664566741)
19126 89429 DPW Maintained 3 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 2608 Anza St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/29/2008 12:00:00 AM 3 3x3   5990547.63767 2112005.7823900003 37.778620499636 -122.476287153711 (37.778620499636, -122.476287153711)
20331 25181 DPW Maintained 3 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 3226 Market St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/18/1996 12:00:00 AM 6 3X3   5999423.66493 2104708.37976 37.7590944103092 -122.44505691664101 (37.7590944103092, -122.445056916641)
20605 23 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 729 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/30/2011 12:00:00 AM 3 4x4   6003875.846919999 2107718.3128400003 37.7676120683604 -122.429873853201 (37.7676120683604, -122.429873853201)
22166 25182 DPW Maintained 3 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 3226 Market St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/18/1996 12:00:00 AM 3 3X3   5999429.9273 2104670.84771 37.7589917140099 -122.4450325603 (37.7589917140099, -122.4450325603)
22918 191269 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 538 Delancey St 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8     6015147.69888 2113724.07494 37.7847344271845 -122.391305511737 (37.7847344271845, -122.391305511737)
23013 15425 DPW Maintained 3 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 2101 Mission St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 2X2   6006866.3108 2106096.3931 37.7633275539022 -122.41941512219401 (37.7633275539022, -122.419415122194)
23366 227653 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 3750 21st St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6003384.06107 2103624.93542 37.7563447763019 -122.43128265198901 (37.7563447763019, -122.431282651989)
23452 207071 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1927 08th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 6ft   5993749.481269999 2102344.6615 37.752278758765605 -122.464509159894 (37.7522787587656, -122.464509159894)
23772 191299 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 601 04th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 5ft   6015177.82762 2107330.32237 37.767180280481895 -122.390754301979 (37.7671802804819, -122.390754301979)
23969 176943 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 19 Lois Ln 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6012322.95001 2087866.52725 37.713578008300296 -122.39926249466801 (37.7135780083003, -122.399262494668)
24380 129424 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 2129 Vallejo St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 4ft   6003346.86179 2117886.37825 37.7955010594853 -122.43242986946699 (37.7955010594853, -122.432429869467)
24787 56080 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 723 47th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/22/2011 12:00:00 AM 2 3x3 Permit Number 51743 5981333.03596 2110794.79787 37.774756814986794 -122.50807353876199 (37.7747568149868, -122.508073538762)
25932 207066 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 71 Wawona St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5993124.54928 2098622.04482 37.7420213577054 -122.46639972369101 (37.7420213577054, -122.466399723691)
26163 247176 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 111 Buena Vista Ave East 1 : 4 Tree 1 Private 1     5 Width 4ft   6001288.35672 2108578.65763 37.7698274924813 -122.438885293015 (37.7698274924813, -122.438885293015)
26269 207097 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 451 Lansdale Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5996075.95126 2096408.69413 37.7361138982453 -122.45603479789301 (37.7361138982453, -122.456034797893)
26316 176960 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 242 Hester Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   6012452.5611 2087695.0016599998 37.7131142557927 -122.39880247885701 (37.7131142557927, -122.398802478857)
26349 129413 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 2111 Webster St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6003291.44456 2115944.18125 37.79016514166771 -122.43248283141399 (37.7901651416677, -122.432482831414)
26504 227603 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1201 San Jose Ave 55 Front Yard : Yard 7 Tree 1 Private 1     2     6004504.07862 2096101.1879099999 37.735749708773795 -122.42687342978998 (37.7357497087738, -122.42687342979)
27568 191287 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 720 04th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6014360.2734 2110545.30097 37.7759625028975 -122.393807184665 (37.7759625028975, -122.393807184665)
27723 129402 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 3000 Lyon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5999090.32735 2119096.86414 37.7985824452762 -122.44724531075 (37.7985824452762, -122.44724531075)
27806 129444 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1338 Clay St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6008418.059880001 2116953.62618 37.793226207275794 -122.414816555443 (37.7932262072758, -122.414816555443)
28130 191253 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 654 Minnesota St 12 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 10ft   6015148.44265 2105367.15882 37.7617882296504 -122.39071873558599 (37.7617882296504, -122.390718735586)
28179 227598 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 501 14th St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6005393.4683 2107800.6400599997 37.7679239451627 -122.424630446843 (37.7679239451627, -122.424630446843)
28468 129406 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 3545 Scott St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6000708.230719999 2120533.5731200003 37.8026195792908 -122.44175003663099 (37.8026195792908, -122.441750036631)
28660 142575 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 2251 MASON ST 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 0ft   6008927.1192 2120859.172 37.803978459247205 -122.41333149055401 (37.8039784592472, -122.413331490554)
28685 99380 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1590 Yosemite Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/09/2012 12:00:00 AM 1 3x3 Permit Number 768917 6014911.1 2092490.7 37.726418980855996 -122.390639783135 (37.726418980856, -122.390639783135)
28729 191333 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1108 04th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 5ft   6014865.84277 2110042.3598599997 37.7746096212801 -122.392023095184 (37.7746096212801, -122.392023095184)
28952 176968 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 134 Craut St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6004019.9865 2094083.3714700001 37.7301818557853 -122.428403350153 (37.7301818557853, -122.428403350153)
29311 199962 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1265 Griffith St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   6018011.0370000005 2092725.2017 37.7272343718441 -122.379939611903 (37.7272343718441, -122.379939611903)
29379 105035 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1550 04th St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 6x6   6015087.4436800005 2107939.01173 37.768846592924 -122.391109479333 (37.768846592924, -122.391109479333)
29524 108754 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 200x Hester Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 3x3   6012760.63999 2087707.7823400002 37.7131665099896 -122.397738543111 (37.7131665099896, -122.397738543111)
29861 227623 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1001 Diamond St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 4ft   6001957.40527 2101134.69618 37.7494262207603 -122.43603832812599 (37.7494262207603, -122.436038328126)
30187 97675 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 2562 Green St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10     6000810.80569 2117928.4487099997 37.7954724412642 -122.441208053918 (37.7954724412642, -122.441208053918)
31053 191303 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 601 04th St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 5ft   6015172.36775 2107445.68773 37.7674967456035 -122.39078125017099 (37.7674967456035, -122.390781250171)
31094 87873 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 2341 Francisco St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/13/2008 12:00:00 AM 3 3x3 Permit Number 50845 6000097.31037 2119864.70248 37.8007482115146 -122.443816038389 (37.8007482115146, -122.443816038389)
31281 227616 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 246 Downey St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5999006.659659999 2106731.5709599997 37.764625778676 -122.44664468051 (37.764625778676, -122.44664468051)
31453 207072 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 245 Pacheco St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5994440.698340001 2100406.16627 37.7469959638947 -122.46197828057899 (37.7469959638947, -122.461978280579)
33222 207070 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1927 08th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 6ft   5993749.21516 2102356.41341 37.752311011160295 -122.464510933358 (37.7523110111603, -122.464510933358)
33248 94086 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1727 29th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/02/2010 12:00:00 AM 2 3x3 Permit Number 53469 5987161.9603 2103493.9012 37.7550523122054 -122.48737396285101 (37.7550523122054, -122.487373962851)
33465 191315 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1505 04th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 5ft   6015139.91127 2108041.11608 37.7691298604716 -122.390935133173 (37.7691298604716, -122.390935133173)
34205 207067 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 319 San Benito Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5992889.43355 2094705.1306900003 37.731252923187796 -122.466927982745 (37.7312529231878, -122.466927982745)
34421 191258 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1901 17th St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   6011671.67609 2106498.8214 37.7647020133105 -122.402823145387 (37.7647020133105, -122.402823145387)
34489 183440 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 2434 22nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   5989549.5958 2098754.1113 37.7421770482141 -122.47877029228998 (37.7421770482141, -122.47877029229)
34497 191363 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 955 Key Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13     6013550.52728 2089583.75311 37.7183615103672 -122.395139727222 (37.7183615103672, -122.395139727222)
34951 191312 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 601 04th St 15 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 5ft   6015149.38015 2107824.64473 37.768536003056504 -122.390887249657 (37.7685360030565, -122.390887249657)
35185 129454 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 855 Chestnut St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 6ft   6007720.06236 2120575.53372 37.8031318169374 -122.41748848713002 (37.8031318169374, -122.41748848713)
35192 191336 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1450 04th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 5ft   6015056.82202 2108488.85287 37.7703546363753 -122.391253838509 (37.7703546363753, -122.391253838509)
35610 176951 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 63 Lois Ln 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   6012562.34064 2087723.35892 37.7131982353775 -122.398425029786 (37.7131982353775, -122.398425029786)
36009 186909 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 2700 Sunset Blvd 58 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5985192.0104 2096702.7177 37.7362904860675 -122.49368611859501 (37.7362904860675, -122.493686118595)
36363 207082 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1963 Funston Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5992234.50744 2102126.7079 37.7515928656239 -122.46973226583799 (37.7515928656239, -122.469732265838)
36838 191250 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 654 Minnesota St 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 10ft   6015147.38841 2105382.23529 37.7618295678896 -122.390723435432 (37.7618295678896, -122.390723435432)
37043 191271 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 659 04th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6014227.23158 2110805.88928 37.776670625478395 -122.394285663563 (37.7766706254784, -122.394285663563)
37113 176939 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 8 Lois Ln 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 2ft   6012245.82216 2087941.3179099998 37.7137790697309 -122.399534325569 (37.7137790697309, -122.399534325569)
37197 191320 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1505 04th St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 5ft   6015132.04881 2108165.57051 37.769471148715894 -122.39097102870701 (37.7694711487159, -122.390971028707)
37307 191325 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1507 04th St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 5ft   6015118.6002 2108416.5397200002 37.7701595086914 -122.391035090994 (37.7701595086914, -122.391035090994)
37316 35009 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1652 Lyon St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/22/1997 12:00:00 AM 4   Permit Number 38581 5999618.3524 2114616.3026 37.7863101621151 -122.445095896882 (37.7863101621151, -122.445095896882)
37340 227600 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 308 Lexington St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     23 Width 4ft   6006510.89149 2104242.1298 37.7582161548565 -122.420512774045 (37.7582161548565, -122.420512774045)
37486 227656 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 148 Buena Vista Ter 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 3ft   6001371.492269999 2107387.94373 37.7665628167523 -122.43851240444799 (37.7665628167523, -122.438512404448)
37575 176976 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 100 Winding Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 5ft   6002487.993290001 2086859.8664400002 37.710260908397395 -122.433183714473 (37.7102609083974, -122.433183714473)
38656 176952 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 75 Lois Ln 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   6012648.82319 2087733.77895 37.713231664082706 -122.39812684519698 (37.7132316640827, -122.398126845197)
38876 142250 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 623 HAYES ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 0ft   6004849.3706 2110876.8893 37.7763398361781 -122.426731515889 (37.7763398361781, -122.426731515889)
38881 129421 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 2129 Vallejo St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 4ft   6003307.9218 2117884.58152 37.795493917972 -122.43256447998999 (37.795493917972, -122.43256447999)
39185 191296 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 740 04th St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   6014597.305819999 2110326.98215 37.7753762177666 -122.392971942918 (37.7753762177666, -122.392971942918)
40498 129411 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 2111 Webster St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6003275.408009999 2116033.9816799997 37.790410801365105 -122.43254473354901 (37.7904108013651, -122.432544733549)
41237 207083 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1959 Funston Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5992235.15443 2102157.44312 37.7516772939722 -122.469732265856 (37.7516772939722, -122.469732265856)
41440 191311 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 601 04th St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 5ft   6015151.76995 2107799.07376 37.76846592338129 -122.39087719613501 (37.7684659233813, -122.390877196135)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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");
Powered by Datasette · Query took 603.149ms · Data source: data.sfgov.org