861 rows where qSpecies_id = 18 sorted by SiteOrder descending

View and edit SQL

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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);