Street_Tree_List

Data source: data.sfgov.org

321 rows where qSpecies = 109 sorted by DBH

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize, PermitNotes

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH ▼ PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
10086 88538 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 1306 York St   Sidewalk: Property side : Cutout 5 Tree 1 Private 1   06/26/2009 12:00:00 AM   3x12 Permit Number 52223 6010027.5 2101589.4 37.7511299031436 -122.40816367021999 (37.7511299031436, -122.40816367022)
83271 43725 Permitted Site 1 Acacia stenophylla :: Shoestring Acacia 109 759 Lakeview Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/25/2000 12:00:00 AM     Permit Number 43364 5994445.58077229 2089904.10562801 37.7181601624587 -122.46120025798099 (37.7181601624587, -122.461200257981)
86576 43724 Permitted Site 1 Acacia stenophylla :: Shoestring Acacia 109 759 Lakeview Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/25/2000 12:00:00 AM     Permit Number 43364 5994445.58077229 2089904.10562801 37.7181601624587 -122.46120025798099 (37.7181601624587, -122.461200257981)
90094 54118 Permitted Site 1 Acacia stenophylla :: Shoestring Acacia 109 760 Lakeview Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/25/2000 12:00:00 AM     Permit Number 43365 5994428.64681371 2089956.34861374 37.7183026346731 -122.461262575973 (37.7183026346731, -122.461262575973)
98416 115516 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 200x Guerrero St 7 Median : Cutout 11 Tree 1 DPW 2           6005415.2 2107753.5 37.767795737129205 -122.424551925681 (37.7677957371292, -122.424551925681)
105304 43729 Permitted Site 1 Acacia stenophylla :: Shoestring Acacia 109 763 Lakeview Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/25/2000 12:00:00 AM     Permit Number 43366 5994409.95328954 2089904.45905166 37.7181590824666 -122.461323431638 (37.7181590824666, -122.461323431638)
111021 43728 Permitted Site 1 Acacia stenophylla :: Shoestring Acacia 109 760 Lakeview Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/25/2000 12:00:00 AM     Permit Number 43365 5994428.64681371 2089956.34861374 37.7183026346731 -122.461262575973 (37.7183026346731, -122.461262575973)
112173 43727 Permitted Site 1 Acacia stenophylla :: Shoestring Acacia 109 760 Lakeview Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/25/2000 12:00:00 AM     Permit Number 43365 5994428.64681371 2089956.34861374 37.7183026346731 -122.461262575973 (37.7183026346731, -122.461262575973)
118657 115521 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 200x Guerrero St 12 Median : Cutout 11 Tree 1 DPW 2           6005415.2 2107753.5 37.767795737129205 -122.424551925681 (37.7677957371292, -122.424551925681)
129415 43734 Permitted Site 1 Acacia stenophylla :: Shoestring Acacia 109 777 Lakeview Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/25/2000 12:00:00 AM     Permit Number 43371 5994281.26699369 2089905.22565848 37.7181537802459 -122.46176829730601 (37.7181537802459, -122.461768297306)
141030 43726 Permitted Site 1 Acacia stenophylla :: Shoestring Acacia 109 760 Lakeview Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/25/2000 12:00:00 AM     Permit Number 43365 5994428.64681371 2089956.34861374 37.7183026346731 -122.461262575973 (37.7183026346731, -122.461262575973)
5110 152413 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 700x Guerrero St 2 Median : Cutout 11 Tree 1 DPW 2     0 Width 3ft   6005625.074080001 2104777.98262 37.7596375207611 -122.42361441706899 (37.7596375207611, -122.423614417069)
5111 152416 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 700x Guerrero St 5 Median : Cutout 11 Tree 1 DPW 2     0 Width 3ft   6005631.99539 2104658.5890900004 37.7593100848133 -122.423581991114 (37.7593100848133, -122.423581991114)
5113 152421 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 700x Guerrero St 10 Median : Cutout 11 Tree 1 DPW 2     0 Width 3ft   6005642.99765 2104457.73967 37.7587592203909 -122.42352966049 (37.7587592203909, -122.42352966049)
5114 152414 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 700x Guerrero St 3 Median : Cutout 11 Tree 1 DPW 2     0 Width 3ft   6005626.99355 2104746.96336 37.7595524574982 -122.423605573157 (37.7595524574982, -122.423605573157)
5118 152420 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 700x Guerrero St 9 Median : Cutout 11 Tree 1 DPW 2     0 Width 3ft   6005641.8915099995 2104501.69931 37.7588798608311 -122.42353661133998 (37.7588798608311, -122.42353661134)
5122 152419 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 700x Guerrero St 8 Median : Cutout 11 Tree 1 DPW 2     0 Width 3ft   6005637.900330001 2104551.94757 37.7590176055009 -122.423553987148 (37.7590176055009, -122.423553987148)
5127 152423 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 700x Guerrero St 12 Median : Cutout 11 Tree 1 DPW 2     0 Width 3ft   6005645.11359 2104396.78205 37.758591964470895 -122.423518008854 (37.7585919644709, -122.423518008854)
5131 152418 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 700x Guerrero St 7 Median : Cutout 11 Tree 1 DPW 2     0 Width 3ft   6005636.4507 2104585.0792400003 37.759108495478394 -122.42356135618999 (37.7591084954784, -122.42356135619)
5135 152417 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 700x Guerrero St 6 Median : Cutout 11 Tree 1 DPW 2     0 Width 3ft   6005634.27087 2104624.16733 37.7592156991708 -122.423571674116 (37.7592156991708, -122.423571674116)
5137 152415 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 700x Guerrero St 4 Median : Cutout 11 Tree 1 DPW 2     0 Width 3ft   6005628.48676 2104715.95286 37.7594673942256 -122.423598204106 (37.7594673942256, -122.423598204106)
5138 152412 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 700x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2     0 Width 3ft   6005623.17605 2104812.38517 37.7597318749526 -122.4236234274 (37.7597318749526, -122.4236234274)
5168 152422 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 700x Guerrero St 11 Median : Cutout 11 Tree 1 DPW 2     0 Width 3ft   6005644.9376300005 2104427.7274700003 37.7586769234173 -122.423520817442 (37.7586769234173, -122.423520817442)
150449 221531 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1100x Guerrero St 11 Median : Cutout 11 Tree 1 DPW 2     0 Width 3ft   6005769.92765 2102140.767 37.7524045154572 -122.422926004956 (37.7524045154572, -122.422926004956)
727 221435 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 100x Guerrero St 8 Median : Cutout 11 Tree 1 DPW 2   07/15/2016 05:58:00 AM 1 Width 3ft   6005438.10251 2108158.21074 37.768908269319795 -122.424501499347 (37.7689082693198, -122.424501499347)
733 221433 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 100x Guerrero St 6 Median : Cutout 11 Tree 1 DPW 2   07/15/2016 06:32:00 AM 1 Width 3ft   6005435.4614 2108218.9893400003 37.7690750036386 -122.42451495861201 (37.7690750036386, -122.424514958612)
737 221436 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 100x Guerrero St 9 Median : Cutout 11 Tree 1 DPW 2   07/15/2016 06:05:00 AM 1 Width 3ft   6005440.21619 2108132.10005 37.768836694985396 -122.424492330751 (37.7688366949854, -122.424492330751)
745 221429 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 100x Guerrero St 2 Median : Cutout 11 Tree 1 DPW 2   07/15/2016 05:39:00 AM 1 Width 3ft   6005428.96653 2108339.30361 37.76940499098671 -122.424545983407 (37.7694049909867, -122.424545983407)
754 221432 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 100x Guerrero St 5 Median : Cutout 11 Tree 1 DPW 2   07/15/2016 05:53:00 AM 1 Width 3ft   6005434.00046 2108253.10785 37.769168602384205 -122.42452243915301 (37.7691686023842, -122.424522439153)
759 221434 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 100x Guerrero St 7 Median : Cutout 11 Tree 1 DPW 2   07/15/2016 06:56:00 AM 1 Width 3ft   6005437.11129 2108190.56795 37.7689970584876 -122.42450722982001 (37.7689970584876, -122.42450722982)
766 221431 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 100x Guerrero St 4 Median : Cutout 11 Tree 1 DPW 2   07/15/2016 06:43:00 AM 1 Width 3ft   6005433.2519 2108280.1340799998 37.769242767658 -122.424526951068 (37.769242767658, -122.424526951068)
772 221430 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 100x Guerrero St 3 Median : Cutout 11 Tree 1 DPW 2   07/15/2016 06:19:00 AM 1 Width 3ft   6005430.67341 2108312.23866 37.7693307735195 -122.424538153922 (37.7693307735195, -122.424538153922)
773 221437 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 100x Guerrero St 10 Median : Cutout 11 Tree 1 DPW 2   07/15/2016 06:48:00 AM 1 Width 3ft   6005441.98545 2108105.3361400003 37.7687633076137 -122.424484307027 (37.7687633076137, -122.424484307027)
787 221428 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 100x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   07/15/2016 05:47:00 AM 1 Width 3ft   6005427.7802 2108362.05998 37.769467407522896 -122.424551705821 (37.7694674075229, -122.424551705821)
4312 221469 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 400x Guerrero St 2 Median : Cutout 11 Tree 1 DPW 2   04/29/2015 10:33:00 AM 1 3x3   6005528.17729 2106528.83552 37.7644394796106 -122.42407404799499 (37.7644394796106, -122.424074047995)
4316 221478 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 400x Guerrero St 11 Median : Cutout 11 Tree 1 DPW 2   04/29/2015 05:18:00 AM 1 Width 3ft   6005544.06849 2106215.1538 37.763579081143604 -122.423996776447 (37.7635790811436, -122.423996776447)
4326 221448 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 200x Guerrero St 8 Median : Cutout 11 Tree 1 DPW 2   02/09/2016 12:52:00 PM 1 Width 3ft   6005473.21673 2107488.5662700003 37.767071568632105 -122.42433240701 (37.7670715686321, -122.42433240701)
4336 221476 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 400x Guerrero St 9 Median : Cutout 11 Tree 1 DPW 2   04/29/2015 09:37:00 AM 1 Width 3ft   6005539.0927099995 2106307.4884599997 37.7638323293302 -122.42402055271799 (37.7638323293302, -122.424020552718)
4338 221462 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 300x Guerrero St 7 Median : Cutout 11 Tree 1 DPW 2   06/19/2015 10:33:00 AM 1 Width 3ft   6005503.98521 2106938.10792 37.7655618784892 -122.424186831055 (37.7655618784892, -122.424186831055)
4340 221479 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 400x Guerrero St 12 Median : Cutout 11 Tree 1 DPW 2   04/28/2015 07:46:00 PM 1 Width 3ft   6005545.66803 2106187.37905 37.7635029085615 -122.42398926890199 (37.7635029085615, -122.423989268902)
4348 221447 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 200x Guerrero St 9 Median : Cutout 11 Tree 1 DPW 2   02/09/2016 12:33:00 PM 1 Width 3ft   6005477.00515 2107432.0079200002 37.7669164868187 -122.424315280345 (37.7669164868187, -122.424315280345)
4354 221470 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 400x Guerrero St 3 Median : Cutout 11 Tree 1 DPW 2   04/29/2015 10:30:00 AM 1 Width 3ft   6005530.44166 2106496.00345 37.7643494583795 -122.42406388114401 (37.7643494583795, -122.424063881144)
4359 221446 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 200x Guerrero St 10 Median : Cutout 11 Tree 1 DPW 2   02/09/2016 11:45:00 AM 1 Width 3ft   6005477.30623 2107402.8649 37.7668364840384 -122.424312165974 (37.7668364840384, -122.424312165974)
4362 221445 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 200x Guerrero St 11 Median : Cutout 11 Tree 1 DPW 2   02/09/2016 10:50:00 AM 1 Width 3ft   6005479.31495 2107369.2041700003 37.7667441731271 -122.424302823815 (37.7667441731271, -122.424302823815)
4370 221471 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 400x Guerrero St 4 Median : Cutout 11 Tree 1 DPW 2   04/29/2015 10:27:00 AM 1 Width 3ft   6005532.14271 2106464.3538900004 37.764262652233704 -122.42405574678301 (37.7642626522337, -122.424055746783)
4371 221454 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 200x Guerrero St 2 Median : Cutout 11 Tree 1 DPW 2   02/09/2016 12:48:00 PM 1 Width 3ft   6005462.2492 2107712.58298 37.7676860457059 -122.42438627731501 (37.7676860457059, -122.424386277315)
4372 221457 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 300x Guerrero St 2 Median : Cutout 11 Tree 1 DPW 2   06/19/2015 10:54:00 AM 1 Width 3ft   6005492.07657 2107122.67642 37.766067987261295 -122.42424114830798 (37.7660679872613, -122.424241148308)
4377 221451 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 200x Guerrero St 5 Median : Cutout 11 Tree 1 DPW 2   02/09/2016 11:36:00 AM 1 Width 3ft   6005468.550009999 2107589.96825 37.76734973074429 -122.424355761536 (37.7673497307443, -122.424355761536)
4386 221473 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 400x Guerrero St 6 Median : Cutout 11 Tree 1 DPW 2   04/29/2015 10:20:00 AM 1 Width 3ft   6005534.54232 2106397.63335 37.764079588928496 -122.424042702116 (37.7640795889285, -122.424042702116)
4392 221453 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 200x Guerrero St 3 Median : Cutout 11 Tree 1 DPW 2   02/09/2016 12:40:00 PM 1 Width 3ft   6005462.88888 2107675.99901 37.7675856309877 -122.424381462352 (37.7675856309877, -122.424381462352)
4408 221472 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 400x Guerrero St 5 Median : Cutout 11 Tree 1 DPW 2   04/29/2015 10:24:00 AM 1 Width 3ft   6005534.310819999 2106426.8401 37.7641597706703 -122.424045579956 (37.7641597706703, -122.424045579956)
4411 221455 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 200x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   02/09/2016 12:55:00 PM 1 Width 3ft   6005458.8795300005 2107745.71785 37.7677768358576 -122.424400289657 (37.7677768358576, -122.424400289657)
4412 221475 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 400x Guerrero St 8 Median : Cutout 11 Tree 1 DPW 2   04/29/2015 10:13:00 AM 1 Width 3ft   6005538.26376 2106334.58706 37.763906688864495 -122.42402534700001 (37.7639066888645, -122.424025347)
4413 221467 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 300x Guerrero St 12 Median : Cutout 11 Tree 1 DPW 2   06/19/2015 10:14:00 AM 1 Width 3ft   6005513.55753 2106751.9184 37.765051186799 -122.424140480012 (37.765051186799, -122.424140480012)
4416 221474 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 400x Guerrero St 7 Median : Cutout 11 Tree 1 DPW 2   04/29/2015 10:16:00 AM 1 Width 3ft   6005537.16302 2106367.52425 37.7639970644374 -122.42403149656401 (37.7639970644374, -122.424031496564)
4419 221477 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 400x Guerrero St 10 Median : Cutout 11 Tree 1 DPW 2   04/29/2015 05:29:00 AM 1 Width 3ft   6005543.73868 2106251.90953 37.763679985054495 -122.424000531101 (37.7636799850545, -122.424000531101)
4420 221452 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 200x Guerrero St 4 Median : Cutout 11 Tree 1 DPW 2   02/09/2016 11:41:00 AM 1 Width 3ft   6005465.56003 2107641.57919 37.7674912732207 -122.42436977475501 (37.7674912732207, -122.424369774755)
4431 221450 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 200x Guerrero St 6 Median : Cutout 11 Tree 1 DPW 2   02/09/2016 11:34:00 AM 1 Width 3ft   6005469.47774 2107557.31332 37.7672601204903 -122.424350229795 (37.7672601204903, -122.424350229795)
4437 221480 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 400x Guerrero St 13 Median : Cutout 11 Tree 1 DPW 2   04/29/2015 05:03:00 AM 1 Width 3ft   6005548.13055 2106148.7780400002 37.7633970583515 -122.423978006683 (37.7633970583515, -122.423978006683)
25703 221449 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 200x Guerrero St 7 Median : Cutout 11 Tree 1 DPW 2     1 Width 3ft   6005469.95975 2107527.1833200003 37.767177417921 -122.42434641935499 (37.767177417921, -122.424346419355)
29150 221508 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 1201 San Jose Ave 15 Front Yard : Yard 7 Tree 1 Private 1     1     6004291.813569999 2095940.5809 37.73529671397821 -122.427595874056 (37.7352967139782, -122.427595874056)
31521 175079 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1104x Alemany Blvd 1 Median : Yard 3 Tree 1 DPW 2     1 Width 10ft   6003837.73065 2094453.4628599999 37.7311877286109 -122.42905980937599 (37.7311877286109, -122.429059809376)
42902 221440 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 100x Guerrero St 13 Median : Cutout 11 Tree 1 DPW 2     1 Width 3ft   6005447.60224 2108007.88033 37.7684960344855 -122.424457946087 (37.7684960344855, -122.424457946087)
43283 221415 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 800x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2     1 Width 3ft   6005678.5014 2103825.14435 37.7570242653802 -122.42336190183201 (37.7570242653802, -122.423361901832)
44105 221562 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 100 San Jose Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6006161.28805 2102498.9287799997 37.753410020459995 -122.421598049829 (37.75341002046, -122.421598049829)
55535 221566 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 4286 23rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6001342.8820400005 2102344.46852 37.7527130350975 -122.43825001643299 (37.7527130350975, -122.438250016433)
71884 221560 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 100 San Jose Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6006161.42459 2102519.64651 37.7534669142699 -122.42159904898001 (37.7534669142699, -122.42159904898)
86391 184203 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 1466 41st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5983430.71 2105161.519 37.75941282066329 -122.500400782356 (37.7594128206633, -122.500400782356)
115942 221483 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 500x Guerrero St 3 Median : Cutout 11 Tree 1 DPW 2     1 Width 3ft   6005560.35948 2105916.5024900003 37.7627599750213 -122.42391919281201 (37.7627599750213, -122.423919192812)
133864 221441 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 100x Guerrero St 14 Median : Cutout 11 Tree 1 DPW 2     1 Width 3ft   6005450.56053 2107974.49254 37.768404526663396 -122.424445338474 (37.7684045266634, -122.424445338474)
136012 187785 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 1740 20th St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 3ft   6012766.00153 2104746.33455 37.7599511143744 -122.39891512883499 (37.7599511143744, -122.398915128835)
148793 221561 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 100 San Jose Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6006161.81341 2102510.42937 37.7534416280528 -122.42159704977 (37.7534416280528, -122.42159704977)
148926 221442 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 100x Guerrero St 15 Median : Cutout 11 Tree 1 DPW 2     1 Width 3ft   6005450.9028900005 2107942.8086599996 37.768317549645 -122.42444190036699 (37.768317549645, -122.424441900367)
151374 221444 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 200x Guerrero St 12 Median : Cutout 11 Tree 1 DPW 2     1 Width 3ft   6005482.048359999 2107327.01142 37.766628476241294 -122.42429036821301 (37.7666284762413, -122.424290368213)
158034 221565 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 4286 23rd St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6001328.916669999 2102339.67059 37.7526990668325 -122.438297967381 (37.7526990668325, -122.438297967381)
159637 221417 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 800x Guerrero St 3 Median : Cutout 11 Tree 1 DPW 2     1 Width 3ft   6005673.16306 2103886.4908 37.7571924071266 -122.42338472483101 (37.7571924071266, -122.423384724831)
159995 221439 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 100x Guerrero St 12 Median : Cutout 11 Tree 1 DPW 2     1 Width 3ft   6005446.76573 2108031.65533 37.768561267704705 -122.424462530821 (37.7685612677047, -122.424462530821)
169800 221482 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 500x Guerrero St 2 Median : Cutout 11 Tree 1 DPW 2     1 Width 3ft   6005559.28434 2105952.19302 37.762857912083795 -122.423925449408 (37.7628579120838, -122.423925449408)
171233 221443 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 100x Guerrero St 16 Median : Cutout 11 Tree 1 DPW 2     1 Width 3ft   6005451.42839 2107920.02985 37.7682550341586 -122.42443846228599 (37.7682550341586, -122.424438462286)
176764 221549 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1000x Guerrero St 6 Median : Cutout 11 Tree 1 DPW 2     1 Width 3ft   6005728.89674 2102911.59468 37.7545187145683 -122.423122682192 (37.7545187145683, -122.423122682192)
177873 221550 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1000x Guerrero St 7 Median : Cutout 11 Tree 1 DPW 2     1 Width 3ft   6005729.97057 2102894.68155 37.7544723356343 -122.423117766494 (37.7544723356343, -122.423117766494)
179284 221563 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 4286 23rd St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6001305.60339 2102341.6071 37.752703058000705 -122.438378727412 (37.7527030580007, -122.438378727412)
179323 221491 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 500x Guerrero St 11 Median : Cutout 11 Tree 1 DPW 2     1 Width 3ft   6005578.642000001 2105634.14294 37.7619857144891 -122.423835881448 (37.7619857144891, -122.423835881448)
179875 221564 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 4286 23rd St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6001316.917769999 2102341.7359599997 37.7527040553705 -122.438339609582 (37.7527040553705, -122.438339609582)
181350 187782 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 101 Pennsylvania Ave 14 Front Yard : Yard 7 Tree 1 Private 1     1     6014325.58247 2106437.08289 37.764680319857995 -122.39363958970199 (37.764680319858, -122.393639589702)
184620 221570 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 117 Alpine Ter 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6001705.56397 2108155.3423 37.768688901296294 -122.437411868978 (37.7686889012963, -122.437411868978)
4319 221466 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 300x Guerrero St 11 Median : Cutout 11 Tree 1 DPW 2   06/19/2015 10:17:00 AM 2 Width 3ft   6005511.21858 2106780.74139 37.7651301958204 -122.42415061986601 (37.7651301958204, -122.424150619866)
4325 221461 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 300x Guerrero St 6 Median : Cutout 11 Tree 1 DPW 2   06/19/2015 10:37:00 AM 2 Width 3ft   6005500.86915 2106969.86586 37.7656489022957 -122.42419986763399 (37.7656489022957, -122.424199867634)
4332 221460 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 300x Guerrero St 5 Median : Cutout 11 Tree 1 DPW 2   06/19/2015 10:41:00 AM 2 Width 3ft   6005499.89777 2107004.0817 37.76574279600489 -122.424205661071 (37.7657427960049, -122.424205661071)
4334 221464 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 300x Guerrero St 9 Median : Cutout 11 Tree 1 DPW 2   06/19/2015 10:25:00 AM 2 Width 3ft   6005509.872909999 2106837.4843200003 37.7652859224425 -122.42415931 (37.7652859224425, -122.42415931)
4373 221456 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 300x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   06/19/2015 10:59:00 AM 2 Width 3ft   6005491.36744 2107155.48275 37.7661580255906 -122.424245934501 (37.7661580255906, -122.424245934501)
4379 221468 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 400x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   04/29/2015 10:37:00 AM 2 Width 3ft   6005525.86145 2106563.70328 37.764535087455 -122.42408453767099 (37.764535087455, -122.424084537671)
4384 221465 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 300x Guerrero St 10 Median : Cutout 11 Tree 1 DPW 2   06/19/2015 10:21:00 AM 2 Width 3ft   6005511.348730001 2106807.4282299997 37.76520347889029 -122.42415206777599 (37.7652034788903, -122.424152067776)
4403 221458 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 300x Guerrero St 3 Median : Cutout 11 Tree 1 DPW 2   06/19/2015 10:49:00 AM 2 Width 3ft   6005493.2574 2107088.45627 37.7659740935515 -122.424234630048 (37.7659740935515, -122.424234630048)
4454 221495 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 600x Guerrero St 2 Median : Cutout 11 Tree 1 DPW 2   02/21/2015 10:54:00 PM 2 Width 3ft   6005593.17627 2105367.35468 37.761253997298205 -122.42376664264299 (37.7612539972982, -122.423766642643)
4478 221500 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 600x Guerrero St 7 Median : Cutout 11 Tree 1 DPW 2   02/28/2015 11:10:00 PM 2 Width 3ft   6005602.08318 2105171.2083400004 37.7607159284129 -122.423721890569 (37.7607159284129, -122.423721890569)
4481 221502 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 600x Guerrero St 9 Median : Cutout 11 Tree 1 DPW 2   02/21/2015 11:07:00 PM 2 Width 3ft   6005607.7078 2105081.85863 37.760470912626296 -122.42369608451 (37.7604709126263, -122.42369608451)
4487 221504 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 600x Guerrero St 11 Median : Cutout 11 Tree 1 DPW 2   02/21/2015 11:05:00 PM 2 Width 3ft   6005611.75297 2105011.45268 37.7602778227802 -122.42367708812901 (37.7602778227802, -122.423677088129)
4491 221497 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 600x Guerrero St 4 Median : Cutout 11 Tree 1 DPW 2   02/21/2015 10:57:00 PM 2 Width 3ft   6005595.06917 2105295.4476799998 37.761056664463204 -122.42375498292499 (37.7610566644632, -122.423754982925)
4499 221499 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 600x Guerrero St 6 Median : Cutout 11 Tree 1 DPW 2   02/28/2015 11:01:00 PM 2 Width 3ft   6005601.090469999 2105206.48742 37.760812740428904 -122.42372783238899 (37.7608127404289, -122.423727832389)

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 111.596ms · Data source: data.sfgov.org