339 rows where qSpecies_id = 30 sorted by DBH

View and edit SQL

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH ▼ PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
53 264969 Undocumented 4 Acacia stenophylla :: Shoestring Acacia 30 1099X Hollister Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF     15x15   6014337 2089983 37.719501468928 -122.392449109694 (37.719501468928, -122.392449109694) 10 3 8 58 1
8773 262076 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 800X Alemany Blvd 16 Median : Cutout Tree DPW 1       3x3   6004191 2094544 37.7314563142861 -122.427844943089 (37.7314563142861, -122.427844943089) 9 7 6 28861 5
20296 43734 Permitted Site 7 Acacia stenophylla :: Shoestring Acacia 30 777 Lakeview Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/2000 12:00:00 AM     Permit Number 43371 5994281.26699369 2089905.22565848 37.7181537802459 -122.461768297306 (37.7181537802459, -122.461768297306) 9 8 6 28861 24
48008 43725 Permitted Site 7 Acacia stenophylla :: Shoestring Acacia 30 759 Lakeview Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/2000 12:00:00 AM     Permit Number 43364 5994445.58077229 2089904.10562801 37.7181601624587 -122.461200257981 (37.7181601624587, -122.461200257981) 9 8 6 28861 24
62006 43724 Permitted Site 7 Acacia stenophylla :: Shoestring Acacia 30 759 Lakeview Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/2000 12:00:00 AM     Permit Number 43364 5994445.58077229 2089904.10562801 37.7181601624587 -122.461200257981 (37.7181601624587, -122.461200257981) 9 8 6 28861 24
62222 54118 Permitted Site 7 Acacia stenophylla :: Shoestring Acacia 30 760 Lakeview Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/2000 12:00:00 AM     Permit Number 43365 5994428.64681371 2089956.34861374 37.7183026346731 -122.461262575973 (37.7183026346731, -122.461262575973) 9 8 6 28861 24
101099 115516 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 200x Guerrero St 7 Median : Cutout Tree DPW 1           6005415.2 2107753.5 37.7677957371292 -122.424551925681 (37.7677957371292, -122.424551925681) 8 4 5 28853 19
112972 88538 Undocumented 4 Acacia stenophylla :: Shoestring Acacia 30 1306 York St   Sidewalk: Property side : Cutout Tree Private 2   06/26/2009 12:00:00 AM   3x12 Permit Number 52223 6010027.5 2101589.4 37.7511299031436 -122.40816367022 (37.7511299031436, -122.40816367022) 2 4 7 28859 19
124564 257893 Undocumented 4 Acacia stenophylla :: Shoestring Acacia 30 23 Canyon Dr 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003365 2086282 37.7087239233851 -122.430111404197 (37.7087239233851, -122.430111404197) 9 7 6 28861 5
125308 43729 Permitted Site 7 Acacia stenophylla :: Shoestring Acacia 30 763 Lakeview Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/2000 12:00:00 AM     Permit Number 43366 5994409.95328954 2089904.45905166 37.7181590824666 -122.461323431638 (37.7181590824666, -122.461323431638) 9 8 6 28861 24
138398 43727 Permitted Site 7 Acacia stenophylla :: Shoestring Acacia 30 760 Lakeview Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   07/25/2000 12:00:00 AM     Permit Number 43365 5994428.64681371 2089956.34861374 37.7183026346731 -122.461262575973 (37.7183026346731, -122.461262575973) 9 8 6 28861 24
141785 43728 Permitted Site 7 Acacia stenophylla :: Shoestring Acacia 30 760 Lakeview Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   07/25/2000 12:00:00 AM     Permit Number 43365 5994428.64681371 2089956.34861374 37.7183026346731 -122.461262575973 (37.7183026346731, -122.461262575973) 9 8 6 28861 24
162604 115521 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 200x Guerrero St 12 Median : Cutout Tree DPW 1           6005415.2 2107753.5 37.7677957371292 -122.424551925681 (37.7677957371292, -122.424551925681) 8 4 5 28853 19
176610 43726 Permitted Site 7 Acacia stenophylla :: Shoestring Acacia 30 760 Lakeview Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   07/25/2000 12:00:00 AM     Permit Number 43365 5994428.64681371 2089956.34861374 37.7183026346731 -122.461262575973 (37.7183026346731, -122.461262575973) 9 8 6 28861 24
6810 243265 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 900x Guerrero St 7 Median : Cutout Tree DPW 1     0 3x3 Permit Number 56125 6005691.43766 2103575.20205 37.7563387121803 -122.42329939627 (37.7563387121803, -122.42329939627) 2 4 5 28859 19
12356 152416 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 700x Guerrero St 5 Median : Cutout Tree DPW 1     0 Width 3ft   6005631.99539 2104658.58909 37.7593100848133 -122.423581991114 (37.7593100848133, -122.423581991114) 2 4 5 28859 19
13699 152413 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 700x Guerrero St 2 Median : Cutout Tree DPW 1     0 Width 3ft   6005625.07408 2104777.98262 37.7596375207611 -122.423614417069 (37.7596375207611, -122.423614417069) 2 4 5 28859 19
18001 243333 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 900x Guerrero St 6 Median : Cutout Tree DPW 1     0 3x3 Permit Number 56125 6005703.0197 2103377.21002 37.7557957257993 -122.423245267872 (37.7557957257993, -122.423245267872) 2 4 5 28859 19
21108 243241 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 800x Guerrero St 11 Median : Cutout Tree DPW 1     0 Width 3ft   6005660.54217 2104179.64824 37.7579966366535 -122.423449213415 (37.7579966366535, -122.423449213415) 2 4 5 28859 19
38474 243239 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 800x Guerrero St 4 Median : Cutout Tree DPW 1     0 Width 3ft   6005667.36599 2103954.71663 37.7573794121443 -122.423409623453 (37.7573794121443, -122.423409623453) 2 4 5 28859 19
46202 152421 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 700x Guerrero St 10 Median : Cutout Tree DPW 1     0 Width 3ft   6005642.99765 2104457.73967 37.7587592203909 -122.42352966049 (37.7587592203909, -122.42352966049) 2 4 5 28859 19
52094 152420 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 700x Guerrero St 9 Median : Cutout Tree DPW 1     0 Width 3ft   6005641.89151 2104501.69931 37.7588798608311 -122.42353661134 (37.7588798608311, -122.42353661134) 2 4 5 28859 19
57039 152414 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 700x Guerrero St 3 Median : Cutout Tree DPW 1     0 Width 3ft   6005626.99355 2104746.96336 37.7595524574982 -122.423605573157 (37.7595524574982, -122.423605573157) 2 4 5 28859 19
58618 152419 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 700x Guerrero St 8 Median : Cutout Tree DPW 1     0 Width 3ft   6005637.90033 2104551.94757 37.7590176055009 -122.423553987148 (37.7590176055009, -122.423553987148) 2 4 5 28859 19
61134 152423 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 700x Guerrero St 12 Median : Cutout Tree DPW 1     0 Width 3ft   6005645.11359 2104396.78205 37.7585919644709 -122.423518008854 (37.7585919644709, -122.423518008854) 2 4 5 28859 19
81807 243240 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 800x Guerrero St 7 Median : Cutout Tree DPW 1     0 Width 3ft   6005663.74872 2104041.4182 37.7576172702474 -122.423428296996 (37.7576172702474, -122.423428296996) 2 4 5 28859 19
84453 152418 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 700x Guerrero St 7 Median : Cutout Tree DPW 1     0 Width 3ft   6005636.4507 2104585.07924 37.7591084954784 -122.42356135619 (37.7591084954784, -122.42356135619) 2 4 5 28859 19
96333 152415 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 700x Guerrero St 4 Median : Cutout Tree DPW 1     0 Width 3ft   6005628.48676 2104715.95286 37.7594673942256 -122.423598204106 (37.7594673942256, -122.423598204106) 2 4 5 28859 19
106244 152412 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 700x Guerrero St 1 Median : Cutout Tree DPW 1     0 Width 3ft   6005623.17605 2104812.38517 37.7597318749526 -122.4236234274 (37.7597318749526, -122.4236234274) 2 4 5 28859 19
107424 152417 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 700x Guerrero St 6 Median : Cutout Tree DPW 1     0 Width 3ft   6005634.27087 2104624.16733 37.7592156991708 -122.423571674116 (37.7592156991708, -122.423571674116) 2 4 5 28859 19
120577 221531 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1100x Guerrero St 11 Median : Cutout Tree DPW 1     0 Width 3ft   6005769.92765 2102140.767 37.7524045154572 -122.422926004956 (37.7524045154572, -122.422926004956) 2 4 5 28859 19
190784 152422 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 700x Guerrero St 11 Median : Cutout Tree DPW 1     0 Width 3ft   6005644.93763 2104427.72747 37.7586769234173 -122.423520817442 (37.7586769234173, -122.423520817442) 2 4 5 28859 19
1516 221470 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 400x Guerrero St 3 Median : Cutout Tree DPW 1   04/29/2015 10:30:00 AM 1 3x3 Permit Number 56125 6005530.44166 2106496.00345 37.7643494583795 -122.424063881144 (37.7643494583795, -122.424063881144) 8 4 5 28859 19
3421 221449 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 200x Guerrero St 7 Median : Cutout Tree DPW 1     1 Width 3ft   6005469.95975 2107527.18332 37.767177417921 -122.424346419355 (37.767177417921, -122.424346419355) 8 4 5 28853 19
5824 221435 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 100x Guerrero St 8 Median : Cutout Tree DPW 1   07/15/2016 05:58:00 AM 1 Width 3ft   6005438.10251 2108158.21074 37.7689082693198 -122.424501499347 (37.7689082693198, -122.424501499347) 8 4 5 28853 19
6153 221430 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 100x Guerrero St 3 Median : Cutout Tree DPW 1   07/15/2016 06:19:00 AM 1 Width 3ft   6005430.67341 2108312.23866 37.7693307735195 -122.424538153922 (37.7693307735195, -122.424538153922) 8 4 5 28853 19
12077 221469 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 400x Guerrero St 2 Median : Cutout Tree DPW 1   04/29/2015 10:33:00 AM 1 3x3   6005528.17729 2106528.83552 37.7644394796106 -122.424074047995 (37.7644394796106, -122.424074047995) 8 4 5 28859 19
12484 221478 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 400x Guerrero St 11 Median : Cutout Tree DPW 1   04/29/2015 05:18:00 AM 1 3x3 Permit Number 56125 6005544.06849 2106215.1538 37.7635790811436 -122.423996776447 (37.7635790811436, -122.423996776447) 8 4 5 28859 19
16547 221467 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 300x Guerrero St 12 Median : Cutout Tree DPW 1   06/19/2015 10:14:00 AM 1 3x3 Permit Number 56125 6005513.55753 2106751.9184 37.765051186799 -122.424140480012 (37.765051186799, -122.424140480012) 8 4 5 28853 19
22553 187785 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1740 20th St 2 Sidewalk: Property side : Yard Tree Private 2     1 Width 3ft   6012766.00153 2104746.33455 37.7599511143744 -122.398915128835 (37.7599511143744, -122.398915128835) 10 3 8 28856 29
22666 221560 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 100 San Jose Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6006161.42459 2102519.64651 37.7534669142699 -122.42159904898 (37.7534669142699, -122.42159904898) 2 4 5 28859 19
24279 175079 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1104x Alemany Blvd 1 Median : Yard Tree DPW 1     1 Width 10ft   6003837.73065 2094453.46286 37.7311877286109 -122.429059809376 (37.7311877286109, -122.429059809376) 9 7 6 28861 25
27676 221462 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 300x Guerrero St 7 Median : Cutout Tree DPW 1   06/19/2015 10:33:00 AM 1 Width 3ft   6005503.98521 2106938.10792 37.7655618784892 -122.424186831055 (37.7655618784892, -122.424186831055) 8 4 5 28853 19
31053 221448 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 200x Guerrero St 8 Median : Cutout Tree DPW 1   02/09/2016 12:52:00 PM 1 Width 3ft   6005473.21673 2107488.56627 37.7670715686321 -122.42433240701 (37.7670715686321, -122.42433240701) 8 4 5 28853 19
35097 221433 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 100x Guerrero St 6 Median : Cutout Tree DPW 1   07/15/2016 06:32:00 AM 1 Width 3ft   6005435.4614 2108218.98934 37.7690750036386 -122.424514958612 (37.7690750036386, -122.424514958612) 8 4 5 28853 19
41302 221436 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 100x Guerrero St 9 Median : Cutout Tree DPW 1   07/15/2016 06:05:00 AM 1 Width 3ft   6005440.21619 2108132.10005 37.7688366949854 -122.424492330751 (37.7688366949854, -122.424492330751) 8 4 5 28853 19
44242 221415 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 800x Guerrero St 1 Median : Cutout Tree DPW 1     1 Width 3ft   6005678.5014 2103825.14435 37.7570242653802 -122.423361901832 (37.7570242653802, -122.423361901832) 2 4 5 28859 19
44481 221476 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 400x Guerrero St 9 Median : Cutout Tree DPW 1   04/29/2015 09:37:00 AM 1 Width 3ft   6005539.09271 2106307.48846 37.7638323293302 -122.424020552718 (37.7638323293302, -122.424020552718) 8 4 5 28859 19
45616 221429 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 100x Guerrero St 2 Median : Cutout Tree DPW 1   07/15/2016 05:39:00 AM 1 Width 3ft   6005428.96653 2108339.30361 37.7694049909867 -122.424545983407 (37.7694049909867, -122.424545983407) 8 4 5 28853 19
47327 221479 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 400x Guerrero St 12 Median : Cutout Tree DPW 1   04/28/2015 07:46:00 PM 1 Width 3ft   6005545.66803 2106187.37905 37.7635029085615 -122.423989268902 (37.7635029085615, -122.423989268902) 8 4 5 28859 19
52247 221440 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 100x Guerrero St 13 Median : Cutout Tree DPW 1     1 Width 3ft   6005447.60224 2108007.88033 37.7684960344855 -122.424457946087 (37.7684960344855, -122.424457946087) 8 4 5 28853 19
67411 221445 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 200x Guerrero St 11 Median : Cutout Tree DPW 1   02/09/2016 10:50:00 AM 1 Width 3ft   6005479.31495 2107369.20417 37.7667441731271 -122.424302823815 (37.7667441731271, -122.424302823815) 8 4 5 28853 19
68150 221564 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 4286 23rd St 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6001316.91777 2102341.73596 37.7527040553705 -122.438339609582 (37.7527040553705, -122.438339609582) 2 4 5 28862 22
69768 221446 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 200x Guerrero St 10 Median : Cutout Tree DPW 1   02/09/2016 11:45:00 AM 1 Width 3ft   6005477.30623 2107402.8649 37.7668364840384 -122.424312165974 (37.7668364840384, -122.424312165974) 8 4 5 28853 19
71684 221447 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 200x Guerrero St 9 Median : Cutout Tree DPW 1   02/09/2016 12:33:00 PM 1 Width 3ft   6005477.00515 2107432.00792 37.7669164868187 -122.424315280345 (37.7669164868187, -122.424315280345) 8 4 5 28853 19
73744 221562 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 100 San Jose Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6006161.28805 2102498.92878 37.75341002046 -122.421598049829 (37.75341002046, -122.421598049829) 2 4 5 28859 19
77452 221561 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 100 San Jose Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6006161.81341 2102510.42937 37.7534416280528 -122.42159704977 (37.7534416280528, -122.42159704977) 2 4 5 28859 19
85250 221432 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 100x Guerrero St 5 Median : Cutout Tree DPW 1   07/15/2016 05:53:00 AM 1 Width 3ft   6005434.00046 2108253.10785 37.7691686023842 -122.424522439153 (37.7691686023842, -122.424522439153) 8 4 5 28853 19
88305 221454 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 200x Guerrero St 2 Median : Cutout Tree DPW 1   02/09/2016 12:48:00 PM 1 Width 3ft   6005462.2492 2107712.58298 37.7676860457059 -122.424386277315 (37.7676860457059, -122.424386277315) 8 4 5 28853 19
92341 221565 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 4286 23rd St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6001328.91667 2102339.67059 37.7526990668325 -122.438297967381 (37.7526990668325, -122.438297967381) 2 4 5 28862 22
94976 221471 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 400x Guerrero St 4 Median : Cutout Tree DPW 1   04/29/2015 10:27:00 AM 1 Width 3ft   6005532.14271 2106464.35389 37.7642626522337 -122.424055746783 (37.7642626522337, -122.424055746783) 8 4 5 28859 19
98181 221451 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 200x Guerrero St 5 Median : Cutout Tree DPW 1   02/09/2016 11:36:00 AM 1 Width 3ft   6005468.55001 2107589.96825 37.7673497307443 -122.424355761536 (37.7673497307443, -122.424355761536) 8 4 5 28853 19
99261 221483 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 500x Guerrero St 3 Median : Cutout Tree DPW 1     1 Width 3ft   6005560.35948 2105916.50249 37.7627599750213 -122.423919192812 (37.7627599750213, -122.423919192812) 8 4 5 28859 19
106689 221434 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 100x Guerrero St 7 Median : Cutout Tree DPW 1   07/15/2016 06:56:00 AM 1 Width 3ft   6005437.11129 2108190.56795 37.7689970584876 -122.42450722982 (37.7689970584876, -122.42450722982) 8 4 5 28853 19
109381 221441 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 100x Guerrero St 14 Median : Cutout Tree DPW 1     1 Width 3ft   6005450.56053 2107974.49254 37.7684045266634 -122.424445338474 (37.7684045266634, -122.424445338474) 8 4 5 28853 19
112321 221457 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 300x Guerrero St 2 Median : Cutout Tree DPW 1   06/19/2015 10:54:00 AM 1 Width 3ft   6005492.07657 2107122.67642 37.7660679872613 -122.424241148308 (37.7660679872613, -122.424241148308) 8 4 5 28853 19
112729 221431 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 100x Guerrero St 4 Median : Cutout Tree DPW 1   07/15/2016 06:43:00 AM 1 Width 3ft   6005433.2519 2108280.13408 37.769242767658 -122.424526951068 (37.769242767658, -122.424526951068) 8 4 5 28853 19
117709 221442 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 100x Guerrero St 15 Median : Cutout Tree DPW 1     1 Width 3ft   6005450.90289 2107942.80866 37.768317549645 -122.424441900367 (37.768317549645, -122.424441900367) 8 4 5 28853 19
119880 221473 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 400x Guerrero St 6 Median : Cutout Tree DPW 1   04/29/2015 10:20:00 AM 1 Width 3ft   6005534.54232 2106397.63335 37.7640795889285 -122.424042702116 (37.7640795889285, -122.424042702116) 8 4 5 28859 19
126359 221444 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 200x Guerrero St 12 Median : Cutout Tree DPW 1     1 Width 3ft   6005482.04836 2107327.01142 37.7666284762413 -122.424290368213 (37.7666284762413, -122.424290368213) 8 4 5 28853 19
135542 187782 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 101 Pennsylvania Ave 14 Front Yard : Yard Tree Private 2     1     6014325.58247 2106437.08289 37.764680319858 -122.393639589702 (37.764680319858, -122.393639589702) 14 3 8 310 29
136051 221508 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1201 San Jose Ave 15 Front Yard : Yard Tree Private 2     1     6004291.81357 2095940.5809 37.7352967139782 -122.427595874056 (37.7352967139782, -122.427595874056) 2 7 5 28861 2
137951 221439 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 100x Guerrero St 12 Median : Cutout Tree DPW 1     1 Width 3ft   6005446.76573 2108031.65533 37.7685612677047 -122.424462530821 (37.7685612677047, -122.424462530821) 8 4 5 28853 19
142195 221437 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 100x Guerrero St 10 Median : Cutout Tree DPW 1   07/15/2016 06:48:00 AM 1 Width 3ft   6005441.98545 2108105.33614 37.7687633076137 -122.424484307027 (37.7687633076137, -122.424484307027) 8 4 5 28853 19
142764 221453 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 200x Guerrero St 3 Median : Cutout Tree DPW 1   02/09/2016 12:40:00 PM 1 Width 3ft   6005462.88888 2107675.99901 37.7675856309877 -122.424381462352 (37.7675856309877, -122.424381462352) 8 4 5 28853 19
143846 221417 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 800x Guerrero St 3 Median : Cutout Tree DPW 1     1 Width 3ft   6005673.16306 2103886.4908 37.7571924071266 -122.423384724831 (37.7571924071266, -122.423384724831) 2 4 5 28859 19
145933 221566 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 4286 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6001342.88204 2102344.46852 37.7527130350975 -122.438250016433 (37.7527130350975, -122.438250016433) 2 4 5 28862 22
154318 221443 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 100x Guerrero St 16 Median : Cutout Tree DPW 1     1 Width 3ft   6005451.42839 2107920.02985 37.7682550341586 -122.424438462286 (37.7682550341586, -122.424438462286) 8 4 5 28853 19
155313 221482 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 500x Guerrero St 2 Median : Cutout Tree DPW 1     1 Width 3ft   6005559.28434 2105952.19302 37.7628579120838 -122.423925449408 (37.7628579120838, -122.423925449408) 8 4 5 28859 19
156067 221563 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 4286 23rd St 4 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6001305.60339 2102341.6071 37.7527030580007 -122.438378727412 (37.7527030580007, -122.438378727412) 2 4 5 28862 22
159617 221472 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 400x Guerrero St 5 Median : Cutout Tree DPW 1   04/29/2015 10:24:00 AM 1 Width 3ft   6005534.31082 2106426.8401 37.7641597706703 -122.424045579956 (37.7641597706703, -122.424045579956) 8 4 5 28859 19
162498 221455 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 200x Guerrero St 1 Median : Cutout Tree DPW 1   02/09/2016 12:55:00 PM 1 Width 3ft   6005458.87953 2107745.71785 37.7677768358576 -122.424400289657 (37.7677768358576, -122.424400289657) 8 4 5 28853 19
167540 221475 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 400x Guerrero St 8 Median : Cutout Tree DPW 1   04/29/2015 10:13:00 AM 1 Width 3ft   6005538.26376 2106334.58706 37.7639066888645 -122.424025347 (37.7639066888645, -122.424025347) 8 4 5 28859 19
168740 221570 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 117 Alpine Ter 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6001705.56397 2108155.3423 37.7686889012963 -122.437411868978 (37.7686889012963, -122.437411868978) 15 5 5 29492 3
169286 221474 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 400x Guerrero St 7 Median : Cutout Tree DPW 1   04/29/2015 10:16:00 AM 1 Width 3ft   6005537.16302 2106367.52425 37.7639970644374 -122.424031496564 (37.7639970644374, -122.424031496564) 8 4 5 28859 19
171592 221452 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 200x Guerrero St 4 Median : Cutout Tree DPW 1   02/09/2016 11:41:00 AM 1 Width 3ft   6005465.56003 2107641.57919 37.7674912732207 -122.424369774755 (37.7674912732207, -122.424369774755) 8 4 5 28853 19
175672 221477 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 400x Guerrero St 10 Median : Cutout Tree DPW 1   04/29/2015 05:29:00 AM 1 Width 3ft   6005543.73868 2106251.90953 37.7636799850545 -122.424000531101 (37.7636799850545, -122.424000531101) 8 4 5 28859 19
176363 221550 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1000x Guerrero St 7 Median : Cutout Tree DPW 1     1 Width 3ft   6005729.97057 2102894.68155 37.7544723356343 -122.423117766494 (37.7544723356343, -122.423117766494) 2 4 5 28859 19
177960 221491 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 500x Guerrero St 11 Median : Cutout Tree DPW 1     1 Width 3ft   6005578.642 2105634.14294 37.7619857144891 -122.423835881448 (37.7619857144891, -122.423835881448) 8 4 5 28859 19
186895 221549 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1000x Guerrero St 6 Median : Cutout Tree DPW 1     1 Width 3ft   6005728.89674 2102911.59468 37.7545187145683 -122.423122682192 (37.7545187145683, -122.423122682192) 2 4 5 28859 19
187472 221450 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 200x Guerrero St 6 Median : Cutout Tree DPW 1   02/09/2016 11:34:00 AM 1 Width 3ft   6005469.47774 2107557.31332 37.7672601204903 -122.424350229795 (37.7672601204903, -122.424350229795) 8 4 5 28853 19
189657 221428 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 100x Guerrero St 1 Median : Cutout Tree DPW 1   07/15/2016 05:47:00 AM 1 Width 3ft   6005427.7802 2108362.05998 37.7694674075229 -122.424551705821 (37.7694674075229, -122.424551705821) 8 4 5 28853 19
190176 184203 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1466 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5983430.71 2105161.519 37.7594128206633 -122.500400782356 (37.7594128206633, -122.500400782356) 1 8 3 56 35
193830 221480 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 400x Guerrero St 13 Median : Cutout Tree DPW 1   04/29/2015 05:03:00 AM 1 Width 3ft   6005548.13055 2106148.77804 37.7633970583515 -122.423978006683 (37.7633970583515, -122.423978006683) 8 4 5 28859 19
63104 221529 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1200x Guerrero St 1 Median : Cutout Tree DPW 1     10 Width 3ft   6005786.9094 2101880.52554 37.751690910628 -122.422848785557 (37.751690910628, -122.422848785557) 2 4 5 28859 19
45188 221530 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1100x Guerrero St 12 Median : Cutout Tree DPW 1     11 Width 3ft   6005772.5167 2102115.11175 37.7523342181522 -122.422915228372 (37.7523342181522, -122.422915228372) 2 4 5 28859 19
20283 221522 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 1200x Guerrero St 11 Median : Cutout Tree DPW 1     18 Width 3ft   6005804.6365 2101559.54048 37.7508105597627 -122.42276467377 (37.7508105597627, -122.42276467377) 2 4 5 28859 19
813 221494 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 600x Guerrero St 1 Median : Cutout Tree DPW 1   02/21/2015 10:53:00 PM 2 3x3 Permit Number 56125 6005589.49697 2105398.29386 37.7613387412987 -122.423781567769 (37.7613387412987, -122.423781567769) 2 4 5 28859 19
1562 221496 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 600x Guerrero St 3 Median : Cutout Tree DPW 1   02/21/2015 12:00:00 AM 2 3x3 Permit Number 56125 6005594.03058 2105332.56679 37.7611585261709 -122.423761214331 (37.7611585261709, -122.423761214331) 2 4 5 28859 19
3217 221495 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 30 600x Guerrero St 2 Median : Cutout Tree DPW 1   02/21/2015 10:54:00 PM 2 3x3 Permit Number 56125 6005593.17627 2105367.35468 37.7612539972982 -122.423766642643 (37.7612539972982, -122.423766642643) 2 4 5 28859 19

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);