trees
861 rows where qSpecies_id = 18 sorted by PlotSize descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
142561 | 191266 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1721 Revere Ave | 1 | : | Tree | Private 2 | 25 | Width 9ft | 6014437.69224 | 2094855.17275 | 37.7328850694924 | -122.392441658555 | (37.7328850694924, -122.392441658555) | 10 | 3 | 8 | 58 | 1 | |||
26722 | 176965 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 327 Craut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 7ft | 6004071.24912 | 2093653.41815 | 37.7290042007626 | -122.428195498837 | (37.7290042007626, -122.428195498837) | 9 | 7 | 6 | 28861 | 5 | |||
101334 | 176964 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 329 Craut St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 7ft | 6004071.94661 | 2093622.05007 | 37.728918110483 | -122.428190852951 | (37.728918110483, -122.428190852951) | 9 | 7 | 6 | 28861 | 5 | |||
108905 | 176966 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 327 Craut St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 7ft | 6004069.61366 | 2093704.49695 | 37.7291443592041 | -122.428204791543 | (37.7291443592041, -122.428204791543) | 9 | 7 | 6 | 28861 | 5 | |||
36673 | 129452 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 855 Chestnut St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 6007720.96455 | 2120575.51523 | 37.8031318169312 | -122.417485363758 | (37.8031318169312, -122.417485363758) | 5 | 1 | 1 | 308 | 32 | |||
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 | |||
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 | |||
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 | |||
76983 | 207075 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 230 Pacheco St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 6ft | 5994498.16233 | 2100407.05536 | 37.7470017132656 | -122.461779641027 | (37.7470017132656, -122.461779641027) | 1 | 8 | 4 | 29491 | 40 | |||
79840 | 207070 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1927 08th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 6ft | 5993749.21516 | 2102356.41341 | 37.7523110111603 | -122.464510933358 | (37.7523110111603, -122.464510933358) | 1 | 8 | 4 | 29491 | 12 | |||
80866 | 129453 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 855 Chestnut St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 6007720.64474 | 2120576.42054 | 37.8031342846895 | -122.417486534671 | (37.8031342846895, -122.417486534671) | 5 | 1 | 1 | 308 | 32 | |||
81946 | 207074 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 230 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 5994502.24516 | 2100385.66213 | 37.7469432078786 | -122.461763972133 | (37.7469432078786, -122.461763972133) | 1 | 8 | 4 | 29491 | 40 | |||
92397 | 248214 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 67 Fair Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 6ft | 6006956.2223 | 2099478.83098 | 37.7451623091856 | -122.41863484214 | (37.7451623091856, -122.41863484214) | 2 | 7 | 7 | 28859 | 2 | |||
111323 | 207069 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1927 08th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 6ft | 5993748.4844 | 2102370.47272 | 37.7523495722986 | -122.46451448117 | (37.7523495722986, -122.46451448117) | 1 | 8 | 4 | 29491 | 12 | |||
112569 | 129450 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1257 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 6ft | 6006338.43207 | 2120038.90392 | 37.8015805322681 | -122.422231514268 | (37.8015805322681, -122.422231514268) | 13 | 9 | 1 | 28858 | 32 | |||
114585 | 207071 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1927 08th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 6ft | 5993749.48127 | 2102344.6615 | 37.7522787587656 | -122.464509159894 | (37.7522787587656, -122.464509159894) | 1 | 8 | 4 | 29491 | 12 | |||
136872 | 129455 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 855 Chestnut St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 6007721.09596 | 2120576.41129 | 37.8031342846798 | -122.417484972552 | (37.8031342846798, -122.417484972552) | 5 | 1 | 1 | 308 | 32 | |||
140567 | 250532 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 79 26th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 6ft | 5987685.24066 | 2115481.63254 | 37.7879977845133 | -122.486444423174 | (37.7879977845133, -122.486444423174) | 11 | 6 | 1 | 55 | 33 | |||
156724 | 129454 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 855 Chestnut St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 6007720.06236 | 2120575.53372 | 37.8031318169374 | -122.41748848713 | (37.8031318169374, -122.41748848713) | 5 | 1 | 1 | 308 | 32 | |||
157479 | 207076 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 230 Pacheco St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 5994497.66006 | 2100431.13069 | 37.7470677891411 | -122.461783123205 | (37.7470677891411, -122.461783123205) | 1 | 8 | 4 | 29491 | 40 | |||
188836 | 207073 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 230 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 5994505.45248 | 2100370.55426 | 37.746901910105 | -122.461751786336 | (37.746901910105, -122.461751786336) | 1 | 8 | 4 | 29491 | 40 | |||
2631 | 176979 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 100 Winding Way | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6002427.23589 | 2086817.03836 | 37.7101398650242 | -122.433390645786 | (37.7101398650242, -122.433390645786) | 9 | 7 | 6 | 28861 | 5 | |||
2814 | 191330 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1108 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6014815.79386 | 2110104.24777 | 37.7747767728644 | -122.392200554832 | (37.7747767728644, -122.392200554832) | 14 | 3 | 9 | 310 | ||||
7029 | 191358 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1780 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015118.78707 | 2107382.75466 | 37.7673209722044 | -122.390962181167 | (37.7673209722044, -122.390962181167) | 14 | 3 | 9 | 310 | 20 | |||
18052 | 197677 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 410 China Basin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/09/2020 12:00:00 AM | 3 | Width 5ft | Permit Number 784444 | 6015989.40646 | 2109125.42769 | 37.7721542427634 | -122.388072430121 | (37.7721542427634, -122.388072430121) | 14 | 3 | 9 | 310 | 20 | |
19841 | 191318 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1505 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015134.48609 | 2108114.99928 | 37.7693324264746 | -122.390959063205 | (37.7693324264746, -122.390959063205) | 14 | 3 | 9 | 310 | 20 | |||
20122 | 191320 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1505 04th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015132.04881 | 2108165.57051 | 37.7694711487159 | -122.390971028707 | (37.7694711487159, -122.390971028707) | 14 | 3 | 9 | 310 | 20 | |||
25240 | 191332 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1108 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6014847.27565 | 2110066.45331 | 37.774674745669 | -122.392089008326 | (37.774674745669, -122.392089008326) | 14 | 3 | 9 | 310 | 20 | |||
27980 | 191314 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1505 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015140.28305 | 2108016.70866 | 37.7690628636861 | -122.390932141124 | (37.7690628636861, -122.390932141124) | 14 | 3 | 9 | 310 | 20 | |||
29337 | 191321 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1507 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015124.16384 | 2108316.28371 | 37.7698845364842 | -122.391008838006 | (37.7698845364842, -122.391008838006) | 14 | 3 | 9 | 310 | 20 | |||
31742 | 191316 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1505 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015137.82836 | 2108066.41916 | 37.7691992215952 | -122.390944106589 | (37.7691992215952, -122.390944106589) | 14 | 3 | 9 | 310 | 20 | |||
32692 | 191309 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 601 04th St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015155.38149 | 2107742.43002 | 37.768310592479 | -122.390860744836 | (37.768310592479, -122.390860744836) | 14 | 3 | 9 | 310 | 20 | |||
33798 | 191304 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 601 04th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015169.51274 | 2107473.76779 | 37.7675736888995 | -122.390793087953 | (37.7675736888995, -122.390793087953) | 14 | 3 | 9 | 310 | 20 | |||
39235 | 191325 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1507 04th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015118.6002 | 2108416.53972 | 37.7701595086914 | -122.391035090994 | (37.7701595086914, -122.391035090994) | 14 | 3 | 9 | 310 | 20 | |||
41237 | 191340 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1450 04th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015061.94317 | 2108389.30473 | 37.7700815833249 | -122.39122916471 | (37.7700815833249, -122.39122916471) | 14 | 3 | 9 | 310 | 20 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
75861 | 191353 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1750 04th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6015102.63762 | 2107654.62196 | 37.7680665641485 | -122.391037044335 | (37.7680665641485, -122.391037044335) | 14 | 3 | 9 | 310 | 20 | |||
80330 | 191361 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1780 04th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015122.97696 | 2107297.48765 | 37.7670870801344 | -122.390941728784 | (37.7670870801344, -122.390941728784) | 14 | 3 | 9 | 310 | 20 | |||
86504 | 191326 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1507 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015116.04644 | 2108440.39907 | 37.7702248795025 | -122.391045592385 | (37.7702248795025, -122.391045592385) | 14 | 3 | 9 | 310 | 20 | |||
94581 | 191298 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 601 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6015180.16063 | 2107302.1939 | 37.7671031752919 | -122.390744266449 | (37.7671031752919, -122.390744266449) | 14 | 3 | 9 | 310 | 20 | |||
94858 | 191349 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1750 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015096.10016 | 2107767.4364 | 37.7683759650927 | -122.391067543049 | (37.7683759650927, -122.391067543049) | 14 | 3 | 9 | 310 | 20 | |||
95247 | 191345 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1550 04th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015084.02733 | 2107988.1043 | 37.7689812007549 | -122.391124728238 | (37.7689812007549, -122.391124728238) | 14 | 3 | 9 | 310 | 20 | |||
95406 | 191351 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1750 04th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015099.52293 | 2107709.56267 | 37.7682172464566 | -122.391051658332 | (37.7682172464566, -122.391051658332) | 14 | 3 | 9 | 310 | 20 | |||
95705 | 191312 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 601 04th St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015149.38015 | 2107824.64473 | 37.7685360030565 | -122.390887249657 | (37.7685360030565, -122.390887249657) | 14 | 3 | 9 | 310 | 20 | |||
102404 | 191303 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 601 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015172.36775 | 2107445.68773 | 37.7674967456035 | -122.390781250171 | (37.7674967456035, -122.390781250171) | 14 | 3 | 9 | 310 | 20 | |||
103363 | 191335 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1108 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6014898.40719 | 2110003.75259 | 37.774505422222 | -122.391907747266 | (37.774505422222, -122.391907747266) | 14 | 3 | 9 | 310 | 20 | |||
104925 | 191301 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 601 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015174.99109 | 2107387.31726 | 37.7673366186106 | -122.390768096675 | (37.7673366186106, -122.390768096675) | 14 | 3 | 9 | 310 | 20 | |||
108940 | 176977 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 100 Winding Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6002472.36908 | 2086850.07188 | 37.7102331283354 | -122.433237015483 | (37.7102331283354, -122.433237015483) | 9 | 7 | 6 | 28861 | 5 | |||
109912 | 191343 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1450 04th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015066.17772 | 2108313.11356 | 37.7698726141514 | -122.391209190745 | (37.7698726141514, -122.391209190745) | 14 | 3 | 9 | 310 | 20 | |||
109932 | 191338 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1450 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015059.91247 | 2108440.08294 | 37.7702208964057 | -122.391239738939 | (37.7702208964057, -122.391239738939) | 14 | 3 | 9 | 310 | 20 | |||
111327 | 191307 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 601 04th St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015158.98774 | 2107685.52339 | 37.7681545394383 | -122.390844293528 | (37.7681545394383, -122.390844293528) | 14 | 3 | 9 | 310 | 20 | |||
112739 | 191302 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 601 04th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015174.0673 | 2107416.87345 | 37.7674177221897 | -122.390773357708 | (37.7674177221897, -122.390773357708) | 14 | 3 | 9 | 310 | 20 | |||
118413 | 191328 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1507 04th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015112.5325 | 2108491.8646 | 37.7703659975189 | -122.391061344907 | (37.7703659975189, -122.391061344907) | 14 | 3 | 9 | 310 | 20 | |||
125735 | 191357 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1780 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015116.28501 | 2107414.99409 | 37.767409355789 | -122.390973089032 | (37.767409355789, -122.390973089032) | 14 | 3 | 9 | 310 | 20 | |||
126991 | 191329 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1507 04th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015112.65717 | 2108516.8034 | 37.7704344808868 | -122.391062657035 | (37.7704344808868, -122.391062657035) | 14 | 3 | 9 | 310 | 20 | |||
128103 | 191306 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 601 04th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015160.53731 | 2107657.60104 | 37.7680779567607 | -122.390836982039 | (37.7680779567607, -122.390836982039) | 14 | 3 | 9 | 310 | 20 | |||
128790 | 191331 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1108 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6014830.54088 | 2110082.99883 | 37.7747192468262 | -122.392148055082 | (37.7747192468262, -122.392148055082) | 14 | 3 | 9 | 310 | ||||
128870 | 191359 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1780 04th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015119.80828 | 2107355.25601 | 37.7672455235927 | -122.39095672679 | (37.7672455235927, -122.39095672679) | 14 | 3 | 9 | 310 | 20 | |||
129111 | 176978 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 100 Winding Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6002453.71663 | 2086834.19677 | 37.7101884805901 | -122.433300348445 | (37.7101884805901, -122.433300348445) | 9 | 7 | 6 | 28861 | 5 | |||
129855 | 191356 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1780 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6015114.10558 | 2107443.69394 | 37.7674880383618 | -122.390982633562 | (37.7674880383618, -122.390982633562) | 14 | 3 | 9 | 310 | 20 | |||
130238 | 191354 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1750 04th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015105.75589 | 2107627.1199 | 37.7679912225533 | -122.391024336029 | (37.7679912225533, -122.391024336029) | 14 | 3 | 9 | 310 | 20 | |||
134291 | 191337 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1450 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015057.64715 | 2108462.45276 | 37.7702821932842 | -122.39124913866 | (37.7702821932842, -122.39124913866) | 14 | 3 | 9 | 310 | 20 | |||
137561 | 191341 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1450 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015063.13507 | 2108364.25056 | 37.7700128562384 | -122.391223290338 | (37.7700128562384, -122.391223290338) | 14 | 3 | 9 | 310 | 20 | |||
138022 | 191305 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 601 04th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015162.58842 | 2107628.3532 | 37.767997762404 | -122.390827843133 | (37.767997762404, -122.390827843133) | 14 | 3 | 9 | 310 | 20 | |||
139715 | 227639 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 326 San Jose Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6006173.90943 | 2101141.69074 | 37.7496840680694 | -122.42145802088 | (37.7496840680694, -122.42145802088) | 2 | 4 | 5 | 28859 | 19 | |||
143178 | 191308 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 601 04th St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015156.6298 | 2107712.6724 | 37.7682289538399 | -122.390854347073 | (37.7682289538399, -122.390854347073) | 14 | 3 | 9 | 310 | 20 | |||
146879 | 191323 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1507 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015122.46281 | 2108363.5556 | 37.7700142403001 | -122.391018026356 | (37.7700142403001, -122.391018026356) | 14 | 3 | 9 | 310 | 20 | |||
147876 | 191336 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1450 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015056.82202 | 2108488.85287 | 37.7703546363753 | -122.391253838509 | (37.7703546363753, -122.391253838509) | 14 | 3 | 9 | 310 | 20 | |||
147945 | 191333 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1108 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6014865.84277 | 2110042.35986 | 37.7746096212801 | -122.392023095184 | (37.7746096212801, -122.392023095184) | 14 | 3 | 9 | 310 | 20 | |||
148902 | 191339 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1450 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015062.12286 | 2108415.00786 | 37.7701521684295 | -122.391230340108 | (37.7701521684295, -122.391230340108) | 14 | 3 | 9 | 310 | 20 | |||
152240 | 191334 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1108 04th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6014881.31548 | 2110022.28226 | 37.7745553516884 | -122.391968167293 | (37.7745553516884, -122.391968167293) | 14 | 3 | 9 | 310 | 20 | |||
155580 | 191299 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 601 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015177.82762 | 2107330.32237 | 37.7671802804819 | -122.390754301979 | (37.7671802804819, -122.390754301979) | 14 | 3 | 9 | 310 | 20 | |||
157264 | 191311 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 601 04th St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6015151.76995 | 2107799.07376 | 37.7684659233813 | -122.390877196135 | (37.7684659233813, -122.390877196135) | 14 | 3 | 9 | 310 | 20 | |||
165523 | 191360 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1780 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015121.96393 | 2107325.37884 | 37.7671636070317 | -122.390947182278 | (37.7671636070317, -122.390947182278) | 14 | 3 | 9 | 310 | 20 | |||
167332 | 191342 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1450 04th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015064.99922 | 2108338.84414 | 37.7699431992568 | -122.391215066031 | (37.7699431992568, -122.391215066031) | 14 | 3 | 9 | 310 | 20 | |||
168044 | 191348 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1750 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015095.00919 | 2107795.26302 | 37.7684523103469 | -122.391073261843 | (37.7684523103469, -122.391073261843) | 14 | 3 | 9 | 310 | 20 | |||
169859 | 191327 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1507 04th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015115.08625 | 2108468.00525 | 37.7703006267103 | -122.391050843517 | (37.7703006267103, -122.391050843517) | 14 | 3 | 9 | 310 | 20 | |||
177615 | 191317 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1505 04th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015134.8576 | 2108090.59219 | 37.7692654305833 | -122.390956072084 | (37.7692654305833, -122.390956072084) | 14 | 3 | 9 | 310 | 20 | |||
181056 | 191300 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 601 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015176.683 | 2107358.12451 | 37.767256555574 | -122.390760204217 | (37.767256555574, -122.390760204217) | 14 | 3 | 9 | 310 | 20 | |||
183411 | 191347 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1750 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6015093.18746 | 2107823.28717 | 37.7685291574227 | -122.391081522115 | (37.7685291574227, -122.391081522115) | 14 | 3 | 9 | 310 | 20 | |||
189467 | 176976 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 100 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6002487.99329 | 2086859.86644 | 37.7102609083974 | -122.433183714473 | (37.7102609083974, -122.433183714473) | 9 | 7 | 6 | 28861 | 5 | |||
5529 | 250619 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 114 28th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5987113.72203 | 2115192.60557 | 37.7871708695801 | -122.48840049988 | (37.7871708695801, -122.48840049988) | 11 | 6 | 1 | 55 | 33 | |||
7817 | 129424 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2129 Vallejo St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2020 12:00:00 AM | 3 | Width 4ft | 6003346.86179 | 2117886.37825 | 37.7955010594853 | -122.432429869467 | (37.7955010594853, -122.432429869467) | 13 | 9 | 1 | 29490 | 27 | ||
8088 | 129417 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2129 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2020 12:00:00 AM | 3 | Width 4ft | 6003236.15275 | 2117871.33798 | 37.7954534844407 | -122.432811866398 | (37.7954534844407, -122.432811866398) | 13 | 9 | 1 | 29490 | 27 | ||
8211 | 118727 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 744 44th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 01/16/2020 12:00:00 AM | 3 | Width 4ft | 5982311.94927 | 2110684.47096 | 37.7745115225468 | -122.504679158367 | (37.7745115225468, -122.504679158367) | 11 | 6 | 2 | 55 | 26 | ||
8222 | 240694 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 316 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6004685.09774 | 2109764.27844 | 37.7732755894234 | -122.427220510535 | (37.7732755894234, -122.427220510535) | 7 | 9 | 11 | 28852 | 10 | |||
12709 | 129426 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2149 Broadway | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6003248.10705 | 2117506.03033 | 37.7944511216749 | -122.432744393832 | (37.7944511216749, -122.432744393832) | 13 | 9 | 1 | 29490 | 27 | |||
13091 | 143983 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 778 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/2019 12:00:00 AM | 3 | Width 4ft | 5985421.76568 | 2110588.19207 | 37.7744296111716 | -122.493914761375 | (37.7744296111716, -122.493914761375) | 11 | 6 | 2 | 55 | 26 | ||
18551 | 129423 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2129 Vallejo St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2020 12:00:00 AM | 3 | Width 4ft | 6003338.49011 | 2117887.74598 | 37.7955043402029 | -122.432458934629 | (37.7955043402029, -122.432458934629) | 13 | 9 | 1 | 29490 | 27 | ||
21260 | 119485 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 5526 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 5986205.51331 | 2109807.27576 | 37.7723312607356 | -122.491146185008 | (37.7723312607356, -122.491146185008) | 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) );