trees
614 rows where qSpecies_id = 29 sorted by qLegalStatus_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
51 | 137691 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2175 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/2020 12:00:00 AM | 3 | Width 0ft | 5999187.5809 | 2111472.1809 | 37.7776526229954 | -122.44635998308 | (37.7776526229954, -122.44635998308) | 15 | 5 | 11 | 54 | 16 | ||
799 | 72078 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 167 20th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/14/2020 12:00:00 AM | 3 | 5989583.57132 | 2114255.42421 | 37.784741432124 | -122.479786850818 | (37.784741432124, -122.479786850818) | 11 | 6 | 2 | 55 | 26 | ||
1858 | 124541 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1001 Balboa St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5992474.53157 | 2111331.5451 | 37.7768807822685 | -122.46957225145 | (37.7768807822685, -122.46957225145) | 11 | 6 | 2 | 54 | 11 | |||
2004 | 73758 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2220 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5988694.03882 | 2110577.4842 | 37.7745911237516 | -122.482594698718 | (37.7745911237516, -122.482594698718) | 11 | 6 | 2 | 55 | 26 | |||
2638 | 32596 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1474 34th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/1996 12:00:00 AM | 2 | Permit Number 37064 | 5985605.53989408 | 2105188.12612078 | 37.7596132973579 | -122.492881221287 | (37.7596132973579, -122.492881221287) | 1 | 8 | 3 | 56 | 35 | |
2740 | 74867 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3501 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5997417.18704 | 2116038.42588 | 37.7900890536146 | -122.452814005488 | (37.7900890536146, -122.452814005488) | 11 | 6 | 1 | 54 | 31 | |||
2771 | 240393 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 35 Hill St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 3ft | 6006109.51353 | 2103440.58038 | 37.7559926584484 | -122.421843980221 | (37.7559926584484, -122.421843980221) | 2 | 4 | 5 | 28859 | 19 | |||
3428 | 37647 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1001 Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/1998 12:00:00 AM | 2 | Permit Number 40060 | 5992426.792 | 2111328.0458 | 37.7768684149352 | -122.469737140808 | (37.7768684149352, -122.469737140808) | 11 | 6 | 2 | 54 | 11 | ||
3822 | 74719 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3501 Jackson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5997437.82689 | 2116041.06971 | 37.7900974955643 | -122.452742784551 | (37.7900974955643, -122.452742784551) | 11 | 6 | 1 | 54 | 31 | |||
4031 | 73753 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2019 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5989295.11737 | 2111227.81825 | 37.7764117112404 | -122.480563089536 | (37.7764117112404, -122.480563089536) | 11 | 6 | 2 | 55 | 26 | |||
5097 | 37962 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 150 Mississippi St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52636 | 6013967.39431 | 2106347.66255 | 37.7644148813545 | -122.394872214003 | (37.7644148813545, -122.394872214003) | 14 | 3 | 8 | 28856 | 29 | |
5160 | 240388 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 65 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008348.72479 | 2098315.88712 | 37.7420474227613 | -122.413737549756 | (37.7420474227613, -122.413737549756) | 2 | 7 | 7 | 28859 | 2 | |||
5774 | 112542 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 438 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/24/2016 12:00:00 AM | 3 | 3x3 | 6011405.06525 | 2118709.92574 | 37.7982159634572 | -122.40460495956 | (37.7982159634572, -122.40460495956) | 3 | 1 | 10 | 308 | 23 | ||
6470 | 78275 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 65 Pomona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6014137.61661 | 2094337.23888 | 37.7314462603177 | -122.393442871089 | (37.7314462603177, -122.393442871089) | 10 | 3 | 8 | 58 | 1 | |||
7825 | 197345 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1277 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008901.33871 | 2110395.02653 | 37.7752450102959 | -122.412680506426 | (37.7752450102959, -122.412680506426) | 8 | 2 | 9 | 28853 | 34 | |||
8833 | 240424 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 5 Penny Ln | 6 | Back Yard : Yard | Tree | Private 2 | 3 | Width 2ft | 6002452.23233 | 2096379.1355 | 37.7363966594644 | -122.433987315365 | (37.7363966594644, -122.433987315365) | 2 | 7 | 5 | 63 | 7 | |||
9509 | 136313 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1201 Sacramento St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6008832.97743 | 2116650.20878 | 37.7924164019518 | -122.413359441492 | (37.7924164019518, -122.413359441492) | 5 | 1 | 10 | 28857 | 21 | |||
9617 | 240412 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3420 Market St | 1 | : | Tree | DPW 1 | 04/19/1996 12:00:00 AM | 7 | Width 3ft | 6000095.05977 | 2103920.26324 | 37.7569687331323 | -122.442678332141 | (37.7569687331323, -122.442678332141) | 2 | 4 | 5 | 28862 | 3 | ||
10754 | 41218 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 21 Mallorca Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1999 12:00:00 AM | 5 | Permit Number 41926 | 6001937.22199 | 2119965.3728 | 37.8011293999489 | -122.43745640431 | (37.8011293999489, -122.43745640431) | 13 | 9 | 1 | 57 | 17 | |
11342 | 141053 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 196 PARKER AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/2019 12:00:00 AM | 3 | Width 0ft | 5996969.9558 | 2113061.6744 | 37.7818900483272 | -122.45414629098 | (37.7818900483272, -122.45414629098) | 11 | 6 | 1 | 54 | 31 | ||
12126 | 184960 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1990 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5983549.8392 | 2101614.3877 | 37.7496803803898 | -122.499726609203 | (37.7496803803898, -122.499726609203) | 1 | 8 | 3 | 29491 | 35 | |||
12169 | 70387 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 81 Lyell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6003118.96111 | 2094567.61018 | 37.7314604381496 | -122.431552867694 | (37.7314604381496, -122.431552867694) | 9 | 7 | 5 | 28861 | 25 | |||
12537 | 54837 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 131 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1972 12:00:00 AM | 8 | Permit Number 10691 | 5998715.81827648 | 2110282.46474316 | 37.7743590132093 | -122.447906287477 | (37.7743590132093, -122.447906287477) | 15 | 5 | 11 | 29492 | 16 | |
13087 | 103083 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 670 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6012579.2635 | 2114003.58062 | 37.785359006363 | -122.400211142746 | (37.785359006363, -122.400211142746) | 12 | 2 | 9 | 28855 | 6 | |||
13360 | 75003 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3501 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5997399.30482 | 2116036.40743 | 37.7900824867734 | -122.452875730442 | (37.7900824867734, -122.452875730442) | 11 | 6 | 1 | 54 | 31 | |||
13609 | 200054 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1800 Lane St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6014879.1353 | 2094151.956 | 37.7309786828797 | -122.39086633517 | (37.7309786828797, -122.39086633517) | 10 | 3 | 8 | 58 | 1 | |||
13641 | 136307 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1110 Jones St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008614.23308 | 2116420.22843 | 37.7917726483359 | -122.41410002782 | (37.7917726483359, -122.41410002782) | 5 | 1 | 10 | 28857 | 21 | |||
13916 | 240385 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 310 Gates St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008245.55924 | 2097104.87481 | 37.7387164553078 | -122.41400861353 | (37.7387164553078, -122.41400861353) | 2 | 7 | 7 | 28859 | 2 | |||
13949 | 70219 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2519 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5999766.96115 | 2119470.28489 | 37.7996463981067 | -122.444930811031 | (37.7996463981067, -122.444930811031) | 13 | 9 | 1 | 57 | 17 | |||
13999 | 73403 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 81 Lyell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6003121.92331 | 2094558.5911 | 37.7314358416937 | -122.43154198317 | (37.7314358416937, -122.43154198317) | 9 | 7 | 5 | 28861 | 25 | |||
14362 | 197348 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 776 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6009001.8467 | 2110254.60923 | 37.7748650979682 | -122.412322898178 | (37.7748650979682, -122.412322898178) | 8 | 2 | 9 | 28853 | 34 | |||
14387 | 181350 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2270 25th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 0ft | 5988575.9018 | 2099879.6972 | 37.7452110255779 | -122.48221942867 | (37.7452110255779, -122.48221942867) | 1 | 8 | 3 | 29491 | 35 | |||
15577 | 61446 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 167 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/14/2020 12:00:00 AM | 3 | Permit Number 48286 | 5989582.2838 | 2114261.13607 | 37.7847570404878 | -122.479791723267 | (37.7847570404878, -122.479791723267) | 11 | 6 | 2 | 55 | 26 | |
15733 | 64781 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3801 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1989 12:00:00 AM | 4 | Permit Number 25773 | 5983728.64713 | 2111021.26009 | 37.7755194830569 | -122.499803502734 | (37.7755194830569, -122.499803502734) | 11 | 6 | 2 | 55 | 26 | |
16030 | 72309 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3555 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5997281.41005 | 2116017.68654 | 37.7900243276015 | -122.453282282457 | (37.7900243276015, -122.453282282457) | 11 | 6 | 1 | 54 | 31 | |||
16441 | 32611 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2926 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | 0 | Permit Number 37076 | 5985807.8579886 | 2105043.58172562 | 37.7592282476447 | -122.492170870983 | (37.7592282476447, -122.492170870983) | 1 | 8 | 3 | 56 | 35 | |
16645 | 74566 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3501 Jackson St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5997456.57692 | 2116043.58234 | 37.7901054689466 | -122.452678092717 | (37.7901054689466, -122.452678092717) | 11 | 6 | 1 | 54 | 31 | |||
16920 | 78303 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 4200 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5985601.84615 | 2111830.05832 | 37.7778499560934 | -122.493383352985 | (37.7778499560934, -122.493383352985) | 11 | 6 | 2 | 55 | 26 | |||
17790 | 181349 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2254 29th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 0ft | 5987333.026 | 2099936.24 | 37.7452939056167 | -122.486521176816 | (37.7452939056167, -122.486521176816) | 1 | 8 | 3 | 29491 | 35 | |||
18662 | 72377 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2015 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5989328.1004 | 2111226.70664 | 37.776410575889 | -122.480448911859 | (37.776410575889, -122.480448911859) | 11 | 6 | 2 | 55 | 26 | |||
19085 | 70121 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2220 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5988662.20068 | 2110577.24438 | 37.7745886129839 | -122.482704814222 | (37.7745886129839, -122.482704814222) | 11 | 6 | 2 | 55 | 26 | |||
20030 | 81327 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3236 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50837 | 5999881.46394 | 2119701.75031 | 37.8002884744792 | -122.444551235949 | (37.8002884744792, -122.444551235949) | 13 | 9 | 1 | 57 | 17 | |
20373 | 122290 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1750 Balboa St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5990062.61204 | 2111318.02169 | 37.7767039596239 | -122.477914733898 | (37.7767039596239, -122.477914733898) | 11 | 6 | 2 | 55 | 26 | |||
20573 | 122277 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1750 Balboa St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5990139.99053 | 2111321.69927 | 37.7767185479371 | -122.477647330613 | (37.7767185479371, -122.477647330613) | 11 | 6 | 2 | 55 | 26 | |||
20954 | 137686 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2143 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5999343.9567 | 2111495.7816 | 37.7777263543907 | -122.445820725833 | (37.7777263543907, -122.445820725833) | 15 | 5 | 11 | 54 | 16 | |||
21474 | 183295 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1262 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5981829.8203 | 2106490.9182 | 37.7629688694519 | -122.506035915679 | (37.7629688694519, -122.506035915679) | 1 | 8 | 3 | 56 | 35 | |||
21604 | 48459 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 520 06th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2002 12:00:00 AM | 2 | Permit Number 45824 | 6011943.63031 | 2110470.08202 | 37.7756213756527 | -122.40216174349 | (37.7756213756527, -122.40216174349) | 14 | 2 | 9 | 28853 | 34 | ||
21743 | 9330 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 159 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/11/2015 03:37:00 AM | 3 | 3x3 | 6000991.5022559 | 2098643.2192577 | 37.7425302962209 | -122.439199887043 | (37.7425302962209, -122.439199887043) | 2 | 7 | 5 | 63 | 7 | ||
21889 | 240418 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 150 Conrad St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6001776.14511 | 2096508.83113 | 37.73671438186 | -122.436334107928 | (37.73671438186, -122.436334107928) | 2 | 7 | 5 | 63 | 7 | |||
23177 | 29219 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1902X 41st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 5983534.5176829 | 2102185.1808128 | 37.7512467209802 | -122.499821775189 | (37.7512467209802, -122.499821775189) | 1 | 8 | 3 | 29491 | 35 | |||
23194 | 136319 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 99 North Point St | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6010537.58998 | 2122003.14861 | 37.8072098224406 | -122.407839040359 | (37.8072098224406, -122.407839040359) | 3 | 1 | 10 | 308 | 23 | |||
23269 | 1772 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2000X Bay Shore Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6012375.8565272 | 2088505.2474917 | 37.7153347551878 | -122.399124435859 | (37.7153347551878, -122.399124435859) | 10 | 7 | 8 | 309 | 39 | |||
23748 | 124092 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 601 Funston Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 5991890.07496 | 2111196.52278 | 37.7764762519633 | -122.471584203691 | (37.7764762519633, -122.471584203691) | 11 | 6 | 2 | 54 | 11 | ||||
24081 | 118563 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 8000 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5982185.81739 | 2112405.54556 | 37.7792296683273 | -122.505243048821 | (37.7792296683273, -122.505243048821) | 11 | 6 | 2 | 55 | 26 | |||
25363 | 32597 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1478 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/1996 12:00:00 AM | 2 | Permit Number 37065 | 5985606.43921528 | 2105161.9851204 | 37.759541574007 | -122.492876185531 | (37.759541574007, -122.492876185531) | 1 | 8 | 3 | 56 | 35 | |
25866 | 32518 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 842 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/2007 12:00:00 AM | 9 | Permit Number 49664 | 6007548.7449 | 2095423.3131 | 37.7340600948986 | -122.41629880637 | (37.7340600948986, -122.41629880637) | 2 | 7 | 7 | 28859 | 2 | |
26259 | 217579 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 636 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5992273.5996 | 2088560.7555 | 37.7143464128453 | -122.468610110073 | (37.7143464128453, -122.468610110073) | 9 | 8 | 6 | 64 | 24 | |||
26602 | 48668 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3362 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/04/2002 12:00:00 AM | 2 | Permit Number 45951 | 5998735.75428 | 2115612.17598 | 37.788994153303 | -122.448221183082 | (37.788994153303, -122.448221183082) | 13 | 6 | 1 | 54 | 31 | ||
27362 | 197344 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 670 Howard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6012519.57167 | 2113947.09446 | 37.7852005799736 | -122.400413690752 | (37.7852005799736, -122.400413690752) | 12 | 2 | 9 | 28855 | 6 | |||
27785 | 31973 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 100 02nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/30/1995 12:00:00 AM | 5 | Permit Number 35372 | 5995224.68838 | 2114814.58842 | 37.7866028473263 | -122.460311111336 | (37.7866028473263, -122.460311111336) | 11 | 6 | 1 | 54 | 11 | |
28313 | 32595 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1383 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/1996 12:00:00 AM | 2 | Permit Number 37063 | 5985531.94877095 | 2105814.83097448 | 37.7613297510328 | -122.493181901529 | (37.7613297510328, -122.493181901529) | 1 | 8 | 3 | 56 | 35 | |
29332 | 40197 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 4845 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/1999 12:00:00 AM | 5 | Permit Number 41381 | 5983545.15866 | 2111697.12052 | 37.7773644306872 | -122.500488206744 | (37.7773644306872, -122.500488206744) | 11 | 6 | 2 | 55 | 26 | |
29514 | 214024 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 118 Baden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6000768.15588 | 2094464.11739 | 37.7310427480136 | -122.439672611702 | (37.7310427480136, -122.439672611702) | 9 | 7 | 4 | 63 | 40 | |||
30102 | 184465 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2182 45th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 0ft | 5982354.8718 | 2100269.3302 | 37.7459170344363 | -122.503759179813 | (37.7459170344363, -122.503759179813) | 1 | 8 | 3 | 29491 | 35 | |||
30433 | 40199 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 4845 Anza St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/1999 12:00:00 AM | 5 | Permit Number 41381 | 5983584.60152 | 2111699.05511 | 37.7773720577908 | -122.500351906273 | (37.7773720577908, -122.500351906273) | 11 | 6 | 2 | 55 | 26 | |
30874 | 18608 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 550 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/03/1997 12:00:00 AM | 6 | 3X3 | 5992502.2173 | 2088557.38 | 37.7143503484358 | -122.467819678694 | (37.7143503484358, -122.467819678694) | 9 | 8 | 6 | 64 | 24 | ||
31150 | 214014 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1462 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992138.11746 | 2105483.85764 | 37.7608051492715 | -122.47031004699 | (37.7608051492715, -122.47031004699) | 1 | 8 | 4 | 56 | 12 | |||
31447 | 240421 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 5 Penny Ln | 3 | Back Yard : Yard | Tree | Private 2 | 2 | Width 2ft | 6002440.89213 | 2096392.57557 | 37.7364329192297 | -122.434027483591 | (37.7364329192297, -122.434027483591) | 2 | 7 | 5 | 63 | 7 | |||
31605 | 118182 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 615 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5985646.49411 | 2111667.23632 | 37.7774055049593 | -122.493216904169 | (37.7774055049593, -122.493216904169) | 11 | 6 | 2 | 55 | 26 | |||
32542 | 214022 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 659 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5997050.53703 | 2094389.33231 | 37.7306251064676 | -122.452519591711 | (37.7306251064676, -122.452519591711) | 9 | 7 | 4 | 28861 | 40 | |||
33110 | 197353 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1750 22nd St | 13 | Side Yard : Yard | Tree | Private 2 | 4 | 6012786.799 | 2103803.61301 | 37.7573637666391 | -122.398777038841 | (37.7573637666391, -122.398777038841) | 10 | 3 | 8 | 28856 | 29 | ||||
33474 | 10670 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1045 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6002868.6063491 | 2110598.6567928 | 37.7754636919659 | -122.433563635643 | (37.7754636919659, -122.433563635643) | 15 | 5 | 11 | 29492 | 10 | |||
35401 | 26068 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 282 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2003 12:00:00 AM | 3 | 2X3 | 5994051.2236 | 2088339.7969 | 37.7138422407476 | -122.46244996961 | (37.7138422407476, -122.46244996961) | 9 | 8 | 6 | 28861 | 24 | ||
35846 | 113422 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1583 Shafter Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 3x3 | 6015014.3399 | 2094064.2928 | 37.7307454784064 | -122.390392783554 | (37.7307454784064, -122.390392783554) | 10 | 3 | 8 | 58 | 1 | ||
36318 | 112537 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 412 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 6011527.0722 | 2118728.84616 | 37.7982747323527 | -122.404184109226 | (37.7982747323527, -122.404184109226) | 3 | 1 | 10 | 308 | 23 | |||
36465 | 214012 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1479 Funston Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5992097.04207 | 2105377.93896 | 37.7605119495939 | -122.47044439309 | (37.7605119495939, -122.47044439309) | 1 | 8 | 4 | 56 | 12 | |||
39109 | 186232 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1701 Sunset Blvd | 43 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5984802.7052 | 2103358.5602 | 37.7545428359635 | -122.495522842112 | (37.7545428359635, -122.495522842112) | 1 | 8 | 3 | 56 | 35 | |||
39553 | 214034 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 218 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 1ft | 5998609.02608 | 2093807.55818 | 37.7291168615442 | -122.447089829625 | (37.7291168615442, -122.447089829625) | 9 | 7 | 4 | 28861 | 40 | |||
40164 | 136317 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 954 Vallejo St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6008931.36114 | 2118725.70113 | 37.7981207171523 | -122.413165857925 | (37.7981207171523, -122.413165857925) | 3 | 1 | 10 | 308 | 21 | |||
40883 | 240415 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 751 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6003800.46059 | 2107711.4253 | 37.7675888874331 | -122.430134113409 | (37.7675888874331, -122.430134113409) | 7 | 9 | 5 | 28862 | 3 | |||
40932 | 179375 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 778 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6001912.74857 | 2089301.24621 | 37.7169317492882 | -122.435346396016 | (37.7169317492882, -122.435346396016) | 9 | 7 | 6 | 28861 | 5 | |||
41119 | 184434 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3816 Quintara St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5981590.8846 | 2100821.8038 | 37.7473890220179 | -122.506441860059 | (37.7473890220179, -122.506441860059) | 1 | 8 | 3 | 29491 | 35 | |||
41839 | 122286 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1750 Balboa St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5990082.62166 | 2111319.5038 | 37.7767091904138 | -122.477845623834 | (37.7767091904138, -122.477845623834) | 11 | 6 | 2 | 55 | 26 | |||
41944 | 140855 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 621 Euclid Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5996425.9427 | 2113796.2189 | 37.7838757026194 | -122.456081435491 | (37.7838757026194, -122.456081435491) | 11 | 6 | 1 | 54 | 31 | |||
42377 | 140854 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 623 Euclid Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5996411.3906 | 2113796.8958 | 37.7838767259243 | -122.456131829019 | (37.7838767259243, -122.456131829019) | 11 | 6 | 1 | 54 | 31 | |||
42922 | 69007 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2115 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1994 12:00:00 AM | 0 | Permit Number 33008 | 5982291.49205895 | 2100703.22551621 | 37.7471046635524 | -122.504010467091 | (37.7471046635524, -122.504010467091) | 1 | 8 | 3 | 29491 | 35 | |
43394 | 92109 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 654 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52365 | 5981669.51861 | 2111284.19832 | 37.7761203861627 | -122.506945906937 | (37.7761203861627, -122.506945906937) | 11 | 6 | 2 | 55 | 26 | |
44625 | 186236 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1701 Sunset Blvd | 47 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984809.6691 | 2103350.7929 | 37.7545219168817 | -122.495498186629 | (37.7545219168817, -122.495498186629) | 1 | 8 | 3 | 56 | 35 | |||
45022 | 240381 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 98 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008070.80857 | 2107998.41684 | 37.7686178359612 | -122.415383805538 | (37.7686178359612, -122.415383805538) | 8 | 4 | 7 | 28853 | 19 | |||
45935 | 7243 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1929X Post St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6002956.0424065 | 2114080.0912444 | 37.7850277993699 | -122.433510025097 | (37.7850277993699, -122.433510025097) | 13 | 9 | 11 | 29490 | 13 | |||
46450 | 69309 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1554 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/1994 12:00:00 AM | 3 | Permit Number 33388 | 5986865.46516485 | 2104681.03924788 | 37.7582945739882 | -122.488486559119 | (37.7582945739882, -122.488486559119) | 1 | 8 | 3 | 56 | 35 | |
48198 | 18596 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 409 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/26/1996 12:00:00 AM | 6 | 3X3 | 5992903.2652 | 2088492.7734 | 37.7141961040887 | -122.466428817805 | (37.7141961040887, -122.466428817805) | 9 | 8 | 6 | 64 | 24 | ||
48554 | 69006 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2111 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1994 12:00:00 AM | 3 | Permit Number 33007 | 5982290.62244002 | 2100729.28975496 | 37.7471761775601 | -122.504015404359 | (37.7471761775601, -122.504015404359) | 1 | 8 | 3 | 29491 | 35 | |
49609 | 48458 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 520 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2002 12:00:00 AM | 3 | Permit Number 45824 | 6011932.18219 | 2110480.19141 | 37.7756484947135 | -122.402202056493 | (37.7756484947135, -122.402202056493) | 14 | 2 | 9 | 28853 | 34 | ||
49755 | 112541 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 438 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 6011421.73685 | 2118713.41459 | 37.798226474727 | -122.404547516275 | (37.798226474727, -122.404547516275) | 3 | 1 | 10 | 308 | 23 | |||
51794 | 214043 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 212 Edna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5998768.52981 | 2093586.90837 | 37.7285201208974 | -122.446522546303 | (37.7285201208974, -122.446522546303) | 9 | 7 | 4 | 28861 | 40 | |||
51945 | 214035 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 142 Staples Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 5999120.59989 | 2093807.09624 | 37.7291448088802 | -122.445321250796 | (37.7291448088802, -122.445321250796) | 9 | 7 | 4 | 28861 | 40 | ||||
52077 | 122289 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1750 Balboa St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5990067.41245 | 2111319.50308 | 37.7767083057233 | -122.477898236364 | (37.7767083057233, -122.477898236364) | 11 | 6 | 2 | 55 | 26 | |||
52120 | 136324 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 448 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6011401 | 2118734 | 37.798281838344 | -122.404620722239 | (37.798281838344, -122.404620722239) | 3 | 1 | 10 | 308 | 23 | |||
53151 | 122280 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1750 Balboa St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5990124.51868 | 2111321.36168 | 37.7767167231412 | -122.477700827061 | (37.7767167231412, -122.477700827061) | 11 | 6 | 2 | 55 | 26 |
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) );