trees

1,914 rows where qSpecies_id = 45 sorted by Zip Codes

✎ 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)
190099 142224 DPW Maintained 1 :: 45 633 HAYES ST 2 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6004805.4597 2110871.2494 37.7763218676751 -122.426883014235 (37.7763218676751, -122.426883014235) 7 9 11 28852 10
192231 244369 DPW Maintained 1 :: 45 301 Octavia St 5 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6005524.5535 2110345.3319 37.7749184587564 -122.424358051661 (37.7749184587564, -122.424358051661) 7 9 11 28852 10
373 200940 DPW Maintained 1 :: 45 1515 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6008432.2434 2109068.8895 37.7715774111529 -122.414209373869 (37.7715774111529, -122.414209373869) 8 2 9 28853 19
758 228462 DPW Maintained 1 :: 45 227 14th St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6007175.76045 2107902.73822 37.7683047783783 -122.418472926402 (37.7683047783783, -122.418472926402) 8 4 7 28853 19
1432 228461 Planning Code 138.1 required 2 :: 45 1813 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft Permit Number 782329 6005355.14245 2107219.1964 37.7663252752163 -122.424721643507 (37.7663252752163, -122.424721643507) 8 4 5 28853 19
8301 114726 Significant Tree 6 :: 45 520 Townsend St 2 Front Yard : Yard Tree Private 2           6012508.1 2109575.3 37.7731959986981 -122.400146236912 (37.7731959986981, -122.400146236912) 14 2 9 28853 34
18479 246372 DPW Maintained 1 :: 45 1999 Mission St 9 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6006820.4847 2107009.8327 37.7658330635794 -122.419638433278 (37.7658330635794, -122.419638433278) 8 4 7 28853 19
25068 246384 DPW Maintained 1 :: 45 1655 Mission St 5 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6006982.6308 2109153.3972 37.7717279173795 -122.419229672629 (37.7717279173795, -122.419229672629) 8 2 9 28853 19
29308 190674 DPW Maintained 1 :: 45 446 Tehama St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6010985.96747 2112156.82627 37.7801992828204 -122.405593378352 (37.7801992828204, -122.405593378352) 14 2 9 28853 34
33531 228505 DPW Maintained 1 :: 45 74 Brady St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6006699.63588 2109500.73575 37.7726656844924 -122.420233227899 (37.7726656844924, -122.420233227899) 8 2 9 28853 19
35954 245454 DPW Maintained 1 :: 45 2700 16th St 7 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6008487.3357 2106844.226 37.7654720981168 -122.41386141193 (37.7654720981168, -122.41386141193) 8 4 7 28853 19
39375 246383 DPW Maintained 1 :: 45 1655 Mission St 4 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6006970.497 2109128.1185 37.771657824727 -122.419269850794 (37.771657824727, -122.419269850794) 8 2 9 28853 19
40092 228506 DPW Maintained 1 :: 45 74 Brady St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6006728.21542 2109473.21902 37.7725917404536 -122.420132414803 (37.7725917404536, -122.420132414803) 8 2 9 28853 19
72393 29881 DPW Maintained 1 :: 45 270 Valencia St 2 Sidewalk: Curb side : Cutout Tree DPW 1     3 3x3   6006056.28059 2108026.10587 37.7685804313738 -122.42235387246 (37.7685804313738, -122.42235387246) 8 4 5 28853 19
76329 246385 DPW Maintained 1 :: 45 1655 Mission St 6 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6006994.7646 2109179.687 37.7718007862576 -122.419189566122 (37.7718007862576, -122.419189566122) 8 2 9 28853 19
82523 200939 DPW Maintained 1 :: 45 1435 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6008734.9445 2109359.299 37.7723918057631 -122.413182848986 (37.7723918057631, -122.413182848986) 8 2 9 28853 34
85945 228504 DPW Maintained 1 :: 45 60 Brady St 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6006682.42728 2109519.39101 37.7727159377106 -122.420294078716 (37.7727159377106, -122.420294078716) 8 2 9 28853 19
91019 246382 DPW Maintained 1 :: 45 1655 Mission St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6006956.341 2109096.7729 37.7715709599047 -122.41931659335 (37.7715709599047, -122.41931659335) 8 2 9 28853 19
102807 228507 DPW Maintained 1 :: 45 74 Brady St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6006742.36606 2109459.07113 37.7725536910199 -122.420082461948 (37.7725536910199, -122.420082461948) 8 2 9 28853 19
110899 114725 Significant Tree 6 :: 45 520 Townsend St 1 Front Yard : Yard Tree Private 2           6012508.1 2109575.3 37.7731959986981 -122.400146236912 (37.7731959986981, -122.400146236912) 14 2 9 28853 34
113764 245458 DPW Maintained 1 :: 45 2800 16th St 4 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6007840.6133 2106809.0367 37.7653391352357 -122.416095791627 (37.7653391352357, -122.416095791627) 8 4 7 28853 19
115574 15276 DPW Maintained 1 :: 45 1563X Mission St 1 Median : Cutout Tree DPW 1   10/28/2016 12:00:00 AM 3   Permit Number 777705 6007259.77782 2109715.95764 37.7732881790271 -122.418310894637 (37.7732881790271, -122.418310894637) 8 2 9 28853 19
119819 116222 Undocumented 4 :: 45 27 RAMONA AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005254 2107682 37.7675903103517 -122.425104409689 (37.7675903103517, -122.425104409689) 8 4 5 28853 19
122461 228508 DPW Maintained 1 :: 45 74 Brady St 4 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6006756.01858 2109446.24098 37.7725192316996 -122.420034325725 (37.7725192316996, -122.420034325725) 8 2 9 28853 19
176151 228503 DPW Maintained 1 :: 45 140 South Van Ness Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007243.83648 2109064.60146 37.7714988123571 -122.418319846488 (37.7714988123571, -122.418319846488) 8 2 9 28853 19
178163 228431 DPW Maintained 1 :: 45 270 Valencia St 1 : Tree Private 2     3 Width 3ft   6006055.13553 2108039.7727 37.7686178926417 -122.422358804308 (37.7686178926417, -122.422358804308) 8 4 5 28853 19
18457 107144 DPW Maintained 1 :: 45 360 Spear St 1 Sidewalk: Curb side : Cutout Landscaping Private 2   02/12/2020 12:00:00 AM 3     6015708 2115219 37.7888702311939 -122.38947147438 (37.7888702311939, -122.38947147438) 6 2 9 28855 6
120746 28868 DPW Maintained 1 :: 45 75 01st St 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/11/2011 12:00:00 AM 3 3x3   6013233.2298598 2115774.102568 37.7902568901803 -122.398072854346 (37.7902568901803, -122.398072854346) 12 2 9 28855 6
253 200884 DPW Maintained 1 :: 45 1200 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6012817.0471 2107089.1245 37.7663867409086 -122.39890301604 (37.7663867409086, -122.39890301604) 14 3 8 28856 20
375 115067 DPW Maintained 1 :: 45 70 Coral Rd 7 Sidewalk: Curb side : Cutout Tree DPW 1           6012676.36761 2102522.24683 37.7538392609312 -122.399069018455 (37.7538392609312, -122.399069018455) 10 3 8 28856 29
1289 190652 DPW Maintained 1 :: 45 310 Arkansas St 1 : Tree Private 2     8 Width 3ft   6012893.9262 2105541.86403 37.7621425904374 -122.398528520183 (37.7621425904374, -122.398528520183) 10 3 8 28856 29
5962 190650 DPW Maintained 1 :: 45 501 Wisconsin St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6012697.31498 2105105.25182 37.7609327945277 -122.399177878376 (37.7609327945277, -122.399177878376) 10 3 8 28856 29
12997 258944 DPW Maintained 1 :: 45 190 Freelon St 1 Sidewalk: Curb side : Yard Landscaping DPW 1       Width 2ft   6013228 2111376 37.7781804260272 -122.397782321929 (37.7781804260272, -122.397782321929) 6 2 9 28856 34
17525 108731 Undocumented 4 :: 45 1822-1898X 23rd St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013006 2102886 37.7548564119513 -122.39795458116 (37.7548564119513, -122.39795458116) 10 3 8 28856 29
20749 190655 DPW Maintained 1 :: 45 354 Arkansas St 1 : Tree Private 2     1 Width 3ft   6012900.86657 2105367.98453 37.7616655423506 -122.398492314369 (37.7616655423506, -122.398492314369) 10 3 8 28856 29
26337 201234 DPW Maintained 1 :: 45 795 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6012343.1682 2112809.9895 37.7820685155731 -122.400944074647 (37.7820685155731, -122.400944074647) 6 2 9 28856 34
30304 190664 DPW Maintained 1 :: 45 153 Freelon St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6013137.75359 2111279.19954 37.7779096079765 -122.398087726493 (37.7779096079765, -122.398087726493) 6 2 9 28856 34
47890 190672 DPW Maintained 1 :: 45 149 Freelon St 4 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   6013276.0134 2111408.93876 37.7782735420174 -122.39761853578 (37.7782735420174, -122.39761853578) 6 2 9 28856 34
52401 190666 DPW Maintained 1 :: 45 153 Freelon St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   6013164.18283 2111305.08822 37.7779821643861 -122.397998114425 (37.7779821643861, -122.397998114425) 6 2 9 28856 34
52669 254715 Permitted Site 7 :: 45 636 Vermont St 1 Sidewalk: Curb side : Cutout Landscaping Private 2   03/20/2018 12:00:00 AM 3 5x5.5   6011227.55095 2105388.49702 37.7616285037909 -122.404281111091 (37.7616285037909, -122.404281111091) 10 3 8 28856 29
57503 115068 DPW Maintained 1 :: 45 70 Coral Rd 8 Sidewalk: Curb side : Cutout Tree DPW 1           6012676.36761 2102522.24683 37.7538392609312 -122.399069018455 (37.7538392609312, -122.399069018455) 10 3 8 28856 29
59015 190673 DPW Maintained 1 :: 45 149 Freelon St 5 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 2ft   6013287.80421 2111419.18552 37.7783023338298 -122.397578465593 (37.7783023338298, -122.397578465593) 6 2 9 28856 34
61589 190669 DPW Maintained 1 :: 45 149 Freelon St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   6013237.11478 2111370.50988 37.7781658589921 -122.397750405181 (37.7781658589921, -122.397750405181) 6 2 9 28856 34
63806 190668 DPW Maintained 1 :: 45 151 Freelon St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6013191.282 2111332.85089 37.7780599035854 -122.397906316128 (37.7780599035854, -122.397906316128) 6 2 9 28856 34
75042 100252 DPW Maintained 1 :: 45 540 Delancey St 6 Sidewalk: Property side : Cutout Tree Private 2     3 3x3   6015236.96681 2113599.67086 37.784397795653 -122.390987973742 (37.784397795653, -122.390987973742) 6 2 9 28856 6
79518 190654 DPW Maintained 1 :: 45 330 Arkansas St 1 : Tree Private 2     14 Width 3ft   6012898.89819 2105464.44963 37.7619303045744 -122.398505891451 (37.7619303045744, -122.398505891451) 10 3 8 28856 29
80878 190651 DPW Maintained 1 :: 45 501 Wisconsin St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6012696.96101 2105116.13755 37.760962664614 -122.399179866755 (37.760962664614, -122.399179866755) 10 3 8 28856 29
93333 254714 Permitted Site 7 :: 45 636 Vermont St 2 Sidewalk: Curb side : Cutout Landscaping Private 2   03/20/2018 12:00:00 AM 3 10x5.5   6011227.55095 2105388.49702 37.7616285037909 -122.404281111091 (37.7616285037909, -122.404281111091) 10 3 8 28856 29
94011 190670 DPW Maintained 1 :: 45 149 Freelon St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6013247.06653 2111383.52028 37.7782021367646 -122.39771689102 (37.7782021367646, -122.39771689102) 6 2 9 28856 34
95951 115061 DPW Maintained 1 :: 45 70 Coral Rd 1 Sidewalk: Curb side : Cutout Tree DPW 1           6012676.36761 2102522.24683 37.7538392609312 -122.399069018455 (37.7538392609312, -122.399069018455) 10 3 8 28856 29
113485 190671 DPW Maintained 1 :: 45 149 Freelon St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6013262.02792 2111394.33223 37.7782326570475 -122.397665892288 (37.7782326570475, -122.397665892288) 6 2 9 28856 34
115561 115066 DPW Maintained 1 :: 45 70 Coral Rd 6 Sidewalk: Curb side : Cutout Tree DPW 1           6012676.36761 2102522.24683 37.7538392609312 -122.399069018455 (37.7538392609312, -122.399069018455) 10 3 8 28856 29
119424 199648 DPW Maintained 1 :: 45 420 05th St 1 Front Yard : Yard Tree Private 2     15 Width 3ft   6012151.63129 2111560.33 37.7786265538123 -122.401518854125 (37.7786265538123, -122.401518854125) 14 2 9 28856 34
124110 190653 DPW Maintained 1 :: 45 320 Arkansas St 2 : Tree Private 2     7 Width 3ft   6012892.66651 2105479.77799 37.7619720457008 -122.398528520179 (37.7619720457008, -122.398528520179) 10 3 8 28856 29
129771 253008 DPW Maintained 1 :: 45 1201 Tennessee St 1 Sidewalk: Curb side : Cutout Landscaping Private 2   07/10/2017 12:00:00 AM 3 11x477   6015595.17459 2103370.35297 37.756330202721 -122.389034232236 (37.756330202721, -122.389034232236) 10 3 8 28856 29
139687 51853 DPW Maintained 1 :: 45 1639 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/14/2005 12:00:00 AM 8   Permit Number 48077 6012728.89469 2105155.76009 37.7610732389628 -122.39907220262 (37.7610732389628, -122.39907220262) 10 3 8 28856 29
143496 190656 DPW Maintained 1 :: 45 358 Arkansas St 1 : Tree Private 2     9 Width 3ft   6012906.49923 2105280.13182 37.7614246319699 -122.398466668421 (37.7614246319699, -122.398466668421) 10 3 8 28856 29
150847 115065 DPW Maintained 1 :: 45 70 Coral Rd 5 Sidewalk: Curb side : Cutout Tree DPW 1           6012676.36761 2102522.24683 37.7538392609312 -122.399069018455 (37.7538392609312, -122.399069018455) 10 3 8 28856 29
154502 115069 DPW Maintained 1 :: 45 70 Coral Rd 9 Sidewalk: Curb side : Cutout Tree DPW 1           6012676.36761 2102522.24683 37.7538392609312 -122.399069018455 (37.7538392609312, -122.399069018455) 10 3 8 28856 29
162453 115062 DPW Maintained 1 :: 45 70 Coral Rd 2 Sidewalk: Curb side : Cutout Tree DPW 1           6012676.36761 2102522.24683 37.7538392609312 -122.399069018455 (37.7538392609312, -122.399069018455) 10 3 8 28856 29
167802 190667 DPW Maintained 1 :: 45 153 Freelon St 4 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   6013174.92981 2111315.77599 37.7780121091073 -122.397961686491 (37.7780121091073, -122.397961686491) 6 2 9 28856 34
177789 115063 DPW Maintained 1 :: 45 70 Coral Rd 3 Sidewalk: Curb side : Cutout Tree DPW 1           6012676.36761 2102522.24683 37.7538392609312 -122.399069018455 (37.7538392609312, -122.399069018455) 10 3 8 28856 29
182182 115064 DPW Maintained 1 :: 45 70 Coral Rd 4 Sidewalk: Curb side : Cutout Tree DPW 1           6012676.36761 2102522.24683 37.7538392609312 -122.399069018455 (37.7538392609312, -122.399069018455) 10 3 8 28856 29
188054 35462 DPW Maintained 1 :: 45 1016 Pennsylvania Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/16/1998 12:00:00 AM 6   Permit Number 38885 6014468.80099 2102427.52316 37.7536788925865 -122.392863694223 (37.7536788925865, -122.392863694223) 10 3 8 28856 29
193887 190665 DPW Maintained 1 :: 45 153 Freelon St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6013152.15167 2111293.3784 37.777949341814 -122.398038913074 (37.777949341814, -122.398038913074) 6 2 9 28856 34
388 109369 DPW Maintained 1 :: 45 2061 Hyde St 1 Sidewalk: Curb side : Cutout Landscaping Private 2 FUF 02/11/2015 12:00:00 AM 3 5x6   6007159.6 2119443.7 37.7999925365465 -122.419347645872 (37.7999925365465, -122.419347645872) 5 1 1 28858 32
7664 261543 Permitted Site 7 :: 45 1305 Lombard St 2 Sidewalk: Property side : Cutout Landscaping Private 2   01/17/2020 12:00:00 AM 3 20x5   6006114.74348 2120010.24127 37.8014892121583 -122.423003541085 (37.8014892121583, -122.423003541085) 13 9 1 28858 32
8883 261542 Permitted Site 7 :: 45 1305 Lombard St 1 Sidewalk: Property side : Cutout Landscaping Private 2   01/17/2020 12:00:00 AM 3 10x5   6006114.74348 2120010.24127 37.8014892121583 -122.423003541085 (37.8014892121583, -122.423003541085) 13 9 1 28858 32
9389 66602 DPW Maintained 1 :: 45 1235 Pine St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/22/1991 12:00:00 AM 13   Permit Number 29795 6008012.17093 2115828.01912 37.7901127525459 -122.416141207354 (37.7901127525459, -122.416141207354) 13 1 10 28858 21
16988 251724 DPW Maintained 1 :: 45 1630 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/06/2017 12:00:00 AM 3 3x3   6006933.88533 2116748.92044 37.7925806317422 -122.419937373279 (37.7925806317422, -122.419937373279) 13 9 10 28858 32
19909 139776 DPW Maintained 1 :: 45 1265 Ellis St 3 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6004800.935 2113296.4778 37.7829806915655 -122.427071445409 (37.7829806915655, -122.427071445409) 7 9 11 28858 41
35856 253828 DPW Maintained 1 :: 45 825 Polk St 2 Sidewalk: Curb side : Cutout Tree Private 2 DPW     3x3   6007000.12586 2113749.24795 37.7843480014325 -122.419495267967 (37.7843480014325, -122.419495267967) 7 9 9 28858 36
37319 105121 Undocumented 4 :: 45 721 BEACH ST   Sidewalk: Curb side : Cutout Tree Private 2     9     6006739.7 2121813.5 37.8064757462399 -122.420969011396 (37.8064757462399, -122.420969011396) 5 1 1 28858 32
41987 139753 DPW Maintained 1 :: 45 1171 Gough St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6005547.6328 2113641.325 37.7839697525349 -122.424512713511 (37.7839697525349, -122.424512713511) 7 9 11 28858 41
45114 109367 DPW Maintained 1 :: 45 1205 Filbert St 4 Sidewalk: Curb side : Cutout Landscaping Private 2 FUF 02/11/2015 12:00:00 AM 3 4.5x6.5   6007075.4 2119431.2 37.7999534721279 -122.419638123127 (37.7999534721279, -122.419638123127) 5 1 1 28858 32
53197 121045 Undocumented 4 :: 45 2316 Polk St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006394 2118785 37.7981407640584 -122.421950099682 (37.7981407640584, -122.421950099682) 13 9 10 28858 32
64175 109535 DPW Maintained 1 :: 45 1234 Filbert St 3 Sidewalk: Property side : Cutout Landscaping Private 2 FUF 02/23/2015 12:00:00 AM 3 1.5x2.4   6007007.9 2119506.8 37.8001572481983 -122.419877066677 (37.8001572481983, -122.419877066677) 5 1 1 28858 32
66039 109366 DPW Maintained 1 :: 45 1205 Filbert St 3 Sidewalk: Property side : Cutout Landscaping Private 2 FUF 02/11/2015 12:00:00 AM 3 3.125x22   6007075.4 2119431.2 37.7999534721279 -122.419638123127 (37.7999534721279, -122.419638123127) 5 1 1 28858 32
67611 129086 DPW Maintained 1 :: 45 1201 Pine St 3 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6008124.6291 2115843.7412 37.7901622440508 -122.415753223646 (37.7901622440508, -122.415753223646) 13 1 10 28858 21
78553 109534 DPW Maintained 1 :: 45 1234 Filbert St 2 Sidewalk: Property side : Cutout Landscaping Private 2 FUF 02/23/2015 12:00:00 AM 3 1.5x2.6   6007007.9 2119506.8 37.8001572481983 -122.419877066677 (37.8001572481983, -122.419877066677) 5 1 1 28858 32
82350 7876 DPW Maintained 1 :: 45 1095X Franklin St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/04/2011 12:00:00 AM 3 3x3   6006012.62101 2113826.37447 37.7845041008944 -122.422917178661 (37.7845041008944, -122.422917178661) 7 9 11 28858 41
85790 66597 DPW Maintained 1 :: 45 1201 Pine St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/22/1991 12:00:00 AM 14   Permit Number 29790 6008070.41503 2115836.67012 37.7901397807808 -122.415940299715 (37.7901397807808, -122.415940299715) 13 1 10 28858 21
94170 139765 DPW Maintained 1 :: 45 1306 Laguna St 3 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6004663.7345 2113397.522 37.7832503745299 -122.427553303818 (37.7832503745299, -122.427553303818) 7 9 11 28858 41
94636 139766 DPW Maintained 1 :: 45 1308 Laguna St 4 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6004662.1567 2113418.8231 37.7833087728144 -122.427560280444 (37.7833087728144, -122.427560280444) 7 9 11 28858 41
100081 138003 DPW Maintained 1 :: 45 1670 Laguna St 2 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6004492.797 2114606.7181 37.7865608551259 -122.428230885205 (37.7865608551259, -122.428230885205) 13 9 11 28858 13
103616 138089 Undocumented 4 :: 45 1600 SUTTER ST 3 Sidewalk: Curb side : Cutout Tree Private 2       Width 0ft   6004809.7961 2114741.3813 37.7869485378128 -122.427143741054 (37.7869485378128, -122.427143741054) 13 9 11 28858 27
103987 121044 Undocumented 4 :: 45 2300 Polk St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006372 2118729 37.7979857614387 -122.422022245981 (37.7979857614387, -122.422022245981) 13 9 10 28858 32
116983 49797 DPW Maintained 1 :: 45 1145 Pine St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/22/1991 12:00:00 AM 13 3x3 Permit Number 46589 6008423.57277 2115887.46945 37.7902991118549 -122.41472199442 (37.7902991118549, -122.41472199442) 5 1 10 28858 21
123221 109536 DPW Maintained 1 :: 45 1234 Filbert St 4 Sidewalk: Property side : Cutout Landscaping Private 2 FUF 02/23/2015 12:00:00 AM 3 1.5x2.4   6007007.9 2119506.8 37.8001572481983 -122.419877066677 (37.8001572481983, -122.419877066677) 5 1 1 28858 32
126828 139746 DPW Maintained 1 :: 45 1314 Laguna St 3 Sidewalk: Curb side : Cutout Tree DPW 1   05/03/2013 12:00:00 AM 2 Width 0ft   6004648.3504 2113539.1351 37.783638338735 -122.427616619318 (37.783638338735, -122.427616619318) 7 9 11 28858 41
130135 253825 DPW Maintained 1 :: 45 725 Ellis St 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW     3x3   6007393.72711 2113660.94359 37.7841277009769 -122.418127279043 (37.7841277009769, -122.418127279043) 7 9 9 28858 36
130980 253827 DPW Maintained 1 :: 45 825 Polk St 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW     3x3   6007000.12586 2113749.24795 37.7843480014325 -122.419495267967 (37.7843480014325, -122.419495267967) 7 9 9 28858 36
131471 7948 DPW Maintained 1 :: 45 1701 Franklin St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/15/2014 12:00:00 AM 6 3X3   6005705.32484 2116013.75926 37.790492771869 -122.424135933935 (37.790492771869, -122.424135933935) 13 9 1 28858 27
134570 253829 DPW Maintained 1 :: 45 869 Ellis St 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW     3x3   6006713.1749 2113568.29571 37.7838349840749 -122.420475171434 (37.7838349840749, -122.420475171434) 7 9 9 28858 36
143343 109370 DPW Maintained 1 :: 45 2061 Hyde St 2 Sidewalk: Curb side : Cutout Landscaping Private 2 FUF 02/11/2015 12:00:00 AM 3 13x6   6007159.6 2119443.7 37.7999925365465 -122.419347645872 (37.7999925365465, -122.419347645872) 5 1 1 28858 32
152658 109368 DPW Maintained 1 :: 45 1205 Filbert St 5 Sidewalk: Curb side : Cutout Landscaping Private 2 FUF 02/11/2015 12:00:00 AM 3 3x22   6007075.4 2119431.2 37.7999534721279 -122.419638123127 (37.7999534721279, -122.419638123127) 5 1 1 28858 32
154649 109365 DPW Maintained 1 :: 45 1205 Filbert St 2 Sidewalk: Curb side : Cutout Landscaping Private 2 FUF 02/11/2015 12:00:00 AM 3 4.5x16   6007075.4 2119431.2 37.7999534721279 -122.419638123127 (37.7999534721279, -122.419638123127) 5 1 1 28858 32
166540 109364 DPW Maintained 1 :: 45 1205 Filbert St 1 Sidewalk: Curb side : Cutout Landscaping Private 2 FUF 02/11/2015 12:00:00 AM 3 4.5x6   6007075.4 2119431.2 37.7999534721279 -122.419638123127 (37.7999534721279, -122.419638123127) 5 1 1 28858 32
166923 117259 DPW Maintained 1 :: 45 670 Eddy St 1 Sidewalk: Property side : Cutout Landscaping Private 2       3x3   6007197.5 2113350.2 37.7832634280904 -122.418784110751 (37.7832634280904, -122.418784110751) 7 9 9 28858 36
167712 137901 DPW Maintained 1 :: 45 402 Austin St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6005281.3807 2115310.0743 37.7885366835693 -122.425552653183 (37.7885366835693, -122.425552653183) 13 9 11 28858 27

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