trees

267 rows where qSpecies_id = 100 sorted by TreeID descending

✎ View and edit SQL

This data as json, CSV (advanced)

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)
107393 98343 Undocumented 4 Pinus Spp :: Pine Spp 100 2999x Turk St 1 Sidewalk: Property side : Cutout Tree Private 2   02/01/2012 12:00:00 AM   5x3 Permit Number 768613 5996638 2111487 37.7775473668867 -122.455180869531 (37.7775473668867, -122.455180869531) 15 6 2 54 16
48765 98082 Significant Tree 6 Pinus Spp :: Pine Spp 100 525 Grafton Ave 1 Sidewalk: Property side : Cutout Tree Private 2           5995193.7 2090526.9 37.7199132334677 -122.45865940878 (37.7199132334677, -122.45865940878) 9 8 6 28861 24
105498 93932 Significant Tree 6 Pinus Spp :: Pine Spp 100     Front Yard : Yard Tree Private 2   04/28/2010 12:00:00 AM     Permit Number 53387 5990375.96797 2090932.55284 37.7207489795508 -122.475342064841 (37.7207489795508, -122.475342064841) 1 8 4 64 14
50522 93931 Significant Tree 6 Pinus Spp :: Pine Spp 100     Front Yard : Yard Tree Private 2   04/28/2010 12:00:00 AM     Permit Number 53387 5990375.96797 2090932.55284 37.7207489795508 -122.475342064841 (37.7207489795508, -122.475342064841) 1 8 4 64 14
162240 93928 Permitted Site 7 Pinus Spp :: Pine Spp 100 737 Gonzalez Dr 3 Sidewalk: Curb side : Yard Tree Private 2   04/28/2010 12:00:00 AM     Permit Number 53387 5988857.6 2089713.7 37.7173141872637 -122.480501360019 (37.7173141872637, -122.480501360019) 1 8 4 64 14
35747 93927 Permitted Site 7 Pinus Spp :: Pine Spp 100 737 Gonzalez Dr 2 Sidewalk: Curb side : Yard Tree Private 2   04/28/2010 12:00:00 AM     Permit Number 53387 5988857.6 2089713.7 37.7173141872637 -122.480501360019 (37.7173141872637, -122.480501360019) 1 8 4 64 14
177628 93925 Permitted Site 7 Pinus Spp :: Pine Spp 100 3711 19th Ave 2 Sidewalk: Curb side : Yard Tree Private 2           5990297.3 2090806 37.7203969366505 -122.475604756889 (37.7203969366505, -122.475604756889) 1 8 4 64 14
63239 93054 Permitted Site 7 Pinus Spp :: Pine Spp 100 737 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree Private 2   04/28/2010 12:00:00 AM 49   Permit Number 53387 5988857.6 2089713.7 37.7173141872637 -122.480501360019 (37.7173141872637, -122.480501360019) 1 8 4 64 14
12300 93053 Permitted Site 7 Pinus Spp :: Pine Spp 100     Front Yard : Yard Tree Private 2   04/28/2010 12:00:00 AM 36   Permit Number 53387                    
90168 91487 DPW Maintained 1 Pinus Spp :: Pine Spp 100 750x Brotherhood Way 21 Median : Cutout Tree DPW 1   03/15/2007 12:00:00 AM 3     5991053.474445 2088092.036965 37.7129888676025 -122.472793145921 (37.7129888676025, -122.472793145921) 1 8 4 64 14
3507 91430 DPW Maintained 1 Pinus Spp :: Pine Spp 100 800X Portola Dr 4 Median : Cutout Tree DPW 1   10/10/2005 12:00:00 AM   4x4   5996711.121131 2099335.742872 37.7441872967186 -122.454050104178 (37.7441872967186, -122.454050104178) 1 7 4 59 40
68559 91429 DPW Maintained 1 Pinus Spp :: Pine Spp 100 800X Portola Dr 3 Median : Cutout Tree DPW 1   10/10/2005 12:00:00 AM   4x4   5996711.121131 2099335.742872 37.7441872967186 -122.454050104178 (37.7441872967186, -122.454050104178) 1 7 4 59 40
52821 91428 DPW Maintained 1 Pinus Spp :: Pine Spp 100 800X Portola Dr 2 Median : Cutout Tree DPW 1   10/10/2005 12:00:00 AM 3 4x4   5996711.121131 2099335.742872 37.7441872967186 -122.454050104178 (37.7441872967186, -122.454050104178) 1 7 4 59 40
137658 91427 DPW Maintained 1 Pinus Spp :: Pine Spp 100 800X Portola Dr 1 Median : Cutout Tree DPW 1   10/10/2005 12:00:00 AM   4x4   5996711.121131 2099335.742872 37.7441872967186 -122.454050104178 (37.7441872967186, -122.454050104178) 1 7 4 59 40
93834 87762 Permitted Site 7 Pinus Spp :: Pine Spp 100 747 Howard St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/28/2008 12:00:00 AM   3x3 Permit Number 50415 6012202 2113577 37.7841666723804 -122.401486377799 (37.7841666723804, -122.401486377799) 6 2 9 28853 34
146890 815 DPW Maintained 1 Pinus Spp :: Pine Spp 100 600X 39th Ave 13 Median : Cutout Tree DPW 1     3 6-HOA   5983831.1679936 2111715.0127262 37.7774303425616 -122.499500145383 (37.7774303425616, -122.499500145383) 11 6 2 55 26
192591 808 DPW Maintained 1 Pinus Spp :: Pine Spp 100 600X 39th Ave 6 Median : Cutout Tree DPW 1     3 6-HOA   5983831.1679936 2111715.0127262 37.7774303425616 -122.499500145383 (37.7774303425616, -122.499500145383) 11 6 2 55 26
112548 3763 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1074 Carolina St 1 Median : Cutout Tree DPW 1     12 18   6012456.6037355 2102966.9856684 37.7550481677782 -122.399860245008 (37.7550481677782, -122.399860245008) 10 3 8 28856 29
167995 3761 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1074 Carolina St 1 Median : Cutout Tree DPW 1     12 18   6012458 2102979 37.7550812343514 -122.399856259894 (37.7550812343514, -122.399856259894) 10 3 8 28856 29
176168 3760 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1062X Carolina St 2 Median : Cutout Tree DPW 1     20     6012453.5755993 2103020.9691678 37.7551962258659 -122.399874507795 (37.7551962258659, -122.399874507795) 10 3 8 28856 29
173188 29631 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1110X Junipero Serra Blvd 4 Median : Cutout Tree DPW 1     3 3X3   5991107.8990451 2089843.5367701 37.717801208369 -122.47273266668 (37.717801208369, -122.47273266668) 9 8 4 64 40
985 262391 Private 9 Pinus Spp :: Pine Spp 100 2646 38th Ave 1 Back Yard : Yard Tree Private 2       Width 0ft   5984657 2097167 37.7375339667511 -122.495570077384 (37.7375339667511, -122.495570077384) 1 8 3 29491 35
15464 262332 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1X Cuesta Ct 1 Unaccepted Street : Yard Tree Private 2       3x3   5999654 2101769 37.7510367373071 -122.444049107076 (37.7510367373071, -122.444049107076) 2 5 5 63 38
1707 262090 DPW Maintained 1 Pinus Spp :: Pine Spp 100 498X Burnett Ave 2 Sidewalk: Property side : Cutout Tree DPW 1 Private     3x3   5999387 2102682 37.7535283774883 -122.445038044935 (37.7535283774883, -122.445038044935) 2 5 5 63 38
11844 262089 DPW Maintained 1 Pinus Spp :: Pine Spp 100 498X Burnett Ave 3 Sidewalk: Property side : Cutout Tree DPW 1 Private     3x3   5999387 2102682 37.7535283774883 -122.445038044935 (37.7535283774883, -122.445038044935) 2 5 5 63 38
1526 262088 DPW Maintained 1 Pinus Spp :: Pine Spp 100 498X Burnett Ave 4 Sidewalk: Property side : Cutout Tree DPW 1 Private     3x3   5999387 2102682 37.7535283774883 -122.445038044935 (37.7535283774883, -122.445038044935) 2 5 5 63 38
12562 262087 DPW Maintained 1 Pinus Spp :: Pine Spp 100 498X Burnett Ave 5 Sidewalk: Property side : Cutout Tree DPW 1 Private     3x3   5999387 2102682 37.7535283774883 -122.445038044935 (37.7535283774883, -122.445038044935) 2 5 5 63 38
1192 262086 DPW Maintained 1 Pinus Spp :: Pine Spp 100 498X Burnett Ave 6 Sidewalk: Property side : Cutout Tree DPW 1 Private     3x3   5999387 2102682 37.7535283774883 -122.445038044935 (37.7535283774883, -122.445038044935) 2 5 5 63 38
5089 262085 DPW Maintained 1 Pinus Spp :: Pine Spp 100 498X Burnett Ave 7 Sidewalk: Property side : Cutout Tree DPW 1 Private     3x3   5999387 2102682 37.7535283774883 -122.445038044935 (37.7535283774883, -122.445038044935) 2 5 5 63 38
13846 262084 DPW Maintained 1 Pinus Spp :: Pine Spp 100 498X Burnett Ave 8 Sidewalk: Property side : Cutout Tree DPW 1 Private     3x3   5999387 2102682 37.7535283774883 -122.445038044935 (37.7535283774883, -122.445038044935) 2 5 5 63 38
11958 262083 DPW Maintained 1 Pinus Spp :: Pine Spp 100 498X Burnett Ave 9 Sidewalk: Property side : Cutout Tree DPW 1 Private     3x3   5999387 2102682 37.7535283774883 -122.445038044935 (37.7535283774883, -122.445038044935) 2 5 5 63 38
18853 262082 DPW Maintained 1 Pinus Spp :: Pine Spp 100 498X Burnett Ave 1 Sidewalk: Property side : Cutout Tree DPW 1 Private     3x3   5999387 2102682 37.7535283774883 -122.445038044935 (37.7535283774883, -122.445038044935) 2 5 5 63 38
72516 258223 Significant Tree 6 Pinus Spp :: Pine Spp 100 53 Starr King Way 1 Sidewalk: Property side : Cutout Tree Private 2       Width 3ft Permit Number 782966 6005764 2113984 37.784922869937 -122.423788535241 (37.784922869937, -122.423788535241) 13 9 11 28858 41
113217 255048 Significant Tree 6 Pinus Spp :: Pine Spp 100 45 Eagle St 3 Front Yard : Yard Tree Private 2       Width 3ft   6000118.88808 2104341.86796 37.7581277146448 -122.44262619575 (37.7581277146448, -122.44262619575) 2 4 5 28862 3
1202 254563 DPW Maintained 1 Pinus Spp :: Pine Spp 100 98x High St 1 unknown : Yard Tree DPW 1       3x3   5999731 2100707 37.748125134697 -122.443706547761 (37.748125134697, -122.443706547761) 2 4 5 63 22
59834 253717 Significant Tree 6 Pinus Spp :: Pine Spp 100 4101 Balboa St 1 Back Yard : Yard Tree Private 2   01/08/2018 12:00:00 AM 3   Permit Number 780863 5982822 2110967 37.7753172554615 -122.50293574331 (37.7753172554615, -122.50293574331) 11 6 2 55 26
64164 251362 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1300X Stanyan St 1 Unaccepted Street : Yard Tree Private 2       3x3   5997565 2104877 37.7594511396077 -122.451497194349 (37.7594511396077, -122.451497194349) 15 5 11 28862 12
193767 251050 DPW Maintained 1 Pinus Spp :: Pine Spp 100 5800x Geary Blvd 1 Median : Yard Tree DPW 1     4 Width 10ft   5988878.2157 2112618.8979 37.7802069893248 -122.482107186669 (37.7802069893248, -122.482107186669) 11 6 2 55 26
90517 249887 DPW Maintained 1 Pinus Spp :: Pine Spp 100 230 Greenwich St 23 Back Yard : Yard Tree Private 2     9 Width 0ft   6011491.95227 2120439.55706 37.8029699659421 -122.404426114084 (37.8029699659421, -122.404426114084) 3 1 10 28860 6
103685 248958 Significant Tree 6 Pinus Spp :: Pine Spp 100 98x Rosewood Dr 1 Sidewalk: Curb side : Cutout Tree Private 2   03/06/2017 12:00:00 AM 3 3x3   5994824 2095658 37.7339807377795 -122.460308897898 (37.7339807377795, -122.460308897898) 9 8 4 59 40
3233 245150 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2     23 Width 0ft   6000845.3118 2109360.3422 37.7719485860085 -122.440473841976 (37.7719485860085, -122.440473841976) 15 5 11 29492 9
134476 245149 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1192 Page St 6 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 0ft   6000871.2374 2109327.7689 37.7718606240856 -122.440381827143 (37.7718606240856, -122.440381827143) 15 5 11 29492 9
192604 24284 DPW Maintained 1 Pinus Spp :: Pine Spp 100 300X Winding Way 22 Median : Cutout Tree DPW 1     6 8   6001646.2933309 2086550.8578367 37.7093646550959 -122.436070699117 (37.7093646550959, -122.436070699117) 9 7 6 28861 5
101304 24281 DPW Maintained 1 Pinus Spp :: Pine Spp 100 300X Winding Way 19 Median : Cutout Tree DPW 1     3 8   6001646.2933309 2086550.8578367 37.7093646550959 -122.436070699117 (37.7093646550959, -122.436070699117) 9 7 6 28861 5
15419 23925 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1700X Webster St 7 Median : Cutout Tree DPW 1     60 12x1   6003454.8844904 2114845.825423 37.7871586020093 -122.431838884639 (37.7871586020093, -122.431838884639) 13 9 11 29490 27
148969 23882 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1500X Webster St 5 Median : Cutout Tree DPW 1     20 12   6003644.6262703 2113904.6308207 37.7845850728987 -122.431115216253 (37.7845850728987, -122.431115216253) 13 9 11 29490 41
22262 23613 DPW Maintained 1 Pinus Spp :: Pine Spp 100 900X Vermont St 1 Sidewalk: Curb side : Cutout Tree DPW 1     36 30X30PL   6011293.8960822 2104150.9045186 37.7582340578883 -122.40396455427 (37.7582340578883, -122.40396455427) 10 3 8 28856 29
167924 23578 DPW Maintained 1 Pinus Spp :: Pine Spp 100 3100X Van Ness Ave 1 Median : Cutout Tree DPW 1     24 9   6005553.2513401 2120985.4040713 37.8041350589608 -122.425015980687 (37.8041350589608, -122.425015980687) 5 1 1 28858 32
78297 234492 DPW Maintained 1 Pinus Spp :: Pine Spp 100 33 Mars St 1 Sidewalk: Property side : Yard Tree Private 2     28 Width 3ft   5999611.22264 2105612.60046 37.7615878796102 -122.444473240453 (37.7615878796102, -122.444473240453) 15 5 5 28862 3
91858 234491 DPW Maintained 1 Pinus Spp :: Pine Spp 100 24 Saturn St 5 Side Yard : Yard Tree Private 2     17 Width 3ft   6000385.28479 2106021.72649 37.7627553749804 -122.44182544749 (37.7627553749804, -122.44182544749) 15 5 5 28862 3
398 234490 DPW Maintained 1 Pinus Spp :: Pine Spp 100 4053 20th St 1 Front Yard : Yard Tree Private 2     13 Width 3ft   6003306.74467 2104167.50736 37.7578301676468 -122.43158877311 (37.7578301676468, -122.43158877311) 2 4 5 28862 3
192049 234489 DPW Maintained 1 Pinus Spp :: Pine Spp 100 4067 20th St 2 Front Yard : Yard Tree Private 2     12 Width 3ft   6003294.37691 2104155.43702 37.7577963243568 -122.431630684215 (37.7577963243568, -122.431630684215) 2 4 5 28862 3
175552 234488 DPW Maintained 1 Pinus Spp :: Pine Spp 100 4090 20th St 7 : Yard Tree Private 2     16 Width 3ft   6003119.17834 2104176.3954 37.7578439389691 -122.432238089941 (37.7578439389691, -122.432238089941) 2 4 5 28862 3
141912 234486 DPW Maintained 1 Pinus Spp :: Pine Spp 100 787 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2     29 Width 3ft   6003746.3772 2103694.46852 37.756556224011 -122.430034597112 (37.756556224011, -122.430034597112) 2 4 5 28862 3
123375 234485 DPW Maintained 1 Pinus Spp :: Pine Spp 100 3690 21st St 3 Sidewalk: Property side : Yard Tree Private 2     21 Width 3ft   6003802.67178 2103657.18078 37.7564570287815 -122.429837250793 (37.7564570287815, -122.429837250793) 2 4 5 28862 3
130527 234484 DPW Maintained 1 Pinus Spp :: Pine Spp 100 310 Liberty St 42 Sidewalk: Curb side : Yard Tree Private 2     17 Width 3ft   6003878.87158 2103925.4289 37.7571978893843 -122.42959285554 (37.7571978893843, -122.42959285554) 2 4 5 28862 3
72931 234470 DPW Maintained 1 Pinus Spp :: Pine Spp 100 3717 23rd St 3 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6005016.09462 2102506.34942 37.7533657549424 -122.425558901529 (37.7533657549424, -122.425558901529) 2 4 5 28862 22
10838 233336 DPW Maintained 1 Pinus Spp :: Pine Spp 100 5545 Diamond Heights Blvd 4 Sidewalk: Property side : Yard Tree Private 2     11 Width 9ft   6001777.47587 2097325.41548 37.7389566084644 -122.436387932367 (37.7389566084644, -122.436387932367) 2 7 5 63 7
45445 21490 DPW Maintained 1 Pinus Spp :: Pine Spp 100 2792X Sunset Blvd 13 Sidewalk: Curb side : Cutout Tree DPW 1     3 60   5985060.3629888 2096294.4798015 37.7351618711636 -122.49411119238 (37.7351618711636, -122.49411119238) 1 8 3 29491 35
43322 21267 DPW Maintained 1 Pinus Spp :: Pine Spp 100 2492X Sunset Blvd 5 Sidewalk: Curb side : Cutout Tree DPW 1     3 60   5984994.4282385 2098239.2478178 37.740497824548 -122.494482465671 (37.740497824548, -122.494482465671) 1 8 3 29491 35
104875 211050 DPW Maintained 1 Pinus Spp :: Pine Spp 100 50 Garcia Ave 26 Sidewalk: Curb side : Yard Tree Private 2     20 Width 3ft   5994765.06139 2099250.41987 37.7438412428942 -122.460772924632 (37.7438412428942, -122.460772924632) 1 8 4 59 40
25634 211049 DPW Maintained 1 Pinus Spp :: Pine Spp 100 50 Garcia Ave 25 Sidewalk: Curb side : Yard Tree Private 2     23 Width 3ft   5994782.37935 2099248.26832 37.7438363316793 -122.460712887715 (37.7438363316793, -122.460712887715) 1 8 4 59 40
177806 211048 DPW Maintained 1 Pinus Spp :: Pine Spp 100 50 Garcia Ave 24 Sidewalk: Curb side : Yard Tree Private 2     25 Width 3ft   5994800.34548 2099248.4883 37.743837969354 -122.460650781424 (37.743837969354, -122.460650781424) 1 8 4 59 40
96210 211047 DPW Maintained 1 Pinus Spp :: Pine Spp 100 50 Garcia Ave 23 Sidewalk: Curb side : Yard Tree Private 2     14 Width 3ft   5994823.08708 2099248.01179 37.7438379693465 -122.460572112329 (37.7438379693465, -122.460572112329) 1 8 4 59 40
193841 211046 DPW Maintained 1 Pinus Spp :: Pine Spp 100 251 Wildwood Way 6 Sidewalk: Curb side : Yard Tree Private 2     19 Width 3ft   5995705.57302 2093291.07499 37.7275324053909 -122.457089894179 (37.7275324053909, -122.457089894179) 9 7 4 28861 40
124287 211045 DPW Maintained 1 Pinus Spp :: Pine Spp 100 380 Santa Clara Ave 6 Sidewalk: Curb side : Yard Tree Private 2     33 Width 3ft   5993150.7745 2095420.35942 37.7332318444736 -122.466076441693 (37.7332318444736, -122.466076441693) 9 8 4 59 40
98857 211044 DPW Maintained 1 Pinus Spp :: Pine Spp 100 372 Santa Clara Ave 3 Sidewalk: Curb side : Yard Tree Private 2     53 Width 3ft   5993146.9743 2095534.41654 37.7335447977497 -122.466097865337 (37.7335447977497, -122.466097865337) 9 8 4 59 40
40408 20784 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1701X Sunset Blvd 11 Sidewalk: Curb side : Cutout Tree DPW 1     12 60   5984888.092725 2103630.7874996 37.7552952964732 -122.49524762816 (37.7552952964732, -122.49524762816) 1 8 3 56 35
99835 20781 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1701X Sunset Blvd 8 Sidewalk: Curb side : Cutout Tree DPW 1     18 60   5984888.092725 2103630.7874996 37.7552952964732 -122.49524762816 (37.7552952964732, -122.49524762816) 1 8 3 56 35
154492 20647 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1501X Sunset Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 60   5984817.9532367 2104951.7766639 37.7589182591611 -122.495587616201 (37.7589182591611, -122.495587616201) 1 8 3 56 35
93621 20546 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1303X Sunset Blvd 24 Sidewalk: Curb side : Cutout Tree DPW 1     3 6O   5984802.8376111 2106327.3646052 37.7626943540195 -122.495741360313 (37.7626943540195, -122.495741360313) 1 8 3 56 35
151364 20534 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1303X Sunset Blvd 12 Sidewalk: Curb side : Cutout Tree DPW 1     6 6O   5984802.8376111 2106327.3646052 37.7626943540195 -122.495741360313 (37.7626943540195, -122.495741360313) 1 8 3 56 35
169637 20525 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1303X Sunset Blvd 3 Sidewalk: Curb side : Cutout Tree DPW 1     3 6O   5984802.8376111 2106327.3646052 37.7626943540195 -122.495741360313 (37.7626943540195, -122.495741360313) 1 8 3 56 35
7553 20501 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1204 Sunset Blvd 22 Sidewalk: Curb side : Cutout Tree Rec/Park 5     24 40   5984687.7602675 2107238.1673169 37.7651884221731 -122.496206568741 (37.7651884221731, -122.496206568741) 11 6 2 55 8
177971 200796 Undocumented 4 Pinus Spp :: Pine Spp 100 700 Jamestown Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6015315.685 2088368.925 37.7151238332906 -122.388953494511 (37.7151238332906, -122.388953494511) 10 3 8 58 1
17887 20041 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY51 12 Sidewalk: Curb side : Cutout Tree DPW 1     6 ST                      
72299 200142 Undocumented 4 Pinus Spp :: Pine Spp 100 700 Jamestown Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6015325.0376 2088350.2198 37.7150729908419 -122.388919862472 (37.7150729908419, -122.388919862472) 10 3 8 58 1
19337 20012 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY47 21 Sidewalk: Curb side : Cutout Tree DPW 1     6 100ST                      
4845 20011 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY47 20 Sidewalk: Curb side : Cutout Tree DPW 1     6 100ST                      
15362 20010 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY47 19 Sidewalk: Curb side : Cutout Tree DPW 1     12 100ST                      
11608 20009 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY47 18 Sidewalk: Curb side : Cutout Tree DPW 1     12 100ST                      
5085 19999 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY46 19 Sidewalk: Curb side : Cutout Tree DPW 1     12 40                      
6893 19997 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY46 17 Sidewalk: Curb side : Cutout Tree DPW 1     12 40                      
19429 19994 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY46 14 Sidewalk: Curb side : Cutout Tree DPW 1     12 40                      
4763 19993 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY46 13 Sidewalk: Curb side : Cutout Tree DPW 1     12 40                      
5857 19992 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY46 12 Sidewalk: Curb side : Cutout Tree DPW 1     12 40                      
6570 19989 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY46 9 Sidewalk: Curb side : Cutout Tree DPW 1     6 40                      
1785 19984 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY46 4 Sidewalk: Curb side : Cutout Tree DPW 1     18 40                      
16896 19981 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY46 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 40                      
17497 19970 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY44 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 15                      
6577 19937 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY38 6 Sidewalk: Curb side : Cutout Tree DPW 1     12 10ST                      
9396 19915 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY35 11 Sidewalk: Curb side : Cutout Tree DPW 1     6 120ST                      
7444 19914 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY35 10 Sidewalk: Curb side : Cutout Tree DPW 1     6 120ST                      
4582 19867 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY30 11 Sidewalk: Curb side : Cutout Tree DPW 1     24 100ST                      
668 19865 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY30 9 Sidewalk: Curb side : Cutout Tree DPW 1     24 100ST                      
16746 19862 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY30 6 Sidewalk: Curb side : Cutout Tree DPW 1     24 100ST                      
16655 19861 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY30 5 Sidewalk: Curb side : Cutout Tree DPW 1     24 30ST                      
3211 19860 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY30 4 Sidewalk: Curb side : Cutout Tree DPW 1     24 30ST                      
4956 19859 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY30 3 Sidewalk: Curb side : Cutout Tree DPW 1     24 30ST                      
9155 19858 DPW Maintained 1 Pinus Spp :: Pine Spp 100 100 STAIRWAY30 2 Sidewalk: Curb side : Cutout Tree DPW 1     24 30ST                      

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)
);