trees
861 rows where qSpecies_id = 18 sorted by PlantDate
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41389 | 191296 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 940 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6014597.30582 | 2110326.98215 | 37.7753762177666 | -122.392971942918 | (37.7753762177666, -122.392971942918) | 6 | 2 | 9 | 310 | 20 | |||
41576 | 207097 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 451 Lansdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996075.95126 | 2096408.69413 | 37.7361138982453 | -122.456034797893 | (37.7361138982453, -122.456034797893) | 9 | 7 | 4 | 59 | 40 | |||
41810 | 191276 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 659 04th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6014137.59227 | 2110902.38763 | 37.7769306051104 | -122.394602513603 | (37.7769306051104, -122.394602513603) | 6 | 2 | 9 | 28856 | 20 | |||
42036 | 1713 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 555 Battery St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 5x6 | 6012507.60717 | 2118114.90232 | 37.796643729085 | -122.40074798855 | (37.796643729085, -122.40074798855) | 3 | 1 | 10 | 28860 | 4 | |||
42195 | 1714 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 555 Battery St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 5x9 | 6012511.35044 | 2118080.94057 | 37.7965506870182 | -122.400732648813 | (37.7965506870182, -122.400732648813) | 3 | 1 | 10 | 28860 | 4 | |||
42397 | 4516 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 20X Cleary Ct | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6004999.51904 | 2113885.82273 | 37.7846101140023 | -122.426426402111 | (37.7846101140023, -122.426426402111) | 13 | 9 | 11 | 28858 | 41 | |||
42693 | 105034 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1550 04th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6015094.5 | 2108059.1 | 37.7691767205026 | -122.391093466638 | (37.7691767205026, -122.391093466638) | 14 | 3 | 9 | 310 | 20 | ||||
43158 | 227617 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 115 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6009080.60999 | 2097991.13845 | 37.7411968070922 | -122.411183978775 | (37.7411968070922, -122.411183978775) | 10 | 7 | 7 | 28859 | 2 | |||
43790 | 176958 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 214 Hester Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6012631.12356 | 2087648.56031 | 37.7129966847253 | -122.398182046487 | (37.7129966847253, -122.398182046487) | 10 | 3 | 8 | 309 | 1 | |||
43874 | 20250 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1880 Steiner St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6002537.9918 | 2114673.3066 | 37.7866328903431 | -122.434998786713 | (37.7866328903431, -122.434998786713) | 13 | 9 | 11 | 29490 | 27 | |||
43906 | 227618 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 119 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6009077.39378 | 2097965.31988 | 37.7411257345706 | -122.411193275964 | (37.7411257345706, -122.411193275964) | 10 | 7 | 7 | 28859 | 2 | |||
44002 | 191344 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1550 04th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015083.27036 | 2108014.27768 | 37.7690530250991 | -122.39112917627 | (37.7690530250991, -122.39112917627) | 14 | 3 | 9 | 310 | 20 | |||
44144 | 207062 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 134 Taraval St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5993034.65386 | 2099189.08337 | 37.7435731145127 | -122.466751760605 | (37.7435731145127, -122.466751760605) | 1 | 8 | 4 | 29491 | 40 | |||
44221 | 176952 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 75 Lois Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6012648.82319 | 2087733.77895 | 37.7132316640827 | -122.398126845197 | (37.7132316640827, -122.398126845197) | 10 | 3 | 8 | 309 | 1 | |||
44766 | 227650 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 154 Danvers St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6000006.33119 | 2104908.86672 | 37.759678136856 | -122.443056184107 | (37.759678136856, -122.443056184107) | 2 | 4 | 5 | 28862 | 3 | |||
44775 | 227659 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 248 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003786.3248 | 2109251.28052 | 37.771816154325 | -122.430292880621 | (37.771816154325, -122.430292880621) | 7 | 9 | 11 | 29492 | 10 | |||
45087 | 114222 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 55 Lois Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 2x2 | 6012512.59554 | 2087744.07842 | 37.7132523556976 | -122.398598420002 | (37.7132523556976, -122.398598420002) | 10 | 3 | 8 | 309 | 1 | |||
45106 | 246316 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1660 Mission St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 0ft | 6006848.8767 | 2108962.1326 | 37.7711952166815 | -122.41967876451 | (37.7711952166815, -122.41967876451) | 8 | 2 | 9 | 28853 | 19 | |||
46272 | 112621 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 226x HESTER AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012667 | 2087636 | 37.7129641948773 | -122.398057164184 | (37.7129641948773, -122.398057164184) | 10 | 3 | 8 | 309 | 1 | ||||
46340 | 129439 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 715 Bush St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6010043.54378 | 2115756.33064 | 37.7900299214 | -122.409107728349 | (37.7900299214, -122.409107728349) | 5 | 1 | 10 | 28857 | 21 | |||
46641 | 191352 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1750 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015101.55033 | 2107682.63159 | 37.7681434121179 | -122.391042763138 | (37.7681434121179, -122.391042763138) | 14 | 3 | 9 | 310 | 20 | |||
47462 | 247480 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 309 Pierce St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6002710.1595 | 2109648.0677 | 37.7728446187699 | -122.434043773953 | (37.7728446187699, -122.434043773953) | 15 | 5 | 11 | 29492 | 9 | |||
47953 | 105316 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2101 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 770797 | 6004250.84301 | 2116191.67517 | 37.7908990545176 | -122.429181041856 | (37.7908990545176, -122.429181041856) | 13 | 9 | 1 | 28858 | 27 | ||||
48071 | 108754 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 200x Hester Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6012760.63999 | 2087707.78234 | 37.7131665099896 | -122.397738543111 | (37.7131665099896, -122.397738543111) | 10 | 3 | 8 | 309 | 1 | |||
48341 | 191313 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1505 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015141.50158 | 2107991.42305 | 37.7689935025667 | -122.390926158818 | (37.7689935025667, -122.390926158818) | 14 | 3 | 9 | 310 | 20 | |||
48383 | 129395 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 3383 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5998662.11007 | 2115556.58452 | 37.7888373034598 | -122.448471976104 | (37.7888373034598, -122.448471976104) | 13 | 6 | 1 | 54 | 31 | |||
48510 | 207092 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2655 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5991411.79539 | 2097355.25398 | 37.738444095618 | -122.4722295024 | (37.738444095618, -122.4722295024) | 1 | 8 | 4 | 29491 | 40 | |||
48527 | 4552 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 85 Cleary Ct | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6004747.7557 | 2113637.7514 | 37.7839147367985 | -122.427279741881 | (37.7839147367985, -122.427279741881) | 7 | 9 | 11 | 28858 | 41 | |||
49037 | 183441 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2434 22nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5989549.5958 | 2098772.4148 | 37.7422273048614 | -122.478771630638 | (37.7422273048614, -122.478771630638) | 1 | 8 | 3 | 29491 | 35 | |||
49081 | 191346 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1550 04th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015085.76507 | 2107965.02098 | 37.7689179154613 | -122.391117103785 | (37.7689179154613, -122.391117103785) | 14 | 3 | 9 | 310 | 20 | |||
49095 | 105027 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1550 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6x6 | 6015075.47854 | 2108137.72551 | 37.7693915533068 | -122.391164757946 | (37.7693915533068, -122.391164757946) | 14 | 3 | 9 | 310 | 20 | |||
49165 | 227649 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 154 Danvers St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5999999.59495 | 2104920.93401 | 37.7597108865789 | -122.443080347989 | (37.7597108865789, -122.443080347989) | 2 | 4 | 5 | 28862 | 3 | |||
49177 | 176922 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 298 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6003957.47292 | 2089506.69936 | 37.7176117887305 | -122.428293410708 | (37.7176117887305, -122.428293410708) | 9 | 7 | 6 | 28861 | 5 | |||
49373 | 200112 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1560 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6014792.7183 | 2092559.9355 | 37.726602519263 | -122.391053863847 | (37.726602519263, -122.391053863847) | 10 | 3 | 8 | 58 | 1 | |||
50235 | 191277 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 659 04th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6014120.49796 | 2110919.75939 | 37.7769773536703 | -122.394662865301 | (37.7769773536703, -122.394662865301) | 6 | 2 | 9 | 28856 | 20 | |||
50537 | 200113 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1566 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6014774.445 | 2092572.7944 | 37.7266368132033 | -122.391117932915 | (37.7266368132033, -122.391117932915) | 10 | 3 | 8 | 58 | 1 | |||
50640 | 129442 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 144 Cyril Magnin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6010104.97756 | 2114284.67603 | 37.7859925517698 | -122.408791302782 | (37.7859925517698, -122.408791302782) | 14 | 10 | 10 | 28852 | 36 | |||
50767 | 227610 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 400 Prospect Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 25 | 6006250.04952 | 2097648.94567 | 37.7400980729811 | -122.420946773391 | (37.7400980729811, -122.420946773391) | 2 | 7 | 7 | 28859 | 2 | ||||
50918 | 227611 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 66 Balmy St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 3ft | 6008811.16325 | 2101739.45031 | 37.751473726132 | -122.412380510571 | (37.751473726132, -122.412380510571) | 2 | 4 | 7 | 28859 | 19 | |||
51145 | 114219 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 31 Lois Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6012347.17965 | 2087849.72367 | 37.7135332193584 | -122.399177569 | (37.7135332193584, -122.399177569) | 10 | 3 | 8 | 309 | 1 | |||
51303 | 200000 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1450 Griffith St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6017688.3023 | 2092371.2757 | 37.726244750724 | -122.381030719301 | (37.726244750724, -122.381030719301) | 10 | 3 | 8 | 58 | 1 | |||
51728 | 191273 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 659 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6014193.41583 | 2110841.84159 | 37.7767674626879 | -122.394405160994 | (37.7767674626879, -122.394405160994) | 6 | 2 | 9 | 28856 | 20 | |||
51842 | 191319 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1505 04th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015133.57873 | 2108141.42692 | 37.7694049406179 | -122.390964049067 | (37.7694049406179, -122.390964049067) | 14 | 3 | 9 | 310 | 20 | |||
52238 | 244059 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1652 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5998660.6331 | 2109020.8428 | 37.7708917674934 | -122.448006327683 | (37.7708917674934, -122.448006327683) | 15 | 5 | 11 | 29492 | 9 | |||
52515 | 191285 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 720 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6014337.49405 | 2110565.62241 | 37.776017035092 | -122.3938874078 | (37.776017035092, -122.3938874078) | 6 | 2 | 9 | 310 | 20 | |||
54124 | 129398 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 3729 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5997021.62902 | 2114999.75252 | 37.7872144597187 | -122.454107547129 | (37.7872144597187, -122.454107547129) | 11 | 6 | 1 | 54 | 31 | |||
54279 | 102559 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1755X 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015173.7 | 2107354.9 | 37.7672475362702 | -122.390770296702 | (37.7672475362702, -122.390770296702) | 14 | 3 | 9 | 310 | 20 | ||||
54297 | 227624 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 4283 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002006.21213 | 2101168.55205 | 37.7495219535904 | -122.435871975115 | (37.7495219535904, -122.435871975115) | 2 | 4 | 5 | 28862 | 22 | |||
55623 | 120374 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 433 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5988073.52579 | 2113031.79545 | 37.7812938539051 | -122.484921243675 | (37.7812938539051, -122.484921243675) | 11 | 6 | 2 | 55 | 26 | |||
55735 | 227590 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 33 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 4ft | 6005514.01431 | 2098729.37498 | 37.7430231709906 | -122.423568480604 | (37.7430231709906, -122.423568480604) | 2 | 7 | 5 | 28859 | 22 | |||
55769 | 176926 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 200 Morse St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | Width 10ft | 6000586.22066 | 2087873.89241 | 37.7129371316064 | -122.439829268227 | (37.7129371316064, -122.439829268227) | 9 | 7 | 6 | 28861 | 5 | |||
55950 | 200104 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1528 Yosemite Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6014963.9454 | 2092431.3459 | 37.726258938018 | -122.390452952009 | (37.726258938018, -122.390452952009) | 10 | 3 | 8 | 58 | 1 | |||
56414 | 129456 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 855 Chestnut St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 6007719.74229 | 2120576.43903 | 37.803134284681 | -122.417489658942 | (37.803134284681, -122.417489658942) | 5 | 1 | 1 | 308 | 32 | |||
56859 | 227608 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1201 San Jose Ave | 73 | Front Yard : Yard | Tree | Private 2 | 3 | 6004572.06439 | 2096162.43718 | 37.7359217292935 | -122.426642736581 | (37.7359217292935, -122.426642736581) | 2 | 7 | 5 | 28861 | 2 | ||||
57151 | 116237 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 639 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 5990321.77949 | 2111019.87703 | 37.775900374977 | -122.47699641585 | (37.775900374977, -122.47699641585) | 11 | 6 | 2 | 55 | 26 | |||
57443 | 129441 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 144 Cyril Magnin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6010109.81427 | 2114257.21673 | 37.7859174259901 | -122.408772631062 | (37.7859174259901, -122.408772631062) | 14 | 10 | 10 | 28852 | 36 | |||
57522 | 119342 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 450 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5985959.22989 | 2112860.79415 | 37.7807009596808 | -122.492222971302 | (37.7807009596808, -122.492222971302) | 11 | 6 | 2 | 55 | 26 | |||
57744 | 191291 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 940 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6014507.50601 | 2110409.04953 | 37.7755965678638 | -122.393288327987 | (37.7755965678638, -122.393288327987) | 6 | 2 | 9 | 310 | 20 | |||
58693 | 200018 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1008 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6018250.1161 | 2092086.6599 | 37.7254942451327 | -122.379068779178 | (37.7254942451327, -122.379068779178) | 10 | 3 | 8 | 58 | 1 | |||
60028 | 4518 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 20X Cleary Ct | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6004999.51904 | 2113885.82273 | 37.7846101140023 | -122.426426402111 | (37.7846101140023, -122.426426402111) | 13 | 9 | 11 | 28858 | 41 | |||
60579 | 79264 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 180 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 5989943.75827 | 2114181.74363 | 37.7845600440954 | -122.478535346694 | (37.7845600440954, -122.478535346694) | 11 | 6 | 2 | 55 | 26 | |||
61133 | 183581 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2614 26th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 5988348.717 | 2097504.9177 | 37.738677287922 | -122.482830978923 | (37.738677287922, -122.482830978923) | 1 | 8 | 3 | 29491 | 35 | |||
61234 | 191322 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1507 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015122.40685 | 2108342.01647 | 37.769955095485 | -122.391016714258 | (37.769955095485, -122.391016714258) | 14 | 3 | 9 | 310 | 20 | |||
61523 | 176925 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 17 Curtis St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 6000534.5551 | 2088493.30994 | 37.7146349724878 | -122.440052229032 | (37.7146349724878, -122.440052229032) | 9 | 7 | 6 | 28861 | 5 | |||
61944 | 207077 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 230 Pacheco St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 5994500.88494 | 2100452.87217 | 37.74712767141 | -122.461773548104 | (37.74712767141, -122.461773548104) | 1 | 8 | 4 | 29491 | 40 | |||
62165 | 227651 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 4118 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001694.86954 | 2103534.27623 | 37.75599997444 | -122.43711796243 | (37.75599997444, -122.43711796243) | 2 | 4 | 5 | 28862 | 3 | |||
62494 | 191261 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 690 Wisconsin St | 3 | : | Tree | Private 2 | 18 | Width 3ft | 6012675.54577 | 2104288.99957 | 37.7586903323146 | -122.399195870217 | (37.7586903323146, -122.399195870217) | 10 | 3 | 8 | 28856 | 29 | |||
62495 | 129399 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 3766 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5996788.91292 | 2115340.40834 | 37.7881364626726 | -122.454937313809 | (37.7881364626726, -122.454937313809) | 11 | 6 | 1 | 54 | 31 | |||
62590 | 176973 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 82 Colby St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008143.29471 | 2093583.45103 | 37.7290416458419 | -122.414113135409 | (37.7290416458419, -122.414113135409) | 9 | 3 | 7 | 309 | 28 | |||
62830 | 129391 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1851 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004117.78483 | 2119036.12679 | 37.7987016585207 | -122.429844394124 | (37.7987016585207, -122.429844394124) | 13 | 9 | 1 | 57 | 17 | |||
62923 | 191315 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1505 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015139.91127 | 2108041.11608 | 37.7691298604716 | -122.390935133173 | (37.7691298604716, -122.390935133173) | 14 | 3 | 9 | 310 | 20 | |||
63082 | 191270 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 659 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6014244.47605 | 2110787.29844 | 37.7766205377503 | -122.394224707529 | (37.7766205377503, -122.394224707529) | 6 | 2 | 9 | 28856 | 20 | |||
63090 | 31965 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1000 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Permit Number 35367 | 6008195.50256 | 2118963.54127 | 37.7987324288073 | -122.415729001311 | (37.7987324288073, -122.415729001311) | 5 | 1 | 10 | 308 | 32 | |||
64244 | 227638 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 326 San Jose Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6006175.20644 | 2101155.72627 | 37.7497226795546 | -122.421454532416 | (37.7497226795546, -122.421454532416) | 2 | 4 | 5 | 28859 | 19 | |||
64744 | 191355 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1780 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015114.26665 | 2107471.16871 | 37.7675634870034 | -122.390983996927 | (37.7675634870034, -122.390983996927) | 14 | 3 | 9 | 310 | 20 | |||
65023 | 227633 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 3240 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008124.7966 | 2100966.18492 | 37.7493119726844 | -122.414699339617 | (37.7493119726844, -122.414699339617) | 2 | 4 | 7 | 28859 | 19 | |||
65178 | 176949 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 59 Lois Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6012531.85348 | 2087734.51235 | 37.7132271620641 | -122.398531186662 | (37.7132271620641, -122.398531186662) | 10 | 3 | 8 | 309 | 1 | |||
65371 | 200099 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1528 Yosemite Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6015044.483 | 2092374.4958 | 37.7261073063636 | -122.390170565448 | (37.7261073063636, -122.390170565448) | 10 | 3 | 8 | 58 | 1 | |||
66527 | 176969 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 134 Craut St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004020.786 | 2094067.71187 | 37.7301389032718 | -122.428399470475 | (37.7301389032718, -122.428399470475) | 9 | 7 | 6 | 28861 | 5 | |||
66670 | 129416 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 218 Presidio Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5999044.58564 | 2115840.24858 | 37.7896380310292 | -122.447169092303 | (37.7896380310292, -122.447169092303) | 13 | 6 | 1 | 29490 | 31 | |||
66891 | 191286 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 720 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6014348.90708 | 2110556.61592 | 37.7759929395558 | -122.393847296238 | (37.7759929395558, -122.393847296238) | 6 | 2 | 9 | 310 | 20 | |||
67020 | 176975 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 248 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002517.77047 | 2092300.43042 | 37.7252011818667 | -122.433469338243 | (37.7252011818667, -122.433469338243) | 9 | 7 | 6 | 28861 | 5 | |||
67835 | 129427 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2149 Broadway | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6003257.40294 | 2117505.83832 | 37.7944511216666 | -122.43271221522 | (37.7944511216666, -122.43271221522) | 13 | 9 | 1 | 29490 | 27 | |||
68049 | 129448 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1190 Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008230.44958 | 2115909.44994 | 37.7903486123517 | -122.415391745646 | (37.7903486123517, -122.415391745646) | 5 | 1 | 10 | 28858 | 21 | |||
68793 | 129433 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2201 Clay St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6004155.37388 | 2116318.23991 | 37.7912411642935 | -122.429520390877 | (37.7912411642935, -122.429520390877) | 13 | 9 | 1 | 29490 | 27 | |||
69978 | 227648 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 154 Danvers St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5999992.54639 | 2104934.00184 | 37.7597463657249 | -122.443105663906 | (37.7597463657249, -122.443105663906) | 2 | 4 | 5 | 28862 | 3 | |||
70959 | 191310 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 601 04th St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015152.46863 | 2107768.27489 | 37.7683813952045 | -122.390872626697 | (37.7683813952045, -122.390872626697) | 14 | 3 | 9 | 310 | 20 | |||
71092 | 250533 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 69 26th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 6ft | 5987683.92995 | 2115503.12844 | 37.7880567296852 | -122.486450536786 | (37.7880567296852, -122.486450536786) | 11 | 6 | 1 | 55 | 33 | |||
71155 | 191324 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1507 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015118.87024 | 2108392.34888 | 37.770093100956 | -122.391032465874 | (37.770093100956, -122.391032465874) | 14 | 3 | 9 | 310 | 20 | |||
71662 | 191263 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 728 Wisconsin St | 2 | : | Tree | Private 2 | 13 | Width 3ft | 6012693.03822 | 2104091.70249 | 37.7581495726586 | -122.399121524154 | (37.7581495726586, -122.399121524154) | 10 | 3 | 8 | 28856 | 29 | |||
71752 | 105029 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1550 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 6x6 | 6015077.74883 | 2108086.46133 | 37.769250919128 | -122.391153321267 | (37.769250919128, -122.391153321267) | 14 | 3 | 9 | 310 | 20 | |||
71868 | 182961 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1901 Ulloa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5990015.6611 | 2098388.4154 | 37.7411999929644 | -122.47713208357 | (37.7411999929644, -122.47713208357) | 1 | 8 | 3 | 29491 | 35 | |||
71944 | 247957 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 8 Joy St | 1 | Front Yard : Yard | Tree | Private 2 | 41 | 6010434.99272 | 2098878.7541 | 37.743709870826 | -122.406563517506 | (37.743709870826, -122.406563517506) | 2 | 7 | 7 | 28859 | 2 | ||||
71950 | 176972 | Planning Code 138.1 required 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 161 University St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | Permit Number 781886 | 6008005.59306 | 2093164.83572 | 37.7278844827614 | -122.414559571484 | (37.7278844827614, -122.414559571484) | 9 | 3 | 7 | 309 | 28 | ||
72261 | 129415 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1914 Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5999481.12228 | 2115602.98861 | 37.7890115102163 | -122.44564165674 | (37.7890115102163, -122.44564165674) | 13 | 6 | 1 | 29490 | 27 | |||
72292 | 227593 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 501 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6005330.86399 | 2107797.8602 | 37.7679127764864 | -122.424846790463 | (37.7679127764864, -122.424846790463) | 8 | 4 | 5 | 28853 | 19 | |||
72314 | 102564 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1655X 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015154.2 | 2107704.9 | 37.7682074777149 | -122.390862208319 | (37.7682074777149, -122.390862208319) | 14 | 3 | 9 | 310 | 20 | ||||
72423 | 191283 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 751 04th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6014423.24539 | 2110620.23478 | 37.7761717535676 | -122.39359459214 | (37.7761717535676, -122.39359459214) | 6 | 2 | 9 | 28856 | 20 | |||
73007 | 56604 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1914 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 5999483.43623 | 2115589.87746 | 37.788975642546 | -122.445632707581 | (37.788975642546, -122.445632707581) | 13 | 6 | 1 | 29490 | 27 | ||||
73078 | 191259 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 900x Carolina St | 27 | Median : Yard | Tree | DPW 1 | 17 | 6012470.08805 | 2103421.28043 | 37.7562963136528 | -122.399845510773 | (37.7562963136528, -122.399845510773) | 10 | 3 | 8 | 28856 | 29 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );