trees
1,377 rows where qSpecies_id = 61 sorted by Police 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
130 | 13128 | DPW Maintained 1 | Tristania conferta :: 61 | 1714 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6004131.2449 | 2119777.2826 | 37.8007374433085 | -122.429850711739 | (37.8007374433085, -122.429850711739) | 13 | 9 | 1 | 57 | 17 | |||
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 | |||
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 | ||
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 | |||
3600 | 23929 | DPW Maintained 1 | Tristania conferta :: 61 | 1715 Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/1992 12:00:00 AM | 20 | 4X4 | 6003463.555 | 2114659.6298 | 37.7866478474124 | -122.431795587112 | (37.7866478474124, -122.431795587112) | 13 | 9 | 11 | 29490 | 27 | ||
3754 | 261321 | DPW Maintained 1 | Tristania conferta :: 61 | 2353 Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001169.3018 | 2119289.54 | 37.7992300540772 | -122.440065245785 | (37.7992300540772, -122.440065245785) | 13 | 9 | 1 | 57 | 17 | ||||
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 | |||
4874 | 143132 | DPW Maintained 1 | Tristania conferta :: 61 | 2435 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6000754.0798 | 2119231.0352 | 37.7990457686205 | -122.441497852636 | (37.7990457686205, -122.441497852636) | 13 | 9 | 1 | 57 | 17 | |||
5148 | 247454 | DPW Maintained 1 | Tristania conferta :: 61 | 563 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6003114.7156 | 2110238.7499 | 37.7744894374273 | -122.432686570898 | (37.7744894374273, -122.432686570898) | 15 | 9 | 11 | 29492 | 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 | |||
5979 | 137873 | DPW Maintained 1 | Tristania conferta :: 61 | 1805 PINE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6005262.4155 | 2115445.1649 | 37.7889065369741 | -122.425627888461 | (37.7889065369741, -122.425627888461) | 13 | 9 | 11 | 28858 | 27 | |||
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 | |||
6704 | 13114 | DPW Maintained 1 | Tristania conferta :: 61 | 1618 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2005 12:00:00 AM | 12 | 3x3 | 6004576.6984 | 2119842.3294 | 37.800941260536 | -122.428313896065 | (37.800941260536, -122.428313896065) | 13 | 9 | 1 | 57 | 17 | ||
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 | |||
8845 | 21605 | DPW Maintained 1 | Tristania conferta :: 61 | 1521 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4X4 | 6005164.0288 | 2114740.1913 | 37.7869652957353 | -122.425918090858 | (37.7869652957353, -122.425918090858) | 13 | 9 | 11 | 28858 | 13 | |||
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 | |||
9366 | 13179 | DPW Maintained 1 | Tristania conferta :: 61 | 1976 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/14/1997 12:00:00 AM | 14 | 3X3 | 6002902.1538 | 2119607.7128 | 37.8002021701058 | -122.434091743886 | (37.8002021701058, -122.434091743886) | 13 | 9 | 1 | 57 | 17 | ||
10876 | 13180 | DPW Maintained 1 | Tristania conferta :: 61 | 1990 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1993 12:00:00 AM | 15 | 3X3 | 6002882.226 | 2119605.2218 | 37.8001941994801 | -122.434160523596 | (37.8001941994801, -122.434160523596) | 13 | 9 | 1 | 57 | 17 | ||
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 | ||
12950 | 138781 | DPW Maintained 1 | Tristania conferta :: 61 | 1600 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6003611.2673 | 2114261.243 | 37.785562349837 | -122.431256090862 | (37.785562349837, -122.431256090862) | 13 | 9 | 11 | 29490 | 13 | |||
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 | |
16548 | 143139 | DPW Maintained 1 | Tristania conferta :: 61 | 2520 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6000358 | 2119336 | 37.7993114011756 | -122.442875959315 | (37.7993114011756, -122.442875959315) | 13 | 9 | 1 | 57 | 17 | |||
16713 | 137874 | DPW Maintained 1 | Tristania conferta :: 61 | 1635 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6005298.8871 | 2115425.6162 | 37.7888549218974 | -122.425500309796 | (37.7888549218974, -122.425500309796) | 13 | 9 | 11 | 28858 | 27 | |||
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 | |||
17209 | 13251 | DPW Maintained 1 | Tristania conferta :: 61 | 2395 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6000984.849 | 2119261.9127 | 37.7991436944439 | -122.440701531677 | (37.7991436944439, -122.440701531677) | 13 | 9 | 1 | 57 | 17 | |||
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 | |||
19778 | 137930 | DPW Maintained 1 | Tristania conferta :: 61 | 1977 PINE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004477.3196 | 2115333.9095 | 37.7885566643943 | -122.428336281189 | (37.7885566643943, -122.428336281189) | 13 | 9 | 11 | 28858 | 27 | |||
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 | |||
24618 | 51914 | DPW Maintained 1 | Tristania conferta :: 61 | 1738 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50190 | 6004049.1514 | 2119767.1187 | 37.8007048866604 | -122.43013406377 | (37.8007048866604, -122.43013406377) | 13 | 9 | 1 | 57 | 17 | |
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 | |||
27170 | 68157 | DPW Maintained 1 | Tristania conferta :: 61 | 1515 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/1994 12:00:00 AM | 8 | Permit Number 33474 | 6005184.9642 | 2114742.2338 | 37.7869720870456 | -122.425845804507 | (37.7869720870456, -122.425845804507) | 13 | 9 | 11 | 28858 | 13 | ||
27181 | 9604 | DPW Maintained 1 | Tristania conferta :: 61 | 1355 Golden Gate Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6003125.8375 | 2112021.5623 | 37.7793852280154 | -122.432775482637 | (37.7793852280154, -122.432775482637) | 15 | 9 | 11 | 29490 | 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 | |||
27995 | 139342 | DPW Maintained 1 | Tristania conferta :: 61 | 1400 GEARY BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6005040.0715 | 2114155.1684 | 37.7853519625541 | -122.426305287483 | (37.7853519625541, -122.426305287483) | 13 | 9 | 11 | 28858 | 13 | |||
28152 | 138780 | DPW Maintained 1 | Tristania conferta :: 61 | 1600 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6003615.8018 | 2114245.3723 | 37.785519029862 | -122.431239269571 | (37.785519029862, -122.431239269571) | 13 | 9 | 11 | 29490 | 13 | |||
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 | |||
30243 | 13145 | DPW Maintained 1 | Tristania conferta :: 61 | 1801 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/1996 12:00:00 AM | 8 | 3X3 | 6003646.5026 | 2119634.2054 | 37.8003171280845 | -122.431517900376 | (37.8003171280845, -122.431517900376) | 13 | 9 | 1 | 57 | 17 | ||
30290 | 13100 | DPW Maintained 1 | Tristania conferta :: 61 | 1501 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/12/2017 12:00:00 AM | 8 | 3X3 | 6005075.7106 | 2119828.8842 | 37.800932566852 | -122.426586143087 | (37.800932566852, -122.426586143087) | 13 | 9 | 1 | 57 | 17 | ||
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 | |||
31794 | 13264 | DPW Maintained 1 | Tristania conferta :: 61 | 2460 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/1993 12:00:00 AM | 19 | 3X3 | 6000672.0217 | 2119297.5934 | 37.7992238445501 | -122.441786579885 | (37.7992238445501, -122.441786579885) | 13 | 9 | 1 | 57 | 17 | ||
32120 | 137838 | DPW Maintained 1 | Tristania conferta :: 61 | 1800X Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6005085 | 2115443 | 37.7888905662133 | -122.426241568128 | (37.7888905662133, -122.426241568128) | 13 | 9 | 11 | 28858 | 27 | |||
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 | |||
32812 | 99009 | DPW Maintained 1 | Tristania conferta :: 61 | 2099X Beach St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 01/20/2015 12:00:00 AM | 3 | Permit Number 771149 | 6000381.4 | 2120794.3 | 37.8033168379221 | -122.442899765771 | (37.8033168379221, -122.442899765771) | 13 | 9 | 1 | 57 | 17 | ||
32919 | 137939 | DPW Maintained 1 | Tristania conferta :: 61 | 1788 SUTTER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6004036.2031 | 2114629.3704 | 37.7865972072742 | -122.429812204107 | (37.7865972072742, -122.429812204107) | 13 | 9 | 11 | 29490 | 27 | |||
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 | ||
33782 | 137840 | DPW Maintained 1 | Tristania conferta :: 61 | 1800X Pine St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6005085 | 2115443 | 37.7888905662133 | -122.426241568128 | (37.7888905662133, -122.426241568128) | 13 | 9 | 11 | 28858 | 27 | |||
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 | |||
34796 | 24416 | DPW Maintained 1 | Tristania conferta :: 61 | 1625 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1995 12:00:00 AM | 18 | 3X3 | 6005321.0617 | 2115263.3908 | 37.7884107443518 | -122.425412039373 | (37.7884107443518, -122.425412039373) | 13 | 9 | 11 | 28858 | 27 | ||
36451 | 18237 | DPW Maintained 1 | Tristania conferta :: 61 | 1790X Post St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2007 12:00:00 AM | 4 | 4X4 | 6003723.9754 | 2114242.1212 | 37.7855162327444 | -122.43086478876 | (37.7855162327444, -122.43086478876) | 13 | 9 | 11 | 29490 | 13 | ||
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 | |||
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 | ||
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 | ||
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 | ||
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 | |||
40821 | 140557 | DPW Maintained 1 | Tristania conferta :: 61 | 1175 MCALLISTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6003583.5208 | 2111740.6921 | 37.7786399751241 | -122.43117211119 | (37.7786399751241, -122.43117211119) | 15 | 9 | 11 | 29492 | 41 | |||
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 | |||
42452 | 13177 | DPW Maintained 1 | Tristania conferta :: 61 | 1970 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/13/1995 12:00:00 AM | 35 | 3x3 | 6002925.1953 | 2119612.072 | 37.8002154469875 | -122.434012323171 | (37.8002154469875, -122.434012323171) | 13 | 9 | 1 | 57 | 17 | ||
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 | ||
42759 | 13242 | DPW Maintained 1 | Tristania conferta :: 61 | 2353 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6001124.6106 | 2119280.6018 | 37.7992029678306 | -122.440219251047 | (37.7992029678306, -122.440219251047) | 13 | 9 | 1 | 57 | 17 | |||
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 |
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) );