trees
1,377 rows where qSpecies_id = 61 sorted by Fire Prevention Districts 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17387 | 216652 | DPW Maintained 1 | Tristania conferta :: 61 | 329 Faxon Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 09/23/2020 12:00:00 AM | 3 | Width 4ft | 5994725.9247 | 2090785.70947 | 37.7205969659665 | -122.460295076156 | (37.7205969659665, -122.460295076156) | 9 | 8 | 6 | 28861 | 24 | ||
22456 | 25279 | DPW Maintained 1 | Tristania conferta :: 61 | 1940 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5993856.5207 | 2092712.5569 | 37.7258375734043 | -122.463440067194 | (37.7258375734043, -122.463440067194) | 9 | 8 | 4 | 59 | 40 | |||
37913 | 25228 | DPW Maintained 1 | Tristania conferta :: 61 | 1923 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 5994038.0508 | 2092538.029 | 37.7253688193969 | -122.462799879695 | (37.7253688193969, -122.462799879695) | 9 | 8 | 4 | 59 | 40 | |||
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 | ||
74394 | 251703 | DPW Maintained 1 | Tristania conferta :: 61 | 123 Trumbull St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/11/2017 10:45:00 AM | 3 | 3x3 | 6004216 | 2094352 | 37.7309305395323 | -122.427744838273 | (37.7309305395323, -122.427744838273) | 9 | 7 | 6 | 28861 | 5 | ||
112960 | 29568 | DPW Maintained 1 | Tristania conferta :: 61 | 1515 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 5995262.4177 | 2092118.4741 | 37.7242872653999 | -122.458537028286 | (37.7242872653999, -122.458537028286) | 9 | 8 | 4 | 28861 | 24 | |||
124692 | 25223 | DPW Maintained 1 | Tristania conferta :: 61 | 1951 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 5993847.033 | 2092637.9106 | 37.7256320661895 | -122.46346745052 | (37.7256320661895, -122.46346745052) | 9 | 8 | 4 | 59 | 40 | |||
160890 | 25225 | DPW Maintained 1 | Tristania conferta :: 61 | 1949 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5993885.2366 | 2092618.1184 | 37.7255799226856 | -122.463333949193 | (37.7255799226856, -122.463333949193) | 9 | 8 | 4 | 59 | 40 | |||
167484 | 25224 | DPW Maintained 1 | Tristania conferta :: 61 | 1951 Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 5993865.4444 | 2092626.4035 | 37.7256015312656 | -122.463402969615 | (37.7256015312656, -122.463402969615) | 9 | 8 | 4 | 59 | 40 | |||
17245 | 245465 | DPW Maintained 1 | Tristania conferta :: 61 | 2601 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6008856.7977 | 2106814.5159 | 37.7654112631592 | -122.412581421905 | (37.7654112631592, -122.412581421905) | 8 | 4 | 7 | 28859 | 19 | |||
26846 | 15288 | DPW Maintained 1 | Tristania conferta :: 61 | 1600 Mission St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/12/1995 12:00:00 AM | 8 | 3X3 | 6006995.5283 | 2109306.0347 | 37.7721477499918 | -122.419195888407 | (37.7721477499918, -122.419195888407) | 8 | 2 | 9 | 28853 | 19 | ||
33383 | 15283 | DPW Maintained 1 | Tristania conferta :: 61 | 1600 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/12/1995 12:00:00 AM | 6 | 3x3 | 6007077.8589 | 2109462.9776 | 37.7725833140899 | -122.418922232447 | (37.7725833140899, -122.418922232447) | 8 | 2 | 9 | 28853 | 19 | ||
43164 | 15285 | DPW Maintained 1 | Tristania conferta :: 61 | 1600 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/12/1995 12:00:00 AM | 6 | 3x3 | 6007055.561 | 2109424.3851 | 37.7724760926839 | -122.4189966256 | (37.7724760926839, -122.4189966256) | 8 | 2 | 9 | 28853 | 19 | ||
64219 | 15286 | DPW Maintained 1 | Tristania conferta :: 61 | 1600 Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/12/1995 12:00:00 AM | 6 | 3x3 | 6007046.1273 | 2109405.5176 | 37.7724237557967 | -122.419027919285 | (37.7724237557967, -122.419027919285) | 8 | 2 | 9 | 28853 | 19 | ||
64950 | 15284 | DPW Maintained 1 | Tristania conferta :: 61 | 1600 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/12/1995 12:00:00 AM | 6 | 3x3 | 6007065.8524 | 2109440.6797 | 37.7725214132882 | -122.418962182475 | (37.7725214132882, -122.418962182475) | 8 | 2 | 9 | 28853 | 19 | ||
68651 | 245425 | DPW Maintained 1 | Tristania conferta :: 61 | 2500 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6009073.1901 | 2106875.611 | 37.7655911583595 | -122.411837285128 | (37.7655911583595, -122.411837285128) | 8 | 4 | 7 | 28853 | 19 | |||
91017 | 15287 | DPW Maintained 1 | Tristania conferta :: 61 | 1600 Mission St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/12/1995 12:00:00 AM | 6 | 3x3 | 6007004.1044 | 2109328.3326 | 37.7722094576916 | -122.41916780485 | (37.7722094576916, -122.41916780485) | 8 | 2 | 9 | 28853 | 19 | ||
95836 | 246309 | DPW Maintained 1 | Tristania conferta :: 61 | 1601 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6007064.7803 | 2109330.2021 | 37.772218007718 | -122.418958053835 | (37.772218007718, -122.418958053835) | 8 | 2 | 9 | 28853 | 19 | |||
104575 | 246310 | DPW Maintained 1 | Tristania conferta :: 61 | 1601 Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/06/2012 10:05:00 AM | 2 | Width 0ft | 6007075.5388 | 2109348.1328 | 37.7722678469563 | -122.418922111123 | (37.7722678469563, -122.418922111123) | 8 | 2 | 9 | 28853 | 19 | ||
111514 | 15321 | DPW Maintained 1 | Tristania conferta :: 61 | 1695 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/1995 12:00:00 AM | 16 | 3x3 | 6006859.38 | 2108800.5123 | 37.7707520374067 | -122.419630964143 | (37.7707520374067, -122.419630964143) | 8 | 2 | 9 | 28853 | 19 | ||
112871 | 246313 | DPW Maintained 1 | Tristania conferta :: 61 | 1655 Mission St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6007004.876 | 2109202.9434 | 37.771865212234 | -122.41915623997 | (37.771865212234, -122.41915623997) | 8 | 2 | 9 | 28853 | 19 | |||
116186 | 245426 | DPW Maintained 1 | Tristania conferta :: 61 | 2500 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6009042.7562 | 2106872.7578 | 37.7655816167175 | -122.411942347984 | (37.7655816167175, -122.411942347984) | 8 | 4 | 7 | 28853 | 19 | |||
141864 | 246311 | Undocumented 4 | Tristania conferta :: 61 | 1601 Mission St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6007089.8834 | 2109370.8451 | 37.772331017243 | -122.418874102872 | (37.772331017243, -122.418874102872) | 8 | 2 | 9 | 28853 | 19 | |||
142502 | 245428 | DPW Maintained 1 | Tristania conferta :: 61 | 2500 16th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6008979.986 | 2106872.7578 | 37.7655780948672 | -122.412159456951 | (37.7655780948672, -122.412159456951) | 8 | 4 | 7 | 28853 | 19 | |||
147781 | 245427 | DPW Maintained 1 | Tristania conferta :: 61 | 2500 16th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6009012.3222 | 2106874.66 | 37.7655851322084 | -122.412047747256 | (37.7655851322084, -122.412047747256) | 8 | 4 | 7 | 28853 | 19 | |||
162722 | 246308 | DPW Maintained 1 | Tristania conferta :: 61 | 1601 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6007054.0219 | 2109305.099 | 37.7721484747698 | -122.418993487345 | (37.7721484747698, -122.418993487345) | 8 | 2 | 9 | 28853 | 19 | |||
168797 | 245424 | DPW Maintained 1 | Tristania conferta :: 61 | 2500 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6009098.8688 | 2106876.5621 | 37.7655952104225 | -122.411748535077 | (37.7655952104225, -122.411748535077) | 8 | 4 | 7 | 28853 | 19 | |||
169757 | 245463 | DPW Maintained 1 | Tristania conferta :: 61 | 2601 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6008760.7624 | 2106810.7125 | 37.7653954296817 | -122.412913318132 | (37.7653954296817, -122.412913318132) | 8 | 4 | 7 | 28859 | 19 | |||
172373 | 246307 | DPW Maintained 1 | Tristania conferta :: 61 | 1601 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6007039.6773 | 2109281.1913 | 37.7720820221483 | -122.419041410572 | (37.7720820221483, -122.419041410572) | 8 | 2 | 9 | 28853 | 19 | |||
182936 | 245464 | DPW Maintained 1 | Tristania conferta :: 61 | 2601 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6008830.1741 | 2106813.5651 | 37.76540715826 | -122.412673439915 | (37.76540715826, -122.412673439915) | 8 | 4 | 7 | 28859 | 19 | |||
188253 | 246306 | DPW Maintained 1 | Tristania conferta :: 61 | 1601 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6007027.7234 | 2109258.4791 | 37.7720189866936 | -122.419081148892 | (37.7720189866936, -122.419081148892) | 8 | 2 | 9 | 28853 | 19 | |||
899 | 9520 | DPW Maintained 1 | Tristania conferta :: 61 | 1046 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/2000 12:00:00 AM | 3 | 3X3 | 6004532.0878 | 2112270.4724 | 37.7801483287397 | -122.427928412048 | (37.7801483287397, -122.427928412048) | 7 | 9 | 11 | 29490 | 41 | ||
1099 | 138916 | DPW Maintained 1 | Tristania conferta :: 61 | 707 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004396.0968 | 2110813.5411 | 37.7761402601039 | -122.428295000541 | (37.7761402601039, -122.428295000541) | 7 | 9 | 11 | 28852 | 10 | |||
3148 | 24262 | DPW Maintained 1 | Tristania conferta :: 61 | 600X Willow St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/19/2004 12:00:00 AM | 3 | 3X3 | 6004514.0905 | 2113119.5269 | 37.7824786038336 | -122.428051195433 | (37.7824786038336, -122.428051195433) | 7 | 9 | 11 | 29490 | 41 | ||
3420 | 79436 | DPW Maintained 1 | Tristania conferta :: 61 | 606 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6004047.0413 | 2110853.2815 | 37.7762296204821 | -122.429505312147 | (37.7762296204821, -122.429505312147) | 7 | 9 | 11 | 28852 | 10 | |||
4598 | 140349 | DPW Maintained 1 | Tristania conferta :: 61 | 1314 ELLIS ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6004502.4614 | 2113302.7614 | 37.7829810622913 | -122.428104489199 | (37.7829810622913, -122.428104489199) | 7 | 9 | 11 | 29490 | 41 | |||
4786 | 70866 | DPW Maintained 1 | Tristania conferta :: 61 | 499 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6005878.7494 | 2111261.8484 | 37.7774549853258 | -122.423197973584 | (37.7774549853258, -122.423197973584) | 7 | 9 | 11 | 28852 | 10 | |||
5368 | 73913 | DPW Maintained 1 | Tristania conferta :: 61 | 499 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6005876.1258 | 2111280.7378 | 37.7775067029674 | -122.423208392543 | (37.7775067029674, -122.423208392543) | 7 | 9 | 11 | 28852 | 10 | |||
5852 | 83783 | DPW Maintained 1 | Tristania conferta :: 61 | 606 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6004048.7127 | 2110839.5763 | 37.7761920840099 | -122.429498552699 | (37.7761920840099, -122.429498552699) | 7 | 9 | 11 | 28852 | 10 | |||
6244 | 138902 | DPW Maintained 1 | Tristania conferta :: 61 | 518 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6004070.6412 | 2110683.9615 | 37.7757660455959 | -122.42941159626 | (37.7757660455959, -122.42941159626) | 7 | 9 | 11 | 28852 | 10 | |||
6717 | 138911 | DPW Maintained 1 | Tristania conferta :: 61 | 723 HAYES ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6004266.8521 | 2110794.1209 | 37.776079623036 | -122.428740708053 | (37.776079623036, -122.428740708053) | 7 | 9 | 11 | 28852 | 10 | |||
6940 | 140679 | DPW Maintained 1 | Tristania conferta :: 61 | 1303 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6004187.9883 | 2112981.79 | 37.7820819575387 | -122.429169542785 | (37.7820819575387, -122.429169542785) | 7 | 9 | 11 | 29490 | 41 | |||
7492 | 138882 | DPW Maintained 1 | Tristania conferta :: 61 | 510 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6004088.2198 | 2110564.2595 | 37.7754383685459 | -122.429342249625 | (37.7754383685459, -122.429342249625) | 7 | 9 | 11 | 28852 | 10 | |||
8910 | 74145 | DPW Maintained 1 | Tristania conferta :: 61 | 499 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6005875.6011 | 2111298.5777 | 37.7775556573861 | -122.423211476089 | (37.7775556573861, -122.423211476089) | 7 | 9 | 11 | 28852 | 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 | ||
12388 | 6901 | DPW Maintained 1 | Tristania conferta :: 61 | 333 Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/14/2015 12:30:00 PM | 3 | 3x3 | 6005680.1943 | 2110643.4354 | 37.775745766228 | -122.423840858061 | (37.775745766228, -122.423840858061) | 7 | 9 | 11 | 28852 | 10 | ||
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 | |||
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 | ||
14541 | 65945 | DPW Maintained 1 | Tristania conferta :: 61 | 528 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1990 12:00:00 AM | 12 | Permit Number 28966 | 6007615.5081 | 2113146.6876 | 37.7827281591619 | -122.417323539063 | (37.7827281591619, -122.417323539063) | 7 | 9 | 9 | 28852 | 36 | |
17145 | 139804 | DPW Maintained 1 | Tristania conferta :: 61 | 1101 GOUGH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6005645.4415 | 2112973.1088 | 37.7821405184571 | -122.424126793395 | (37.7821405184571, -122.424126793395) | 7 | 9 | 11 | 28852 | 41 | |||
17424 | 9664 | DPW Maintained 1 | Tristania conferta :: 61 | 115 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/07/1995 12:00:00 AM | 18 | 3X3 | 6006036.6387 | 2110130.4049 | 37.7743572242045 | -122.422571361821 | (37.7743572242045, -122.422571361821) | 7 | 9 | 11 | 28852 | 10 | ||
18491 | 141846 | DPW Maintained 1 | Tristania conferta :: 61 | 1273 EDDY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6004395.0795 | 2112899.1361 | 37.781866731536 | -122.428447208044 | (37.781866731536, -122.428447208044) | 7 | 9 | 11 | 29490 | 41 | |||
19251 | 142786 | DPW Maintained 1 | Tristania conferta :: 61 | 730 POLK ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6007071.7839 | 2113562.2092 | 37.7838384745362 | -122.419234083256 | (37.7838384745362, -122.419234083256) | 7 | 9 | 9 | 28858 | 36 | |||
19333 | 244143 | DPW Maintained 1 | Tristania conferta :: 61 | 423 Rose St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6004418.4707 | 2109613.03 | 37.7728452161751 | -122.428132029093 | (37.7728452161751, -122.428132029093) | 7 | 9 | 11 | 28852 | 10 | |||
19744 | 138921 | DPW Maintained 1 | Tristania conferta :: 61 | 631 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004505.2517 | 2110712.757 | 37.7758697074358 | -122.427910221054 | (37.7758697074358, -122.427910221054) | 7 | 9 | 11 | 28852 | 10 | |||
20401 | 140131 | Permitted Site 7 | Tristania conferta :: 61 | 501 GOUGH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/11/2002 12:00:00 AM | 5 | Width 0ft | 6005847.0047 | 2111508.1975 | 37.7781296085056 | -122.423325305774 | (37.7781296085056, -122.423325305774) | 7 | 9 | 11 | 28852 | 10 | ||
20668 | 142244 | DPW Maintained 1 | Tristania conferta :: 61 | 419 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6005364 | 2110769 | 37.7760726809274 | -122.424943590033 | (37.7760726809274, -122.424943590033) | 7 | 9 | 11 | 28852 | 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 | |||
22006 | 6951 | DPW Maintained 1 | Tristania conferta :: 61 | 603 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/11/1990 12:00:00 AM | 6 | 3x3 | 6004469.2574 | 2110472.8506 | 37.7752089468863 | -122.428017634821 | (37.7752089468863, -122.428017634821) | 7 | 9 | 11 | 28852 | 10 | ||
22324 | 141816 | DPW Maintained 1 | Tristania conferta :: 61 | 1218 EDDY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6004565.725 | 2112968.4018 | 37.7820665729689 | -122.427861790691 | (37.7820665729689, -122.427861790691) | 7 | 9 | 11 | 29490 | 41 | |||
22953 | 244944 | DPW Maintained 1 | Tristania conferta :: 61 | 333 Fell St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6005861.1541 | 2110670.4754 | 37.775830225555 | -122.423216794436 | (37.775830225555, -122.423216794436) | 7 | 9 | 11 | 28852 | 10 | |||
23140 | 142358 | DPW Maintained 1 | Tristania conferta :: 61 | 1135 ELLIS ST | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6005410.0165 | 2113384.468 | 37.7832567141838 | -122.424970534924 | (37.7832567141838, -122.424970534924) | 7 | 9 | 11 | 28858 | 41 | |||
24168 | 142357 | DPW Maintained 1 | Tristania conferta :: 61 | 1135 ELLIS ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6005388.7452 | 2113384.468 | 37.7832555126318 | -122.425044125193 | (37.7832555126318, -122.425044125193) | 7 | 9 | 11 | 28858 | 41 | |||
24537 | 142352 | DPW Maintained 1 | Tristania conferta :: 61 | 1135 ELLIS ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6005138.142 | 2113344.5842 | 37.783131842304 | -122.425908272817 | (37.783131842304, -122.425908272817) | 7 | 9 | 11 | 28858 | 41 | |||
25025 | 12266 | DPW Maintained 1 | Tristania conferta :: 61 | 649 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/02/1991 12:00:00 AM | 16 | 3X3 | 6004915.2268 | 2111219.2684 | 37.7772836485499 | -122.426528085844 | (37.7772836485499, -122.426528085844) | 7 | 9 | 11 | 28852 | 10 | ||
25859 | 140097 | DPW Maintained 1 | Tristania conferta :: 61 | 515 GOUGH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005837.56 | 2111570.1127 | 37.7782990795293 | -122.423362381053 | (37.7782990795293, -122.423362381053) | 7 | 9 | 11 | 28852 | 10 | |||
26175 | 138912 | DPW Maintained 1 | Tristania conferta :: 61 | 719 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004292.6341 | 2110798.4737 | 37.7760930338959 | -122.428651831595 | (37.7760930338959, -122.428651831595) | 7 | 9 | 11 | 28852 | 10 | |||
26320 | 6186 | DPW Maintained 1 | Tristania conferta :: 61 | 1100 Ellis St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005445.8524 | 2113436.2606 | 37.783400948036 | -122.424850242823 | (37.783400948036, -122.424850242823) | 7 | 9 | 11 | 28858 | 41 | |||
26474 | 6905 | DPW Maintained 1 | Tristania conferta :: 61 | 333 Fell St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3X3 | 6005791.8208 | 2110660.0754 | 37.7757977566382 | -122.423455896757 | (37.7757977566382, -122.423455896757) | 7 | 9 | 11 | 28852 | 10 | |||
26593 | 65948 | DPW Maintained 1 | Tristania conferta :: 61 | 550 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1990 12:00:00 AM | 12 | Permit Number 28969 | 6007606.7794 | 2113206.8791 | 37.7828929393541 | -122.417358003683 | (37.7828929393541, -122.417358003683) | 7 | 9 | 9 | 28852 | 36 | |
26711 | 6184 | DPW Maintained 1 | Tristania conferta :: 61 | 1100 Ellis St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005484.2824 | 2113445.6337 | 37.7834288547985 | -122.424717956993 | (37.7834288547985, -122.424717956993) | 7 | 9 | 11 | 28858 | 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 | |||
27421 | 140039 | DPW Maintained 1 | Tristania conferta :: 61 | 555 GOUGH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6005821.2941 | 2111685.5479 | 37.7786151184258 | -122.423426859428 | (37.7786151184258, -122.423426859428) | 7 | 9 | 11 | 28852 | 10 | |||
27583 | 140342 | DPW Maintained 1 | Tristania conferta :: 61 | 1335 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6004604.4556 | 2113518.6258 | 37.7835795423556 | -122.42776701682 | (37.7835795423556, -122.42776701682) | 7 | 9 | 11 | 29490 | 41 | |||
28272 | 141813 | DPW Maintained 1 | Tristania conferta :: 61 | 631 WILLOW ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6004531.7581 | 2113098.1631 | 37.7824209436961 | -122.42798855036 | (37.7824209436961, -122.42798855036) | 7 | 9 | 11 | 29490 | 41 | |||
29736 | 12282 | DPW Maintained 1 | Tristania conferta :: 61 | 745 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x10 | 6004875.3929 | 2111529.8441 | 37.7781341613075 | -122.426688006249 | (37.7781341613075, -122.426688006249) | 7 | 9 | 11 | 28852 | 10 | |||
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 | |||
30412 | 139853 | DPW Maintained 1 | Tristania conferta :: 61 | 735 GOUGH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6005744.0619 | 2112263.2548 | 37.7801970011251 | -122.423735122838 | (37.7801970011251, -122.423735122838) | 7 | 9 | 11 | 28852 | 41 | |||
30683 | 6223 | DPW Maintained 1 | Tristania conferta :: 61 | 1220 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/13/1997 12:00:00 AM | 12 | 3X4 | 6005122.7706 | 2113389.4093 | 37.7832540522328 | -122.425964643575 | (37.7832540522328, -122.425964643575) | 7 | 9 | 11 | 28858 | 41 | ||
31234 | 141807 | DPW Maintained 1 | Tristania conferta :: 61 | 1398 WILLOW ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6004301.1437 | 2113069.4068 | 37.7823289364611 | -122.428784324512 | (37.7823289364611, -122.428784324512) | 7 | 9 | 11 | 29490 | 41 | |||
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 | |||
32762 | 141976 | DPW Maintained 1 | Tristania conferta :: 61 | 632 FULTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6004632.3853 | 2111592.8247 | 37.7782933487801 | -122.427533145885 | (37.7782933487801, -122.427533145885) | 7 | 9 | 11 | 28852 | 41 | |||
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 | ||||
33537 | 244129 | DPW Maintained 1 | Tristania conferta :: 61 | 312 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004596.6687 | 2109503.17 | 37.7725536479568 | -122.427507793274 | (37.7725536479568, -122.427507793274) | 7 | 9 | 11 | 28852 | 10 | |||
33638 | 27330 | DPW Maintained 1 | Tristania conferta :: 61 | 348 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/12/1998 12:00:00 AM | 25 | 4X4 | 6004421.6425 | 2109483.8508 | 37.7724907010193 | -122.4281118499 | (37.7724907010193, -122.4281118499) | 7 | 9 | 11 | 28852 | 10 | ||
33724 | 12273 | DPW Maintained 1 | Tristania conferta :: 61 | 721 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1991 12:00:00 AM | 12 | 3X3 | 6004895.7756 | 2111355.1796 | 37.7776557277721 | -122.426605054269 | (37.7776557277721, -122.426605054269) | 7 | 9 | 11 | 28852 | 10 | ||
34786 | 6183 | DPW Maintained 1 | Tristania conferta :: 61 | 1100 Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005506.7779 | 2113443.7591 | 37.7834249780962 | -122.424639997895 | (37.7834249780962, -122.424639997895) | 7 | 9 | 11 | 28858 | 41 | |||
36821 | 140399 | DPW Maintained 1 | Tristania conferta :: 61 | 650 WILLOW ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6004395.7092 | 2113101.266 | 37.7824217656528 | -122.42845944123 | (37.7824217656528, -122.42845944123) | 7 | 9 | 11 | 29490 | 41 | |||
37861 | 138901 | DPW Maintained 1 | Tristania conferta :: 61 | 512 WEBSTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6004073.9895 | 2110663.202 | 37.7757092346813 | -122.429398532918 | (37.7757092346813, -122.429398532918) | 7 | 9 | 11 | 28852 | 10 | |||
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 | |||
38816 | 12338 | DPW Maintained 1 | Tristania conferta :: 61 | 1151X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/10/1997 12:00:00 AM | 12 | 3X3 | 6004696.7001 | 2112810.35 | 37.7816400103646 | -122.427397413482 | (37.7816400103646, -122.427397413482) | 7 | 9 | 11 | 29490 | 41 | ||
39999 | 138914 | DPW Maintained 1 | Tristania conferta :: 61 | 715 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6004339.5104 | 2110805.84 | 37.7761159127531 | -122.428490199112 | (37.7761159127531, -122.428490199112) | 7 | 9 | 11 | 28852 | 10 | |||
41978 | 142365 | DPW Maintained 1 | Tristania conferta :: 61 | 1135 ELLIS ST | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6005547.6156 | 2113403.0804 | 37.7833155906951 | -122.424495820848 | (37.7833155906951, -122.424495820848) | 7 | 9 | 11 | 28858 | 41 | |||
42460 | 142016 | DPW Maintained 1 | Tristania conferta :: 61 | 721 LAGUNA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6004898.2842 | 2111330.7203 | 37.7775887103504 | -122.426594634026 | (37.7775887103504, -122.426594634026) | 7 | 9 | 11 | 28852 | 10 | |||
42747 | 9669 | DPW Maintained 1 | Tristania conferta :: 61 | 203 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/07/1995 12:00:00 AM | 18 | 3X3 | 6006010.537 | 2110311.0286 | 37.7748517007261 | -122.42267449095 | (37.7748517007261, -122.42267449095) | 7 | 9 | 11 | 28852 | 10 | ||
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 | |||
44579 | 24261 | DPW Maintained 1 | Tristania conferta :: 61 | 600X Willow St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/19/2004 12:00:00 AM | 5 | 3X3 | 6004538.0187 | 2113122.6754 | 37.7824886025731 | -122.427968638693 | (37.7824886025731, -122.427968638693) | 7 | 9 | 11 | 29490 | 41 | ||
45018 | 244322 | DPW Maintained 1 | Tristania conferta :: 61 | 255 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6005988.2373 | 2110510.0695 | 37.7753969608082 | -122.422765778568 | (37.7753969608082, -122.422765778568) | 7 | 9 | 11 | 28852 | 10 | |||
45104 | 253527 | DPW Maintained 1 | Tristania conferta :: 61 | 100 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/19/2017 09:54:00 AM | 3 | 3X3 | 6005589.149 | 2109643.5092 | 37.7729950707153 | -122.424084680793 | (37.7729950707153, -122.424084680793) | 7 | 9 | 11 | 28852 | 10 |
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) );