trees
861 rows where qSpecies_id = 18 sorted by SiteOrder 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2588 | 101345 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 600 Chestnut St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1993 12:00:00 AM | 22 | Permit Number 32655 | 6008773.8267 | 2120774.1665 | 37.8037364477628 | -122.413855954453 | (37.8037364477628, -122.413855954453) | 3 | 1 | 10 | 308 | 23 | ||
3361 | 261454 | Private 9 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2 Geneva Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2020 12:00:00 AM | 3 | 3x4 | Permit Number 782541 | 5997165 | 2091482 | 37.7226488176407 | -122.451914211983 | (37.7226488176407, -122.451914211983) | 9 | 8 | 6 | 28861 | 24 |
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 | ||||
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 | |||
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 | |||
99134 | 4519 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 20X Cleary Ct | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/29/2015 11:31:00 AM | 12 | 3x3 | 6004999.51904 | 2113885.82273 | 37.7846101140023 | -122.426426402111 | (37.7846101140023, -122.426426402111) | 13 | 9 | 11 | 28858 | 41 | ||
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 | |||
151040 | 99386 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1590 Yosemite Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | ||
152679 | 191278 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 659 04th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6014098.28059 | 2110942.62046 | 37.7770388897689 | -122.394741323978 | (37.7770388897689, -122.394741323978) | 6 | 2 | 9 | 28856 | 20 | |||
172712 | 191251 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 654 Minnesota St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 6015148.84129 | 2105378.48456 | 37.7618193498029 | -122.390718148336 | (37.7618193498029, -122.390718148336) | 10 | 3 | 8 | 28856 | 29 | |||
179884 | 94214 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 465 Missouri St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53589 | 6013545.01697 | 2104957.62874 | 37.7605746593094 | -122.396235681545 | (37.7605746593094, -122.396235681545) | 10 | 3 | 8 | 28856 | 29 | |
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 | ||
11930 | 4545 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 66 Cleary Ct | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6004823.98553 | 2113713.43923 | 37.784126867551 | -122.427021407244 | (37.784126867551, -122.427021407244) | 13 | 9 | 11 | 28858 | 41 | |||
16566 | 261453 | Private 9 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2 Geneva Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2020 12:00:00 AM | 3 | 3x4 | Permit Number 782541 | 5997165 | 2091482 | 37.7226488176407 | -122.451914211983 | (37.7226488176407, -122.451914211983) | 9 | 8 | 6 | 28861 | 24 |
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 | |||
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 | |||
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 | |||
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 | |||
101952 | 191250 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 654 Minnesota St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 6015147.38841 | 2105382.23529 | 37.7618295678896 | -122.390723435432 | (37.7618295678896, -122.390723435432) | 10 | 3 | 8 | 28856 | 29 | |||
108911 | 105033 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1550 04th St | 8 | 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 | ||||
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 | |||
112126 | 129414 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2501 Jackson St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6001550.43955 | 2116611.49961 | 37.7918985453389 | -122.438554394686 | (37.7918985453389, -122.438554394686) | 13 | 6 | 1 | 29490 | 27 | |||
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 | |||
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 | |||
131123 | 200103 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1528 Yosemite Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6014982.2186 | 2092417.8102 | 37.7262227853507 | -122.390388836652 | (37.7262227853507, -122.390388836652) | 10 | 3 | 8 | 58 | 1 | |||
135449 | 99385 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1590 Yosemite Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | ||
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 | |||
165931 | 102568 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1655X 04th St | 8 | 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 | ||||
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 | ||||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
106988 | 227598 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 501 14th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6005393.4683 | 2107800.64006 | 37.7679239451627 | -122.424630446843 | (37.7679239451627, -122.424630446843) | 8 | 4 | 5 | 28853 | 19 | |||
107011 | 105032 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1550 04th St | 7 | 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 | ||||
126715 | 129435 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2201 Clay St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6004184.0136 | 2116319.13373 | 37.7912452400168 | -122.429421362005 | (37.7912452400168, -122.429421362005) | 13 | 9 | 1 | 29490 | 27 | |||
143309 | 176963 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 83 Badger St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 2ft | 6002428.97482 | 2094295.2581 | 37.7306734890866 | -122.433918818513 | (37.7306734890866, -122.433918818513) | 9 | 7 | 5 | 28861 | 25 | |||
157982 | 102560 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1755X 04th St | 7 | 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 | ||||
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 | |||
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 | |||
172719 | 191297 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 740 04th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6014617.26494 | 2110308.92783 | 37.7753277532976 | -122.392901635701 | (37.7753277532976, -122.392901635701) | 6 | 2 | 9 | 310 | 20 | |||
180384 | 4517 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 20X Cleary Ct | 7 | 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 | |||
184748 | 102567 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1655X 04th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2013 12:00:00 AM | 3x3 | Permit Number 769962 | 6015154.2 | 2107704.9 | 37.7682074777149 | -122.390862208319 | (37.7682074777149, -122.390862208319) | 14 | 3 | 9 | 310 | 20 | ||
117025 | 187130 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2600 Sunset Blvd | 66 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985156.874 | 2097417.7557 | 37.7382517335963 | -122.493860275789 | (37.7382517335963, -122.493860275789) | 1 | 8 | 3 | 29491 | 35 | |||
93391 | 227607 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1201 San Jose Ave | 61 | Front Yard : Yard | Tree | Private 2 | 2 | 6004513.17713 | 2096122.0643 | 37.7358075450783 | -122.426843458979 | (37.7358075450783, -122.426843458979) | 2 | 7 | 5 | 28861 | 2 | ||||
27188 | 227606 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1201 San Jose Ave | 60 | Front Yard : Yard | Tree | Private 2 | 3 | 6004509.90475 | 2096122.13365 | 37.7358075504724 | -122.426854777822 | (37.7358075504724, -122.426854777822) | 2 | 7 | 5 | 28861 | 2 | ||||
8479 | 204048 | Private 9 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2 Geneva Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2020 12:00:00 AM | 3 | 3x4 | Permit Number 782541 | 5997165 | 2091482 | 37.7226488176407 | -122.451914211983 | (37.7226488176407, -122.451914211983) | 9 | 8 | 6 | 28861 | 24 |
14062 | 227597 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 501 14th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6005381.2036 | 2107800.12984 | 37.7679218515506 | -122.424672832791 | (37.7679218515506, -122.424672832791) | 8 | 4 | 5 | 28853 | 19 | |||
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 | |||
25393 | 31771 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2000 Ulloa St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | Permit Number 35250 | 5989839.49734774 | 2098377.72398218 | 37.7411604150808 | -122.477740406961 | (37.7411604150808, -122.477740406961) | 1 | 8 | 3 | 29491 | 35 | ||
26767 | 129422 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2129 Vallejo St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6003322.87221 | 2117886.87369 | 37.7955010594859 | -122.432512912861 | (37.7955010594859, -122.432512912861) | 13 | 9 | 1 | 29490 | 27 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | ||||
85279 | 200004 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1450 Griffith St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6017626.5562 | 2092285.3405 | 37.7260053809224 | -122.381238201921 | (37.7260053809224, -122.381238201921) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
88043 | 191269 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 538 Delancey St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6015147.69888 | 2113724.07494 | 37.7847344271845 | -122.391305511737 | (37.7847344271845, -122.391305511737) | 6 | 2 | 9 | 28856 | 6 | ||||
88948 | 191275 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 659 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6014152.76855 | 2110885.05471 | 37.7768838565355 | -122.394548799799 | (37.7768838565355, -122.394548799799) | 6 | 2 | 9 | 28856 | 20 | |||
101511 | 129434 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2201 Clay St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6004173.55874 | 2116318.162 | 37.7912419799702 | -122.429457466206 | (37.7912419799702, -122.429457466206) | 13 | 9 | 1 | 29490 | 27 | |||
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 | |||
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 | |||
139421 | 105031 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1550 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 6x6 | 6015081.19497 | 2108038.83155 | 37.7691203294602 | -122.391138071471 | (37.7691203294602, -122.391138071471) | 14 | 3 | 9 | 310 | 20 | |||
140684 | 176927 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 200 Morse St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 30 | Width 10ft | 6000575.21017 | 2087869.90013 | 37.7129255429455 | -122.439867037942 | (37.7129255429455, -122.439867037942) | 9 | 7 | 6 | 28861 | 5 | |||
145623 | 102566 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1655X 04th St | 6 | 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 | ||||
151514 | 191290 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 720 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6014418.02792 | 2110488.47672 | 37.7758096856109 | -122.393603417186 | (37.7758096856109, -122.393603417186) | 6 | 2 | 9 | 310 | 20 | |||
162746 | 94211 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 465 Missouri St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53589 | 6013546.79092 | 2104912.40006 | 37.7604505699522 | -122.396226376258 | (37.7604505699522, -122.396226376258) | 10 | 3 | 8 | 28856 | 29 | |
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 | |||
166455 | 4543 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 66 Cleary Ct | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/21/1994 12:00:00 AM | 12 | 3X3 | 6004823.98553 | 2113713.43923 | 37.784126867551 | -122.427021407244 | (37.784126867551, -122.427021407244) | 13 | 9 | 11 | 28858 | 41 | ||
166949 | 1718 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 555 Battery St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 9x6 | 6012538.25649 | 2117884.3369 | 37.7960123609319 | -122.400625729299 | (37.7960123609319, -122.400625729299) | 3 | 1 | 10 | 28860 | 4 | |||
169259 | 129413 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2111 Webster St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003291.44456 | 2115944.18125 | 37.7901651416677 | -122.432482831414 | (37.7901651416677, -122.432482831414) | 13 | 9 | 1 | 29490 | 27 | |||
176725 | 191284 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 751 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6014408.26812 | 2110636.4725 | 37.7762155064684 | -122.393647539722 | (37.7762155064684, -122.393647539722) | 6 | 2 | 9 | 28856 | 20 | |||
96416 | 186909 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2700 Sunset Blvd | 58 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985192.0104 | 2096702.7177 | 37.7362904860675 | -122.493686118595 | (37.7362904860675, -122.493686118595) | 1 | 8 | 3 | 29491 | 35 | |||
101466 | 227605 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1201 San Jose Ave | 58 | Front Yard : Yard | Tree | Private 2 | 2 | 6004504.61589 | 2096121.06345 | 37.7358043129022 | -122.426872987299 | (37.7358043129022, -122.426872987299) | 2 | 7 | 5 | 28861 | 2 | ||||
82542 | 186908 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2700 Sunset Blvd | 57 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985188.8014 | 2096694.9245 | 37.736268900285 | -122.493696639188 | (37.736268900285, -122.493696639188) | 1 | 8 | 3 | 29491 | 35 | |||
97150 | 227604 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1201 San Jose Ave | 57 | Front Yard : Yard | Tree | Private 2 | 4 | 6004502.9106 | 2096117.99556 | 37.7357957927473 | -122.426878664735 | (37.7357957927473, -122.426878664735) | 2 | 7 | 5 | 28861 | 2 | ||||
2463 | 227603 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1201 San Jose Ave | 55 | Front Yard : Yard | Tree | Private 2 | 2 | 6004504.07862 | 2096101.18791 | 37.7357497087738 | -122.42687342979 | (37.7357497087738, -122.42687342979) | 2 | 7 | 5 | 28861 | 2 | ||||
81506 | 227602 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1201 San Jose Ave | 54 | Front Yard : Yard | Tree | Private 2 | 1 | 6004494.61967 | 2096104.27773 | 37.735757657888 | -122.426906353066 | (37.735757657888, -122.426906353066) | 2 | 7 | 5 | 28861 | 2 | ||||
30144 | 129421 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2129 Vallejo St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6003307.9218 | 2117884.58152 | 37.795493917972 | -122.43256447999 | (37.795493917972, -122.43256447999) | 13 | 9 | 1 | 29490 | 27 | |||
36949 | 227666 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 46 Gough St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006306.62249 | 2109592.20963 | 37.7728946968577 | -122.421599203664 | (37.7728946968577, -122.421599203664) | 8 | 2 | 9 | 28853 | 19 | |||
37373 | 48451 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 740 Euclid Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2002 12:00:00 AM | 4 | Permit Number 45822 | 5995956.24653 | 2113838.6701 | 37.7839652911282 | -122.457709472605 | (37.7839652911282, -122.457709472605) | 11 | 6 | 1 | 54 | 31 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
81296 | 191274 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 659 04th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6014170.53603 | 2110866.45323 | 37.7768337688053 | -122.394486033405 | (37.7768337688053, -122.394486033405) | 6 | 2 | 9 | 28856 | 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 | |||
98350 | 227609 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 400 Prospect Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 33 | 6006260.17283 | 2097644.39448 | 37.740086147061 | -122.420911448013 | (37.740086147061, -122.420911448013) | 2 | 7 | 7 | 28859 | 2 | ||||
100490 | 4553 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 85 Cleary Ct | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6004771.4236 | 2113636.9625 | 37.7839139091534 | -122.427197803426 | (37.7839139091534, -122.427197803426) | 7 | 9 | 11 | 28858 | 41 | |||
104464 | 102565 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1655X 04th St | 5 | 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 | ||||
110399 | 227596 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 501 14th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6005369.47041 | 2107799.69843 | 37.7679200043356 | -122.424713385909 | (37.7679200043356, -122.424713385909) | 8 | 4 | 5 | 28853 | 19 |
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) );