trees
430 rows where qSpecies_id = 99 sorted by qAddress
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 58154 | 121665 | Undocumented 4 | Ulmus pumila :: Siberian Elm 99 | 100 Montalvo Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x6 | 5993653 | 2099666 | 37.7449182738718 | -122.464648312953 | (37.7449182738718, -122.464648312953) | 1 | 8 | 4 | 29491 | 40 | ||||
| 16067 | 19787 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 100 STAIRWAY19 | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 50ST | |||||||||||||
| 16487 | 19779 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 100 STAIRWAY19 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 50ST | |||||||||||||
| 51308 | 242791 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1001 San Jose Ave | 14 | Front Yard : Yard | Tree | Private 2 | 5 | 6005175.70924 | 2096892.88162 | 37.7379614744454 | -122.424607638258 | (37.7379614744454, -122.424607638258) | 2 | 7 | 5 | 28859 | 2 | ||||
| 47411 | 1433 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 100X Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 5X5 | 5995535.85964 | 2115388.72149 | 37.7881971563264 | -122.459276133553 | (37.7881971563264, -122.459276133553) | 11 | 6 | 1 | 54 | 31 | |||
| 157104 | 1434 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 100X Arguello Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 125 | 3X5 | 5995535.03638 | 2115411.50396 | 37.7882596635004 | -122.459280632339 | (37.7882596635004, -122.459280632339) | 11 | 6 | 1 | 54 | 31 | |||
| 75188 | 1437 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 101X Arguello Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 37 | 5 | 5995475.83232 | 2115319.03247 | 37.7880023578197 | -122.459478767425 | (37.7880023578197, -122.459478767425) | 11 | 6 | 1 | 54 | 11 | |||
| 139838 | 1438 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 101X Arguello Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 5 | 5995477.38208 | 2115292.89339 | 37.7879306760788 | -122.459471511755 | (37.7879306760788, -122.459471511755) | 11 | 6 | 1 | 54 | 11 | |||
| 188888 | 1435 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 101X Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 5 | 5995475.98082 | 2115376.20265 | 37.7881593402184 | -122.459482395726 | (37.7881593402184, -122.459482395726) | 11 | 6 | 1 | 54 | 11 | |||
| 5701 | 215593 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 103 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5995757.42889 | 2087376.90008 | 37.7112964570463 | -122.456483140498 | (37.7112964570463, -122.456483140498) | 9 | 8 | 6 | 28861 | 24 | |||
| 48438 | 26629 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1099X Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/02/2017 12:00:00 AM | 6 | 3x3 | 6011248.5682 | 2094191.84655 | 37.7308861005042 | -122.403420689108 | (37.7308861005042, -122.403420689108) | 10 | 3 | 8 | 58 | 1 | ||
| 4126 | 115471 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 10X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | ||||||||||||||
| 123890 | 253385 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1100 Golden Gate Ave | 1 | Front Yard : Yard | Tree | Private 2 | 6004275 | 2112509 | 37.7807887188922 | -122.428834805692 | (37.7807887188922, -122.428834805692) | 7 | 9 | 11 | 29490 | 41 | |||||
| 66372 | 883 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1100X ALEMANY BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X6 | 6003437 | 2094359 | 37.7309056628368 | -122.430438468366 | (37.7309056628368, -122.430438468366) | 9 | 7 | 5 | 28861 | 25 | |||
| 69092 | 885 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 1100X ALEMANY BLVD | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 6003437 | 2094359 | 37.7309056628368 | -122.430438468366 | (37.7309056628368, -122.430438468366) | 9 | 7 | 5 | 28861 | 25 | ||||
| 147678 | 884 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 1100X ALEMANY BLVD | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/22/2008 12:00:00 AM | 24 | 3X6 | 6003437 | 2094359 | 37.7309056628368 | -122.430438468366 | (37.7309056628368, -122.430438468366) | 9 | 7 | 5 | 28861 | 25 | ||
| 85776 | 19045 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 111 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 5995778.7610227 | 2087391.1107423 | 37.7113367008986 | -122.456410438628 | (37.7113367008986, -122.456410438628) | 9 | 8 | 6 | 28861 | 24 | |||
| 119308 | 180582 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1110 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 4ft | 6003793.49913 | 2094480.4258 | 37.7312592588934 | -122.429214647441 | (37.7312592588934, -122.429214647441) | 9 | 7 | 5 | 28861 | 25 | |||
| 47119 | 180584 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1114 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 6003732.95256 | 2094463.14814 | 37.7312083905422 | -122.429422736186 | (37.7312083905422, -122.429422736186) | 9 | 7 | 5 | 28861 | 25 | |||
| 151809 | 180583 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1114 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 4ft | 6003761.56491 | 2094470.84041 | 37.7312311316907 | -122.429324366526 | (37.7312311316907, -122.429324366526) | 9 | 7 | 5 | 28861 | 25 | |||
| 15479 | 896 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 1155X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 4X4 | 6003365.90456 | 2094243.14139 | 37.7305835136383 | -122.43067599245 | (37.7305835136383, -122.43067599245) | 9 | 7 | 6 | 28861 | 25 | |||
| 136001 | 180590 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1159 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 4ft | 6003628.44812 | 2094335.41976 | 37.7308517598817 | -122.429774919684 | (37.7308517598817, -122.429774919684) | 9 | 7 | 6 | 28861 | 25 | |||
| 2820 | 899 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1161 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4X5 | 6003541.15178 | 2094307.19105 | 37.7307693064514 | -122.43007470418 | (37.7307693064514, -122.43007470418) | 9 | 7 | 6 | 28861 | 25 | |||
| 191151 | 900 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1167 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6003509.89866 | 2094295.64409 | 37.7307358309933 | -122.43018192766 | (37.7307358309933, -122.43018192766) | 9 | 7 | 6 | 28861 | 25 | |||
| 193226 | 242792 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1200 San Jose Ave | 12 | Front Yard : Yard | Tree | Private 2 | 37 | 6003987.76148 | 2095934.32271 | 37.7352623274905 | -122.428646648224 | (37.7352623274905, -122.428646648224) | 2 | 7 | 5 | 28861 | 7 | ||||
| 26511 | 11792 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1200X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 2 | 5991118.2706518 | 2089586.5464947 | 37.7170961765154 | -122.472678089933 | (37.7170961765154, -122.472678089933) | 1 | 8 | 4 | 64 | 14 | |||
| 27401 | 912 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1229 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 4X4 | 6003089.95028 | 2094152.43682 | 37.7303188216593 | -122.431623533692 | (37.7303188216593, -122.431623533692) | 9 | 7 | 6 | 28861 | 25 | |||
| 22805 | 914 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1233 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3X5 | 6003058.45033 | 2094142.01954 | 37.7302884326438 | -122.431731689776 | (37.7302884326438, -122.431731689776) | 9 | 7 | 6 | 28861 | 25 | |||
| 98146 | 915 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1237 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6003037.51053 | 2094134.66319 | 37.7302670467787 | -122.431803556408 | (37.7302670467787, -122.431803556408) | 9 | 7 | 6 | 28861 | 25 | |||
| 41289 | 124637 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 124 Arguello Blvd | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 31 | Width 5ft | 5995537.16304 | 2115311.02189 | 37.7879838891542 | -122.459265995172 | (37.7879838891542, -122.459265995172) | 11 | 6 | 1 | 54 | 31 | ||||
| 65775 | 180589 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1241 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 6003010.99045 | 2094126.19284 | 37.7302422857354 | -122.431894635246 | (37.7302422857354, -122.431894635246) | 9 | 7 | 6 | 28861 | 25 | |||
| 186626 | 917 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1245 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6003003.64796 | 2094102.53816 | 37.7301769190865 | -122.431918330789 | (37.7301769190865, -122.431918330789) | 9 | 7 | 6 | 28861 | 25 | |||
| 61561 | 1440 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 126 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 5X5 | 5995572.08179 | 2115303.34583 | 37.7879648202564 | -122.459144627311 | (37.7879648202564, -122.459144627311) | 11 | 6 | 1 | 54 | 31 | |||
| 139940 | 180580 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1282 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6002752.91911 | 2094123.24132 | 37.7302195481937 | -122.432786610727 | (37.7302195481937, -122.432786610727) | 9 | 7 | 5 | 28861 | 25 | |||
| 56999 | 929 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1286X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3x3 | 6002834.53778 | 2094157.03866 | 37.7303169767627 | -122.432506857514 | (37.7303169767627, -122.432506857514) | 9 | 7 | 5 | 28861 | 25 | |||
| 54348 | 933 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1294X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6002802.17626 | 2094143.63343 | 37.7302783338422 | -122.432617778446 | (37.7302783338422, -122.432617778446) | 9 | 7 | 5 | 28861 | 25 | |||
| 146878 | 16359 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1306x Montgomery St | 3 | Median : Cutout | Tree | DPW 1 | 18 | 8 | 6011459.70542 | 2119848.6083 | 37.8013455628052 | -122.404496083149 | (37.8013455628052, -122.404496083149) | 3 | 1 | 10 | 308 | 23 | |||
| 159593 | 107483 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1306x Montgomery St | 6 | Median : Cutout | Tree | DPW 1 | 17 | 6011458.52251 | 2119859.64432 | 37.8013757989196 | -122.404500953851 | (37.8013757989196, -122.404500953851) | 3 | 1 | 10 | 308 | 23 | ||||
| 62520 | 936 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1309 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/09/2016 12:00:00 AM | 3 | 3X3 | 6002560.70092 | 2093898.03009 | 37.7295902655741 | -122.433435046188 | (37.7295902655741, -122.433435046188) | 9 | 7 | 6 | 28861 | 25 | ||
| 63749 | 938 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1319 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 3X3 | 6002521.94299 | 2093864.98404 | 37.7294973296157 | -122.433566675476 | (37.7294973296157, -122.433566675476) | 9 | 7 | 6 | 28861 | 25 | |||
| 147602 | 939 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1325 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3X3 | 6002500.20649 | 2093846.32088 | 37.7294448514873 | -122.433640487323 | (37.7294448514873, -122.433640487323) | 9 | 7 | 6 | 28861 | 25 | |||
| 4371 | 45657 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1330 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2001 12:00:00 AM | 18 | Permit Number 44353 | 6006599 | 2119096 | 37.7990062508654 | -122.421262834262 | (37.7990062508654, -122.421262834262) | 13 | 9 | 1 | 28858 | 32 | ||
| 91731 | 940 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1331 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4x4 | 6002472.82123 | 2093812.78737 | 37.7293512221746 | -122.433732764948 | (37.7293512221746, -122.433732764948) | 9 | 7 | 6 | 28861 | 25 | |||
| 149879 | 5927 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1335 Eddy St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/26/2016 12:00:00 AM | 12 | 4X4 | 6004029.33456 | 2112693.29822 | 37.781280848415 | -122.429697830179 | (37.781280848415, -122.429697830179) | 7 | 9 | 11 | 29490 | 41 | ||
| 76840 | 117189 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1335 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008262.17379 | 2117224.41185 | 37.7939609578909 | -122.415375111785 | (37.7939609578909, -122.415375111785) | 5 | 1 | 10 | 28858 | 21 | |||
| 112007 | 39229 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1335 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1998 12:00:00 AM | 15 | 3x3 | Permit Number 40871 | 6008226.63206 | 2117220.68496 | 37.793948727108 | -122.415497826087 | (37.793948727108, -122.415497826087) | 5 | 1 | 10 | 28858 | 21 | |
| 64618 | 1441 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 138 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 5X5 | 5995537.91826 | 2115271.42403 | 37.7878752075455 | -122.459260513654 | (37.7878752075455, -122.459260513654) | 11 | 6 | 1 | 54 | 31 | |||
| 23519 | 180581 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1394 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 5ft | 6002394.23037 | 2093854.80651 | 37.7294621373592 | -122.434007462878 | (37.7294621373592, -122.434007462878) | 9 | 7 | 5 | 28861 | 25 | |||
| 184825 | 22541 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1396X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 26 | 3X3 | 6002380.38751 | 2093819.80205 | 37.7293652374447 | -122.434052817677 | (37.7293652374447, -122.434052817677) | 9 | 7 | 6 | 28861 | 25 | |||
| 50531 | 242796 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 140 Belgrave Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | Width 2ft | 5997883.86583 | 2104916.82278 | 37.7595787374877 | -122.450397275322 | (37.7595787374877, -122.450397275322) | 15 | 5 | 11 | 29492 | 12 | |||
| 68463 | 11849 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1401X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3 | 5991539.129622 | 2088082.4465587 | 37.7129906371476 | -122.471113878415 | (37.7129906371476, -122.471113878415) | 9 | 8 | 6 | 64 | 24 | |||
| 35965 | 19053 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 141 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 5995501.70307 | 2087378.49279 | 37.7112861454175 | -122.457367103015 | (37.7112861454175, -122.457367103015) | 9 | 8 | 6 | 28861 | 24 | |||
| 46333 | 21830 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1419X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X6 | 6002361.46709 | 2093663.80125 | 37.7289358208429 | -122.434107079856 | (37.7289358208429, -122.434107079856) | 9 | 7 | 6 | 28861 | 25 | |||
| 68307 | 6271 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 1420X Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6004021.46971 | 2113238.82139 | 37.7827782737541 | -122.429763959937 | (37.7827782737541, -122.429763959937) | 7 | 9 | 11 | 29490 | 41 | |||
| 68771 | 6272 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 1420X Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6003992.00537 | 2113234.021 | 37.782763424573 | -122.429865551596 | (37.782763424573, -122.429865551596) | 7 | 9 | 11 | 29490 | 41 | |||
| 89806 | 6273 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 1420X Ellis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6003962.57834 | 2113230.61655 | 37.78275241032 | -122.429967113747 | (37.78275241032, -122.429967113747) | 7 | 9 | 11 | 29490 | 41 | |||
| 137453 | 6274 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1420X Ellis St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6003886.01337 | 2113219.41254 | 37.7827173105424 | -122.430231196525 | (37.7827173105424, -122.430231196525) | 7 | 9 | 11 | 29490 | 41 | |||
| 118533 | 6276 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1421X Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003957.21776 | 2113179.66455 | 37.7826122052638 | -122.429982023346 | (37.7826122052638, -122.429982023346) | 7 | 9 | 11 | 29490 | 41 | |||
| 131369 | 6275 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1421X Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003957.21776 | 2113179.66455 | 37.7826122052638 | -122.429982023346 | (37.7826122052638, -122.429982023346) | 7 | 9 | 11 | 29490 | 41 | |||
| 176801 | 22540 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 1441X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 12X6 | 6002335.85354 | 2093628.68187 | 37.728837937275 | -122.434193118021 | (37.728837937275, -122.434193118021) | 9 | 7 | 6 | 28861 | 25 | |||
| 95286 | 180588 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1447 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 5ft | 6002392.55611 | 2093716.48474 | 37.7290822421508 | -122.434003367375 | (37.7290822421508, -122.434003367375) | 9 | 7 | 6 | 28861 | 25 | |||
| 135732 | 4849 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1469X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3X6 | 6002249.52444 | 2093516.68285 | 37.7285255132222 | -122.434483558574 | (37.7285255132222, -122.434483558574) | 9 | 7 | 6 | 28861 | 25 | |||
| 69972 | 180587 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1473 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 4ft | 6002172.86661 | 2093413.14517 | 37.7282368704302 | -122.434741167586 | (37.7282368704302, -122.434741167586) | 9 | 7 | 6 | 28861 | 25 | |||
| 46485 | 6279 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1475 Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003832.24761 | 2113162.85488 | 37.7825589718872 | -122.430413166544 | (37.7825589718872, -122.430413166544) | 7 | 9 | 11 | 29490 | 41 | |||
| 68509 | 6281 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1475 Ellis St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003892.9969 | 2113024.38483 | 37.7821822086902 | -122.430193118546 | (37.7821822086902, -122.430193118546) | 7 | 9 | 11 | 29490 | 41 | |||
| 76992 | 6280 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1475 Ellis St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003892.9969 | 2113024.38483 | 37.7821822086902 | -122.430193118546 | (37.7821822086902, -122.430193118546) | 7 | 9 | 11 | 29490 | 41 | |||
| 98627 | 6282 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1475 Ellis St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003892.9969 | 2113024.38483 | 37.7821822086902 | -122.430193118546 | (37.7821822086902, -122.430193118546) | 7 | 9 | 11 | 29490 | 41 | |||
| 107344 | 6284 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1475 Ellis St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003892.9969 | 2113024.38483 | 37.7821822086902 | -122.430193118546 | (37.7821822086902, -122.430193118546) | 7 | 9 | 11 | 29490 | 41 | |||
| 142481 | 26486 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1475 Ellis St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003892.9969 | 2113024.38483 | 37.7821822086902 | -122.430193118546 | (37.7821822086902, -122.430193118546) | 7 | 9 | 11 | 29490 | 41 | |||
| 192958 | 6278 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1475 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003892.9969 | 2113024.38483 | 37.7821822086902 | -122.430193118546 | (37.7821822086902, -122.430193118546) | 7 | 9 | 11 | 29490 | 41 | |||
| 121303 | 4850 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1499X ALEMANY BLVD | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 6x6 | 6002180 | 2093376 | 37.7281352832027 | -122.43471385212 | (37.7281352832027, -122.43471385212) | 9 | 7 | 6 | 28861 | 25 | |||
| 22831 | 11871 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 1499X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 24 | 3 | 5991566.5284818 | 2087248.8358641 | 37.7107033285334 | -122.470958490818 | (37.7107033285334, -122.470958490818) | 9 | 8 | 4 | 64 | 24 | |||
| 119872 | 11873 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 1499X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 30 | 3 | 5991566.5284818 | 2087248.8358641 | 37.7107033285334 | -122.470958490818 | (37.7107033285334, -122.470958490818) | 9 | 8 | 4 | 64 | 24 | |||
| 179933 | 11874 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 1499X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 30 | 3 | 5991566.5284818 | 2087248.8358641 | 37.7107033285334 | -122.470958490818 | (37.7107033285334, -122.470958490818) | 9 | 8 | 4 | 64 | 24 | |||
| 83226 | 182457 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1500 31st Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 27 | Width 0ft | 5986548.9803 | 2104732.6813 | 37.7584178970063 | -122.489584885211 | (37.7584178970063, -122.489584885211) | 1 | 8 | 3 | 56 | 35 | |||
| 165571 | 182456 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1500 31st Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | Width 0ft | 5986548.9803 | 2104699.0505 | 37.7583255560621 | -122.489582412162 | (37.7583255560621, -122.489582412162) | 1 | 8 | 3 | 56 | 35 | |||
| 170304 | 182454 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1500 31st Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 0ft | 5986553.619 | 2104615.5531 | 37.7580965659316 | -122.489560229786 | (37.7580965659316, -122.489560229786) | 1 | 8 | 3 | 56 | 35 | |||
| 60286 | 19057 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 155 Sagamore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 5995437.65535 | 2087381.53973 | 37.7112908326789 | -122.457588686968 | (37.7112908326789, -122.457588686968) | 9 | 8 | 6 | 28861 | 24 | |||
| 74694 | 51907 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 157 Day St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2005 12:00:00 AM | Permit Number 48113 | 6004926.17092668 | 2098691.36646376 | 37.7428856098168 | -122.425598379966 | (37.7428856098168, -122.425598379966) | 2 | 7 | 5 | 63 | 22 | |||
| 113992 | 51906 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 157 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2005 12:00:00 AM | Permit Number 48113 | 6004926.17092668 | 2098691.36646376 | 37.7428856098168 | -122.425598379966 | (37.7428856098168, -122.425598379966) | 2 | 7 | 5 | 63 | 22 | |||
| 57689 | 117255 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1570 31ST AVE | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 5986686.8 | 2104596 | 37.7580506528461 | -122.489098201432 | (37.7580506528461, -122.489098201432) | 1 | 8 | 3 | 56 | 35 | |||||
| 81017 | 117256 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1570 31ST AVE | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 5986686.8 | 2104596 | 37.7580506528461 | -122.489098201432 | (37.7580506528461, -122.489098201432) | 1 | 8 | 3 | 56 | 35 | |||||
| 91388 | 105784 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1570 31ST AVE | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 04/18/2014 12:00:00 AM | Permit Number 772914 | 5986686.8 | 2104596 | 37.7580506528461 | -122.489098201432 | (37.7580506528461, -122.489098201432) | 1 | 8 | 3 | 56 | 35 | |||
| 30682 | 970 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1599 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 38 | 4X4 | 6001869.51123 | 2092911.87236 | 37.7268432620915 | -122.435754028151 | (37.7268432620915, -122.435754028151) | 9 | 7 | 6 | 28861 | 25 | |||
| 128474 | 974 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1599 Alemany Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 3X5 | 6001933.92809 | 2093061.63022 | 37.7272581220521 | -122.435542049851 | (37.7272581220521, -122.435542049851) | 9 | 7 | 6 | 28861 | 25 | |||
| 10682 | 978 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1601 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6001786.79947 | 2092741.59351 | 37.7263710164051 | -122.436027780876 | (37.7263710164051, -122.436027780876) | 9 | 7 | 6 | 28861 | 25 | |||
| 135020 | 979 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1601 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6001800.3284 | 2092768.49495 | 37.7264456502383 | -122.435982936161 | (37.7264456502383, -122.435982936161) | 9 | 7 | 6 | 28861 | 25 | |||
| 5897 | 199851 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1601 Armstrong Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | Width 0ft | 6014366.3226 | 2092462.8184 | 37.7263121847089 | -122.392521119846 | (37.7263121847089, -122.392521119846) | 10 | 3 | 8 | 58 | 1 | |||
| 30014 | 199844 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1601 Armstrong Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 32 | Width 0ft | 6014142.1837 | 2092625.4409 | 37.7267462633936 | -122.393307337928 | (37.7267462633936, -122.393307337928) | 10 | 3 | 8 | 58 | 1 | |||
| 122123 | 199849 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1601 Armstrong Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 0ft | 6014322.4694 | 2092498.1446 | 37.7264067479006 | -122.392675189528 | (37.7264067479006, -122.392675189528) | 10 | 3 | 8 | 58 | 1 | |||
| 153823 | 199846 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1601 Armstrong Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | Width 0ft | 6014210.3999 | 2092579.1513 | 37.7266229511494 | -122.393068277245 | (37.7266229511494, -122.393068277245) | 10 | 3 | 8 | 58 | 1 | |||
| 154944 | 199847 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1601 Armstrong Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | Width 0ft | 6014254.2532 | 2092550.5249 | 37.7265467847844 | -122.392914674805 | (37.7265467847844, -122.392914674805) | 10 | 3 | 8 | 58 | 1 | |||
| 150449 | 116138 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1601X Armstrong Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 30 | 6014404.0852 | 2092434.1919 | 37.7262356791342 | -122.392388573996 | (37.7262356791342, -122.392388573996) | 10 | 3 | 8 | 58 | 1 | ||||
| 56066 | 137081 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1627 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008775.75798 | 2118410.46159 | 37.7972464106437 | -122.413681983361 | (37.7972464106437, -122.413681983361) | 5 | 1 | 10 | 308 | 21 | |||
| 174305 | 137082 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1627 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008777.37552 | 2118389.76877 | 37.7971896841052 | -122.413674921875 | (37.7971896841052, -122.413674921875) | 5 | 1 | 10 | 308 | 21 | |||
| 164727 | 99894 | Significant Tree 6 | Ulmus pumila :: Siberian Elm 99 | 1636 Bush St | 1 | Front Yard : Yard | Tree | Private 2 | 07/11/2012 12:00:00 AM | Permit Number 768849 | 6005665 | 2115204 | 37.7882670981083 | -122.424217840789 | (37.7882670981083, -122.424217840789) | 13 | 9 | 1 | 28858 | 41 | |||
| 27130 | 137079 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1639 Taylor St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008755.55812 | 2118570.22529 | 37.7976839479247 | -122.413763186745 | (37.7976839479247, -122.413763186745) | 5 | 1 | 10 | 308 | 21 | |||
| 74287 | 137080 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1639 Taylor St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008758.62885 | 2118554.07509 | 37.7976397759128 | -122.41375141819 | (37.7976397759128, -122.41375141819) | 5 | 1 | 10 | 308 | 21 | |||
| 191892 | 137078 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1639 Taylor St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008753.16727 | 2118586.36158 | 37.7977281199218 | -122.413772601749 | (37.7977281199218, -122.413772601749) | 5 | 1 | 10 | 308 | 21 | |||
| 8385 | 83273 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1639X Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6008750.42598 | 2118601.99703 | 37.7977708970553 | -122.413783193943 | (37.7977708970553, -122.413783193943) | 5 | 1 | 10 | 308 | 21 |
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) );