Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
179 | 179 | 182083 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1101 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2017 12:33:00 PM | 3 | Width 0ft | 5989775.2775 | 2098997.3719 | 37.742858080169505 | -122.47800774412599 | (37.7428580801695, -122.478007744126) | ||
1386 | 1386 | 183693 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1341 42nd Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983046.6569 | 2105897.5428 | 37.7614111825323 | -122.501783460946 | (37.7614111825323, -122.501783460946) | ||
1390 | 1390 | 183692 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1341 42nd Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983047.3598 | 2105912.7714 | 37.761453037237 | -122.501782156698 | (37.761453037237, -122.501782156698) | ||
1404 | 1404 | 183694 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1341 42nd Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983048.5312 | 2105875.9885 | 37.7613521106328 | -122.501775383852 | (37.7613521106328, -122.501775383852) | ||
1408 | 1408 | 183696 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1341 42nd Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983051.3079 | 2105837.6039 | 37.7612468805065 | -122.50176294055599 | (37.7612468805065, -122.501762940556) | ||
1417 | 1417 | 183690 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1341 42nd Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983045.4855 | 2105953.0685 | 37.7615635715471 | -122.50179162058001 | (37.7615635715471, -122.50179162058) | ||
1419 | 1419 | 183699 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1341 42nd Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983053.3747 | 2105791.1008 | 37.761119317578505 | -122.501752351825 | (37.7611193175785, -122.501752351825) | ||
1428 | 1428 | 183691 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1341 42nd Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983046.4226 | 2105931.5142 | 37.76150444459871 | -122.50178678479799 | (37.7615044445987, -122.501786784798) | ||
1430 | 1430 | 183687 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1341 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 33196 | 5983043.3769 | 2106010.2341 | 37.7617204082059 | -122.50180314292801 | (37.7617204082059, -122.501803142928) | |
3913 | 3913 | 253116 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Cayuga Ave | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 12:00:00 PM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.719783405947204 | -122.442045963044 | (37.7197834059472, -122.442045963044) | ||
3915 | 3915 | 160069 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Cayuga Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 11:26:00 AM | 3 | Width 0ft | 6000296.79811 | 2090527.7878900003 | 37.7202076512361 | -122.441019880684 | (37.7202076512361, -122.441019880684) | ||
3918 | 3918 | 253108 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Cayuga Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 11:41:00 AM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.719783405947204 | -122.442045963044 | (37.7197834059472, -122.442045963044) | ||
3922 | 3922 | 160059 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Cayuga Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 10:50:00 AM | 3 | Width 0ft | 6000588.557440001 | 2091082.6412900002 | 37.7217477663201 | -122.440051133668 | (37.7217477663201, -122.440051133668) | ||
3928 | 3928 | 253114 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Cayuga Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 11:55:00 AM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.719783405947204 | -122.442045963044 | (37.7197834059472, -122.442045963044) | ||
3934 | 3934 | 160071 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Cayuga Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 11:31:00 AM | 3 | Width 0ft | 6000209.4859 | 2090450.10808 | 37.7199893866688 | -122.44131611827 | (37.7199893866688, -122.44131611827) | ||
3935 | 3935 | 160073 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Cayuga Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 11:36:00 AM | 3 | Width 0ft | 6000082.999340001 | 2090399.7386 | 37.7198438772755 | -122.44174972458201 | (37.7198438772755, -122.441749724582) | ||
3937 | 3937 | 253112 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Cayuga Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 11:51:00 AM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.719783405947204 | -122.442045963044 | (37.7197834059472, -122.442045963044) | ||
3939 | 3939 | 160065 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Cayuga Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 11:13:00 AM | 3 | Width 0ft | 6000417.53141 | 2090750.6791299998 | 37.7208265358932 | -122.440618525839 | (37.7208265358932, -122.440618525839) | ||
3946 | 3946 | 160063 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Cayuga Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 11:07:00 AM | 3 | Width 0ft | 6000471.59074 | 2090857.9533099998 | 37.7211241647202 | -122.440439349407 | (37.7211241647202, -122.440439349407) | ||
3950 | 3950 | 162332 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 36 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 02:06:00 PM | 3 | Width 0ft | 5996526.7373 | 2090117.21242 | 37.718864853708205 | -122.45402201441001 | (37.7188648537082, -122.45402201441) | ||
3960 | 3960 | 160061 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Cayuga Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 11:02:00 AM | 3 | Width 0ft | 6000547.454419999 | 2091000.21878 | 37.7215191128017 | -122.440187308101 | (37.7215191128017, -122.440187308101) | ||
3968 | 3968 | 253118 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Cayuga Ave | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 01:35:00 PM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.719783405947204 | -122.442045963044 | (37.7197834059472, -122.442045963044) | ||
3973 | 3973 | 253110 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Cayuga Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 11:46:00 AM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.719783405947204 | -122.442045963044 | (37.7197834059472, -122.442045963044) | ||
3974 | 3974 | 162331 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 26 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 02:09:00 PM | 3 | Width 0ft | 5996526.61739 | 2090076.5104099999 | 37.7187530886569 | -122.454019490912 | (37.7187530886569, -122.454019490912) | ||
3982 | 3982 | 159338 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 517 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 11:04:00 AM | 3 | Width 0ft | 5998112.9338 | 2087183.20699 | 37.7108995709325 | -122.44832801714199 | (37.7108995709325, -122.448328017142) | ||
3992 | 3992 | 159336 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 523 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 10:36:00 AM | 3 | Width 0ft | 5998080.57171 | 2087152.95418 | 37.7108146533454 | -122.448437690352 | (37.7108146533454, -122.448437690352) | ||
4058 | 4058 | 159346 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 461 Ellington Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 11:49:00 AM | 3 | Width 0ft | 5998276.6806 | 2087336.8062099998 | 37.7113306798385 | -122.44777312285 | (37.7113306798385, -122.44777312285) | ||
4070 | 4070 | 159339 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 517 Ellington Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 11:12:00 AM | 3 | Width 0ft | 5998126.4578599995 | 2087195.02696 | 37.710932799068104 | -122.44828212563 | (37.7109327990681, -122.44828212563) | ||
4072 | 4072 | 159348 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 461 Ellington Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 11:44:00 AM | 3 | Width 0ft | 5998312.68186 | 2087372.3667799998 | 37.711430378688796 | -122.447651252104 | (37.7114303786888, -122.447651252104) | ||
4077 | 4077 | 159345 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 461 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 11:39:00 AM | 3 | Width 0ft | 5998268.07471 | 2087327.6085 | 37.7113049331395 | -122.447802205131 | (37.7113049331395, -122.447802205131) | ||
4091 | 4091 | 159347 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 461 Ellington Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 11:27:00 AM | 3 | Width 0ft | 5998288.37354 | 2087349.92963 | 37.711367382076396 | -122.44773365338999 | (37.7113673820764, -122.44773365339) | ||
27198 | 27198 | 140780 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 5 Encanto Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6000014.7367 | 2112198.3604 | 37.7796937331341 | -122.44355075738399 | (37.7796937331341, -122.443550757384) | |||
28351 | 28351 | 248531 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 800 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5997658.267999999 | 2107761.8815 | 37.767377634072794 | -122.451382700243 | (37.7673776340728, -122.451382700243) | |||
28890 | 28890 | 182659 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2252 Ortega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5986985.3742 | 2102363.8158 | 37.7519391046129 | -122.487901613135 | (37.7519391046129, -122.487901613135) | |||
32349 | 32349 | 184697 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1616 43rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5982844.3503 | 2104136.3629 | 37.7565635951525 | -122.502352798468 | (37.7565635951525, -122.502352798468) | |||
34972 | 34972 | 244513 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 500 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004128.882 | 2109777.8057 | 37.7732812611379 | -122.429145501014 | (37.7732812611379, -122.429145501014) | |||
35420 | 35420 | 182699 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1659 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5989088.7291 | 2103739.8915 | 37.755839910949895 | -122.480728726959 | (37.7558399109499, -122.480728726959) | |||
37433 | 37433 | 184723 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1635 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5983115.9866 | 2103988.5253 | 37.7561736313112 | -122.501402462618 | (37.7561736313112, -122.501402462618) | |||
41737 | 41737 | 183303 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1286 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5982766.9656 | 2106385.9546 | 37.7627357893861 | -122.502786935917 | (37.7627357893861, -122.502786935917) | |||
43034 | 43034 | 140758 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 42 TERRA VISTA AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6000316.7782 | 2112875.0348 | 37.781568928755895 | -122.442554464995 | (37.7815689287559, -122.442554464995) | |||
48320 | 48320 | 140696 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 162 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5997358.0622 | 2109907.9029 | 37.7732528619693 | -122.452575957146 | (37.7732528619693, -122.452575957146) | |||
51569 | 51569 | 200835 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1101 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6013058.6169 | 2107038.7182 | 37.7662617940431 | -122.398063928568 | (37.7662617940431, -122.398063928568) | |||
58411 | 58411 | 248399 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 115 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5998223.6499 | 2108104.3812 | 37.768350409277396 | -122.449451812394 | (37.7683504092774, -122.449451812394) | |||
60263 | 60263 | 247309 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 220 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6002790.9139 | 2109368.8454 | 37.7720825259473 | -122.43374447503099 | (37.7720825259473, -122.433744475031) | |||
63459 | 63459 | 184208 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1474 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5983740.5189 | 2105133.2538 | 37.759353393050105 | -122.49932723943 | (37.7593533930501, -122.49932723943) | |||
63806 | 63806 | 181949 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2450 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5986451.9754 | 2098568.253 | 37.7414863814969 | -122.489467090095 | (37.7414863814969, -122.489467090095) | |||
66926 | 66926 | 184599 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1795 40th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5983770.6594 | 2102984.6576 | 37.7534557168171 | -122.499064248064 | (37.7534557168171, -122.499064248064) | |||
117673 | 117673 | 140302 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 143 COLE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5997780.8586 | 2110053.3207 | 37.773676357183 | -122.45112394331899 | (37.773676357183, -122.451123943319) | |||
130143 | 130143 | 182826 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1781 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5986558.6884 | 2103101.4836 | 37.7539396409234 | -122.48943136928999 | (37.7539396409234, -122.48943136929) | |||
131222 | 131222 | 247385 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 355 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6002203.8017 | 2109776.7723 | 37.7731692596784 | -122.435804531936 | (37.7731692596784, -122.435804531936) | |||
132639 | 132639 | 183523 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2542 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986781.4828 | 2097933.2945 | 37.7397621847049 | -122.488281131206 | (37.7397621847049, -122.488281131206) | |||
135392 | 135392 | 181684 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1347 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5986459.3313 | 2106064.8642 | 37.7620704697574 | -122.48999290967501 | (37.7620704697574, -122.489992909675) | |||
150547 | 150547 | 200836 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1101 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6013076.6871 | 2107039.6693 | 37.766265411985295 | -122.398001493496 | (37.7662654119853, -122.398001493496) | |||
153218 | 153218 | 182607 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1867 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5986269.2088 | 2102542.1488 | 37.7523869566931 | -122.49039129916001 | (37.7523869566931, -122.49039129916) | |||
153529 | 153529 | 183672 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1254 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5984312.3195 | 2106638.1262 | 37.7635188796404 | -122.497460805156 | (37.7635188796404, -122.497460805156) | |||
154400 | 154400 | 141717 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2545 TURK BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5998369.6346 | 2111707.5824 | 37.778252224784005 | -122.44920648801201 | (37.778252224784, -122.449206488012) | |||
160731 | 160731 | 140699 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 224 ASHBURY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5998816.4363 | 2109919.7991 | 37.773368976906205 | -122.447532121663 | (37.7733689769062, -122.447532121663) | |||
161381 | 161381 | 245893 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1001 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6001728.4463 | 2109399.5631 | 37.772106523732 | -122.437421829009 | (37.772106523732, -122.437421829009) | |||
167364 | 167364 | 182307 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1509 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5987118.7965 | 2104973.5941 | 37.7591126281614 | -122.487631931758 | (37.7591126281614, -122.487631931758) | |||
171120 | 171120 | 184598 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1795 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5983770.321 | 2103008.0087 | 37.7535198125919 | -122.499067143504 | (37.7535198125919, -122.499067143504) | |||
172020 | 172020 | 184126 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1643 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986219.0266 | 2104040.7857 | 37.756498872957394 | -122.490675089245 | (37.7564988729574, -122.490675089245) | |||
173458 | 173458 | 184640 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1650 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5983160.9711 | 2103902.0944 | 37.7559389581009 | -122.501240500695 | (37.7559389581009, -122.501240500695) | |||
176471 | 176471 | 182700 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1651 Moraga St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5989102.9459 | 2103739.8915 | 37.7558407372502 | -122.48067956122401 | (37.7558407372502, -122.480679561224) | |||
178120 | 178120 | 181690 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1374 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5982168.1662 | 2105754.9295 | 37.760967965591604 | -122.504811174863 | (37.7609679655916, -122.504811174863) | |||
179813 | 179813 | 137671 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 756 LYON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6000049.6788 | 2111547.4906 | 37.7779086039439 | -122.443383113797 | (37.7779086039439, -122.443383113797) | |||
185807 | 185807 | 182658 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2242 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5987004.6631 | 2102364.6195 | 37.751942436508706 | -122.487834969288 | (37.7519424365087, -122.487834969288) | |||
188215 | 188215 | 183121 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2327 41st Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5983581.7952 | 2099373.3538 | 37.7435289932417 | -122.49945051311 | (37.7435289932417, -122.49945051311) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");