trees

891 rows where qSpecies_id = 75 sorted by Police Districts descending

✎ View and edit SQL

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)
5294 8118 DPW Maintained 1 Acer rubrum :: Red Maple 75 841 Fulton St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/15/2005 12:00:00 AM 3 3X3   6003718.373 2111409.0283 37.7777369494126 -122.430681932079 (37.7777369494126, -122.430681932079) 7 9 11 29492 10
9298 141986 DPW Maintained 1 Acer rubrum :: Red Maple 75 1067 MCALLISTER ST 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6004102.6078 2111812.2185 37.7788657708335 -122.429381491168 (37.7788657708335, -122.429381491168) 7 9 11 29490 41
23226 139865 DPW Maintained 1 Acer rubrum :: Red Maple 75 752 MCALLISTER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6005530.836 2112064.5728 37.7796394301742 -122.424458633546 (37.7796394301742, -122.424458633546) 7 9 11 28852 41
28925 139861 DPW Maintained 1 Acer rubrum :: Red Maple 75 710 McAllister St 5 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6005666.4072 2112084.3112 37.7797012818942 -122.423991037673 (37.7797012818942, -122.423991037673) 7 9 11 28852 41
31890 141993 DPW Maintained 1 Acer rubrum :: Red Maple 75 818 Webster St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/21/2008 12:00:00 AM 2 Width 0ft   6003993.152 2111582.4748 37.778228754 -122.429743751351 (37.778228754, -122.429743751351) 7 9 11 29490 41
38677 59325 DPW Maintained 1 Acer rubrum :: Red Maple 75 345 Grove St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/26/1990 12:00:00 AM 12   Permit Number 29282 6006158.21098 2111403.55582 37.7778598467005 -122.422241292597 (37.7778598467005, -122.422241292597) 7 9 11 28852 10
41766 87428 Permitted Site 7 Acer rubrum :: Red Maple 75 688X McAllister St 4 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6005853.5155 2112100.03893 37.7797550282384 -122.423344866205 (37.7797550282384, -122.423344866205) 7 9 11 28852 41
42224 100778 DPW Maintained 1 Acer rubrum :: Red Maple 75 450 Hayes St 6 Sidewalk: Curb side : Cutout Tree Private 2   09/10/2012 12:00:00 AM   3x4 Permit Number 768934 6005678.7 2111113.4 37.7770360905223 -122.423879452899 (37.7770360905223, -122.423879452899) 7 9 11 28852 10
42806 125410 DPW Maintained 1 Acer rubrum :: Red Maple 75 680 McAllister St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6005899.66008 2112113.57436 37.7797947974368 -122.423186194101 (37.7797947974368, -122.423186194101) 7 9 11 28852 41
44427 140559 DPW Maintained 1 Acer rubrum :: Red Maple 75 1165 MCALLISTER ST 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6003635.7523 2111746.192 37.7786580361961 -122.430991815 (37.7786580361961, -122.430991815) 15 9 11 29492 41
44631 122582 Undocumented 4 Acer rubrum :: Red Maple 75 2500X Lyon St 2 Median : Cutout Tree Private 2     6 10x20   5999276 2117538 37.7943128273924 -122.446490617691 (37.7943128273924, -122.446490617691) 13 9 1 57 27
47001 14652 DPW Maintained 1 Acer rubrum :: Red Maple 75 655X McAllister St 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/09/2008 12:00:00 AM 3 3x3   6006015.9359491 2112078.013352 37.7797037167615 -122.422781416289 (37.7797037167615, -122.422781416289) 7 9 11 28852 10
49706 125406 DPW Maintained 1 Acer rubrum :: Red Maple 75 2650 Pierce St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6001656.15712 2117548.20785 37.7944765158415 -122.438255746918 (37.7944765158415, -122.438255746918) 13 9 1 57 27
52833 141981 DPW Maintained 1 Acer rubrum :: Red Maple 75 961 Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6004347.2458 2111841.6916 37.7789605439257 -122.428537292711 (37.7789605439257, -122.428537292711) 7 9 11 29490 41
53217 100773 DPW Maintained 1 Acer rubrum :: Red Maple 75 450 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/10/2012 12:00:00 AM   3x4 Permit Number 768934 6005678.7 2111113.4 37.7770360905223 -122.423879452899 (37.7770360905223, -122.423879452899) 7 9 11 28852 10
57246 125407 DPW Maintained 1 Acer rubrum :: Red Maple 75 2600 Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6003635.60452 2117293.35447 37.7938891371273 -122.431388416755 (37.7938891371273, -122.431388416755) 13 9 1 29490 27
57733 29065 Permitted Site 7 Acer rubrum :: Red Maple 75 1001X McAllister St 1 Sidewalk: Curb side : Cutout Tree Rec/Park 5   12/15/2005 12:00:00 AM 3 3x3   6004375.703483 2111849.9138357 37.7789847305516 -122.42843943238 (37.7789847305516, -122.42843943238) 7 9 11 29490 41
60082 29064 Permitted Site 7 Acer rubrum :: Red Maple 75 1000X McAllister St 1 Sidewalk: Curb side : Cutout Tree Office of Mayor 9   03/02/2006 12:00:00 AM 3 3x3   6004368.8552829 2111899.4426369 37.7791203368819 -122.428466654288 (37.7791203368819, -122.428466654288) 7 9 11 29490 41
62005 100775 DPW Maintained 1 Acer rubrum :: Red Maple 75 450 Hayes St 3 Sidewalk: Curb side : Cutout Tree Private 2   09/10/2012 12:00:00 AM   3x4 Permit Number 768934 6005678.7 2111113.4 37.7770360905223 -122.423879452899 (37.7770360905223, -122.423879452899) 7 9 11 28852 10
64870 255402 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 150 Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3   6006976 2111107 37.7770916699959 -122.419391225109 (37.7770916699959, -122.419391225109) 7 9 9 28852 36
65770 14780 DPW Maintained 1 Acer rubrum :: Red Maple 75 1019 McAllister St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/15/2005 12:00:00 AM 3 3X3   6004321.3595 2111841.1408 37.7789575666093 -122.428626804528 (37.7789575666093, -122.428626804528) 7 9 11 29490 41
66306 103269 DPW Maintained 1 Acer rubrum :: Red Maple 75 1175 McAllister St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003540.3 2111739 37.7786328797101 -122.431321507712 (37.7786328797101, -122.431321507712) 15 9 11 29492 41
67270 141925 DPW Maintained 1 Acer rubrum :: Red Maple 75 900 MCALLISTER ST 15 Sidewalk: Curb side : Cutout Tree DPW 1   05/23/2013 12:00:00 AM 2 Width 0ft   6004344.9249 2111897.598 37.7791139177501 -122.428549307734 (37.7791139177501, -122.428549307734) 7 9 11 29490 41
69133 14784 DPW Maintained 1 Acer rubrum :: Red Maple 75 1067 McAllister St 2 Sidewalk: Curb side : Cutout Tree DPW 1   12/15/2005 12:00:00 AM 3 4X4   6004083.6303203 2111809.5297481 37.7788573137505 -122.429446949988 (37.7788573137505, -122.429446949988) 7 9 11 29490 41
70917 125412 DPW Maintained 1 Acer rubrum :: Red Maple 75 677 McAllister St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6005967.20107 2112072.22937 37.779685085531 -122.42294960047 (37.779685085531, -122.42294960047) 7 9 11 28852 10
72419 255414 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 199x Hayes St 10 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3   6006976 2111107 37.7770916699959 -122.419391225109 (37.7770916699959, -122.419391225109) 7 9 9 28852 36
73171 141924 DPW Maintained 1 Acer rubrum :: Red Maple 75 900 MCALLISTER ST 14 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6004374.9759 2111902.445 37.7791289269844 -122.428445694629 (37.7791289269844, -122.428445694629) 7 9 11 29490 41
76492 247421 DPW Maintained 1 Acer rubrum :: Red Maple 75 541 Steiner St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6003124.7415 2110178.9182 37.7743257229582 -122.432647614631 (37.7743257229582, -122.432647614631) 15 9 11 29492 10
76879 139864 DPW Maintained 1 Acer rubrum :: Red Maple 75 716 MCALLISTER ST 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6005563.5601 2112069.7671 37.7796555403571 -122.424345796171 (37.7796555403571, -122.424345796171) 7 9 11 28852 41
78499 255416 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 99x Polk St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3   6007395 2111066 37.7770026839515 -122.417938862064 (37.7770026839515, -122.417938862064) 7 9 9 28852 36
81239 9751 DPW Maintained 1 Acer rubrum :: Red Maple 75 688X McAllister St 3 Sidewalk: Curb side : Cutout Tree DPW 1   03/25/2006 12:00:00 AM 3 3x3   6005981.3683502 2112123.5425617 37.7798267784404 -122.422904237561 (37.7798267784404, -122.422904237561) 7 9 11 28852 41
83821 100777 DPW Maintained 1 Acer rubrum :: Red Maple 75 450 Hayes St 5 Sidewalk: Curb side : Cutout Tree Private 2   09/10/2012 12:00:00 AM   4x3 Permit Number 768934 6005678.7 2111113.4 37.7770360905223 -122.423879452899 (37.7770360905223, -122.423879452899) 7 9 11 28852 10
86398 125408 Permitted Site 7 Acer rubrum :: Red Maple 75 830 Eddy St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/17/2015 12:00:00 AM 4 Width 4ft   6006361.84102 2113219.81406 37.7828583334858 -122.42166589828 (37.7828583334858, -122.42166589828) 7 9 11 28858 41
87472 255403 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 150 Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3   6006976 2111107 37.7770916699959 -122.419391225109 (37.7770916699959, -122.419391225109) 7 9 9 28852 36
87652 125409 DPW Maintained 1 Acer rubrum :: Red Maple 75 680 McAllister St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6005915.13087 2112115.06535 37.7797997643918 -122.42313277978 (37.7797997643918, -122.42313277978) 7 9 11 28852 41
92963 125413 DPW Maintained 1 Acer rubrum :: Red Maple 75 677 McAllister St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6005987.46942 2112075.64039 37.7796955950146 -122.42287972584 (37.7796955950146, -122.42287972584) 7 9 11 28852 10
102704 139863 DPW Maintained 1 Acer rubrum :: Red Maple 75 716 MCALLISTER ST 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6005598.3619 2112075.4809 37.7796731941675 -122.42422580803 (37.7796731941675, -122.42422580803) 7 9 11 28852 41
103123 14797 Permitted Site 7 Acer rubrum :: Red Maple 75 1135 McAllister St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/21/1999 12:00:00 AM 0 4X4   6003741.3117055 2111761.9657456 37.7787073276968 -122.430627770211 (37.7787073276968, -122.430627770211) 15 9 11 29492 41
104491 100779 Permitted Site 7 Acer rubrum :: Red Maple 75 450 Hayes St 7 Sidewalk: Curb side : Cutout Tree Private 2   09/10/2012 12:00:00 AM   3x4 Permit Number 768934 6005678.7 2111113.4 37.7770360905223 -122.423879452899 (37.7770360905223, -122.423879452899) 7 9 11 28852 10
105591 141982 DPW Maintained 1 Acer rubrum :: Red Maple 75 961 Buchanan St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6004375.3351 2111847.7501 37.7789787686216 -122.428440552501 (37.7789787686216, -122.428440552501) 7 9 11 29490 41
108535 255409 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 199x Hayes St 5 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3   6006976 2111107 37.7770916699959 -122.419391225109 (37.7770916699959, -122.419391225109) 7 9 9 28852 36
109022 255406 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 199x Hayes St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3   6006976 2111107 37.7770916699959 -122.419391225109 (37.7770916699959, -122.419391225109) 7 9 9 28852 36
113395 6293 DPW Maintained 1 Acer rubrum :: Red Maple 75 1700X Ellis St 15 Sidewalk: Curb side : Cutout Tree DPW 1   01/28/2013 12:00:00 AM 24 5x7 Permit Number 768629 6002728.2699376 2113059.4201816 37.7822123689276 -122.434225051326 (37.7822123689276, -122.434225051326) 15 9 11 29490 41
113476 139862 DPW Maintained 1 Acer rubrum :: Red Maple 75 716 MCALLISTER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6005633.1637 2112080.6752 37.7796894214359 -122.424105782878 (37.7796894214359, -122.424105782878) 7 9 11 28852 41
117432 14667 Permitted Site 7 Acer rubrum :: Red Maple 75 716 McAllister St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/09/2006 12:00:00 AM 3 4x4   6005306.03378 2112177.46067 37.7799366952092 -122.425244357372 (37.7799366952092, -122.425244357372) 7 9 11 28852 41
121811 125411 DPW Maintained 1 Acer rubrum :: Red Maple 75 680 McAllister St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6005845.66481 2112104.7354 37.7797674805156 -122.423372359172 (37.7797674805156, -122.423372359172) 7 9 11 28852 41
121815 140603 DPW Maintained 1 Acer rubrum :: Red Maple 75 827 Fulton St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6003831.5032 2111426.0587 37.7777901192553 -122.430291791287 (37.7777901192553, -122.430291791287) 7 9 11 29492 10
124352 255410 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 199x Hayes St 6 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3   6006976 2111107 37.7770916699959 -122.419391225109 (37.7770916699959, -122.419391225109) 7 9 9 28852 36
126056 255417 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 99x Polk St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3   6007395 2111066 37.7770026839515 -122.417938862064 (37.7770026839515, -122.417938862064) 7 9 9 28852 36
130074 255415 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 199x Hayes St 11 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3   6006976 2111107 37.7770916699959 -122.419391225109 (37.7770916699959, -122.419391225109) 7 9 9 28852 36
131776 141946 DPW Maintained 1 Acer rubrum :: Red Maple 75 1101 GOLDEN GATE AVE 11 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6004240.9751 2112176.1634 37.7798729062422 -122.428928778012 (37.7798729062422, -122.428928778012) 7 9 11 29490 41
133206 14653 DPW Maintained 1 Acer rubrum :: Red Maple 75 655X McAllister St 3 Sidewalk: Curb side : Cutout Tree DPW 1   03/09/2008 12:00:00 AM 3 3x3   6006015.9359491 2112078.013352 37.7797037167615 -122.422781416289 (37.7797037167615, -122.422781416289) 7 9 11 28852 10
139116 255407 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 199x Hayes St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3   6006976 2111107 37.7770916699959 -122.419391225109 (37.7770916699959, -122.419391225109) 7 9 9 28852 36
141033 29066 Permitted Site 7 Acer rubrum :: Red Maple 75 1001X McAllister St 2 Sidewalk: Curb side : Cutout Tree Rec/Park 5   12/15/2005 12:00:00 AM 3 3x3   6004375.703483 2111849.9138357 37.7789847305516 -122.42843943238 (37.7789847305516, -122.42843943238) 7 9 11 29490 41
142750 8105 DPW Maintained 1 Acer rubrum :: Red Maple 75 780 Fulton St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/15/2005 12:00:00 AM 8 3X3   6004061.6732 2111513.0828 37.7780421005615 -122.429501761419 (37.7780421005615, -122.429501761419) 7 9 11 28852 41
144642 14755 DPW Maintained 1 Acer rubrum :: Red Maple 75 950X McAllister St 3 Sidewalk: Curb side : Cutout Tree DPW 1   05/23/2013 12:00:00 AM 0 4X4   6004580.51193 2112075.36147 37.7796153416711 -122.427746985107 (37.7796153416711, -122.427746985107) 7 9 11 29490 41
147343 52126 DPW Maintained 1 Acer rubrum :: Red Maple 75 482 Linden St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/26/2005 12:00:00 AM 5   Permit Number 48311 6005097.5281 2110773.3561 37.7760695863917 -122.425865698035 (37.7760695863917, -122.425865698035) 7 9 11 28852 10
148004 109047 DPW Maintained 1 Acer rubrum :: Red Maple 75 2146 Bay St 1 Sidewalk: Curb side : Cutout Tree Private 2     1     6000527.7493 2120317.86339 37.802017012843 -122.442359096207 (37.802017012843, -122.442359096207) 13 9 1 57 17
149074 255412 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 199x Hayes St 8 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3   6006976 2111107 37.7770916699959 -122.419391225109 (37.7770916699959, -122.419391225109) 7 9 9 28852 36
149926 100776 DPW Maintained 1 Acer rubrum :: Red Maple 75 450 Hayes St 4 Sidewalk: Curb side : Cutout Tree Private 2   09/10/2012 12:00:00 AM   3x4 Permit Number 768934 6005678.7 2111113.4 37.7770360905223 -122.423879452899 (37.7770360905223, -122.423879452899) 7 9 11 28852 10
164769 255405 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 199x Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3   6006976 2111107 37.7770916699959 -122.419391225109 (37.7770916699959, -122.419391225109) 7 9 9 28852 36
165740 255404 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 150 Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3   6006976 2111107 37.7770916699959 -122.419391225109 (37.7770916699959, -122.419391225109) 7 9 9 28852 36
167057 6288 Permitted Site 7 Acer rubrum :: Red Maple 75 1700X Ellis St 2 Sidewalk: Curb side : Cutout Tree Rec/Park 5   01/28/2013 12:00:00 AM   4x3 Permit Number 768629 6002728.2699376 2113059.4201816 37.7822123689276 -122.434225051326 (37.7822123689276, -122.434225051326) 15 9 11 29490 41
167550 255408 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 199x Hayes St 4 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3   6006976 2111107 37.7770916699959 -122.419391225109 (37.7770916699959, -122.419391225109) 7 9 9 28852 36
178102 255413 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 199x Hayes St 9 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3   6006976 2111107 37.7770916699959 -122.419391225109 (37.7770916699959, -122.419391225109) 7 9 9 28852 36
179705 255411 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 199x Hayes St 7 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3   6006976 2111107 37.7770916699959 -122.419391225109 (37.7770916699959, -122.419391225109) 7 9 9 28852 36
180115 9750 DPW Maintained 1 Acer rubrum :: Red Maple 75 688X McAllister St 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/25/2006 12:00:00 AM 3 3x3   6005981.3683502 2112123.5425617 37.7798267784404 -122.422904237561 (37.7798267784404, -122.422904237561) 7 9 11 28852 41
184236 100774 DPW Maintained 1 Acer rubrum :: Red Maple 75 450 Hayes St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/10/2012 12:00:00 AM   3x4 Permit Number 768934 6005678.7 2111113.4 37.7770360905223 -122.423879452899 (37.7770360905223, -122.423879452899) 7 9 11 28852 10
186343 141990 DPW Maintained 1 Acer rubrum :: Red Maple 75 780 FULTON ST 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6004028.4702 2111508.2869 37.7780270522314 -122.429616280333 (37.7780270522314, -122.429616280333) 7 9 11 28852 41
191096 29063 Permitted Site 7 Acer rubrum :: Red Maple 75 1000X McAllister St 2 Sidewalk: Curb side : Cutout Tree Office of Mayor 9   12/15/2005 12:00:00 AM 3 3x3   6004368.8552829 2111899.4426369 37.7791203368819 -122.428466654288 (37.7791203368819, -122.428466654288) 7 9 11 29490 41
5464 66327 DPW Maintained 1 Acer rubrum :: Red Maple 75 1231 29th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/05/1990 12:00:00 AM 4   Permit Number 29446 5987052.1054 2106857.6987 37.7642819711606 -122.488001017639 (37.7642819711606, -122.488001017639) 1 8 3 56 35
6716 208999 DPW Maintained 1 Acer rubrum :: Red Maple 75 10 Yerba Buena Ave 4 Sidewalk: Curb side : Yard Tree Private 2     33 Width 4ft   5993404.32279 2097201.32336 37.7381365526709 -122.465329186907 (37.7381365526709, -122.465329186907) 1 8 4 59 40
13427 208966 DPW Maintained 1 Acer rubrum :: Red Maple 75 44 Yerba Buena Ave 1 Sidewalk: Curb side : Yard Tree Private 2   07/17/2018 12:00:00 AM 3 Width 6ft Permit Number 781880 5993637 2097007 37.7376164050624 -122.464510605988 (37.7376164050624, -122.464510605988) 1 8 4 59 40
18211 49144 Permitted Site 7 Acer rubrum :: Red Maple 75 206 Lobos St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/21/2003 12:00:00 AM     Permit Number 46269 5994953.84956095 2088734.37736924 37.7149776031797 -122.459358738579 (37.7149776031797, -122.459358738579) 9 8 6 28861 24
19089 203401 DPW Maintained 1 Acer rubrum :: Red Maple 75 24 Yerba Buena Ave 1 Sidewalk: Curb side : Yard Tree Private 2     1 Width 6ft   5993518.80789 2097119.92672 37.7379196595754 -122.464927448042 (37.7379196595754, -122.464927448042) 1 8 4 59 40
25740 116468 Permitted Site 7 Acer rubrum :: Red Maple 75 1945 08th Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   04/04/2016 12:00:00 AM 3 3x3 Permit Number 777920 5993792.2 2102201.1 37.751887038112 -122.464351010806 (37.751887038112, -122.464351010806) 1 8 4 29491 12
28189 203426 DPW Maintained 1 Acer rubrum :: Red Maple 75 135 Yerba Buena Ave 4 Sidewalk: Curb side : Yard Tree Private 2     2 Width 4ft   5994229.44749 2096660.50029 37.7366991374492 -122.462437122787 (37.7366991374492, -122.462437122787) 9 8 4 59 40
28362 203408 DPW Maintained 1 Acer rubrum :: Red Maple 75 1945 08th Ave 3 Sidewalk: Curb side : Yard Tree Private 2     2 Width 6ft   5993769.17892 2102256.91781 37.7520389725334 -122.464434672649 (37.7520389725334, -122.464434672649) 1 8 4 29491 12
31270 28843 DPW Maintained 1 Acer rubrum :: Red Maple 75 338 Shields St 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/30/2008 12:00:00 AM 3 3X3   5993062.32103 2089859.01247 37.7179566445716 -122.465978279778 (37.7179566445716, -122.465978279778) 9 8 6 64 24
37037 203405 DPW Maintained 1 Acer rubrum :: Red Maple 75 155 Yerba Buena Ave 4 Sidewalk: Curb side : Yard Tree Private 2     1 Width 8ft   5994431.87617 2096469.95405 37.7361875994652 -122.461723432511 (37.7361875994652, -122.461723432511) 9 8 4 59 40
39683 203406 DPW Maintained 1 Acer rubrum :: Red Maple 75 155 Yerba Buena Ave 5 Sidewalk: Curb side : Yard Tree Private 2     1 Width 8ft   5994466.0383 2096440.37443 37.7361083476053 -122.461603176966 (37.7361083476053, -122.461603176966) 9 8 4 59 40
42049 116467 Permitted Site 7 Acer rubrum :: Red Maple 75 1945 08th Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   04/04/2016 12:00:00 AM 3 3x3 Permit Number 777920 5993792.2 2102201.1 37.751887038112 -122.464351010806 (37.751887038112, -122.464351010806) 1 8 4 29491 12
42705 203416 DPW Maintained 1 Acer rubrum :: Red Maple 75 75 Yerba Buena Ave 1 Sidewalk: Curb side : Yard Tree Private 2     2 Width 4ft   5993822.50089 2096951.15994 37.7374737738828 -122.463865194036 (37.7374737738828, -122.463865194036) 1 8 4 59 40
47342 203409 DPW Maintained 1 Acer rubrum :: Red Maple 75 1945 08th Ave 4 Sidewalk: Curb side : Yard Tree Private 2     4 Width 6ft   5993779.2225 2102246.74831 37.7520116286371 -122.464399202454 (37.7520116286371, -122.464399202454) 1 8 4 29491 12
50165 203399 DPW Maintained 1 Acer rubrum :: Red Maple 75 1898 08th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5993788.70878 2102627.32377 37.7530571381766 -122.464394026856 (37.7530571381766, -122.464394026856) 1 8 4 56 12
52186 185222 DPW Maintained 1 Acer rubrum :: Red Maple 75 2507 34th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     4 Width 0ft   5985796.7937 2098135.752 37.740260579141 -122.491700620712 (37.740260579141, -122.491700620712) 1 8 3 29491 35
54288 115736 Significant Tree 6 Acer rubrum :: Red Maple 75 66 Yerba Buena Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3   Permit Number 776551 5993801.4 2096894.7 37.7373175329251 -122.463934052027 (37.7373175329251, -122.463934052027) 1 8 4 59 40
54520 203411 DPW Maintained 1 Acer rubrum :: Red Maple 75 1945 08th Ave 6 Sidewalk: Curb side : Yard Tree Private 2     2 Width 6ft   5993801.54167 2102222.78745 37.7519471247661 -122.464320280662 (37.7519471247661, -122.464320280662) 1 8 4 29491 12
54765 203417 DPW Maintained 1 Acer rubrum :: Red Maple 75 57 Yerba Buena Ave 1 Sidewalk: Curb side : Yard Tree Private 2     2 Width 4ft   5993769.49059 2096990.17002 37.7375778308529 -122.46405130512 (37.7375778308529, -122.46405130512) 1 8 4 59 40
61751 116466 Permitted Site 7 Acer rubrum :: Red Maple 75 1945 08th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   04/04/2016 12:00:00 AM 3 3x3 Permit Number 777920 5993792.2 2102201.1 37.751887038112 -122.464351010806 (37.751887038112, -122.464351010806) 1 8 4 29491 12
69264 116464 Permitted Site 7 Acer rubrum :: Red Maple 75 1945 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/04/2016 12:00:00 AM 3 3x3 Permit Number 777920 5993792.2 2102201.1 37.751887038112 -122.464351010806 (37.751887038112, -122.464351010806) 1 8 4 29491 12
71364 115730 Significant Tree 6 Acer rubrum :: Red Maple 75 10x Yerba Buena Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3   Permit Number 776540 5993642.27748 2097056.19499 37.7377517864641 -122.46449593033 (37.7377517864641, -122.46449593033) 1 8 4 59 40
73267 115729 Significant Tree 6 Acer rubrum :: Red Maple 75 10x Yerba Buena Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3   Permit Number 776540 5993642.27748 2097056.19499 37.7377517864641 -122.46449593033 (37.7377517864641, -122.46449593033) 1 8 4 59 40
74820 203413 DPW Maintained 1 Acer rubrum :: Red Maple 75 1945 08th Ave 8 Sidewalk: Curb side : Yard Tree Private 2     3 Width 6ft   5993820.42059 2102181.53499 37.7518349442394 -122.464252000534 (37.7518349442394, -122.464252000534) 1 8 4 29491 12
77903 203422 DPW Maintained 1 Acer rubrum :: Red Maple 75 9 Yerba Buena Ave 1 Sidewalk: Curb side : Yard Tree Private 2     2 Width 4ft   5993354.86667 2097295.22775 37.738391538344 -122.465506999949 (37.738391538344, -122.465506999949) 1 8 4 59 40
83163 115737 Significant Tree 6 Acer rubrum :: Red Maple 75 9x Yerba Buena Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3   Permit Number 776557 5993642.27748 2097056.19499 37.7377517864641 -122.46449593033 (37.7377517864641, -122.46449593033) 1 8 4 59 40
85232 87436 DPW Maintained 1 Acer rubrum :: Red Maple 75 3726X Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/22/2008 12:00:00 AM 3 3x3   5993141.944866 2087637.371973 37.7118611458885 -122.465541749955 (37.7118611458885, -122.465541749955) 9 8 4 64 24
89204 185773 DPW Maintained 1 Acer rubrum :: Red Maple 75 1615 Ortega St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5989001.3995 2102380.5121 37.7521023420375 -122.480931213247 (37.7521023420375, -122.480931213247) 1 8 3 29491 35
90224 1221 DPW Maintained 1 Acer rubrum :: Red Maple 75 3600X Alemany Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1   04/22/2008 12:00:00 AM 3 3X5   5993524.0546702 2087589.4711722 37.7117516532039 -122.464217607089 (37.7117516532039, -122.464217607089) 9 8 4 64 24
96718 115731 Significant Tree 6 Acer rubrum :: Red Maple 75 15 Yerba Buena Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3   Permit Number 776556 5993468.8 2097225 37.7382052810266 -122.465107977902 (37.7382052810266, -122.465107977902) 1 8 4 59 40

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