trees
1,746 rows where qSpecies_id = 10 sorted by qCareAssistant 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23754 | 113821 | Undocumented 4 | Melaleuca quinquenervia :: Cajeput 10 | 4101x 25TH ST | 14 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 10 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | ||
64581 | 99308 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1902X 41st Ave | 20 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 6 | 3X3 | 5983703.9 | 2101544.3 | 37.7494969779561 | -122.499188691375 | (37.7494969779561, -122.499188691375) | 1 | 8 | 3 | 29491 | 35 | ||
50943 | 258449 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 540 Hampshire St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3x3 | 6010043 | 2105722 | 37.7624779645344 | -122.408401534669 | (37.7624779645344, -122.408401534669) | 8 | 4 | 8 | 28859 | 19 | |||
81089 | 258450 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 540 Hampshire St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3x3 | 6010043 | 2105722 | 37.7624779645344 | -122.408401534669 | (37.7624779645344, -122.408401534669) | 8 | 4 | 8 | 28859 | 19 | |||
159974 | 187630 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 4255x Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 03/23/2015 05:35:00 PM | 3x3 | 5981269 | 2105492 | 37.7601930989218 | -122.507901429287 | (37.7601930989218, -122.507901429287) | 1 | 8 | 3 | 56 | 35 | ||
179423 | 258451 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 540 Hampshire St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3x3 | 6010043 | 2105722 | 37.7624779645344 | -122.408401534669 | (37.7624779645344, -122.408401534669) | 8 | 4 | 8 | 28859 | 19 | |||
186546 | 258448 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 540 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3x3 | 6010043 | 2105722 | 37.7624779645344 | -122.408401534669 | (37.7624779645344, -122.408401534669) | 8 | 4 | 8 | 28859 | 19 | |||
91 | 260225 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2201x 22nd Ave | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | ||||||||||||
552 | 78931 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2701 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5986423.7343 | 2105012.1654 | 37.7591779705862 | -122.490038592243 | (37.7591779705862, -122.490038592243) | 1 | 8 | 3 | 56 | 35 | |||
566 | 260237 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2201x 22nd Ave | 33 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | ||||||||||||
607 | 34245 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 778 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1997 12:00:00 AM | 8 | Permit Number 38055 | 6011531.92576 | 2104772.40188 | 37.7599538473986 | -122.403185056849 | (37.7599538473986, -122.403185056849) | 10 | 3 | 8 | 28856 | 29 | |
997 | 42493 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 50 Phelan Ave | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997102.28501 | 2092861.95301 | 37.7264342507672 | -122.452230525303 | (37.7264342507672, -122.452230525303) | 9 | 7 | 4 | 28861 | 40 | ||
1214 | 44389 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 15 Cordova St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/2001 12:00:00 AM | Permit Number 43749 | 6001647.0719332 | 2087964.37014378 | 37.7132458927569 | -122.436169094311 | (37.7132458927569, -122.436169094311) | 9 | 7 | 6 | 28861 | 5 | ||
1306 | 78279 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 773 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 16 | 6001349.14865 | 2092521.0021 | 37.7257404495571 | -122.437524926331 | (37.7257404495571, -122.437524926331) | 9 | 7 | 6 | 28861 | 25 | |||
1309 | 73822 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 118X Lowell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 3x3 | 5998761.76944 | 2087100.1867 | 37.7107086898252 | -122.44607953034 | (37.7107086898252, -122.44607953034) | 9 | 7 | 6 | 28861 | 5 | ||
1539 | 39700 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 360 Colon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41085 | 5995865.64470652 | 2094899.35552532 | 37.7319575477065 | -122.456652788497 | (37.7319575477065, -122.456652788497) | 9 | 7 | 4 | 59 | 40 | ||
1570 | 172003 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 440 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 0 | 4x5 | 6009403.11273 | 2093936.36515 | 37.7300813538655 | -122.409782729785 | (37.7300813538655, -122.409782729785) | 9 | 3 | 7 | 309 | 28 | ||
1939 | 81851 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 234X Eddy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6009256.87157 | 2113623.19571 | 37.7841287454965 | -122.411678774977 | (37.7841287454965, -122.411678774977) | 14 | 10 | 9 | 28852 | 36 | |||
1944 | 260235 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2201x 22nd Ave | 31 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | ||||||||||||
2034 | 260230 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2201x 22nd Ave | 26 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | ||||||||||||
2441 | 37478 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1375 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/09/2011 12:00:00 AM | 3x3 | Permit Number 767462 | 5991110.32977564 | 2106057.84846708 | 37.7623216986727 | -122.473906549358 | (37.7623216986727, -122.473906549358) | 1 | 8 | 11 | 56 | 12 | |
2587 | 62602 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 790 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1986 12:00:00 AM | 7 | Permit Number 22910 | 5984500.58062 | 2110524.76974 | 37.774201531153 | -122.49709658414 | (37.774201531153, -122.49709658414) | 11 | 6 | 2 | 55 | 26 | |
2675 | 78240 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 783 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 6001313.10029 | 2092436.35435 | 37.7255059765042 | -122.43764348307 | (37.7255059765042, -122.43764348307) | 9 | 7 | 6 | 28861 | 25 | |||
2886 | 78623 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 440 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6008334.45492 | 2113493.19738 | 37.7837200144185 | -122.414860811987 | (37.7837200144185, -122.414860811987) | 7 | 10 | 9 | 28858 | 36 | |||
2994 | 78611 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1443 21st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5989582.5846 | 2105504.4557 | 37.7607136229671 | -122.479149906586 | (37.7607136229671, -122.479149906586) | 1 | 8 | 3 | 56 | 35 | |||
3228 | 41394 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1250 Sunnydale Ave | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.7112689138709 | -122.413443728962 | (37.7112689138709, -122.413443728962) | 9 | 7 | 8 | 309 | 39 | ||
3316 | 40992 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1300 Illinois St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/04/2005 12:00:00 AM | Permit Number 41816 | 6016132.48160546 | 2103021.5500289 | 37.7554022327395 | -122.387151692888 | (37.7554022327395, -122.387151692888) | 10 | 3 | 8 | 28856 | 29 | ||
3466 | 42606 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1450 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | 24 | Permit Number 42674 | 6006095.71991 | 2118663.62857 | 37.7977906821616 | -122.422973606963 | (37.7977906821616, -122.422973606963) | 13 | 9 | 10 | 28858 | 32 | |
3487 | 60052 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1427 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/1982 12:00:00 AM | 5 | Permit Number 19551 | 5988338.7048 | 2105586.102 | 37.76086548376 | -122.483457861607 | (37.76086548376, -122.483457861607) | 1 | 8 | 3 | 56 | 35 | |
3541 | 258357 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 446 Silliman St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x5 | 6009476.28698 | 2093953.76582 | 37.7301332328809 | -122.409530983744 | (37.7301332328809, -122.409530983744) | 9 | 3 | 7 | 309 | 28 | |||
3589 | 254266 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 85X Sussex St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778120 | ||||||||||
3689 | 78930 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2701 Kirkham St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5986452.1466 | 2105013.3251 | 37.7591828139052 | -122.48994041552 | (37.7591828139052, -122.48994041552) | 1 | 8 | 3 | 56 | 35 | |||
3898 | 258170 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 148 Felton St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6010466.36455 | 2093776.54364 | 37.7297020458087 | -122.406095661025 | (37.7297020458087, -122.406095661025) | 10 | 3 | 7 | 309 | 28 | |||
3994 | 256688 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1477 Green St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782620 | |||||||||||
5662 | 76427 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 118X Lowell St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | 5998792.69271 | 2087037.26679 | 37.7105376918253 | -122.445968130449 | (37.7105376918253, -122.445968130449) | 9 | 7 | 6 | 28861 | 5 | ||
5794 | 255199 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 201 Burrows St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
6101 | 71175 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1450 Santiago St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 5988319.432 | 2099688.0916 | 37.7446700060747 | -122.483092205488 | (37.7446700060747, -122.483092205488) | 1 | 8 | 3 | 29491 | 35 | |||
6785 | 255190 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 201 Burrows St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
7159 | 33199 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 740 Laguna Honda Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1996 12:00:00 AM | Permit Number 37404 | 5995918.52562455 | 2099456.80293437 | 37.7444742187741 | -122.45679946352 | (37.7444742187741, -122.45679946352) | 1 | 5 | 4 | 59 | 40 | ||
7375 | 260231 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2201x 22nd Ave | 27 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | ||||||||||||
7831 | 43263 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 449 Holyoke St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/2000 12:00:00 AM | Permit Number 43044 | 6009825.48813974 | 2092359.64445753 | 37.7257756724777 | -122.408211357365 | (37.7257756724777, -122.408211357365) | 10 | 3 | 7 | 309 | 28 | ||
8203 | 33351 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 156 Kenwood Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42327 | 5994316.91365045 | 2093552.57844974 | 37.7281705833725 | -122.461909418866 | (37.7281705833725, -122.461909418866) | 9 | 8 | 4 | 59 | 40 | ||
8834 | 72501 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 3245 Ulloa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 3.5x5 | 5985932.8363 | 2098188.2054 | 37.7404125521238 | -122.491234105912 | (37.7404125521238, -122.491234105912) | 1 | 8 | 3 | 29491 | 35 | ||
9576 | 258366 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 816 Silliman St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6008411.83681 | 2093627.45022 | 37.7291775379757 | -122.413187871426 | (37.7291775379757, -122.413187871426) | 9 | 3 | 7 | 309 | 28 | ||||
9925 | 255197 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 201 Burrows St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
9960 | 39843 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 3151 Ortega St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41160 | 5984281.43555925 | 2102217.56111428 | 37.7513794309419 | -122.49724128025 | (37.7513794309419, -122.49724128025) | 1 | 8 | 3 | 29491 | 35 | ||
10071 | 255198 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 201 Burrows St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
10131 | 255195 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 201 Burrows St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
10246 | 73817 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 125 Morse St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6000831.98332 | 2087914.47159 | 37.7130625393704 | -122.438982739962 | (37.7130625393704, -122.438982739962) | 9 | 7 | 6 | 28861 | 5 | |||
10267 | 255196 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 201 Burrows St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
10809 | 82390 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1783 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6001502.3544 | 2112144.9743 | 37.7796318765871 | -122.438400625768 | (37.7796318765871, -122.438400625768) | 15 | 5 | 11 | 29490 | 41 | |||
10949 | 66447 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1717 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 13 | Permit Number 32898 | 6009150.19031 | 2119198.20098 | 37.7994303674837 | -122.41244205838 | (37.7994303674837, -122.41244205838) | 3 | 1 | 10 | 308 | 32 | |
11121 | 78902 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1443 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5989581.2299 | 2105525.1155 | 37.7607702705418 | -122.479156103143 | (37.7607702705418, -122.479156103143) | 1 | 8 | 3 | 56 | 35 | |||
11661 | 73117 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 170 Rome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 5998798.49436 | 2089027.53111 | 37.7160028368265 | -122.446091142417 | (37.7160028368265, -122.446091142417) | 9 | 7 | 6 | 28861 | 25 | |||
11957 | 260232 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2201x 22nd Ave | 28 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | ||||||||||||
12198 | 260226 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2201x 22nd Ave | 22 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | ||||||||||||
12220 | 43101 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 44 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/2000 12:00:00 AM | 14 | Permit Number 42932 | 6008904.81369 | 2112529.72749 | 37.7811065881247 | -122.412819439978 | (37.7811065881247, -122.412819439978) | 7 | 10 | 9 | 28852 | 36 | |
12256 | 78779 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 50 Farragut Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 5997572.00322 | 2087132.19247 | 37.7107285558476 | -122.450193916137 | (37.7107285558476, -122.450193916137) | 9 | 7 | 6 | 28861 | 25 | |||
12325 | 42608 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1775 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42675 | 6004555.83509625 | 2118398.4069888 | 37.796975439849 | -122.428283124742 | (37.796975439849, -122.428283124742) | 13 | 9 | 1 | 57 | 17 | ||
12500 | 255191 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 201 Burrows St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
12673 | 70698 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 591 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6003529.56495 | 2089763.19093 | 37.7182918362743 | -122.429790778347 | (37.7182918362743, -122.429790778347) | 9 | 7 | 6 | 28861 | 5 | |||
12912 | 50271 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 46 Saint Mary's Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/2003 12:00:00 AM | Permit Number 46975 | 6003961.77190842 | 2095882.86717576 | 37.7351195713487 | -122.428732836762 | (37.7351195713487, -122.428732836762) | 2 | 7 | 5 | 28861 | 7 | ||
13175 | 30752 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1507 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | 11 | 3x3 | Permit Number 34633 | 6015383.6793 | 2093790.5859 | 37.73001441519 | -122.389096804708 | (37.73001441519, -122.389096804708) | 10 | 3 | 8 | 58 | 1 |
13400 | 81931 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 234X Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6009287.21527 | 2113626.45246 | 37.7841393898643 | -122.411574026434 | (37.7841393898643, -122.411574026434) | 14 | 10 | 9 | 28852 | 36 | |||
13482 | 72809 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 118X Lowell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 3x3 | 5998733.92072 | 2087172.14442 | 37.7109046790814 | -122.446180954109 | (37.7109046790814, -122.446180954109) | 9 | 7 | 6 | 28861 | 5 | ||
13627 | 78732 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 53 Foote Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 5998972.2526 | 2087962.75673 | 37.7130891296288 | -122.44541403745 | (37.7130891296288, -122.44541403745) | 9 | 7 | 6 | 28861 | 25 | |||
13695 | 39699 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 360 Colon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41085 | 5995865.64470652 | 2094899.35552532 | 37.7319575477065 | -122.456652788497 | (37.7319575477065, -122.456652788497) | 9 | 7 | 4 | 59 | 40 | ||
13817 | 78590 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 440 Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6008293.184 | 2113486.29357 | 37.7836987391503 | -122.415003105409 | (37.7836987391503, -122.415003105409) | 7 | 10 | 9 | 28858 | 36 | |||
14252 | 76445 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 118X Lowell St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 3x3 | 5998808.02641 | 2086988.08444 | 37.710403523785 | -122.445911599067 | (37.710403523785, -122.445911599067) | 9 | 7 | 6 | 28861 | 5 | ||
14517 | 81930 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 234X Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6009272.01277 | 2113623.31708 | 37.7841299280977 | -122.411626400234 | (37.7841299280977, -122.411626400234) | 14 | 10 | 9 | 28852 | 36 | |||
14828 | 82804 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 46 Otsego Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6000854.60594 | 2092857.18319 | 37.7266353963958 | -122.4392586043 | (37.7266353963958, -122.4392586043) | 9 | 7 | 6 | 28861 | 25 | |||
14990 | 260236 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2201x 22nd Ave | 32 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | ||||||||||||
15074 | 61794 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2112 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/24/1985 12:00:00 AM | 11 | Permit Number 21817 | 6012105.79225 | 2102838.47853 | 37.7546757515047 | -122.401064430306 | (37.7546757515047, -122.401064430306) | 10 | 3 | 8 | 28856 | 29 | |
15383 | 260234 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2201x 22nd Ave | 30 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | ||||||||||||
15406 | 255194 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 201 Burrows St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
16295 | 69167 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1357 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1994 12:00:00 AM | 8 | Permit Number 33204 | 5982738.1126 | 2105902.9753 | 37.7614079699737 | -122.502850971641 | (37.7614079699737, -122.502850971641) | 1 | 8 | 3 | 56 | 35 | |
16307 | 254265 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 85X Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778120 | ||||||||||
16476 | 260228 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2201x 22nd Ave | 24 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | ||||||||||||
16501 | 255192 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 201 Burrows St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
16512 | 72518 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1385 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 5999282.60736 | 2089782.01796 | 37.718102119793 | -122.444472018286 | (37.718102119793, -122.444472018286) | 9 | 7 | 6 | 28861 | 25 | |||
16625 | 259862 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1300x Brussels St | 1 | Side Yard : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
16807 | 255193 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 201 Burrows St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
17329 | 42509 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 163 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42623 | 5999007.81241244 | 2093762.41150779 | 37.7290156761066 | -122.445707952741 | (37.7290156761066, -122.445707952741) | 9 | 7 | 4 | 28861 | 40 | ||
17408 | 72787 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 125 Morse St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6000842.13872 | 2087917.52073 | 37.7130714894434 | -122.438947857962 | (37.7130714894434, -122.438947857962) | 9 | 7 | 6 | 28861 | 5 | |||
18390 | 78903 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2078 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5989460.8159 | 2101226.1598 | 37.7489594901873 | -122.479258062134 | (37.7489594901873, -122.479258062134) | 1 | 8 | 3 | 29491 | 35 | |||
18477 | 260227 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2201x 22nd Ave | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | ||||||||||||
18688 | 70201 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1811 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 5987499.4352 | 2102910.1581 | 37.7534691863201 | -122.486164042507 | (37.7534691863201, -122.486164042507) | 1 | 8 | 3 | 56 | 35 | |||
18691 | 78242 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 767 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6001367.70534 | 2092560.86013 | 37.725850945661 | -122.437463630336 | (37.725850945661, -122.437463630336) | 9 | 7 | 6 | 28861 | 25 | |||
18708 | 74162 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1450 Santiago St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5988352.2909 | 2099691.0788 | 37.7446801201935 | -122.482978806105 | (37.7446801201935, -122.482978806105) | 1 | 8 | 3 | 29491 | 35 | |||
19341 | 260229 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2201x 22nd Ave | 25 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | ||||||||||||
19462 | 41404 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1252 Sunnydale Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/17/2000 12:00:00 AM | 7 | Permit Number 42021 | 6008157.91792 | 2087132.40574 | 37.7113292562177 | -122.413606495143 | (37.7113292562177, -122.413606495143) | 9 | 7 | 8 | 309 | 39 | |
19508 | 262456 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 784 Cayuga Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 02/09/2019 12:00:00 AM | 3 | 6001253 | 2092432 | 37.7254906030662 | -122.437850932396 | (37.7254906030662, -122.437850932396) | 9 | 7 | 6 | 28861 | 25 | ||
19612 | 260233 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2201x 22nd Ave | 29 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | ||||||||||||
19965 | 42912 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 2624 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42823 | 6010365.23344045 | 2103432.32493154 | 37.756209071018 | -122.40712563844 | (37.756209071018, -122.40712563844) | 10 | 4 | 7 | 28859 | 19 | ||
20237 | 42318 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 301 Edna St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42532 | 5998734.92164885 | 2093801.38025355 | 37.7291070907004 | -122.446654155848 | (37.7291070907004, -122.446654155848) | 9 | 7 | 4 | 28861 | 40 | ||
21519 | 43264 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 449 Holyoke St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/2000 12:00:00 AM | Permit Number 43044 | 6009825.48813974 | 2092359.64445753 | 37.7257756724777 | -122.408211357365 | (37.7257756724777, -122.408211357365) | 10 | 3 | 7 | 309 | 28 | ||
21738 | 33348 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 120 Kenwood Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | Permit Number 37485 | 5994502.21171905 | 2093669.50135187 | 37.7285022911433 | -122.461277313418 | (37.7285022911433, -122.461277313418) | 9 | 8 | 4 | 59 | 40 | ||
22265 | 34205 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 615 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767518 | 6002522.9923571 | 2090183.36055345 | 37.719388477306 | -122.433300078328 | (37.719388477306, -122.433300078328) | 9 | 7 | 6 | 28861 | 5 | |
22298 | 39806 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1920 41st Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41143 | 5983539.51267339 | 2102067.82749571 | 37.7509247944527 | -122.499795829171 | (37.7509247944527, -122.499795829171) | 1 | 8 | 3 | 29491 | 35 | ||
24101 | 35896 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 225 Industrial St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/1998 12:00:00 AM | Permit Number 39088 | 6010847.02207847 | 2096940.13108018 | 37.7384098714444 | -122.405002340826 | (37.7384098714444, -122.405002340826) | 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) );