trees
1,377 rows where qSpecies_id = 61 sorted by qAddress 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 70527 | 140498 | DPW Maintained 1 | Tristania conferta :: 61 | 991 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6003824.4306 | 2112091.3054 | 37.7796163211601 | -122.430363733487 | (37.7796163211601, -122.430363733487) | 15 | 9 | 11 | 29490 | 41 | |||
| 109615 | 140499 | DPW Maintained 1 | Tristania conferta :: 61 | 981 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6003828.2288 | 2112060.1604 | 37.7795310198701 | -122.430348371165 | (37.7795310198701, -122.430348371165) | 15 | 9 | 11 | 29490 | 41 | |||
| 109141 | 140500 | DPW Maintained 1 | Tristania conferta :: 61 | 971 Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003831.2673 | 2112037.3714 | 37.7794686190462 | -122.430336233336 | (37.7794686190462, -122.430336233336) | 15 | 9 | 11 | 29490 | 41 | |||
| 59169 | 140036 | DPW Maintained 1 | Tristania conferta :: 61 | 970 Scott St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6001970.0892 | 2111822.8668 | 37.7787740442343 | -122.436759467778 | (37.7787740442343, -122.436759467778) | 15 | 5 | 11 | 29490 | 41 | |||
| 127592 | 47606 | DPW Maintained 1 | Tristania conferta :: 61 | 965 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/2002 12:00:00 AM | 6 | 3x3 | Permit Number 45442 | 6011251.7668 | 2111767.4922 | 37.7791451213921 | -122.404646435966 | (37.7791451213921, -122.404646435966) | 14 | 2 | 9 | 28856 | 34 | |
| 72846 | 245878 | DPW Maintained 1 | Tristania conferta :: 61 | 964 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6001502.0953 | 2109071.836 | 37.7711937958365 | -122.438181312666 | (37.7711937958365, -122.438181312666) | 15 | 5 | 11 | 29492 | 9 | |||
| 163601 | 140501 | DPW Maintained 1 | Tristania conferta :: 61 | 961 Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6003835.0655 | 2112008.5054 | 37.7793895753187 | -122.430321033718 | (37.7793895753187, -122.430321033718) | 15 | 9 | 11 | 29490 | 41 | |||
| 148654 | 140035 | DPW Maintained 1 | Tristania conferta :: 61 | 960 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6001972.2185 | 2111799.7483 | 37.7787106876669 | -122.436750446365 | (37.7787106876669, -122.436750446365) | 15 | 5 | 11 | 29490 | 41 | |||
| 160020 | 140502 | DPW Maintained 1 | Tristania conferta :: 61 | 951 Webster St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6003839.6233 | 2111973.5622 | 37.7792938881307 | -122.430302772663 | (37.7792938881307, -122.430302772663) | 15 | 9 | 11 | 29490 | 41 | |||
| 73063 | 6999 | DPW Maintained 1 | Tristania conferta :: 61 | 950X Fell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/08/2006 12:00:00 AM | 3 | 3X3 | 6002754.2205 | 2110289.0229 | 37.774607023478 | -122.433937185692 | (37.774607023478, -122.433937185692) | 15 | 5 | 11 | 29492 | 10 | ||
| 86409 | 6997 | DPW Maintained 1 | Tristania conferta :: 61 | 950X Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/06/1992 12:00:00 AM | 12 | 3X3 | 6002869.8876 | 2110306.5014 | 37.7746615784305 | -122.433538320063 | (37.7746615784305, -122.433538320063) | 15 | 5 | 11 | 29492 | 10 | ||
| 108181 | 6998 | DPW Maintained 1 | Tristania conferta :: 61 | 950X Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/06/1992 12:00:00 AM | 12 | 3X3 | 6002824.6489 | 2110299.3044 | 37.7746392504236 | -122.43369429515 | (37.7746392504236, -122.43369429515) | 15 | 5 | 11 | 29492 | 10 | ||
| 116409 | 7000 | DPW Maintained 1 | Tristania conferta :: 61 | 950X Fell St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/06/1992 12:00:00 AM | 12 | 3X3 | 6002725.4323 | 2110284.3962 | 37.7745926859617 | -122.434036438862 | (37.7745926859617, -122.434036438862) | 15 | 5 | 11 | 29492 | 10 | ||
| 43134 | 140034 | DPW Maintained 1 | Tristania conferta :: 61 | 950 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6001975.5646 | 2111780.2801 | 37.7786574230551 | -122.436737476963 | (37.7786574230551, -122.436737476963) | 15 | 5 | 11 | 29490 | 41 | |||
| 48995 | 9657 | DPW Maintained 1 | Tristania conferta :: 61 | 95 Gough St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/07/1995 12:00:00 AM | 18 | 3X3 | 6006069.5259 | 2109884.9457 | 37.7736851076601 | -122.422440154098 | (37.7736851076601, -122.422440154098) | 7 | 9 | 11 | 28852 | 10 | ||
| 84811 | 9654 | DPW Maintained 1 | Tristania conferta :: 61 | 95 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/07/1995 12:00:00 AM | 3 | 3X3 | 6006063.7461 | 2109945.4115 | 37.7738508061395 | -122.422464444627 | (37.7738508061395, -122.422464444627) | 7 | 9 | 11 | 28852 | 10 | ||
| 112128 | 9656 | DPW Maintained 1 | Tristania conferta :: 61 | 95 Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/07/1995 12:00:00 AM | 18 | 3X3 | 6006068.1921 | 2109906.7312 | 37.773744850157 | -122.422446316196 | (37.773744850157, -122.422446316196) | 7 | 9 | 11 | 28852 | 10 | ||
| 113268 | 9653 | DPW Maintained 1 | Tristania conferta :: 61 | 95 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/07/1995 12:00:00 AM | 18 | 3x3 | 6006060.8562 | 2109963.4178 | 37.7739000840763 | -122.422475720985 | (37.7739000840763, -122.422475720985) | 7 | 9 | 11 | 28852 | 10 | ||
| 118858 | 9655 | DPW Maintained 1 | Tristania conferta :: 61 | 95 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/07/1995 12:00:00 AM | 18 | 3X3 | 6006065.5245 | 2109925.4044 | 37.7737959717838 | -122.42245687095 | (37.7737959717838, -122.42245687095) | 7 | 9 | 11 | 28852 | 10 | ||
| 124308 | 10344 | DPW Maintained 1 | Tristania conferta :: 61 | 946 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6001573.5571 | 2109081.4751 | 37.7712243264402 | -122.437934814539 | (37.7712243264402, -122.437934814539) | 15 | 5 | 11 | 29492 | 9 | |||
| 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 | |||
| 139281 | 122838 | DPW Maintained 1 | Tristania conferta :: 61 | 945 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 2x3 | 6001931.7611 | 2111776.6298 | 37.7786449107474 | -122.436888748547 | (37.7786449107474, -122.436888748547) | 15 | 5 | 11 | 29490 | 41 | |||
| 188487 | 122837 | DPW Maintained 1 | Tristania conferta :: 61 | 945 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 2x3 | 6001926.8941 | 2111799.4441 | 37.7787072764484 | -122.436907219039 | (37.7787072764484, -122.436907219039) | 15 | 5 | 11 | 29490 | 41 | |||
| 64454 | 10657 | DPW Maintained 1 | Tristania conferta :: 61 | 945 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/05/1990 12:00:00 AM | 6 | 6003325.2554 | 2110665.5174 | 37.7756731734805 | -122.431988754437 | (37.7756731734805, -122.431988754437) | 15 | 9 | 11 | 29492 | 10 | |||
| 54954 | 62838 | DPW Maintained 1 | Tristania conferta :: 61 | 936 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1986 12:00:00 AM | 12 | Permit Number 23205 | 6001983.1694 | 2111715.7917 | 37.7784807863281 | -122.436706551647 | (37.7784807863281, -122.436706551647) | 15 | 5 | 11 | 29490 | 41 | ||
| 31384 | 61393 | DPW Maintained 1 | Tristania conferta :: 61 | 926 Taraval St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50349 | 5990253.2983 | 2099081.9773 | 37.7431181185655 | -122.476361078322 | (37.7431181185655, -122.476361078322) | 1 | 8 | 3 | 29491 | 35 | |
| 14129 | 71258 | DPW Maintained 1 | Tristania conferta :: 61 | 923 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 3x3 | 6001950.0126 | 2111666.817 | 37.778344429762 | -122.436817746544 | (37.778344429762, -122.436817746544) | 15 | 5 | 11 | 29490 | 41 | ||
| 55374 | 140044 | DPW Maintained 1 | Tristania conferta :: 61 | 920 SCOTT ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6001989.2532 | 2111661.9499 | 37.778333296035 | -122.436681650462 | (37.778333296035, -122.436681650462) | 15 | 5 | 11 | 29490 | 41 | |||
| 75868 | 28074 | DPW Maintained 1 | Tristania conferta :: 61 | 915 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2010 12:00:00 AM | 3 | 3X3 | 6008638.4319 | 2120527.3912 | 37.8030512599832 | -122.414307026238 | (37.8030512599832, -122.414307026238) | 3 | 1 | 10 | 308 | 32 | ||
| 112653 | 28076 | DPW Maintained 1 | Tristania conferta :: 61 | 915 Columbus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/13/2003 12:00:00 AM | 25 | 3X3 | 6008674.8876 | 2120493.8068 | 37.8029610933815 | -122.414178492558 | (37.8029610933815, -122.414178492558) | 3 | 1 | 10 | 308 | 32 | ||
| 179871 | 28075 | DPW Maintained 1 | Tristania conferta :: 61 | 915 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2010 12:00:00 AM | 3 | 3X3 | 6008651.5543 | 2120512.2278 | 37.8030103621977 | -122.414260542242 | (37.8030103621977, -122.414260542242) | 3 | 1 | 10 | 308 | 32 | ||
| 15166 | 10340 | DPW Maintained 1 | Tristania conferta :: 61 | 914 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X4 | 6001716.4806 | 2109101.7503 | 37.7712881236094 | -122.437441889428 | (37.7712881236094, -122.437441889428) | 15 | 5 | 11 | 29492 | 9 | |||
| 190957 | 140043 | DPW Maintained 1 | Tristania conferta :: 61 | 910 SCOTT ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6001994.1202 | 2111638.8314 | 37.7782700950378 | -122.436663158472 | (37.7782700950378, -122.436663158472) | 15 | 5 | 11 | 29490 | 41 | |||
| 120678 | 140042 | DPW Maintained 1 | Tristania conferta :: 61 | 902 SCOTT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6001996.8579 | 2111620.58 | 37.7782201368644 | -122.436652381004 | (37.7782201368644, -122.436652381004) | 15 | 5 | 11 | 29490 | 41 | |||
| 121291 | 142103 | DPW Maintained 1 | Tristania conferta :: 61 | 902 Fell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6003027.1948 | 2110329.1208 | 37.7747326096469 | -122.432995779785 | (37.7747326096469, -122.432995779785) | 15 | 5 | 11 | 29492 | 10 | |||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | |||
| 77722 | 139452 | DPW Maintained 1 | Tristania conferta :: 61 | 901 SCOTT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6001957.009 | 2111635.1811 | 37.7782579631689 | -122.436791278192 | (37.7782579631689, -122.436791278192) | 15 | 5 | 11 | 29490 | 41 | |||
| 128566 | 139454 | DPW Maintained 1 | Tristania conferta :: 61 | 901 SCOTT ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6001961.876 | 2111598.6783 | 37.7781580122672 | -122.436771827776 | (37.7781580122672, -122.436771827776) | 15 | 5 | 11 | 29490 | 41 | |||
| 21688 | 24501 | DPW Maintained 1 | Tristania conferta :: 61 | 901 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/24/1995 12:00:00 AM | 6 | 3X3 | 6003042.5941 | 2110274.0021 | 37.7745821407981 | -122.43293857186 | (37.7745821407981, -122.43293857186) | 15 | 5 | 11 | 29492 | 10 | ||
| 170675 | 24502 | DPW Maintained 1 | Tristania conferta :: 61 | 901 Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/24/1995 12:00:00 AM | 6 | 3X3 | 6003065.2332 | 2110278.53 | 37.7745958573502 | -122.432860582365 | (37.7745958573502, -122.432860582365) | 15 | 5 | 11 | 29492 | 10 | ||
| 81371 | 23753 | DPW Maintained 1 | Tristania conferta :: 61 | 900X Webster St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/19/1992 12:00:00 AM | 25 | 4x4 | 6003923.4316 | 2112087.5817 | 37.7796117041387 | -122.430020980715 | (37.7796117041387, -122.430020980715) | 7 | 9 | 11 | 29490 | 41 | ||
| 121810 | 140041 | DPW Maintained 1 | Tristania conferta :: 61 | 900 SCOTT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6001999.2915 | 2111605.9788 | 37.7781801839393 | -122.436642916889 | (37.7781801839393, -122.436642916889) | 15 | 5 | 11 | 29490 | 41 | |||
| 122899 | 142101 | DPW Maintained 1 | Tristania conferta :: 61 | 900 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6003064.2082 | 2110331.6912 | 37.7747417667139 | -122.43286792667 | (37.7747417667139, -122.43286792667) | 15 | 5 | 11 | 29492 | 10 | |||
| 105742 | 141458 | DPW Maintained 1 | Tristania conferta :: 61 | 9 Kittredge Ter | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5997945.4102 | 2111586.3754 | 37.7778951483556 | -122.450665288127 | (37.7778951483556, -122.450665288127) | 15 | 6 | 2 | 54 | 16 | |||
| 114052 | 244385 | DPW Maintained 1 | Tristania conferta :: 61 | 897 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6003194.2623 | 2110294.2764 | 37.774646410436 | -122.432415370472 | (37.774646410436, -122.432415370472) | 15 | 9 | 11 | 29492 | 10 | |||
| 70906 | 10640 | DPW Maintained 1 | Tristania conferta :: 61 | 879 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/26/1992 12:00:00 AM | 12 | 3X3 | 6003664.2022 | 2110709.9334 | 37.7758143385689 | -122.430819424449 | (37.7758143385689, -122.430819424449) | 7 | 9 | 11 | 29492 | 10 | ||
| 164336 | 244387 | DPW Maintained 1 | Tristania conferta :: 61 | 877 Fell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6003242.3169 | 2110300.201 | 37.7746654027157 | -122.432249563339 | (37.7746654027157, -122.432249563339) | 15 | 9 | 11 | 29492 | 10 | |||
| 162275 | 6993 | DPW Maintained 1 | Tristania conferta :: 61 | 861 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6003293.0047 | 2110308.1004 | 37.7746899663633 | -122.43207478841 | (37.7746899663633, -122.43207478841) | 15 | 9 | 11 | 29492 | 10 | |||
| 1445 | 140697 | DPW Maintained 1 | Tristania conferta :: 61 | 859 MASONIC AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5999231.335 | 2109939.9835 | 37.7734481000077 | -122.446098386426 | (37.7734481000077, -122.446098386426) | 15 | 5 | 11 | 29492 | 16 | |||
| 82861 | 6992 | DPW Maintained 1 | Tristania conferta :: 61 | 859 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6003319.0069 | 2110312.3792 | 37.7747031890375 | -122.431985147215 | (37.7747031890375, -122.431985147215) | 15 | 9 | 11 | 29492 | 10 | |||
| 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 | |||
| 39132 | 143429 | DPW Maintained 1 | Tristania conferta :: 61 | 855 SACRAMENTO ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6010687.6362 | 2116910.2621 | 37.7932344012545 | -122.406960577759 | (37.7932344012545, -122.406960577759) | 3 | 1 | 10 | 28857 | 4 | |||
| 56090 | 143431 | DPW Maintained 1 | Tristania conferta :: 61 | 855 SACRAMENTO ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6010731.6396 | 2116914.7262 | 37.7932491208157 | -122.406808637133 | (37.7932491208157, -122.406808637133) | 3 | 1 | 10 | 28857 | 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 | |||
| 193240 | 143432 | DPW Maintained 1 | Tristania conferta :: 61 | 855 SACRAMENTO ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6010753.9601 | 2116917.9148 | 37.7932591248157 | -122.406731631165 | (37.7932591248157, -122.406731631165) | 3 | 1 | 10 | 28857 | 4 | |||
| 58973 | 245957 | DPW Maintained 1 | Tristania conferta :: 61 | 850 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5997681.1316 | 2107596.9911 | 37.7669261962578 | -122.451291725243 | (37.7669261962578, -122.451291725243) | 15 | 5 | 11 | 29492 | 9 | |||
| 38253 | 24498 | DPW Maintained 1 | Tristania conferta :: 61 | 849 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/22/2008 12:00:00 AM | 6 | 3X3 | 6003351.2628 | 2110317.6455 | 37.7747194775899 | -122.43187394371 | (37.7747194775899, -122.43187394371) | 15 | 9 | 11 | 29492 | 10 | ||
| 181534 | 5215 | DPW Maintained 1 | Tristania conferta :: 61 | 846 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/1990 12:00:00 AM | 18 | 3X3 | 6001547.7869 | 2111374.9525 | 37.7775201753497 | -122.438188278406 | (37.7775201753497, -122.438188278406) | 15 | 5 | 11 | 29492 | 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 | ||||
| 177868 | 6988 | DPW Maintained 1 | Tristania conferta :: 61 | 843 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/11/1990 12:00:00 AM | 11 | 3X3 | 6003376.2775 | 2110319.6203 | 37.7747263179186 | -122.431787553866 | (37.7747263179186, -122.431787553866) | 15 | 9 | 11 | 29492 | 10 | ||
| 39428 | 24489 | DPW Maintained 1 | Tristania conferta :: 61 | 840 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/2006 12:00:00 AM | 3 | 3X3 | 6003385.8226 | 2110373.2704 | 37.774874168918 | -122.431758366815 | (37.774874168918, -122.431758366815) | 15 | 9 | 11 | 29492 | 10 | ||
| 47974 | 24500 | DPW Maintained 1 | Tristania conferta :: 61 | 829X Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/24/1995 12:00:00 AM | 12 | 3X3 | 6003428.9402 | 2110326.2031 | 37.7747473777613 | -122.431605853044 | (37.7747473777613, -122.431605853044) | 15 | 9 | 11 | 29492 | 10 | ||
| 132428 | 6987 | DPW Maintained 1 | Tristania conferta :: 61 | 829X Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/24/1995 12:00:00 AM | 12 | 3X3 | 6003407.8751 | 2110323.57 | 37.7747389539117 | -122.431678533456 | (37.7747389539117, -122.431678533456) | 15 | 9 | 11 | 29492 | 10 | ||
| 24694 | 200893 | DPW Maintained 1 | Tristania conferta :: 61 | 825 Newhall St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6015466.1111 | 2097093.8178 | 37.7390889909368 | -122.389042368279 | (37.7390889909368, -122.389042368279) | 10 | 3 | 8 | 58 | 1 | |||
| 147893 | 24497 | DPW Maintained 1 | Tristania conferta :: 61 | 823 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/01/2011 12:00:00 AM | 3 | 3x3 | 6003451.3218 | 2110329.4946 | 37.7747576839874 | -122.431528665589 | (37.7747576839874, -122.431528665589) | 15 | 9 | 11 | 29492 | 10 | ||
| 31069 | 50648 | DPW Maintained 1 | Tristania conferta :: 61 | 821 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2003 12:00:00 AM | 4 | Permit Number 47233 | 6012137.5662 | 2112614.0037 | 37.7815189132409 | -122.401641589024 | (37.7815189132409, -122.401641589024) | 6 | 2 | 9 | 28856 | 34 | ||
| 74845 | 50647 | DPW Maintained 1 | Tristania conferta :: 61 | 821 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2003 12:00:00 AM | 4 | Permit Number 47233 | 6012121.5394 | 2112599.3505 | 37.7814777846222 | -122.401696004131 | (37.7814777846222, -122.401696004131) | 6 | 2 | 9 | 28856 | 34 | ||
| 76410 | 50649 | DPW Maintained 1 | Tristania conferta :: 61 | 821 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51399 | 6012160.9197 | 2112637.3571 | 37.7815843393908 | -122.401562438489 | (37.7815843393908, -122.401562438489) | 6 | 2 | 9 | 28856 | 34 | |
| 133170 | 50650 | DPW Maintained 1 | Tristania conferta :: 61 | 821 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/2012 12:00:00 AM | 2 | Permit Number 768661 | 6012184.2732 | 2112660.7106 | 37.7816497657614 | -122.401483287822 | (37.7816497657614, -122.401483287822) | 6 | 2 | 9 | 28856 | 34 | ||
| 2931 | 6985 | DPW Maintained 1 | Tristania conferta :: 61 | 819 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/22/2008 12:00:00 AM | 3 | 3X3 | 6003479.628 | 2110333.4443 | 37.7747701331995 | -122.431431030712 | (37.7747701331995, -122.431431030712) | 15 | 9 | 11 | 29492 | 10 | ||
| 11077 | 141992 | DPW Maintained 1 | Tristania conferta :: 61 | 818 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/31/1991 12:00:00 AM | 9 | Width 0ft | 6003994.291 | 2111559.6951 | 37.7781662710742 | -122.429738185966 | (37.7781662710742, -122.429738185966) | 7 | 9 | 11 | 29490 | 41 | ||
| 14066 | 141995 | DPW Maintained 1 | Tristania conferta :: 61 | 818 WEBSTER ST | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/21/1999 12:00:00 AM | 5 | Width 0ft | 6003983.7554 | 2111636.8614 | 37.778377554053 | -122.429780137803 | (37.778377554053, -122.429780137803) | 7 | 9 | 11 | 29490 | 41 | ||
| 176645 | 141998 | DPW Maintained 1 | Tristania conferta :: 61 | 818 WEBSTER ST | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/23/1990 12:00:00 AM | 13 | Width 0ft | 6003974.6435 | 2111716.5903 | 37.7785959538958 | -122.429817347587 | (37.7785959538958, -122.429817347587) | 7 | 9 | 11 | 29490 | 41 | ||
| 158205 | 140566 | DPW Maintained 1 | Tristania conferta :: 61 | 815 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6003896.7882 | 2111570.6213 | 37.7781907500531 | -122.430076263169 | (37.7781907500531, -122.430076263169) | 15 | 9 | 11 | 29492 | 41 | |||
| 187806 | 6984 | DPW Maintained 1 | Tristania conferta :: 61 | 815 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/22/2008 12:00:00 AM | 6 | 3X3 | 6003507.9341 | 2110337.394 | 37.7747825823251 | -122.431333396148 | (37.7747825823251, -122.431333396148) | 15 | 9 | 11 | 29492 | 10 | ||
| 28616 | 248567 | DPW Maintained 1 | Tristania conferta :: 61 | 809 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5997620.5658 | 2107720.8482 | 37.7672628081675 | -122.451510146252 | (37.7672628081675, -122.451510146252) | 15 | 5 | 11 | 29492 | 9 | |||
| 76380 | 50978 | DPW Maintained 1 | Tristania conferta :: 61 | 807REVISED Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2004 12:00:00 AM | 11 | Permit Number 47464 | 6008954.8893 | 2120241.9921 | 37.8022853965169 | -122.413191720991 | (37.8022853965169, -122.413191720991) | 3 | 1 | 10 | 308 | 32 | ||
| 115696 | 247298 | DPW Maintained 1 | Tristania conferta :: 61 | 803 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6002635.074 | 2109529.456 | 37.772514678827 | -122.434295021641 | (37.772514678827, -122.434295021641) | 15 | 5 | 11 | 29492 | 9 | |||
| 140308 | 6981 | DPW Maintained 1 | Tristania conferta :: 61 | 802 Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003535.9112 | 2110394.3354 | 37.7749405148667 | -122.431240682973 | (37.7749405148667, -122.431240682973) | 15 | 9 | 11 | 29492 | 10 | |||
| 21270 | 139936 | DPW Maintained 1 | Tristania conferta :: 61 | 800 GOUGH ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6005717.7716 | 2112456.4224 | 37.7807259079437 | -122.423839812492 | (37.7807259079437, -122.423839812492) | 7 | 9 | 11 | 28852 | 41 | |||
| 27373 | 139930 | DPW Maintained 1 | Tristania conferta :: 61 | 800 GOUGH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6005698.3365 | 2112597.5586 | 37.7811123361694 | -122.423917086976 | (37.7811123361694, -122.423917086976) | 7 | 9 | 11 | 28852 | 41 | |||
| 30175 | 139929 | DPW Maintained 1 | Tristania conferta :: 61 | 800 GOUGH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6005694.4032 | 2112619.0761 | 37.7811711958921 | -122.423932224805 | (37.7811711958921, -122.423932224805) | 7 | 9 | 11 | 28852 | 41 | |||
| 37867 | 139932 | DPW Maintained 1 | Tristania conferta :: 61 | 800 GOUGH ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6005703.8894 | 2112554.5236 | 37.7809944860981 | -122.423894815633 | (37.7809944860981, -122.423894815633) | 7 | 9 | 11 | 28852 | 41 | |||
| 46817 | 139934 | DPW Maintained 1 | Tristania conferta :: 61 | 800 GOUGH ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6005710.3678 | 2112505.9358 | 37.78086144164 | -122.423868947638 | (37.78086144164, -122.423868947638) | 7 | 9 | 11 | 28852 | 41 | |||
| 48658 | 139935 | DPW Maintained 1 | Tristania conferta :: 61 | 800 GOUGH ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6005714.5324 | 2112478.1713 | 37.7807854422322 | -122.423852565408 | (37.7807854422322, -122.423852565408) | 7 | 9 | 11 | 28852 | 41 | |||
| 129373 | 139931 | DPW Maintained 1 | Tristania conferta :: 61 | 800 GOUGH ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6005701.5757 | 2112576.2725 | 37.7810540726267 | -122.423904366871 | (37.7810540726267, -122.423904366871) | 7 | 9 | 11 | 28852 | 41 | |||
| 147487 | 139928 | DPW Maintained 1 | Tristania conferta :: 61 | 800 GOUGH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6005691.164 | 2112649.617 | 37.7812548708412 | -122.42394560326 | (37.7812548708412, -122.42394560326) | 7 | 9 | 11 | 28852 | 41 | |||
| 170004 | 139927 | DPW Maintained 1 | Tristania conferta :: 61 | 800 GOUGH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6005686.5366 | 2112676.4561 | 37.7813283031803 | -122.423963520927 | (37.7813283031803, -122.423963520927) | 7 | 9 | 11 | 28852 | 41 | |||
| 154643 | 16975 | DPW Maintained 1 | Tristania conferta :: 61 | 799 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003231.482 | 2109954.4979 | 37.7737155730107 | -122.432262348922 | (37.7737155730107, -122.432262348922) | 15 | 9 | 11 | 29492 | 10 | |||
| 41040 | 247485 | DPW Maintained 1 | Tristania conferta :: 61 | 780 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6002841.2579 | 2109599.114 | 37.7727176432561 | -122.43358679066 | (37.7727176432561, -122.43358679066) | 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) );