trees
1,377 rows where qSpecies_id = 61 sorted by DBH
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3754 | 261321 | DPW Maintained 1 | Tristania conferta :: 61 | 2353 Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001169.3018 | 2119289.54 | 37.7992300540772 | -122.440065245785 | (37.7992300540772, -122.440065245785) | 13 | 9 | 1 | 57 | 17 | ||||
| 16954 | 259600 | DPW Maintained 1 | Tristania conferta :: 61 | 1595 Newcomb Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6015285.2988 | 2095613.9245 | 37.7350154810982 | -122.389564212737 | (37.7350154810982, -122.389564212737) | 10 | 3 | 8 | 58 | 1 | ||||
| 32994 | 257945 | Undocumented 4 | Tristania conferta :: 61 | 901x Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005635 | 2113075 | 37.782419697088 | -122.42417016492 | (37.782419697088, -122.42417016492) | 7 | 9 | 11 | 28852 | 41 | ||||
| 58879 | 49069 | Permitted Site 7 | Tristania conferta :: 61 | 1298 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2015 12:00:00 AM | 3x3 | Permit Number 776020 | 5995836.31315767 | 2092013.47244835 | 37.7240319217297 | -122.45654557668 | (37.7240319217297, -122.45654557668) | 9 | 8 | 4 | 28861 | 40 | ||
| 72043 | 257947 | Undocumented 4 | Tristania conferta :: 61 | 901x Gough St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005635 | 2113075 | 37.782419697088 | -122.42417016492 | (37.782419697088, -122.42417016492) | 7 | 9 | 11 | 28852 | 41 | ||||
| 77502 | 256068 | DPW Maintained 1 | Tristania conferta :: 61 | 2501X Ingalls St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3X3 | 6015373.5361 | 2091407.2745 | 37.7234697537221 | -122.388965539304 | (37.7234697537221, -122.388965539304) | 10 | 3 | 8 | 58 | 1 | ||||
| 82752 | 257946 | Undocumented 4 | Tristania conferta :: 61 | 901x Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005635 | 2113075 | 37.782419697088 | -122.42417016492 | (37.782419697088, -122.42417016492) | 7 | 9 | 11 | 28852 | 41 | ||||
| 88062 | 253300 | DPW Maintained 1 | Tristania conferta :: 61 | 844 33rd Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5985769 | 2110141 | 37.773222058846 | -122.492680686455 | (37.773222058846, -122.492680686455) | 11 | 6 | 2 | 55 | 26 | ||||
| 91678 | 257943 | Undocumented 4 | Tristania conferta :: 61 | 901x Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005635 | 2113075 | 37.782419697088 | -122.42417016492 | (37.782419697088, -122.42417016492) | 7 | 9 | 11 | 28852 | 41 | ||||
| 95289 | 115299 | Permitted Site 7 | Tristania conferta :: 61 | 177 Lomita Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | Permit Number 775793 | 5991298.7 | 2104254.5 | 37.757381090716 | -122.473123533862 | (37.757381090716, -122.473123533862) | 1 | 8 | 4 | 56 | 12 | |||
| 97027 | 115300 | Permitted Site 7 | Tristania conferta :: 61 | 177 Lomita Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | Permit Number 775793 | 5991298.7 | 2104254.5 | 37.757381090716 | -122.473123533862 | (37.757381090716, -122.473123533862) | 1 | 8 | 4 | 56 | 12 | |||
| 107579 | 114595 | DPW Maintained 1 | Tristania conferta :: 61 | 2584 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2015 12:00:00 AM | Permit Number 775079 | 6000253.6 | 2114128.6 | 37.7850072942162 | -122.442863075731 | (37.7850072942162, -122.442863075731) | 15 | 6 | 1 | 29490 | 27 | |||
| 122790 | 257949 | Undocumented 4 | Tristania conferta :: 61 | 901x Gough St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005635 | 2113075 | 37.782419697088 | -122.42417016492 | (37.782419697088, -122.42417016492) | 7 | 9 | 11 | 28852 | 41 | ||||
| 128744 | 257950 | Undocumented 4 | Tristania conferta :: 61 | 901x Gough St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005635 | 2113075 | 37.782419697088 | -122.42417016492 | (37.782419697088, -122.42417016492) | 7 | 9 | 11 | 28852 | 41 | ||||
| 160460 | 257944 | Undocumented 4 | Tristania conferta :: 61 | 901x Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005635 | 2113075 | 37.782419697088 | -122.42417016492 | (37.782419697088, -122.42417016492) | 7 | 9 | 11 | 28852 | 41 | ||||
| 161319 | 257953 | Undocumented 4 | Tristania conferta :: 61 | 901x Gough St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005635 | 2113075 | 37.782419697088 | -122.42417016492 | (37.782419697088, -122.42417016492) | 7 | 9 | 11 | 28852 | 41 | ||||
| 161373 | 255639 | Undocumented 4 | Tristania conferta :: 61 | 200 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999023 | 2112089 | 37.7793368479896 | -122.446973720271 | (37.7793368479896, -122.446973720271) | 15 | 5 | 1 | 54 | 16 | ||||
| 170156 | 114594 | DPW Maintained 1 | Tristania conferta :: 61 | 2584 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2015 12:00:00 AM | Permit Number 775079 | 6000253.6 | 2114128.6 | 37.7850072942162 | -122.442863075731 | (37.7850072942162, -122.442863075731) | 15 | 6 | 1 | 29490 | 27 | |||
| 185914 | 99306 | Permitted Site 7 | Tristania conferta :: 61 | 1345 Turk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2012 12:00:00 AM | 3x3 | Permit Number 768843 | 6003605.0174 | 2112439.8748 | 37.780560974986 | -122.43114766452 | (37.780560974986, -122.43114766452) | 15 | 9 | 11 | 29490 | 41 | ||
| 187605 | 257952 | Undocumented 4 | Tristania conferta :: 61 | 901x Gough St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005635 | 2113075 | 37.782419697088 | -122.42417016492 | (37.782419697088, -122.42417016492) | 7 | 9 | 11 | 28852 | 41 | ||||
| 190547 | 257948 | Undocumented 4 | Tristania conferta :: 61 | 901x Gough St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005635 | 2113075 | 37.782419697088 | -122.42417016492 | (37.782419697088, -122.42417016492) | 7 | 9 | 11 | 28852 | 41 | ||||
| 128869 | 103963 | DPW Maintained 1 | Tristania conferta :: 61 | 2534 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2015 12:00:00 AM | 0 | Permit Number 773267 | 6000467 | 2114127 | 37.7850150648369 | -122.442124666784 | (37.7850150648369, -122.442124666784) | 15 | 6 | 1 | 29490 | 27 | ||
| 21423 | 143427 | DPW Maintained 1 | Tristania conferta :: 61 | 855 SACRAMENTO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6010650.0101 | 2116903.247 | 37.7932130339503 | -122.407090272453 | (37.7932130339503, -122.407090272453) | 3 | 1 | 10 | 28857 | 4 | |||
| 23279 | 22495 | DPW Maintained 1 | Tristania conferta :: 61 | 6315 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/07/2011 12:00:00 AM | 1 | 3x3 | 6013233.044 | 2090405.2973 | 37.7205996457096 | -122.396294690849 | (37.7205996457096, -122.396294690849) | 10 | 3 | 8 | 58 | 1 | ||
| 24711 | 138398 | DPW Maintained 1 | Tristania conferta :: 61 | 2445 PINE ST | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 1 | Width 0ft | 6002388.1124 | 2115043.7135 | 37.7876414218449 | -122.435543840756 | (37.7876414218449, -122.435543840756) | 13 | 6 | 11 | 29490 | 27 | |||
| 24759 | 200143 | DPW Maintained 1 | Tristania conferta :: 61 | 6215 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6013445.5739 | 2090955.2697 | 37.7221215837156 | -122.395598549244 | (37.7221215837156, -122.395598549244) | 10 | 3 | 8 | 58 | 1 | |||
| 27028 | 68142 | DPW Maintained 1 | Tristania conferta :: 61 | 2532 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1993 12:00:00 AM | 1 | Permit Number 31896 | 6000452.2737 | 2114128.7986 | 37.785019164077 | -122.442175744115 | (37.785019164077, -122.442175744115) | 15 | 6 | 1 | 29490 | 27 | |
| 44952 | 200910 | DPW Maintained 1 | Tristania conferta :: 61 | 3801 03rd St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6015813.5433 | 2098253.2638 | 37.7422918453939 | -122.387921978414 | (37.7422918453939, -122.387921978414) | 10 | 3 | 8 | 58 | 1 | |||
| 55863 | 200225 | DPW Maintained 1 | Tristania conferta :: 61 | 3098 Ingalls St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6014353.5321 | 2090113.0139 | 37.7198593794464 | -122.392401052747 | (37.7198593794464, -122.392401052747) | 10 | 3 | 8 | 58 | 1 | |||
| 59790 | 142498 | DPW Maintained 1 | Tristania conferta :: 61 | 535 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6009947.0726 | 2119329.9097 | 37.7998366945829 | -122.409693853229 | (37.7998366945829, -122.409693853229) | 3 | 1 | 10 | 308 | 4 | |||
| 60842 | 143430 | DPW Maintained 1 | Tristania conferta :: 61 | 855 SACRAMENTO ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6010708.6813 | 2116911.5375 | 37.7932390808025 | -122.406887849913 | (37.7932390808025, -122.406887849913) | 3 | 1 | 10 | 28857 | 4 | |||
| 62303 | 199712 | DPW Maintained 1 | Tristania conferta :: 61 | 1510 Wallace Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6015224.5084 | 2092584.2998 | 37.7266933699424 | -122.389562869076 | (37.7266933699424, -122.389562869076) | 10 | 3 | 8 | 58 | 1 | |||
| 63696 | 200519 | DPW Maintained 1 | Tristania conferta :: 61 | 1400x La Salle Ave | 62 | Median : Cutout | Tree | DPW 1 | 1 | Width 0ft | 6016469.2023 | 2095054.3401 | 37.7335445478075 | -122.385432015834 | (37.7335445478075, -122.385432015834) | 10 | 3 | 8 | 58 | 1 | |||
| 65080 | 200763 | DPW Maintained 1 | Tristania conferta :: 61 | 5299 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6014413.6169 | 2093574.8725 | 37.7293682877316 | -122.392435373742 | (37.7293682877316, -122.392435373742) | 10 | 3 | 8 | 58 | 1 | |||
| 69119 | 96027 | DPW Maintained 1 | Tristania conferta :: 61 | 724 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/21/2016 12:00:00 AM | 1 | 3x3 | Permit Number 773631 | 6007519.56601 | 2113828.09623 | 37.7845937435516 | -122.41770377222 | (37.7845937435516, -122.41770377222) | 7 | 9 | 9 | 28858 | 36 |
| 79018 | 140188 | DPW Maintained 1 | Tristania conferta :: 61 | 294 Shrader St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5997403.6344 | 2109575.9167 | 37.772343924669 | -122.452394356341 | (37.772343924669, -122.452394356341) | 15 | 5 | 11 | 29492 | 16 | |||
| 80829 | 246102 | DPW Maintained 1 | Tristania conferta :: 61 | 1764 Waller St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 1 | Width 0ft | 5997188.4287 | 2108119.9769 | 37.7683339575358 | -122.453033652641 | (37.7683339575358, -122.453033652641) | 15 | 5 | 11 | 29492 | 9 | |||
| 82224 | 51915 | DPW Maintained 1 | Tristania conferta :: 61 | 1738 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2008 12:00:00 AM | 1 | 3x3 | Permit Number 50190 | 6004018.6596 | 2119764.7731 | 37.8006967192313 | -122.430239410546 | (37.8006967192313, -122.430239410546) | 13 | 9 | 1 | 57 | 17 | |
| 92466 | 200909 | DPW Maintained 1 | Tristania conferta :: 61 | 3801 03rd St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6015806.4577 | 2098231.0621 | 37.7422304915422 | -122.387944929586 | (37.7422304915422, -122.387944929586) | 10 | 3 | 8 | 58 | 1 | |||
| 97432 | 53100 | DPW Maintained 1 | Tristania conferta :: 61 | 560@ PINE Presidio Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2011 12:00:00 AM | 1 | Permit Number 767803 | 5999200.433 | 2114690.2424 | 37.7864893192828 | -122.446547106561 | (37.7864893192828, -122.446547106561) | 15 | 6 | 1 | 29490 | 31 | ||
| 122744 | 10510 | DPW Maintained 1 | Tristania conferta :: 61 | 1793 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/09/1992 12:00:00 AM | 1 | 5997601.0333 | 2108476.5582 | 37.7693366759731 | -122.451632224006 | (37.7693366759731, -122.451632224006) | 15 | 5 | 11 | 29492 | 9 | |||
| 123740 | 141362 | DPW Maintained 1 | Tristania conferta :: 61 | 1116 FELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6002077.2497 | 2110193.7413 | 37.7743069632368 | -122.436272137566 | (37.7743069632368, -122.436272137566) | 15 | 5 | 11 | 29492 | 10 | |||
| 126613 | 199819 | DPW Maintained 1 | Tristania conferta :: 61 | 2225 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6015792.5909 | 2091976.5907 | 37.7250562032851 | -122.387556629575 | (37.7250562032851, -122.387556629575) | 10 | 3 | 8 | 58 | 1 | |||
| 169282 | 10471 | DPW Maintained 1 | Tristania conferta :: 61 | 1628 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/06/2011 12:00:00 AM | 1 | 3x3 | 5998338.8079 | 2108630.4441 | 37.7698014309157 | -122.44909139548 | (37.7698014309157, -122.44909139548) | 15 | 5 | 11 | 29492 | 9 | ||
| 176867 | 137780 | DPW Maintained 1 | Tristania conferta :: 61 | 1773 Golden Gate Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6001115.5375 | 2111737.5615 | 37.7784912146937 | -122.439709572654 | (37.7784912146937, -122.439709572654) | 15 | 5 | 11 | 29490 | 41 | |||
| 178841 | 10480 | DPW Maintained 1 | Tristania conferta :: 61 | 1665 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/09/1992 12:00:00 AM | 1 | 3X3 | 5998086.3169 | 2108545.149 | 37.7695527882164 | -122.449958603017 | (37.7695527882164, -122.449958603017) | 15 | 5 | 11 | 29492 | 9 | ||
| 185338 | 141842 | DPW Maintained 1 | Tristania conferta :: 61 | 1268 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/26/2011 12:00:00 AM | 1 | Width 0ft | 6004263.4746 | 2112800.275 | 37.7815878353953 | -122.428895449654 | (37.7815878353953, -122.428895449654) | 7 | 9 | 11 | 29490 | 41 | ||
| 191309 | 140352 | DPW Maintained 1 | Tristania conferta :: 61 | 1314 ELLIS ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6004399.7686 | 2113290.1868 | 37.7829407248934 | -122.428458867439 | (37.7829407248934, -122.428458867439) | 7 | 9 | 11 | 29490 | 41 | |||
| 1715 | 122822 | DPW Maintained 1 | Tristania conferta :: 61 | 1736 Stockton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6010044.5984 | 2120081.0225 | 37.8019045299018 | -122.409409413578 | (37.8019045299018, -122.409409413578) | 3 | 1 | 10 | 308 | 23 | |||
| 4029 | 138227 | DPW Maintained 1 | Tristania conferta :: 61 | 101 Anza St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5998554.9543 | 2112632.7248 | 37.7808030238066 | -122.448632050181 | (37.7808030238066, -122.448632050181) | 15 | 6 | 2 | 54 | 16 | |||
| 5348 | 72411 | DPW Maintained 1 | Tristania conferta :: 61 | 475 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6x6 | 6010101.0381 | 2120567.585 | 37.8032436723817 | -122.409248460006 | (37.8032436723817, -122.409248460006) | 3 | 1 | 10 | 308 | 23 | ||
| 10009 | 141171 | DPW Maintained 1 | Tristania conferta :: 61 | 1804 ELLIS ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6002115.9977 | 2112972.331 | 37.7819384740439 | -122.436337000836 | (37.7819384740439, -122.436337000836) | 15 | 5 | 11 | 29490 | 41 | |||
| 13783 | 244951 | DPW Maintained 1 | Tristania conferta :: 61 | 251 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6005979.0205 | 2110582.4222 | 37.7755951037998 | -122.422802804782 | (37.7755951037998, -122.422802804782) | 7 | 9 | 11 | 28852 | 10 | |||
| 15729 | 247461 | DPW Maintained 1 | Tristania conferta :: 61 | 756 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6002953.7505 | 2109617.4268 | 37.7727743077426 | -122.433198975484 | (37.7727743077426, -122.433198975484) | 15 | 5 | 11 | 29492 | 9 | |||
| 16713 | 137874 | DPW Maintained 1 | Tristania conferta :: 61 | 1635 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6005298.8871 | 2115425.6162 | 37.7888549218974 | -122.425500309796 | (37.7888549218974, -122.425500309796) | 13 | 9 | 11 | 28858 | 27 | |||
| 19889 | 248530 | DPW Maintained 1 | Tristania conferta :: 61 | 35 Beulah St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5997722.0136 | 2107803.8234 | 37.7674964457612 | -122.451165239168 | (37.7674964457612, -122.451165239168) | 15 | 5 | 11 | 29492 | 9 | |||
| 20510 | 142108 | DPW Maintained 1 | Tristania conferta :: 61 | 758 FULTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6001607.3106 | 2111115.6492 | 37.7768115789366 | -122.437963788403 | (37.7768115789366, -122.437963788403) | 15 | 5 | 11 | 29492 | 10 | |||
| 25002 | 141440 | DPW Maintained 1 | Tristania conferta :: 61 | 10 Roselyn Ter | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5998236.4031 | 2111655.6366 | 37.7781019737431 | -122.449663638425 | (37.7781019737431, -122.449663638425) | 15 | 6 | 2 | 54 | 16 | |||
| 25063 | 139453 | DPW Maintained 1 | Tristania conferta :: 61 | 901 SCOTT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6001959.1383 | 2111617.5381 | 37.7782096409436 | -122.436782648878 | (37.7782096409436, -122.436782648878) | 15 | 5 | 11 | 29490 | 41 | |||
| 32039 | 245197 | DPW Maintained 1 | Tristania conferta :: 61 | 121 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6001305.0532 | 2109199.3117 | 37.7715326038297 | -122.438872024121 | (37.7715326038297, -122.438872024121) | 15 | 5 | 11 | 29492 | 9 | |||
| 32140 | 140396 | DPW Maintained 1 | Tristania conferta :: 61 | 1260 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6004649.1654 | 2113184.6997 | 37.7826651932841 | -122.427588539655 | (37.7826651932841, -122.427588539655) | 7 | 9 | 11 | 29490 | 41 | |||
| 32919 | 137939 | DPW Maintained 1 | Tristania conferta :: 61 | 1788 SUTTER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6004036.2031 | 2114629.3704 | 37.7865972072742 | -122.429812204107 | (37.7865972072742, -122.429812204107) | 13 | 9 | 11 | 29490 | 27 | |||
| 36334 | 138235 | DPW Maintained 1 | Tristania conferta :: 61 | 230 Masonic Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5998964.7831 | 2112316.4696 | 37.7799580944916 | -122.447191491368 | (37.7799580944916, -122.447191491368) | 15 | 5 | 1 | 54 | 16 | |||
| 40758 | 139813 | DPW Maintained 1 | Tristania conferta :: 61 | 1624 EDDY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6002704.9363 | 2112706.5853 | 37.7812422487992 | -122.434280542357 | (37.7812422487992, -122.434280542357) | 15 | 5 | 11 | 29490 | 41 | |||
| 40821 | 140557 | DPW Maintained 1 | Tristania conferta :: 61 | 1175 MCALLISTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6003583.5208 | 2111740.6921 | 37.7786399751241 | -122.43117211119 | (37.7786399751241, -122.43117211119) | 15 | 9 | 11 | 29492 | 41 | |||
| 43265 | 141978 | DPW Maintained 1 | Tristania conferta :: 61 | 660 FULTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6004530.1468 | 2111579.6326 | 37.7782513432629 | -122.427885886468 | (37.7782513432629, -122.427885886468) | 7 | 9 | 11 | 28852 | 41 | |||
| 43974 | 138903 | DPW Maintained 1 | Tristania conferta :: 61 | 518 WEBSTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6004068.2974 | 2110700.7031 | 37.7758118812147 | -122.42942089821 | (37.7758118812147, -122.42942089821) | 7 | 9 | 11 | 28852 | 10 | |||
| 48811 | 138913 | DPW Maintained 1 | Tristania conferta :: 61 | 719 HAYES ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6004306.0273 | 2110800.8175 | 37.7761002273608 | -122.428605668045 | (37.7761002273608, -122.428605668045) | 7 | 9 | 11 | 28852 | 10 | |||
| 55550 | 138919 | DPW Maintained 1 | Tristania conferta :: 61 | 639 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6004490.1843 | 2110801.4872 | 37.7761124864045 | -122.427968667322 | (37.7761124864045, -122.427968667322) | 7 | 9 | 11 | 28852 | 10 | |||
| 58342 | 244922 | DPW Maintained 1 | Tristania conferta :: 61 | 1306 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5999852.2786 | 2108842.3283 | 37.7704696563836 | -122.44387158208 | (37.7704696563836, -122.44387158208) | 15 | 5 | 11 | 29492 | 9 | |||
| 58783 | 10468 | DPW Maintained 1 | Tristania conferta :: 61 | 1600 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/04/1993 12:00:00 AM | 10 | 3x3 | 5998442.2021 | 2108643.6888 | 37.7698437104477 | -122.448734713286 | (37.7698437104477, -122.448734713286) | 15 | 5 | 11 | 29492 | 9 | ||
| 59303 | 141664 | DPW Maintained 1 | Tristania conferta :: 61 | 1 MASONIC AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5998850.0581 | 2112402.9363 | 37.7801889538337 | -122.447594600794 | (37.7801889538337, -122.447594600794) | 15 | 6 | 2 | 54 | 16 | |||
| 59606 | 40033 | DPW Maintained 1 | Tristania conferta :: 61 | 1526 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/2010 12:00:00 AM | 10 | 3x3 | Permit Number 53136 | 6015229.2383 | 2095373.744 | 37.7343528855845 | -122.389741265179 | (37.7343528855845, -122.389741265179) | 10 | 3 | 8 | 58 | 1 | |
| 61783 | 244949 | DPW Maintained 1 | Tristania conferta :: 61 | 271 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6005972.7806 | 2110626.1021 | 37.7757146861676 | -122.422827495123 | (37.7757146861676, -122.422827495123) | 7 | 9 | 11 | 28852 | 10 | |||
| 67221 | 141932 | DPW Maintained 1 | Tristania conferta :: 61 | 1050 MCALLISTER ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6004095.7926 | 2111864.1542 | 37.7790079875659 | -122.429408772279 | (37.7790079875659, -122.429408772279) | 7 | 9 | 11 | 29490 | 41 | |||
| 69266 | 64367 | DPW Maintained 1 | Tristania conferta :: 61 | 545 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1988 12:00:00 AM | 10 | Permit Number 25206 | 6010276.1583 | 2120241.7062 | 37.8023586991127 | -122.408619445814 | (37.8023586991127, -122.408619445814) | 3 | 1 | 10 | 308 | 23 | |
| 75894 | 141853 | DPW Maintained 1 | Tristania conferta :: 61 | 1165 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6004693.5517 | 2112865.7626 | 37.7817919815777 | -122.42741225416 | (37.7817919815777, -122.42741225416) | 7 | 9 | 11 | 29490 | 41 | |||
| 76237 | 142362 | DPW Maintained 1 | Tristania conferta :: 61 | 1135 ELLIS ST | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6005497.0961 | 2113397.7625 | 37.7832981359874 | -122.424670220029 | (37.7832981359874, -122.424670220029) | 7 | 9 | 11 | 28858 | 41 | |||
| 77373 | 122839 | DPW Maintained 1 | Tristania conferta :: 61 | 945 Scott St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 2x3 | 6001935.4114 | 2111748.3401 | 37.7785674418218 | -122.436874095034 | (37.7785674418218, -122.436874095034) | 15 | 5 | 11 | 29490 | 41 | |||
| 80249 | 142366 | DPW Maintained 1 | Tristania conferta :: 61 | 1135 ELLIS ST | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6005560.2454 | 2113404.4098 | 37.7833199541216 | -122.424452221294 | (37.7833199541216, -122.424452221294) | 7 | 9 | 11 | 28858 | 41 | |||
| 81565 | 141775 | DPW Maintained 1 | Tristania conferta :: 61 | 1330 Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6003753.6876 | 2113301.7561 | 37.7829359095028 | -122.430694865244 | (37.7829359095028, -122.430694865244) | 7 | 9 | 11 | 29490 | 41 | |||
| 83679 | 95598 | DPW Maintained 1 | Tristania conferta :: 61 | 1625 Carroll Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6013982.6065 | 2092044.9941 | 37.7251436063452 | -122.393818384028 | (37.7251436063452, -122.393818384028) | 10 | 3 | 8 | 58 | 1 | |||
| 86436 | 142315 | DPW Maintained 1 | Tristania conferta :: 61 | 1679 Grove St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5999782.049 | 2110521.1531 | 37.7750752776396 | -122.444235164846 | (37.7750752776396, -122.444235164846) | 15 | 5 | 11 | 29492 | 16 | |||
| 89530 | 99869 | DPW Maintained 1 | Tristania conferta :: 61 | 550 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Permit Number 28969 | 6007604.2335 | 2113225.7913 | 37.7829447244363 | -122.417368152144 | (37.7829447244363, -122.417368152144) | 7 | 9 | 9 | 28852 | 36 | |||
| 93756 | 244130 | DPW Maintained 1 | Tristania conferta :: 61 | 312 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6004573.601 | 2109501.44 | 37.7725475930506 | -122.427587463556 | (37.7725475930506, -122.427587463556) | 7 | 9 | 11 | 28852 | 10 | |||
| 95054 | 137897 | DPW Maintained 1 | Tristania conferta :: 61 | 1826 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6003450.1895 | 2115108.5741 | 37.7878797772028 | -122.431873896488 | (37.7878797772028, -122.431873896488) | 13 | 9 | 11 | 29490 | 27 | |||
| 96017 | 140234 | DPW Maintained 1 | Tristania conferta :: 61 | 1 SHRADER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5997242.3128 | 2110421.4899 | 37.7746564060011 | -122.453013427896 | (37.7746564060011, -122.453013427896) | 15 | 5 | 2 | 29492 | 16 | |||
| 99330 | 137776 | DPW Maintained 1 | Tristania conferta :: 61 | 1773 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6001036.7553 | 2111727.7137 | 37.7784596906602 | -122.439981403163 | (37.7784596906602, -122.439981403163) | 15 | 5 | 11 | 29490 | 41 | |||
| 99874 | 29387 | DPW Maintained 1 | Tristania conferta :: 61 | 3103 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2006 12:00:00 AM | 10 | 3x3 | 6014285.3159 | 2089950.3913 | 37.7194090616104 | -122.392625484256 | (37.7194090616104, -122.392625484256) | 10 | 3 | 8 | 58 | 1 | ||
| 101869 | 107147 | DPW Maintained 1 | Tristania conferta :: 61 | 2466 34th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 5985833.5095 | 2098430.6846 | 37.7410725309134 | -122.491595378553 | (37.7410725309134, -122.491595378553) | 1 | 8 | 3 | 29491 | 35 | ||||
| 104500 | 200992 | DPW Maintained 1 | Tristania conferta :: 61 | 75 Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6015461.3418 | 2115791.5015 | 37.7904285101106 | -122.390364901286 | (37.7904285101106, -122.390364901286) | 6 | 2 | 9 | 28855 | 6 | |||
| 109869 | 138450 | DPW Maintained 1 | Tristania conferta :: 61 | 1700 PIERCE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6002081.3526 | 2114464.1963 | 37.7860327882669 | -122.436563672241 | (37.7860327882669, -122.436563672241) | 13 | 6 | 1 | 29490 | 27 | |||
| 112724 | 138451 | DPW Maintained 1 | Tristania conferta :: 61 | 2182 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6002125.8695 | 2114363.4018 | 37.7857585619048 | -122.436402439491 | (37.7857585619048, -122.436402439491) | 13 | 6 | 1 | 29490 | 27 | |||
| 114964 | 200661 | DPW Maintained 1 | Tristania conferta :: 61 | 1530 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6015191.3151 | 2095402.8734 | 37.7344307659905 | -122.389874413148 | (37.7344307659905, -122.389874413148) | 10 | 3 | 8 | 58 | 1 | |||
| 122959 | 45601 | DPW Maintained 1 | Tristania conferta :: 61 | 1100 Fillmore St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2001 12:00:00 AM | 10 | Permit Number 44335 | 6003419.3416 | 2112114.1133 | 37.7796559917005 | -122.431766739067 | (37.7796559917005, -122.431766739067) | 15 | 9 | 11 | 29490 | 41 | ||
| 124213 | 200669 | DPW Maintained 1 | Tristania conferta :: 61 | 1589 Newcomb Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6015338.0615 | 2095574.9021 | 37.7349112589219 | -122.389379067602 | (37.7349112589219, -122.389379067602) | 10 | 3 | 8 | 58 | 1 | |||
| 127215 | 184353 | DPW Maintained 1 | Tristania conferta :: 61 | 1251 Sunset Blvd | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 0ft | 5984679.818 | 2106506.8001 | 37.763179828395 | -122.496180074201 | (37.763179828395, -122.496180074201) | 1 | 8 | 3 | 56 | 35 | |||
| 128044 | 29379 | DPW Maintained 1 | Tristania conferta :: 61 | 3225 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2006 12:00:00 AM | 10 | 3x3 | 6014101.9849 | 2089704.3258 | 37.7187232309961 | -122.393241987123 | (37.7187232309961, -122.393241987123) | 10 | 3 | 8 | 58 | 1 | ||
| 151271 | 244372 | DPW Maintained 1 | Tristania conferta :: 61 | 683 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6004140.6209 | 2110429.49 | 37.7750712910971 | -122.429151370284 | (37.7750712910971, -122.429151370284) | 7 | 9 | 11 | 28852 | 10 | |||
| 152365 | 10492 | DPW Maintained 1 | Tristania conferta :: 61 | 1699 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/09/1992 12:00:00 AM | 10 | 3X3 | 5997918.2468 | 2108523.3453 | 37.7694833025616 | -122.450538376308 | (37.7694833025616, -122.450538376308) | 15 | 5 | 11 | 29492 | 9 |
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) );