290 rows where Police Districts = 7 and qSpecies_id = 6 sorted by XCoord

View and edit SQL

These facets timed out: Police Districts

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)
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
47209 165132 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 929 Monterey Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/22/2018 12:00:00 AM 3 3x3 Permit Number 781230 5995776.8676 2094560.79185 37.7310228361347 -122.456935228771 (37.7310228361347, -122.456935228771) 9 7 4 28861 40
92269 165133 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 929 Monterey Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/22/2018 12:00:00 AM 3 3x3 Permit Number 781230 5995820.38989 2094571.40487 37.731054476063 -122.456785533051 (37.731054476063, -122.456785533051) 9 7 4 28861 40
70068 207041 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1414 Plymouth Ave 1 Sidewalk: Curb side : Yard Tree Private 2     8 Width 3ft   5995889.45634 2093373.14104 37.727768297568 -122.456460143934 (37.727768297568, -122.456460143934) 9 7 4 28861 40
48472 207040 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 115 Greenwood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5996029.16987 2093727.86128 37.7287502942706 -122.456002788314 (37.7287502942706, -122.456002788314) 9 7 4 28861 40
26675 207018 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 466 Staples Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   5997114.73821 2093838.00202 37.7291149630685 -122.452257872798 (37.7291149630685, -122.452257872798) 9 7 4 28861 40
113846 207017 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 466 Staples Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   5997128.21176 2093837.95674 37.7291156105912 -122.452211290622 (37.7291156105912, -122.452211290622) 9 7 4 28861 40
132775 180842 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 87 Laura St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/10/2017 03:54:00 PM 3 Width 2ft   5997291.8877 2087045.22216 37.710473721248 -122.451155786013 (37.710473721248, -122.451155786013) 9 7 6 28861 25
147878 207049 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 662 Joost Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   5997703.56918 2095007.7992 37.7323606631136 -122.450306536421 (37.7323606631136, -122.450306536421) 9 7 4 59 40
29381 94673 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 662 Joost Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/22/2010 12:00:00 AM   3x3 Permit Number 53809 5997706.3 2095032.9 37.7324297402139 -122.450298904109 (37.7324297402139, -122.450298904109) 9 7 4 59 40
6051 207048 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 658 Joost Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/20/2017 12:00:00 AM 3 Width 2ft Permit Number 772511 5997718.79866 2095007.66028 37.7323611532403 -122.450253874818 (37.7323611532403, -122.450253874818) 9 7 4 59 40
79056 94672 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 658 Joost Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/22/2010 12:00:00 AM   3x3 Permit Number 53808 5997731.1 2095032.6 37.732430335747 -122.450213143469 (37.732430335747, -122.450213143469) 9 7 4 59 40
19808 207047 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 654 Joost Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   5997739.24902 2095008.66176 37.7323650733825 -122.450183245677 (37.7323650733825, -122.450183245677) 9 7 4 59 40
109198 94671 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 654 Joost Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/22/2010 12:00:00 AM   3x3 Permit Number 53807 5997755.7 2095032.2 37.7324306451966 -122.450128067067 (37.7324306451966, -122.450128067067) 9 7 4 59 40
189614 94670 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 654 Joost Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/22/2010 12:00:00 AM   3x3 Permit Number 53807 5997755.7 2095032.2 37.7324306451966 -122.450128067067 (37.7324306451966, -122.450128067067) 9 7 4 59 40
173911 207046 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 654 Joost Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   5997758.19926 2095006.4821 37.7323601729864 -122.450117573561 (37.7323601729864, -122.450117573561) 9 7 4 59 40
81975 207014 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 651 Joost Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   11/20/2017 12:00:00 AM 3 Width 1ft Permit Number 771866 5997782.54111 2094977.36202 37.7322816090925 -122.450031320482 (37.7322816090925, -122.450031320482) 9 7 4 59 40
57763 207044 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 755 Foerster St 1 Sidewalk: Property side : Yard Tree Private 2     4 Width 3ft   5998014.32968 2095894.50831 37.7348131350024 -122.44929603208 (37.7348131350024, -122.44929603208) 9 7 4 59 40
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
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
139943 115757 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1718 Cayuga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3   Permit Number 772425 5998122.34061 2088716.21291 37.7151093927473 -122.448405831859 (37.7151093927473, -122.448405831859) 9 7 6 28861 25
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
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
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
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
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
94734 207019 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 234 Staples Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 1ft   5998513.62611 2093807.4558 37.7291111292533 -122.447419626323 (37.7291111292533, -122.447419626323) 9 7 4 28861 40
113520 207008 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 451 Hearst Ave 23 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   5998589.10288 2094366.3057 37.730649912467 -122.447198902106 (37.730649912467, -122.447198902106) 9 7 4 28861 40
184989 207009 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 451 Hearst Ave 26 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   5998610.96321 2094365.8508 37.7306499124634 -122.447123295197 (37.7306499124634, -122.447123295197) 9 7 4 28861 40
47657 207016 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 409 Edna St 5 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 1ft   5998750.98669 2094179.12135 37.7301451967391 -122.446625784855 (37.7301451967391, -122.446625784855) 9 7 4 28861 40
108686 207015 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 409 Edna St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 1ft   5998751.39592 2094165.76826 37.7301085556677 -122.446623409741 (37.7301085556677, -122.446623409741) 9 7 4 28861 40
66000 88139 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 523 Teresita Blvd   Sidewalk: Curb side : Cutout Tree Private 2   07/07/2008 12:00:00 AM   3x3 Permit Number 51168 5998937.5 2097522.9 37.7393370734625 -122.446221422912 (37.7393370734625, -122.446221422912) 9 7 4 59 40
161683 207045 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 607 Teresita Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5998977.59415 2096753.43976 37.7372266087217 -122.446027465895 (37.7372266087217, -122.446027465895) 9 7 4 59 40
12813 207010 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 305 Hearst Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   5999351.3193 2094355.62728 37.7306641145479 -122.444563045861 (37.7306641145479, -122.444563045861) 9 7 4 28861 40
163948 42105 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 305 Hearst Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/21/2008 12:00:00 AM   3x3 Permit Number 51455 5999382.77994639 2094344.80390055 37.730636191214 -122.444453504412 (37.730636191214, -122.444453504412) 9 7 4 28861 40
17284 81630 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 50 Paulding St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     5999996.8419 2093367.66723 37.7279882186648 -122.44226048643 (37.7279882186648, -122.44226048643) 9 7 6 28861 25
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
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
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
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
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
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
194121 52944 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 20 Paulding St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/03/2006 12:00:00 AM     Permit Number 48931 6000207.27773758 2093260.71462594 37.727706542786 -122.441525334084 (37.727706542786, -122.441525334084) 9 7 6 28861 25
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
115282 207013 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 178 Hearst Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6000221.87075 2094376.84303 37.7307720044131 -122.441554946711 (37.7307720044131, -122.441554946711) 9 7 4 63 40
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
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
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
39381 181028 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 95 Rolph St 2 Sidewalk: Curb side : Yard Tree Private 2   10/05/2017 04:38:00 PM 3 Width 4ft   6000533.08885 2088674.46766 37.7151323074928 -122.440070279342 (37.7151323074928, -122.440070279342) 9 7 6 28861 5
133452 181027 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 95 Rolph St 1 Sidewalk: Curb side : Yard Tree Private 2   10/05/2017 04:23:00 PM 3 Width 4ft   6000546.58685 2088667.24811 37.7151132526545 -122.440023107188 (37.7151132526545, -122.440023107188) 9 7 6 28861 5
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
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
131707 52954 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 975 Cayuga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/03/2006 12:00:00 AM 5   Permit Number 48941 6000767.51384 2091342.11633 37.7224704120511 -122.439451120374 (37.7224704120511, -122.439451120374) 9 7 6 28861 25
15013 170657 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 399X San Juan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/19/2019 12:00:00 AM 3 Width 3ft   6000770.58972 2092571.08998 37.7258450685777 -122.439528544816 (37.7258450685777, -122.439528544816) 9 7 6 28861 25
1882 170658 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 399X San Juan Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/19/2019 12:00:00 AM 3 4x6   6000800.50336 2092551.29112 37.7257924078835 -122.439423717141 (37.7257924078835, -122.439423717141) 9 7 6 28861 25
14410 170659 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 399X San Juan Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   02/19/2019 12:00:00 AM 3 6x4   6000830.95965 2092528.01217 37.7257302224446 -122.439316764384 (37.7257302224446, -122.439316764384) 9 7 6 28861 25
10461 170660 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 301X San Juan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/19/2020 12:00:00 AM 3 Width 3ft   6000886.10189 2092489.73569 37.7256282618212 -122.439123400224 (37.7256282618212, -122.439123400224) 9 7 6 28861 25
17874 170661 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 301X San Juan Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/19/2019 12:00:00 AM 3 Width 3ft   6000920.86362 2092466.57168 37.7255666366796 -122.439001572678 (37.7255666366796, -122.439001572678) 9 7 6 28861 25
57710 181021 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 179 Rolph St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/10/2017 12:49:00 PM 3 8x6   6000934.69942 2088437.13017 37.71450348711 -122.438665147076 (37.71450348711, -122.438665147076) 9 7 6 28861 5
117385 181020 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 183 Rolph St 1 Sidewalk: Curb side : Yard Tree Private 2   10/10/2017 12:41:00 PM 3 Width 4ft   6000952.49174 2088426.93011 37.7144764921819 -122.438602919392 (37.7144764921819, -122.438602919392) 9 7 6 28861 5
109143 181019 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 191 Rolph St 1 Sidewalk: Curb side : Yard Tree Private 2   10/10/2017 12:36:00 PM 3 Width 4ft   6000981.45407 2088409.26942 37.7144296473919 -122.438501549606 (37.7144296473919, -122.438501549606) 9 7 6 28861 5
30385 181018 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 197 Rolph St 2 Sidewalk: Curb side : Yard Tree Private 2   10/10/2017 11:31:00 AM 3 Width 4ft   6001005.57228 2088396.04691 37.7143947132291 -122.43841724089 (37.7143947132291, -122.43841724089) 9 7 6 28861 5
194177 181017 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 197 Rolph St 1 Sidewalk: Curb side : Yard Tree Private 2   10/10/2017 11:28:00 AM 3 Width 4ft   6001019.31887 2088386.79799 37.7143700996689 -122.438369065102 (37.7143700996689, -122.438369065102) 9 7 6 28861 5
2654 108556 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 62 San Gabriel Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/09/2019 12:00:00 AM 3 3x3 Permit Number 773715 6001062.72482 2093636.21513 37.7287862806562 -122.43859494063 (37.7287862806562, -122.43859494063) 9 7 6 28861 25
1269 262440 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 99 San Gabriel Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/09/2019 12:00:00 AM 3 Width 4ft   6001119 2093653 37.728835569179 -122.438401596107 (37.728835569179, -122.438401596107) 9 7 6 28861 25
2939 262442 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 99 San Gabriel Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   02/09/2019 12:00:00 AM 3 Width 4ft   6001119 2093653 37.728835569179 -122.438401596107 (37.728835569179, -122.438401596107) 9 7 6 28861 25
15310 262443 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 99 San Gabriel Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   02/09/2019 12:00:00 AM 3 Width 4ft   6001119 2093653 37.728835569179 -122.438401596107 (37.728835569179, -122.438401596107) 9 7 6 28861 25
15599 262439 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 99 San Gabriel Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/09/2019 12:00:00 AM 3 Width 4ft   6001119 2093653 37.728835569179 -122.438401596107 (37.728835569179, -122.438401596107) 9 7 6 28861 25
168066 181011 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 207 Rolph St 1 Sidewalk: Curb side : Yard Tree Private 2   10/10/2017 11:21:00 AM 3 Width 4ft   6001121.31583 2088326.00254 37.7142089699327 -122.438012171843 (37.7142089699327, -122.438012171843) 9 7 6 28861 5
192989 181010 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 215 Rolph St 1 Sidewalk: Curb side : Yard Tree Private 2   10/10/2017 11:17:00 AM 3 Width 4ft   6001139.6561 2088316.90059 37.7141850209845 -122.437948129327 (37.7141850209845, -122.437948129327) 9 7 6 28861 5
84873 69398 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1174 Munich St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/09/1994 12:00:00 AM 6   Permit Number 33502 6001210.49529 2087131.44104 37.7109340401325 -122.43761843606 (37.7109340401325, -122.43761843606) 9 7 6 28861 5
74921 227129 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 291 Sussex St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   6001319.20971 2096463.36674 37.7365635736601 -122.437910673444 (37.7365635736601, -122.437910673444) 2 7 5 63 7
53980 207012 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 16 Circular Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6001339.26796 2094505.80603 37.731189705325 -122.437701168268 (37.731189705325, -122.437701168268) 9 7 4 63 40
45819 207011 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 16 Circular Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6001351.22893 2094512.68179 37.7312092646733 -122.437660309391 (37.7312092646733, -122.437660309391) 9 7 4 63 40
186495 57147 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 578 London St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/2012 12:00:00 AM 6 4x4 Permit Number 14422 6001353.29798 2090440.69811 37.7200286411902 -122.4373616868 (37.7200286411902, -122.4373616868) 9 7 6 28861 5
72338 227121 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 791 27th St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6001433.87774 2099966.59062 37.7461891245209 -122.437765046244 (37.7461891245209, -122.437765046244) 2 7 5 63 22
181974 227119 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 799 Duncan St 4 Sidewalk: Property side : Yard Tree Private 2     11 Width 4ft   6001473.16561 2099668.76787 37.7453736076231 -122.437607869022 (37.7453736076231, -122.437607869022) 2 7 5 63 22
192824 227120 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 799 Duncan St 6 Sidewalk: Property side : Yard Tree Private 2     3 Width 4ft   6001486.23397 2099669.55813 37.7453765205103 -122.43756273743 (37.7453765205103, -122.43756273743) 2 7 5 63 22
15346 262448 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 145 Santa Rosa Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/09/2019 12:00:00 AM 3 3x3   6001496 2093037 37.7271656105126 -122.43705419947 (37.7271656105126, -122.43705419947) 9 7 6 28861 25
154340 176919 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 140 Seville St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 5ft   6001505.61042 2087336.29034 37.7115132862848 -122.436613103724 (37.7115132862848, -122.436613103724) 9 7 6 28861 5
29210 176917 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1002x Naples St 9 Median : Yard Tree DPW 1     3     6001514.03799 2088123.65893 37.7136757052349 -122.436640299224 (37.7136757052349, -122.436640299224) 9 7 6 28861 5
58866 116551 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1002x Naples St 7 Median : Yard Tree DPW 1     4 3x3   6001523.56178 2088140.13665 37.713721490625 -122.436608560332 (37.713721490625, -122.436608560332) 9 7 6 28861 5
123255 116550 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1002x Naples St 6 Median : Yard Tree DPW 1     5 3x3   6001534.78323 2088160.34451 37.7137776146169 -122.436571220504 (37.7137776146169, -122.436571220504) 9 7 6 28861 5
144424 116545 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1041x Naples St 1 Median : Yard Tree DPW 1     2 3x3   6001537.05763 2088100.5912 37.7136136745151 -122.436559085032 (37.7136136745151, -122.436559085032) 9 7 6 28861 5
138388 116548 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1002x Naples St 4 Median : Yard Tree DPW 1     3 3x3   6001544.87474 2088178.15499 37.7138270917124 -122.436537614614 (37.7138270917124, -122.436537614614) 9 7 6 28861 5
116664 116546 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1041x Naples St 2 Median : Yard Tree DPW 1     3 3x3   6001545.43478 2088113.86518 37.7136505979649 -122.436531080144 (37.7136505979649, -122.436531080144) 9 7 6 28861 5
95040 116547 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1041x Naples St 3 Median : Yard Tree DPW 1     4 3x3   6001554.67745 2088129.8106 37.7136949057732 -122.436500274771 (37.7136949057732, -122.436500274771) 9 7 6 28861 5
44017 116540 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1002x Naples St 3 Median : Yard Tree DPW 1     3 3x3   6001555.50616 2088195.95431 37.7138765688354 -122.436502141754 (37.7138765688354, -122.436502141754) 9 7 6 28861 5
139455 116549 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1041x Naples St 5 Median : Yard Tree DPW 1     4 3x3   6001562.82912 2088145.24079 37.7137377368707 -122.436473203396 (37.7137377368707, -122.436473203396) 9 7 6 28861 5
138570 116539 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1002x Naples St 2 Median : Yard Tree DPW 1     3 3x3   6001567.48738 2088213.72569 37.7139260459311 -122.436462001442 (37.7139260459311, -122.436462001442) 9 7 6 28861 5
69235 116543 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1041x Naples St 6 Median : Yard Tree DPW 1     5 3x3   6001574.84931 2088164.89401 37.7137923832878 -122.43643306305 (37.7137923832878, -122.43643306305) 9 7 6 28861 5
65853 116538 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1002x Naples St 1 Median : Yard Tree DPW 1     1 3x3   6001578.10158 2088233.43486 37.7139807660769 -122.436426724612 (37.7139807660769, -122.436426724612) 9 7 6 28861 5
7686 116544 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1041x Naples St 7 Median : Yard Tree DPW 1     5 3x3   6001586.02621 2088182.95127 37.7138425996209 -122.436395723209 (37.7138425996209, -122.436395723209) 9 7 6 28861 5
27595 63507 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 574 Paris St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/08/1987 12:00:00 AM 4   Permit Number 24113 6001588.8915 2090307.92108 37.7196774559426 -122.436537823274 (37.7196774559426, -122.436537823274) 9 7 6 28861 5
17357 116552 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1041x Naples St 8 Median : Yard Tree DPW 1     3 3x3   6001598.03525 2088202.06693 37.7138957693564 -122.436355582838 (37.7138957693564, -122.436355582838) 9 7 6 28861 5
155326 176918 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1041x Naples St 9 Median : Yard Tree DPW 1     4     6001604.80367 2088215.91202 37.7139341694897 -122.436333178956 (37.7139341694897, -122.436333178956) 9 7 6 28861 5
163710 108371 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 575 Paris St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   1 3x3   6001620.80772 2090281.19611 37.7196058887813 -122.43642558878 (37.7196058887813, -122.43642558878) 9 7 6 28861 5
173908 251743 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 143 Cordova St   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001773 2087479 37.7119203272299 -122.43569914015 (37.7119203272299, -122.43569914015) 9 7 6 28861 5
161307 176916 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 380 Rolph St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6001888.93185 2087835.89796 37.7129068748214 -122.435323960636 (37.7129068748214, -122.435323960636) 9 7 6 28861 5

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