84 rows where PlotSize = "Width 0ft" and qSpecies_id = 6

View and edit SQL

PlotSize

  • Width 0ft · 84
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)
334 162296 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 299 Olmstead St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/23/2020 12:00:00 AM 3 Width 0ft   6010920.41592 2090984.45712 37.7220609417541 -122.40432950351 (37.7220609417541, -122.40432950351) 10 3 7 309 28
9692 183446 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2511 26th Ave 1 Sidewalk: Curb side : Yard Tree Private 2   10/08/2020 12:00:00 AM 3 Width 0ft   5988279.6214 2098205.3016 37.7405963382743 -122.483121197886 (37.7405963382743, -122.483121197886) 1 8 3 29491 35
9949 162295 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 299 Olmstead St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/23/2020 12:00:00 AM 3 Width 0ft   6010903.85659 2090979.54911 37.7220465400048 -122.404386400036 (37.7220465400048, -122.404386400036) 10 3 7 309 28
10037 183693 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1341 42nd Ave 7 Sidewalk: Curb side : Cutout Tree Private 2   05/05/2017 12:00:00 AM 3 Width 0ft   5983046.6569 2105897.5428 37.7614111825323 -122.501783460946 (37.7614111825323, -122.501783460946) 1 8 3 56 35
14976 160069 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1000 Cayuga Ave 12 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 11:26:00 AM 3 Width 0ft   6000296.79811 2090527.78789 37.7202076512361 -122.441019880684 (37.7202076512361, -122.441019880684) 9 7 6 28861 25
19993 182699 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1659 Moraga St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5989088.7291 2103739.8915 37.7558399109499 -122.480728726959 (37.7558399109499, -122.480728726959) 1 8 3 56 35
25751 182700 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1651 Moraga St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5989102.9459 2103739.8915 37.7558407372502 -122.480679561224 (37.7558407372502, -122.480679561224) 1 8 3 56 35
27064 182564 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2122 Ulloa St 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft Permit Number 783239 5989402.8067 2098365.7306 37.7411021315374 -122.479249432397 (37.7411021315374, -122.479249432397) 1 8 3 29491 35
28327 162331 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 26 Lee Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 02:09:00 PM 3 Width 0ft   5996526.61739 2090076.51041 37.7187530886569 -122.454019490912 (37.7187530886569, -122.454019490912) 9 8 6 28861 24
28544 159338 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 517 Ellington Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2017 11:04:00 AM 3 Width 0ft   5998112.9338 2087183.20699 37.7108995709325 -122.448328017142 (37.7108995709325, -122.448328017142) 9 7 6 28861 25
28945 157260 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1059 Portola Dr 1 Sidewalk: Curb side : Cutout Tree Private 2   05/31/2018 12:00:00 AM 3 Width 0ft Permit Number 781960 5995594.16193 2098091.79633 37.7407076181758 -122.457822284089 (37.7407076181758, -122.457822284089) 9 7 4 59 40
29174 183692 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1341 42nd Ave 6 Sidewalk: Curb side : Cutout Tree Private 2   05/05/2017 12:00:00 AM 3 Width 0ft   5983047.3598 2105912.7714 37.761453037237 -122.501782156698 (37.761453037237, -122.501782156698) 1 8 3 56 35
29694 248531 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 800 Shrader St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   5997658.268 2107761.8815 37.7673776340728 -122.451382700243 (37.7673776340728, -122.451382700243) 15 5 11 29492 9
29952 137671 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 756 LYON ST 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6000049.6788 2111547.4906 37.7779086039439 -122.443383113797 (37.7779086039439, -122.443383113797) 15 5 11 29490 16
30373 184599 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1795 40th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5983770.6594 2102984.6576 37.7534557168171 -122.499064248064 (37.7534557168171, -122.499064248064) 1 8 3 56 35
30582 183121 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2327 41st Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5983581.7952 2099373.3538 37.7435289932417 -122.49945051311 (37.7435289932417, -122.49945051311) 1 8 3 29491 35
35869 140696 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 162 Shrader St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5997358.0622 2109907.9029 37.7732528619693 -122.452575957146 (37.7732528619693, -122.452575957146) 15 5 11 29492 16
39727 182826 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1781 31st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5986558.6884 2103101.4836 37.7539396409234 -122.48943136929 (37.7539396409234, -122.48943136929) 1 8 3 56 35
41454 253116 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1000 Cayuga Ave 26 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 12:00:00 PM 3 Width 0ft   5999996.87806 2090379.50245 37.7197834059472 -122.442045963044 (37.7197834059472, -122.442045963044) 9 7 6 28861 25
44290 140758 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 42 TERRA VISTA AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6000316.7782 2112875.0348 37.7815689287559 -122.442554464995 (37.7815689287559, -122.442554464995) 15 5 1 29490 16
44798 184494 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1875 38th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     3 Width 0ft   5984410.615 2102424.5695 37.7519553887834 -122.496809845733 (37.7519553887834, -122.496809845733) 1 8 3 56 35
50194 183672 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1254 38th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5984312.3195 2106638.1262 37.7635188796404 -122.497460805156 (37.7635188796404, -122.497460805156) 1 8 3 56 35
51774 184549 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 3501 Moraga St 3 Sidewalk: Curb side : Yard Tree Private 2     1 Width 0ft   5983411.1343 2103548.3965 37.754982490057 -122.500349218821 (37.754982490057, -122.500349218821) 1 8 3 56 35
52571 182607 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1867 32nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/22/2018 12:00:00 AM 3 Width 0ft Permit Number 781588 5986269.2088 2102542.1488 37.7523869566931 -122.49039129916 (37.7523869566931, -122.49039129916) 1 8 3 56 35
56104 182307 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1509 29th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5987118.7965 2104973.5941 37.7591126281614 -122.487631931758 (37.7591126281614, -122.487631931758) 1 8 3 56 35
57846 159339 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 517 Ellington Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2017 11:12:00 AM 3 Width 0ft   5998126.45786 2087195.02696 37.7109327990681 -122.44828212563 (37.7109327990681, -122.44828212563) 9 7 6 28861 25
59117 184544 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 3425 Moraga St 1 Sidewalk: Curb side : Yard Tree Private 2   03/06/2018 12:00:00 AM 3 Width 0ft Permit Number 781517 5983632.4928 2103556.7404 37.7550183908439 -122.499584326949 (37.7550183908439, -122.499584326949) 1 8 3 56 35
60258 184208 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1474 40th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   5983740.5189 2105133.2538 37.7593533930501 -122.49932723943 (37.7593533930501, -122.49932723943) 1 8 3 56 35
77482 248399 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 115 Belvedere St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   5998223.6499 2108104.3812 37.7683504092774 -122.449451812394 (37.7683504092774, -122.449451812394) 15 5 11 29492 9
80153 183694 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1341 42nd Ave 8 Sidewalk: Curb side : Cutout Tree Private 2   05/05/2017 12:00:00 AM 3 Width 0ft   5983048.5312 2105875.9885 37.7613521106328 -122.501775383852 (37.7613521106328, -122.501775383852) 1 8 3 56 35
80180 160063 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1000 Cayuga Ave 6 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 11:07:00 AM 3 Width 0ft   6000471.59074 2090857.95331 37.7211241647202 -122.440439349407 (37.7211241647202, -122.440439349407) 9 7 6 28861 25
80376 184160 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 3538 Lawton St 1 Sidewalk: Curb side : Yard Tree Private 2   02/28/2018 12:00:00 AM 3 Width 0ft Permit Number 781479 5983222.1931 2104276.0104 37.7569692214498 -122.50105643195 (37.7569692214498, -122.50105643195) 1 8 3 56 35
81002 159346 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 461 Ellington Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2017 11:49:00 AM 3 Width 0ft   5998276.6806 2087336.80621 37.7113306798385 -122.44777312285 (37.7113306798385, -122.44777312285) 9 7 6 28861 25
92387 184697 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1616 43rd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   5982844.3503 2104136.3629 37.7565635951525 -122.502352798468 (37.7565635951525, -122.502352798468) 1 8 3 56 35
96117 184640 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1650 42nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5983160.9711 2103902.0944 37.7559389581009 -122.501240500695 (37.7559389581009, -122.501240500695) 1 8 3 56 35
96295 253108 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1000 Cayuga Ave 18 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 11:41:00 AM 3 Width 0ft   5999996.87806 2090379.50245 37.7197834059472 -122.442045963044 (37.7197834059472, -122.442045963044) 9 7 6 28861 25
97071 183696 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1341 42nd Ave 10 Sidewalk: Curb side : Cutout Tree Private 2   05/05/2017 12:00:00 AM 3 Width 0ft   5983051.3079 2105837.6039 37.7612468805065 -122.501762940556 (37.7612468805065, -122.501762940556) 1 8 3 56 35
104234 160065 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1000 Cayuga Ave 8 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 11:13:00 AM 3 Width 0ft   6000417.53141 2090750.67913 37.7208265358932 -122.440618525839 (37.7208265358932, -122.440618525839) 9 7 6 28861 25
104950 183303 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1286 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5982766.9656 2106385.9546 37.7627357893861 -122.502786935917 (37.7627357893861, -122.502786935917) 1 8 3 56 35
106816 181949 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2450 32nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5986451.9754 2098568.253 37.7414863814969 -122.489467090095 (37.7414863814969, -122.489467090095) 1 8 3 29491 35
109495 184723 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1635 42nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5983115.9866 2103988.5253 37.7561736313112 -122.501402462618 (37.7561736313112, -122.501402462618) 1 8 3 56 35
115203 183690 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1341 42nd Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   05/05/2017 12:00:00 AM 3 Width 0ft   5983045.4855 2105953.0685 37.7615635715471 -122.50179162058 (37.7615635715471, -122.50179162058) 1 8 3 56 35
117585 160061 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1000 Cayuga Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 11:02:00 AM 3 Width 0ft   6000547.45442 2091000.21878 37.7215191128017 -122.440187308101 (37.7215191128017, -122.440187308101) 9 7 6 28861 25
120653 200835 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1101 16th St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6013058.6169 2107038.7182 37.7662617940431 -122.398063928568 (37.7662617940431, -122.398063928568) 14 3 8 28856 20
122431 160059 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1000 Cayuga Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 10:50:00 AM 3 Width 0ft   6000588.55744 2091082.64129 37.7217477663201 -122.440051133668 (37.7217477663201, -122.440051133668) 9 7 6 28861 25
122783 159336 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 523 Ellington Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2017 10:36:00 AM 3 Width 0ft   5998080.57171 2087152.95418 37.7108146533454 -122.448437690352 (37.7108146533454, -122.448437690352) 9 7 6 28861 25
125420 245893 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1001 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6001728.4463 2109399.5631 37.772106523732 -122.437421829009 (37.772106523732, -122.437421829009) 15 5 11 29492 9
129143 181684 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1347 31st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5986459.3313 2106064.8642 37.7620704697574 -122.489992909675 (37.7620704697574, -122.489992909675) 1 8 3 56 35
129549 184161 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 3540 Lawton St 2 Sidewalk: Curb side : Yard Tree Private 2   02/28/2018 12:00:00 AM 3 Width 0ft Permit Number 781479 5983209.359 2104274.4825 37.7569642726582 -122.501100703383 (37.7569642726582, -122.501100703383) 1 8 3 56 35
129850 244513 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 500 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6004128.882 2109777.8057 37.7732812611379 -122.429145501014 (37.7732812611379, -122.429145501014) 7 9 11 29492 10
131978 141717 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2545 TURK BLVD 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   5998369.6346 2111707.5824 37.778252224784 -122.449206488012 (37.778252224784, -122.449206488012) 15 6 2 54 16
134028 181690 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1374 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5982168.1662 2105754.9295 37.7609679655916 -122.504811174863 (37.7609679655916, -122.504811174863) 1 8 3 56 35
135324 184721 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1630 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/02/2018 12:00:00 AM 3 Width 0ft Permit Number 781490 5982537.7064 2103994.8819 37.7561571061486 -122.503402789254 (37.7561571061486, -122.503402789254) 1 8 3 56 35
138543 183699 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1341 42nd Ave 13 Sidewalk: Curb side : Cutout Tree Private 2   05/05/2017 12:00:00 AM 3 Width 0ft   5983053.3747 2105791.1008 37.7611193175785 -122.501752351825 (37.7611193175785, -122.501752351825) 1 8 3 56 35
139614 159347 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 461 Ellington Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2017 11:27:00 AM 3 Width 0ft   5998288.37354 2087349.92963 37.7113673820764 -122.44773365339 (37.7113673820764, -122.44773365339) 9 7 6 28861 25
139625 184669 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1679 37th Ave 1 Sidewalk: Curb side : Yard Tree Private 2   01/03/2019 12:00:00 AM 3 Width 0ft Permit Number 782746 5984671.7436 2103779.4399 37.7556907855566 -122.496006782875 (37.7556907855566, -122.496006782875) 1 8 3 56 35
140348 183523 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2542 31st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   5986781.4828 2097933.2945 37.7397621847049 -122.488281131206 (37.7397621847049, -122.488281131206) 1 8 3 29491 35
140883 184598 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1795 40th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5983770.321 2103008.0087 37.7535198125919 -122.499067143504 (37.7535198125919, -122.499067143504) 1 8 3 56 35
141967 159345 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 461 Ellington Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2017 11:39:00 AM 3 Width 0ft   5998268.07471 2087327.6085 37.7113049331395 -122.447802205131 (37.7113049331395, -122.447802205131) 9 7 6 28861 25
143452 160073 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1000 Cayuga Ave 16 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 11:36:00 AM 3 Width 0ft   6000082.99934 2090399.7386 37.7198438772755 -122.441749724582 (37.7198438772755, -122.441749724582) 9 7 6 28861 25
145798 140302 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 143 COLE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5997780.8586 2110053.3207 37.773676357183 -122.451123943319 (37.773676357183, -122.451123943319) 15 5 11 29492 16
145954 184331 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 4020 Judah St 1 Sidewalk: Curb side : Cutout Tree DPW 1   09/19/2016 11:29:00 AM 10 Width 0ft   5981969.4907 2105600.2172 37.7605314799939 -122.505486826629 (37.7605314799939, -122.505486826629) 1 8 3 56 35
156762 253110 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1000 Cayuga Ave 20 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 11:46:00 AM 3 Width 0ft   5999996.87806 2090379.50245 37.7197834059472 -122.442045963044 (37.7197834059472, -122.442045963044) 9 7 6 28861 25
158809 184688 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1611 37th Ave 1 Sidewalk: Curb side : Yard Tree Private 2   01/03/2019 12:00:00 AM 3 Width 0ft Permit Number 782745 5984657.9281 2104207.7196 37.7568659135367 -122.496086155975 (37.7568659135367, -122.496086155975) 1 8 3 56 35
159564 247309 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 220 Pierce St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6002790.9139 2109368.8454 37.7720825259473 -122.433744475031 (37.7720825259473, -122.433744475031) 15 5 11 29492 9
161367 182659 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2252 Ortega St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5986985.3742 2102363.8158 37.7519391046129 -122.487901613135 (37.7519391046129, -122.487901613135) 1 8 3 56 35
163976 140699 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 224 ASHBURY ST 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5998816.4363 2109919.7991 37.7733689769062 -122.447532121663 (37.7733689769062, -122.447532121663) 15 5 11 29492 16
165323 160071 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1000 Cayuga Ave 14 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 11:31:00 AM 3 Width 0ft   6000209.4859 2090450.10808 37.7199893866688 -122.44131611827 (37.7199893866688, -122.44131611827) 9 7 6 28861 25
166863 140780 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 5 Encanto Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6000014.7367 2112198.3604 37.7796937331341 -122.443550757384 (37.7796937331341, -122.443550757384) 15 5 1 29490 16
171958 159348 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 461 Ellington Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2017 11:44:00 AM 3 Width 0ft   5998312.68186 2087372.36678 37.7114303786888 -122.447651252104 (37.7114303786888, -122.447651252104) 9 7 6 28861 25
172760 253118 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1000 Cayuga Ave 28 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 01:35:00 PM 3 Width 0ft   5999996.87806 2090379.50245 37.7197834059472 -122.442045963044 (37.7197834059472, -122.442045963044) 9 7 6 28861 25
173524 253112 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1000 Cayuga Ave 22 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 11:51:00 AM 3 Width 0ft   5999996.87806 2090379.50245 37.7197834059472 -122.442045963044 (37.7197834059472, -122.442045963044) 9 7 6 28861 25
175735 247385 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 355 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6002203.8017 2109776.7723 37.7731692596784 -122.435804531936 (37.7731692596784, -122.435804531936) 15 5 11 29492 9
181063 182513 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1573 34th Ave 1 Sidewalk: Curb side : Yard Tree Private 2   03/23/2018 12:00:00 AM 3 Width 0ft Permit Number 777985 5985578.9968 2104511.5721 37.7577541150318 -122.492923184352 (37.7577541150318, -122.492923184352) 1 8 3 56 35
181692 182658 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2242 Ortega St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5987004.6631 2102364.6195 37.7519424365087 -122.487834969288 (37.7519424365087, -122.487834969288) 1 8 3 56 35
182139 183687 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1341 42nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/05/2017 12:00:00 AM 3 Width 0ft Permit Number 33196 5983043.3769 2106010.2341 37.7617204082059 -122.501803142928 (37.7617204082059, -122.501803142928) 1 8 3 56 35
182173 253114 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1000 Cayuga Ave 24 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 11:55:00 AM 3 Width 0ft   5999996.87806 2090379.50245 37.7197834059472 -122.442045963044 (37.7197834059472, -122.442045963044) 9 7 6 28861 25
185726 200836 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1101 16th St 4 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   6013076.6871 2107039.6693 37.7662654119853 -122.398001493496 (37.7662654119853, -122.398001493496) 14 3 8 28856 20
185808 183691 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1341 42nd Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   05/05/2017 12:00:00 AM 3 Width 0ft   5983046.4226 2105931.5142 37.7615044445987 -122.501786784798 (37.7615044445987, -122.501786784798) 1 8 3 56 35
187202 183640 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1484 47th Ave 3 Sidewalk: Curb side : Yard Tree Private 2     3 Width 0ft   5981572.1323 2104991.2828 37.7588361283195 -122.506815916291 (37.7588361283195, -122.506815916291) 1 8 3 56 35
189393 162332 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 36 Lee Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 02:06:00 PM 3 Width 0ft   5996526.7373 2090117.21242 37.7188648537082 -122.45402201441 (37.7188648537082, -122.45402201441) 9 8 6 28861 24
191846 182083 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1101 Taraval St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/28/2017 12:33:00 PM 3 Width 0ft   5989775.2775 2098997.3719 37.7428580801695 -122.478007744126 (37.7428580801695, -122.478007744126) 1 8 3 29491 35
193090 184126 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1643 32nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   5986219.0266 2104040.7857 37.7564988729574 -122.490675089245 (37.7564988729574, -122.490675089245) 1 8 3 56 35
194395 183689 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1351 42nd Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   5983050 2105938 37.7615224629013 -122.501774892125 (37.7615224629013, -122.501774892125) 1 8 3 56 35

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