trees
891 rows where qSpecies_id = 75 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7971 | 122653 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
14316 | 256204 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 800 Broadway | 9 | Median : Cutout | Tree | DPW 1 | 3x3 | 6009530 | 2118420 | 37.797314926041 | -122.411072779375 | (37.797314926041, -122.411072779375) | 3 | 1 | 10 | 308 | 4 | ||||
26350 | 115356 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 399 Fremont St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014763.69701 | 2114705.74438 | 37.7874085478076 | -122.392702738938 | (37.7874085478076, -122.392702738938) | 6 | 2 | 9 | 28855 | 6 | |
49283 | 49391 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 522Walbridge Carter St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Permit Number 46344 | 6005169.44863 | 2086179.03953 | 37.7085432500485 | -122.423867667086 | (37.7085432500485, -122.423867667086) | 9 | 7 | 8 | 309 | 5 | |||
50737 | 220459 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1801 Bryant St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6009533.63521 | 2106182.62398 | 37.7637141952672 | -122.410195770427 | (37.7637141952672, -122.410195770427) | 8 | 4 | 8 | 28859 | 19 | |||
68685 | 220421 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1601 Bryant St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009460.39622 | 2107397.55212 | 37.7670460035972 | -122.410534879606 | (37.7670460035972, -122.410534879606) | 8 | 4 | 8 | 28853 | 19 | |||
89633 | 189100 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1444 Galvez Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6015967.06592 | 2097626.12065 | 37.7405783424142 | -122.387347401158 | (37.7405783424142, -122.387347401158) | 10 | 3 | 8 | 58 | 1 | |||
96355 | 84895 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 1699X Valencia St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2007 12:00:00 AM | 3 | 3x3 | Permit No. 49257 | 6006643 | 2099756 | 37.7459057132351 | -122.419737575743 | (37.7459057132351, -122.419737575743) | 2 | 7 | 7 | 28859 | 2 | |
98992 | 88176 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 366 Clementina St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51186 | 6011675 | 2112537 | 37.7812816562818 | -122.403236436508 | (37.7812816562818, -122.403236436508) | 6 | 2 | 9 | 28853 | 34 | ||
100301 | 8266 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1555 Galvez Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/2004 12:00:00 AM | 3 | 3x3 | 6016120.90063 | 2097426.65215 | 37.7400391610845 | -122.386801588226 | (37.7400391610845, -122.386801588226) | 10 | 3 | 8 | 58 | 1 | ||
110028 | 189083 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 320 Clementina St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6011822.07431 | 2112680.25228 | 37.7816832064575 | -122.402737706174 | (37.7816832064575, -122.402737706174) | 6 | 2 | 9 | 28853 | 34 | |||
110523 | 251505 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 360 Clementina St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011658.68026 | 2112523.02352 | 37.7812423686803 | -122.403291911611 | (37.7812423686803, -122.403291911611) | 6 | 2 | 9 | 28853 | 34 | ||||
176715 | 187873 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1600 Indiana St | 9 | : | Tree | Private 2 | 3 | Width 3ft | 6015126.80958 | 2100859.52415 | 37.7494100248665 | -122.390478580644 | (37.7494100248665, -122.390478580644) | 10 | 3 | 8 | 58 | 1 | |||
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 | ||
399 | 137749 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1000x DIVISADERO ST | 8 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001417.6643 | 2112072.2982 | 37.7794275088949 | -122.438688395719 | (37.7794275088949, -122.438688395719) | 15 | 5 | 11 | 29490 | 41 | |||
3351 | 81717 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 998 Indiana St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6014951.75745 | 2104011.46368 | 37.7580548686454 | -122.391304224825 | (37.7580548686454, -122.391304224825) | 10 | 3 | 8 | 28856 | 29 | |||
14390 | 122652 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
19741 | 256203 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 800 Broadway | 8 | Median : Cutout | Tree | DPW 1 | 3x3 | 6009530 | 2118420 | 37.797314926041 | -122.411072779375 | (37.797314926041, -122.411072779375) | 3 | 1 | 10 | 308 | 4 | ||||
22594 | 137765 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 900x DIVISADERO ST | 8 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001461.6592 | 2111740.6449 | 37.7785193755481 | -122.438512430085 | (37.7785193755481, -122.438512430085) | 15 | 5 | 11 | 29490 | 41 | |||
28668 | 140748 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1300x DIVISADERO ST | 8 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001272.3122 | 2113103.8079 | 37.7822515022367 | -122.439265184087 | (37.7822515022367, -122.439265184087) | 15 | 5 | 11 | 29490 | 41 | |||
29382 | 220466 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2044 Bryant St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009529.8002 | 2105117.47534 | 37.7607893248 | -122.410133830538 | (37.7607893248, -122.410133830538) | 2 | 4 | 7 | 28859 | 19 | |||
36095 | 187897 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1701 Indiana St | 8 | : | Tree | Private 2 | 9 | Width 6ft | 6015199.38185 | 2100557.40869 | 37.7485845047902 | -122.39020651772 | (37.7485845047902, -122.39020651772) | 10 | 3 | 8 | 58 | 1 | |||
36653 | 247514 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Divisadero St | 8 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001758.7748 | 2109713.6816 | 37.7729707390414 | -122.437339416937 | (37.7729707390414, -122.437339416937) | 15 | 5 | 11 | 29492 | 9 | |||
48226 | 121547 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 318 Main St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8x15 | 6015095 | 2115307 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | 6 | 2 | 9 | 28855 | 6 | ||||
53294 | 220434 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2x Coso Ave | 8 | Median : Yard | Tree | DPW 1 | 6 | 6007135.32414 | 2099827.64271 | 37.746130149684 | -122.418040260776 | (37.746130149684, -122.418040260776) | 2 | 7 | 7 | 28859 | 2 | ||||
65353 | 115355 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 399 Fremont St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014786.34664 | 2114681.69198 | 37.7873437633547 | -122.392622692086 | (37.7873437633547, -122.392622692086) | 6 | 2 | 9 | 28855 | 6 | |
69442 | 220420 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1601 Bryant St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009463.61799 | 2107301.18006 | 37.766781568731 | -122.410516930005 | (37.766781568731, -122.410516930005) | 8 | 4 | 8 | 28853 | 19 | |||
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 | |||
78835 | 8265 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1555 Galvez Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/2004 12:00:00 AM | 4 | 3x3 | 6016061.13265 | 2097468.88208 | 37.7401518065476 | -122.387011187809 | (37.7401518065476, -122.387011187809) | 10 | 3 | 8 | 58 | 1 | ||
79551 | 141337 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 500x DIVISADERO ST | 8 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001660.0118 | 2110364.3804 | 37.7747517801963 | -122.437727661031 | (37.7747517801963, -122.437727661031) | 15 | 5 | 11 | 29492 | 10 | |||
80657 | 175147 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 199 Hamilton St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 6009085.10423 | 2093766.47253 | 37.7295970383684 | -122.410870135171 | (37.7295970383684, -122.410870135171) | 9 | 3 | 7 | 309 | 28 | |||
84304 | 187899 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1635 Indiana St | 8 | : | Tree | Private 2 | 8 | Width 6ft | 6015181.09261 | 2100903.60273 | 37.7495340665546 | -122.390293946212 | (37.7495340665546, -122.390293946212) | 10 | 3 | 8 | 58 | 1 | |||
85110 | 141592 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 700x DIVISADERO ST | 8 | Median : Cutout | Tree | DPW 1 | 2 | Width 0ft | 6001554.6124 | 2111065.2353 | 37.7766701581153 | -122.438142474688 | (37.7766701581153, -122.438142474688) | 15 | 5 | 11 | 29492 | 10 | |||
87614 | 189099 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1444 Galvez Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6015984.41779 | 2097613.57521 | 37.7405448561703 | -122.387286529648 | (37.7405448561703, -122.387286529648) | 10 | 3 | 8 | 58 | 1 | |||
96395 | 247511 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 400x Divisadero St | 8 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001702.678 | 2110029.6578 | 37.7738351415861 | -122.437556094552 | (37.7738351415861, -122.437556094552) | 15 | 5 | 11 | 29492 | 10 | |||
97729 | 137746 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1100x DIVISADERO ST | 8 | Median : Cutout | Tree | DPW 1 | 2 | Width 0ft | 6001366.2242 | 2112424.9338 | 37.7803928303127 | -122.438891626083 | (37.7803928303127, -122.438891626083) | 15 | 5 | 11 | 29490 | 41 | |||
102819 | 88175 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 360 Clementina St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51186 | 6011658.68026 | 2112523.02352 | 37.7812423686803 | -122.403291911611 | (37.7812423686803, -122.403291911611) | 6 | 2 | 9 | 28853 | 34 | |
122606 | 187947 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 300 Main St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6015161.72984 | 2115222.99296 | 37.7888508922136 | -122.391361788631 | (37.7888508922136, -122.391361788631) | 6 | 2 | 9 | 28855 | 6 | ||||
128497 | 84894 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 1699X Valencia St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2007 12:00:00 AM | 3 | 3x3 | Permit No. 49257 | 6006643 | 2099756 | 37.7459057132351 | -122.419737575743 | (37.7459057132351, -122.419737575743) | 2 | 7 | 7 | 28859 | 2 | |
131621 | 112598 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1200X Divisadero St | 8 | Median : Cutout | Tree | DPW 1 | 3 | 3x3 | 6001320.7065 | 2112754.895 | 37.7812962300665 | -122.439072747614 | (37.7812962300665, -122.439072747614) | 15 | 5 | 11 | 29490 | 41 | |||
135609 | 187872 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1600 Indiana St | 8 | : | Tree | Private 2 | 3 | Width 3ft | 6015125.02693 | 2100883.99929 | 37.7494771295685 | -122.390486455093 | (37.7494771295685, -122.390486455093) | 10 | 3 | 8 | 58 | 1 | |||
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 | ||
160416 | 187917 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 5 Natoma St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6013888.85856 | 2115506.90932 | 37.7895597342357 | -122.395785680575 | (37.7895597342357, -122.395785680575) | 12 | 2 | 9 | 28855 | 6 | |||
164311 | 862 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 400X Alemany Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4x4 | 6008011.36344 | 2095005.68806 | 37.732939390338 | -122.414669840947 | (37.732939390338, -122.414669840947) | 2 | 7 | 7 | 28859 | 2 | |||
165762 | 141322 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 600x DIVISADERO ST | 8 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001602.5949 | 2110732.7849 | 37.7757600616344 | -122.437952671067 | (37.7757600616344, -122.437952671067) | 15 | 5 | 11 | 29492 | 10 | |||
178516 | 220411 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1504 Bryant St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009388.71104 | 2107693.51126 | 37.7678546200096 | -122.410803732829 | (37.7678546200096, -122.410803732829) | 8 | 4 | 7 | 28853 | 19 | |||
183604 | 189082 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 320 Clementina St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6011829.14154 | 2112689.69375 | 37.7817095251229 | -122.402713920937 | (37.7817095251229, -122.402713920937) | 6 | 2 | 9 | 28853 | 34 | |||
189869 | 187863 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1000 22nd St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6014779.35542 | 2103919.85891 | 37.7577937720836 | -122.391894064084 | (37.7577937720836, -122.391894064084) | 10 | 3 | 8 | 28856 | 29 | |||
353 | 112597 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1200X Divisadero St | 7 | Median : Cutout | Tree | DPW 1 | 3 | 3x3 | 6001322.3986 | 2112740.3429 | 37.7812563699828 | -122.439065850543 | (37.7812563699828, -122.439065850543) | 15 | 5 | 11 | 29490 | 41 | |||
2135 | 187956 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 340 Fremont St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6014829.80215 | 2114536.31276 | 37.7869469986487 | -122.392462171218 | (37.7869469986487, -122.392462171218) | 6 | 2 | 9 | 28855 | 6 | |||
15425 | 256202 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 800 Broadway | 7 | Median : Cutout | Tree | DPW 1 | 3x3 | 6009530 | 2118420 | 37.797314926041 | -122.411072779375 | (37.797314926041, -122.411072779375) | 3 | 1 | 10 | 308 | 4 | ||||
17771 | 122651 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
17833 | 261334 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 831 Broadway | 7 | Median : Cutout | Tree | DPW 1 | 3x3 | 6009625 | 2118347 | 37.7971198129045 | -122.410738895692 | (37.7971198129045, -122.410738895692) | 3 | 1 | 10 | 308 | 4 | ||||
18632 | 141321 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 600x DIVISADERO ST | 7 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001606.879 | 2110711.3642 | 37.7757014893927 | -122.437936316665 | (37.7757014893927, -122.437936316665) | 15 | 5 | 11 | 29492 | 10 | |||
25455 | 175146 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 199 Hamilton St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 6009095.72656 | 2093731.386 | 37.7295012938507 | -122.410830935508 | (37.7295012938507, -122.410830935508) | 9 | 3 | 7 | 309 | 28 | |||
27184 | 256213 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 837 Broadway | 7 | Median : Cutout | Tree | DPW 1 | 3x3 | 6009431 | 2118388 | 37.7972215096833 | -122.411413084134 | (37.7972215096833, -122.411413084134) | 3 | 1 | 10 | 308 | 4 | ||||
34640 | 141336 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 500x DIVISADERO ST | 7 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001660.0118 | 2110350.0832 | 37.7747125236659 | -122.437726636856 | (37.7747125236659, -122.437726636856) | 15 | 5 | 11 | 29492 | 10 | |||
54377 | 187896 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1701 Indiana St | 7 | : | Tree | Private 2 | 8 | Width 6ft | 6015200.42778 | 2100533.54912 | 37.7485190494227 | -122.390201234205 | (37.7485190494227, -122.390201234205) | 10 | 3 | 8 | 58 | 1 | |||
75283 | 118380 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 340 Fremont St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | 6014683 | 2114666 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | 6 | 2 | 9 | 28855 | 6 | ||||
78495 | 187871 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1600 Indiana St | 7 | : | Tree | Private 2 | 3 | Width 3ft | 6015124.43266 | 2100904.67109 | 37.7495338570216 | -122.390489954346 | (37.7495338570216, -122.390489954346) | 10 | 3 | 8 | 58 | 1 | |||
94992 | 244916 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 250x Divisadero St | 7 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001807.6192 | 2109359.5595 | 37.7720011845678 | -122.437145099308 | (37.7720011845678, -122.437145099308) | 15 | 5 | 11 | 29492 | 9 | |||
98543 | 116470 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 1945 08th Ave | 7 | 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 | |
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 | ||
106477 | 189098 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1444 Galvez Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6016001.03551 | 2097602.56889 | 37.7405155553478 | -122.387228303953 | (37.7405155553478, -122.387228303953) | 10 | 3 | 8 | 58 | 1 | |||
107786 | 137709 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 800x DIVISADERO ST | 7 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001515.4682 | 2111357.213 | 37.7774696290159 | -122.438298808154 | (37.7774696290159, -122.438298808154) | 15 | 5 | 11 | 29492 | 41 | |||
111858 | 84893 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 1699X Valencia St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2007 12:00:00 AM | 3 | 3x3 | Permit No. 49257 | 6006643 | 2099756 | 37.7459057132351 | -122.419737575743 | (37.7459057132351, -122.419737575743) | 2 | 7 | 7 | 28859 | 2 | |
116898 | 115354 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 399 Fremont St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014804.62773 | 2114662.16926 | 37.7872911737029 | -122.39255807669 | (37.7872911737029, -122.39255807669) | 6 | 2 | 9 | 28855 | 6 | |
130651 | 203412 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1945 08th Ave | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5993816.05949 | 2102205.88495 | 37.7519015516321 | -122.464268849347 | (37.7519015516321, -122.464268849347) | 1 | 8 | 4 | 29491 | 12 | |||
139844 | 121546 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 318 Main St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8x15 | 6015095 | 2115307 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | 6 | 2 | 9 | 28855 | 6 | ||||
139980 | 256007 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 302 Main St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6015252.9594 | 2115128.97629 | 37.7885978067978 | -122.391039570534 | (37.7885978067978, -122.391039570534) | 6 | 2 | 9 | 28855 | 6 | |||||
141746 | 187898 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1635 Indiana St | 7 | : | Tree | Private 2 | 7 | Width 6ft | 6015180.25331 | 2100882.371 | 37.749475722127 | -122.390295365361 | (37.749475722127, -122.390295365361) | 10 | 3 | 8 | 58 | 1 | |||
145342 | 189081 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 320 Clementina St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6011852.23142 | 2112709.4214 | 37.7817649818068 | -122.4026354281 | (37.7817649818068, -122.4026354281) | 6 | 2 | 9 | 28853 | 34 | |||
145821 | 137745 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1100x DIVISADERO ST | 7 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001366.2242 | 2112409.7048 | 37.7803510153457 | -122.438890534421 | (37.7803510153457, -122.438890534421) | 15 | 5 | 11 | 29490 | 41 | |||
145906 | 88174 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 360 Clementina St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51186 | 6011666.30434 | 2112532.55024 | 37.7812689526358 | -122.403266206273 | (37.7812689526358, -122.403266206273) | 6 | 2 | 9 | 28853 | 34 | |
149325 | 187946 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 300 Main St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6015145.56326 | 2115239.56325 | 37.7888954931699 | -122.391418882079 | (37.7888954931699, -122.391418882079) | 6 | 2 | 9 | 28855 | 6 | ||||
150391 | 8264 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1555 Galvez Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/26/2004 12:00:00 AM | 3 | 3x3 | 6016042.02687 | 2097486.66692 | 37.7401995821388 | -122.387078488584 | (37.7401995821388, -122.387078488584) | 10 | 3 | 8 | 58 | 1 | ||
167552 | 187916 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 5 Natoma St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6013874.56797 | 2115495.81816 | 37.7895284855 | -122.395834347372 | (37.7895284855, -122.395834347372) | 12 | 2 | 9 | 28855 | 6 | |||
170997 | 141591 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 700x DIVISADERO ST | 7 | Median : Cutout | Tree | DPW 1 | 2 | Width 0ft | 6001556.326 | 2111042.9577 | 37.776609086888 | -122.438134950627 | (37.776609086888, -122.438134950627) | 15 | 5 | 11 | 29492 | 10 | |||
172086 | 247518 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Divisadero St | 7 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001762.8451 | 2109678.405 | 37.7728741096846 | -122.437322810858 | (37.7728741096846, -122.437322810858) | 15 | 5 | 11 | 29492 | 9 | |||
173604 | 137750 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1000x DIVISADERO ST | 7 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001422.0638 | 2112046.2398 | 37.779356209409 | -122.43867130831 | (37.779356209409, -122.43867130831) | 15 | 5 | 11 | 29490 | 41 | |||
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 | ||
180842 | 140747 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1300x DIVISADERO ST | 7 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001275.0195 | 2113083.841 | 37.7821968322814 | -122.439254386463 | (37.7821968322814, -122.439254386463) | 15 | 5 | 11 | 29490 | 41 | |||
182793 | 861 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 400X Alemany Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/02/2013 12:00:00 AM | 3 | 4x4 | 6008036.03862 | 2095018.0701 | 37.7329747750588 | -122.414585408098 | (37.7329747750588, -122.414585408098) | 2 | 7 | 7 | 28859 | 2 | ||
186328 | 247510 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 400x Divisadero St | 7 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001703.2636 | 2110010.3317 | 37.7737821102395 | -122.437552684593 | (37.7737821102395, -122.437552684593) | 15 | 5 | 11 | 29492 | 10 | |||
1240 | 860 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 400X Alemany Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2003 12:00:00 AM | 9 | 3x3 | 6008061.902 | 2095033.66744 | 37.7330190549875 | -122.414497094675 | (37.7330190549875, -122.414497094675) | 2 | 7 | 7 | 28859 | 2 | ||
1468 | 261333 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 831 Broadway | 6 | Median : Cutout | Tree | DPW 1 | 3x3 | 6009625 | 2118347 | 37.7971198129045 | -122.410738895692 | (37.7971198129045, -122.410738895692) | 3 | 1 | 10 | 308 | 4 | ||||
6100 | 141590 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 700x DIVISADERO ST | 6 | Median : Cutout | Tree | DPW 1 | 2 | Width 0ft | 6001558.8965 | 2111018.1096 | 37.7765410064467 | -122.438124278141 | (37.7765410064467, -122.438124278141) | 15 | 5 | 11 | 29492 | 10 | |||
10505 | 122650 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
10703 | 254081 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1525 Bryant St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 6009448.22373 | 2107633.16245 | 37.7676922528232 | -122.410593622391 | (37.7676922528232, -122.410593622391) | 8 | 4 | 8 | 28853 | 19 | ||||
12995 | 81719 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 998 Indiana St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6014948.61072 | 2104053.54358 | 37.7581702363807 | -122.391318049186 | (37.7581702363807, -122.391318049186) | 10 | 3 | 8 | 28856 | 29 | |||
15780 | 220419 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1601 Bryant St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009469.46402 | 2107213.18669 | 37.7665402869247 | -122.410490495353 | (37.7665402869247, -122.410490495353) | 8 | 4 | 8 | 28853 | 19 | |||
17501 | 251213 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 210X Shipley St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2017 12:00:00 AM | 3 | 2.5x6 | Permit Number 778048 | 6011604 | 2111950 | 37.7796659253507 | -122.403440753721 | (37.7796659253507, -122.403440753721) | 14 | 2 | 9 | 28856 | 34 | |
22052 | 115353 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 399 Fremont St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014819.91687 | 2114646.31579 | 37.7872484927813 | -122.39250406973 | (37.7872484927813, -122.39250406973) | 6 | 2 | 9 | 28855 | 6 | |
32270 | 118379 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 340 Fremont St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | 6014683 | 2114666 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | 6 | 2 | 9 | 28855 | 6 | ||||
34543 | 187929 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 11 Natoma St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6013625.5813 | 2115247.15828 | 37.7888318688552 | -122.396678381805 | (37.7888318688552, -122.396678381805) | 12 | 2 | 9 | 28855 | 6 | |||
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 | ||
43508 | 84892 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 1699X Valencia St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2007 12:00:00 AM | 3 | 3x3 | Permit No. 49257 | 6006643 | 2099756 | 37.7459057132351 | -122.419737575743 | (37.7459057132351, -122.419737575743) | 2 | 7 | 7 | 28859 | 2 | |
47368 | 256212 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 837 Broadway | 6 | Median : Cutout | Tree | DPW 1 | 3x3 | 6009431 | 2118388 | 37.7972215096833 | -122.411413084134 | (37.7972215096833, -122.411413084134) | 3 | 1 | 10 | 308 | 4 | ||||
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 | |||
57096 | 187870 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1600 Indiana St | 6 | : | Tree | Private 2 | 3 | Width 3ft | 6015123.31698 | 2100924.59748 | 37.7495885088097 | -122.390495204594 | (37.7495885088097, -122.390495204594) | 10 | 3 | 8 | 58 | 1 |
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) );