trees
1,377 rows where qSpecies_id = 61 sorted by qCaretaker_id
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 | |||
303 | 87474 | DPW Maintained 1 | Tristania conferta :: 61 | 6290 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x5 | 6013182.5276 | 2090518.895 | 37.7209087510834 | -122.39647726989 | (37.7209087510834, -122.39647726989) | 10 | 3 | 8 | 58 | 1 | |||
788 | 200933 | DPW Maintained 1 | Tristania conferta :: 61 | 4210 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6015403.5213 | 2097186.1672 | 37.7393390938031 | -122.389265224086 | (37.7393390938031, -122.389265224086) | 10 | 3 | 8 | 58 | 1 | |||
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 | ||
3625 | 22438 | DPW Maintained 1 | Tristania conferta :: 61 | 6025 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6013608.4406 | 2091403.3166 | 37.7233608886837 | -122.395066921688 | (37.7233608886837, -122.395066921688) | 10 | 3 | 8 | 58 | 1 | |||
4020 | 22395 | DPW Maintained 1 | Tristania conferta :: 61 | 5700 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/31/2011 12:00:00 AM | 6 | 3x3 | 6013894.8509 | 2092365.7305 | 37.7260194067343 | -122.394144192498 | (37.7260194067343, -122.394144192498) | 10 | 3 | 8 | 58 | 1 | ||
4880 | 10701 | DPW Maintained 1 | Tristania conferta :: 61 | 1290 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6001704.3359 | 2110485.9297 | 37.7750880443133 | -122.437583041692 | (37.7750880443133, -122.437583041692) | 15 | 5 | 11 | 29492 | 10 | |||
5658 | 6307 | DPW Maintained 1 | Tristania conferta :: 61 | 1804 Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4x4 | 6002139.3488 | 2112974.3616 | 37.781945376326 | -122.436256362281 | (37.781945376326, -122.436256362281) | 15 | 5 | 11 | 29490 | 41 | |||
5894 | 29427 | DPW Maintained 1 | Tristania conferta :: 61 | 2501X Ingalls St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6015373.5361 | 2091407.2745 | 37.7234697537221 | -122.388965539304 | (37.7234697537221, -122.388965539304) | 10 | 3 | 8 | 58 | 1 | ||
6267 | 200934 | DPW Maintained 1 | Tristania conferta :: 61 | 4220 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | Width 0ft | 6015398.3252 | 2097166.7998 | 37.7392856268198 | -122.389281837998 | (37.7392856268198, -122.389281837998) | 10 | 3 | 8 | 58 | 1 | |||
8629 | 29437 | DPW Maintained 1 | Tristania conferta :: 61 | 2307X Ingalls St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6015612.318 | 2091732.5629 | 37.7243761643823 | -122.388162796666 | (37.7243761643823, -122.388162796666) | 10 | 3 | 8 | 58 | 1 | ||
8657 | 6306 | DPW Maintained 1 | Tristania conferta :: 61 | 1804 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6002160.6694 | 2112978.761 | 37.7819586673159 | -122.436182917866 | (37.7819586673159, -122.436182917866) | 15 | 5 | 11 | 29490 | 41 | |||
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 | ||
10110 | 13676 | DPW Maintained 1 | Tristania conferta :: 61 | 681 Market St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/14/2020 12:00:00 AM | 3 | 4X4 | Permit Number 771659 | 6011822.15902 | 2114934.32739 | 37.7878723731553 | -122.402895995877 | (37.7878723731553, -122.402895995877) | 12 | 2 | 9 | 28855 | 6 | |
10885 | 13675 | DPW Maintained 1 | Tristania conferta :: 61 | 681 Market St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/14/2020 12:00:00 AM | 3 | 4X4 | Permit Number 771659 | 6011805.84433 | 2114919.40836 | 37.7878304980227 | -122.402951392291 | (37.7878304980227, -122.402951392291) | 12 | 2 | 9 | 28855 | 6 | |
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 | ||
11906 | 13674 | DPW Maintained 1 | Tristania conferta :: 61 | 681 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/14/2020 12:00:00 AM | 3 | 4X4 | Permit Number 771659 | 6011788.8197 | 2114903.8104 | 37.787786719038 | -122.403009197144 | (37.787786719038, -122.403009197144) | 12 | 2 | 9 | 28855 | 6 | |
12207 | 6322 | DPW Maintained 1 | Tristania conferta :: 61 | 1864 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 6001909.5604 | 2112942.2115 | 37.7818440417219 | -122.43704902047 | (37.7818440417219, -122.43704902047) | 15 | 5 | 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 | ||
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 | ||
14783 | 200936 | DPW Maintained 1 | Tristania conferta :: 61 | 4240 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | Width 0ft | 6015378.4854 | 2097095.9435 | 37.7390899699971 | -122.389345489075 | (37.7390899699971, -122.389345489075) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
15536 | 200935 | DPW Maintained 1 | Tristania conferta :: 61 | 4230 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6015383.6815 | 2097122.3965 | 37.7391628925988 | -122.389329369915 | (37.7391628925988, -122.389329369915) | 10 | 3 | 8 | 58 | 1 | |||
15605 | 6319 | DPW Maintained 1 | Tristania conferta :: 61 | 1860 Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 6001987.059 | 2112951.3489 | 37.7818735354474 | -122.436781566115 | (37.7818735354474, -122.436781566115) | 15 | 5 | 11 | 29490 | 41 | |||
16824 | 13677 | DPW Maintained 1 | Tristania conferta :: 61 | 681 Market St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/14/2020 12:00:00 AM | 3 | 4X4 | Permit Number 771659 | 6011836.71983 | 2114948.58904 | 37.7879123453203 | -122.402846621288 | (37.7879123453203, -122.402846621288) | 12 | 2 | 9 | 28855 | 6 | |
16944 | 1665 | DPW Maintained 1 | Tristania conferta :: 61 | 1400X Fell St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/06/1992 12:00:00 AM | 18 | 3X3 | 6000409.8977 | 2109962.9335 | 37.7735783473195 | -122.442023227789 | (37.7735783473195, -122.442023227789) | 15 | 5 | 11 | 29492 | 16 | ||
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 | ||
18999 | 29494 | DPW Maintained 1 | Tristania conferta :: 61 | 1700X Ingalls St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2006 12:00:00 AM | 12 | 3X3 | 6016622.9685 | 2093155.934 | 37.7283404071211 | -122.384768194628 | (37.7283404071211, -122.384768194628) | 10 | 3 | 8 | 58 | 1 | ||
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 | ||
21816 | 29421 | DPW Maintained 1 | Tristania conferta :: 61 | 2501X Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2006 12:00:00 AM | 4 | 3x3 | 6015238.3862 | 2091224.5002 | 37.7229603992916 | -122.389419974154 | (37.7229603992916, -122.389419974154) | 10 | 3 | 8 | 58 | 1 | ||
21861 | 22334 | DPW Maintained 1 | Tristania conferta :: 61 | 5201 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/17/2015 02:59:00 PM | 3 | 3X3 | 6014532.0059 | 2093984.9826 | 37.7305009408534 | -122.392054756971 | (37.7305009408534, -122.392054756971) | 10 | 3 | 8 | 58 | 1 | ||
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 | ||
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 | |||
23142 | 22404 | DPW Maintained 1 | Tristania conferta :: 61 | 5800 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | 3X3 | 6013789.3037 | 2092097.7658 | 37.7252777625947 | -122.394490310229 | (37.7252777625947, -122.394490310229) | 10 | 3 | 8 | 58 | 1 | |||
23279 | 22495 | DPW Maintained 1 | Tristania conferta :: 61 | 6315 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/07/2011 12:00:00 AM | 1 | 3x3 | 6013233.044 | 2090405.2973 | 37.7205996457096 | -122.396294690849 | (37.7205996457096, -122.396294690849) | 10 | 3 | 8 | 58 | 1 | ||
23304 | 29532 | DPW Maintained 1 | Tristania conferta :: 61 | 2302X Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6015618.3638 | 2091811.707 | 37.7245938134403 | -122.388147417672 | (37.7245938134403, -122.388147417672) | 10 | 3 | 8 | 58 | 1 | ||
24345 | 29560 | DPW Maintained 1 | Tristania conferta :: 61 | 3100X Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2006 12:00:00 AM | 16 | 3X3 | 6014251.2078 | 2089975.3633 | 37.7194757354442 | -122.39274513029 | (37.7194757354442, -122.39274513029) | 10 | 3 | 8 | 58 | 1 | ||
24711 | 138398 | DPW Maintained 1 | Tristania conferta :: 61 | 2445 PINE ST | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 1 | Width 0ft | 6002388.1124 | 2115043.7135 | 37.7876414218449 | -122.435543840756 | (37.7876414218449, -122.435543840756) | 13 | 6 | 11 | 29490 | 27 | |||
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 | ||
25849 | 10432 | DPW Maintained 1 | Tristania conferta :: 61 | 1441 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/1999 12:00:00 AM | 18 | 3X3 | 5999180.1356 | 2108696.8663 | 37.7700318922285 | -122.446186054388 | (37.7700318922285, -122.446186054388) | 15 | 5 | 11 | 29492 | 9 | ||
25862 | 29433 | DPW Maintained 1 | Tristania conferta :: 61 | 2401X Ingalls St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/19/2011 12:00:00 AM | 3 | 3x3 | 6015500.9632 | 2091579.7516 | 37.7239504043026 | -122.388537076537 | (37.7239504043026, -122.388537076537) | 10 | 3 | 8 | 58 | 1 | ||
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 | |||
26472 | 6077 | DPW Maintained 1 | Tristania conferta :: 61 | 1966 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/06/2007 12:00:00 AM | 18 | 4X4 | 6001073.8278 | 2112479.7581 | 37.7805267238289 | -122.439907091482 | (37.7805267238289, -122.439907091482) | 15 | 5 | 11 | 29490 | 41 | ||
26557 | 7067 | DPW Maintained 1 | Tristania conferta :: 61 | 1600 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/26/2016 12:00:00 AM | 3 | 3x3 | 5999719.0796 | 2109864.829 | 37.7732695858551 | -122.444405811275 | (37.7732695858551, -122.444405811275) | 15 | 5 | 11 | 29492 | 16 | ||
26636 | 29439 | DPW Maintained 1 | Tristania conferta :: 61 | 2303X Ingalls St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6015640.8979 | 2091772.6846 | 37.7244879141293 | -122.388066797622 | (37.7244879141293, -122.388066797622) | 10 | 3 | 8 | 58 | 1 | ||
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 | |||
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 | ||
26936 | 10692 | DPW Maintained 1 | Tristania conferta :: 61 | 1249 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6001880.3859 | 2110463.9678 | 37.7750377503654 | -122.436972474402 | (37.7750377503654, -122.436972474402) | 15 | 5 | 11 | 29492 | 10 | |||
29504 | 138720 | DPW Maintained 1 | Tristania conferta :: 61 | 2921 PINE ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/22/2016 03:10:00 PM | 2 | Width 0ft | 5999959.1608 | 2114707.5789 | 37.7865802293131 | -122.443923351787 | (37.7865802293131, -122.443923351787) | 15 | 6 | 1 | 29490 | 31 | ||
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 | |||
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 | ||
30389 | 29432 | DPW Maintained 1 | Tristania conferta :: 61 | 2401X Ingalls St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2006 12:00:00 AM | 3 | 3X3 | 6015452.0518 | 2091514.7509 | 37.7237692145382 | -122.38870162152 | (37.7237692145382, -122.38870162152) | 10 | 3 | 8 | 58 | 1 | ||
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 | ||
31489 | 8187 | DPW Maintained 1 | Tristania conferta :: 61 | 1255 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001743.6158 | 2111134.8252 | 37.7768719817661 | -122.437493642173 | (37.7768719817661, -122.437493642173) | 15 | 5 | 11 | 29492 | 10 | |||
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 | ||
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 | ||
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 | ||
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 | |||
36114 | 10440 | DPW Maintained 1 | Tristania conferta :: 61 | 1476 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 5999041.0219 | 2108727.6134 | 37.770108370408 | -122.44666945727 | (37.770108370408, -122.44666945727) | 15 | 5 | 11 | 29492 | 9 | |||
36968 | 29526 | DPW Maintained 1 | Tristania conferta :: 61 | 2200X Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2006 12:00:00 AM | 4 | 2X3 | 6015798.6366 | 2092060.1318 | 37.725285925529 | -122.387541555629 | (37.725285925529, -122.387541555629) | 10 | 3 | 8 | 58 | 1 | ||
37992 | 22342 | DPW Maintained 1 | Tristania conferta :: 61 | 5256 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/23/1997 12:00:00 AM | 6 | 3X3 | 6014378.1352 | 2093759.8228 | 37.7298741534257 | -122.392570970493 | (37.7298741534257, -122.392570970493) | 10 | 3 | 8 | 58 | 1 | ||
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 | ||
39184 | 6318 | DPW Maintained 1 | Tristania conferta :: 61 | 1860 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6002006.0106 | 2112955.7484 | 37.7818866924078 | -122.436716317501 | (37.7818866924078, -122.436716317501) | 15 | 5 | 11 | 29490 | 41 | |||
40818 | 22363 | DPW Maintained 1 | Tristania conferta :: 61 | 5307X 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/29/1992 12:00:00 AM | 5 | 3x3 | 6014340.3596 | 2093332.2076 | 37.728697910554 | -122.392671664285 | (37.728697910554, -122.392671664285) | 10 | 3 | 8 | 58 | 1 | ||
40994 | 7057 | DPW Maintained 1 | Tristania conferta :: 61 | 1390 Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/13/1990 12:00:00 AM | 12 | 3X3 | 6000831.7617 | 2110022.9142 | 37.7737670706815 | -122.440568243599 | (37.7737670706815, -122.440568243599) | 15 | 5 | 11 | 29492 | 10 | ||
41127 | 22494 | DPW Maintained 1 | Tristania conferta :: 61 | 6315 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6013237.8961 | 2090421.2401 | 37.7206436914379 | -122.396279035367 | (37.7206436914379, -122.396279035367) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
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 | ||
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 | ||
44590 | 22496 | DPW Maintained 1 | Tristania conferta :: 61 | 6321 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/03/2011 12:00:00 AM | 3 | 3x3 | 6013227.4986 | 2090389.3545 | 37.7205555613998 | -122.396312742847 | (37.7205555613998, -122.396312742847) | 10 | 3 | 8 | 58 | 1 | ||
44853 | 22403 | DPW Maintained 1 | Tristania conferta :: 61 | 5800 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/13/1995 12:00:00 AM | 4 | 3X3 | 6013795.569 | 2092117.5258 | 37.7253323678743 | -122.394470034522 | (37.7253323678743, -122.394470034522) | 10 | 3 | 8 | 58 | 1 | ||
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 | ||
45358 | 18082 | DPW Maintained 1 | Tristania conferta :: 61 | 2970 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/17/2009 12:00:00 AM | 6 | 3X3 | 5999722.7619 | 2114728.5921 | 37.7866244385926 | -122.444742742308 | (37.7866244385926, -122.444742742308) | 15 | 6 | 1 | 29490 | 31 | ||
47191 | 7102 | DPW Maintained 1 | Tristania conferta :: 61 | 2080 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4X4 | 5997497.5881 | 2109552.6978 | 37.7722855537803 | -122.45206768793 | (37.7722855537803, -122.45206768793) | 15 | 5 | 11 | 29492 | 16 | |||
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 | ||
48504 | 200920 | DPW Maintained 1 | Tristania conferta :: 61 | 4018 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6015570.2699 | 2097736.9572 | 37.7408606933275 | -122.388727116112 | (37.7408606933275, -122.388727116112) | 10 | 3 | 8 | 58 | 1 | |||
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 | ||
50735 | 22330 | DPW Maintained 1 | Tristania conferta :: 61 | 5165 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/1995 12:00:00 AM | 6 | 3X3 | 6014601.3387 | 2094219.1443 | 37.731147750666 | -122.391831428581 | (37.731147750666, -122.391831428581) | 10 | 3 | 8 | 58 | 1 | ||
52298 | 10365 | DPW Maintained 1 | Tristania conferta :: 61 | 1158 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/01/2001 12:00:00 AM | 20 | 3X3 | 6000552.7964 | 2108940.2901 | 37.7707785679811 | -122.441455524572 | (37.7707785679811, -122.441455524572) | 15 | 5 | 11 | 29492 | 9 | ||
52446 | 6185 | DPW Maintained 1 | Tristania conferta :: 61 | 1100 Ellis St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005465.536 | 2113438.1352 | 37.783407206982 | -122.424782278636 | (37.783407206982, -122.424782278636) | 7 | 9 | 11 | 28858 | 41 | |||
53231 | 14801 | DPW Maintained 1 | Tristania conferta :: 61 | 1140 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/30/1994 12:00:00 AM | 12 | 4X4 | 6003706.6875 | 2111805.6833 | 37.7788254036612 | -122.430750669342 | (37.7788254036612, -122.430750669342) | 15 | 9 | 11 | 29490 | 41 | ||
54144 | 17684 | DPW Maintained 1 | Tristania conferta :: 61 | 1090 Pierce St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6002398.395 | 2112227.2208 | 37.7799086308334 | -122.435306723377 | (37.7799086308334, -122.435306723377) | 15 | 5 | 11 | 29490 | 41 | |||
54167 | 2443 | DPW Maintained 1 | Tristania conferta :: 61 | 1296X Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/22/1990 12:00:00 AM | 12 | 3X3 | 6004305.6638 | 2112931.8799 | 37.7819515776166 | -122.428758879855 | (37.7819515776166, -122.428758879855) | 7 | 9 | 11 | 29490 | 41 | ||
56620 | 12345 | DPW Maintained 1 | Tristania conferta :: 61 | 1200 Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/27/1992 12:00:00 AM | 6 | 4X4 | 6004709.3369 | 2113084.1368 | 37.782392475782 | -122.427373205801 | (37.782392475782, -122.427373205801) | 7 | 9 | 11 | 28858 | 41 | ||
57279 | 12346 | DPW Maintained 1 | Tristania conferta :: 61 | 1200X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 13 | 6004717.664 | 2113030.0107 | 37.7822443298756 | -122.427340540761 | (37.7822443298756, -122.427340540761) | 7 | 9 | 11 | 28858 | 41 | ||||
59468 | 6936 | DPW Maintained 1 | Tristania conferta :: 61 | 528 Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/22/2008 12:00:00 AM | 3 | 3X3 | 6004857.7315 | 2110586.3971 | 37.775542688283 | -122.426681902022 | (37.775542688283, -122.426681902022) | 7 | 9 | 11 | 28852 | 10 | ||
59643 | 6906 | DPW Maintained 1 | Tristania conferta :: 61 | 333 Fell St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/19/2017 09:59:00 AM | 3 | 3X3 | 6005816.7808 | 2110662.8487 | 37.7758067801978 | -122.423369750882 | (37.7758067801978, -122.423369750882) | 7 | 9 | 11 | 28852 | 10 | ||
60466 | 6970 | DPW Maintained 1 | Tristania conferta :: 61 | 735 Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/24/1995 12:00:00 AM | 12 | 3X3 | 6003863.6109 | 2110389.5025 | 37.7749458101955 | -122.430106755206 | (37.7749458101955, -122.430106755206) | 7 | 9 | 11 | 29492 | 10 | ||
62524 | 10700 | DPW Maintained 1 | Tristania conferta :: 61 | 1290 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6001738.9392 | 2110489.0192 | 37.7750984946528 | -122.437463562764 | (37.7750984946528, -122.437463562764) | 15 | 5 | 11 | 29492 | 10 | |||
62655 | 9589 | DPW Maintained 1 | Tristania conferta :: 61 | 1320 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/11/1997 12:00:00 AM | 6 | 3X3 | 6003248.1509 | 2112093.2525 | 37.7795890076566 | -122.432357471075 | (37.7795890076566, -122.432357471075) | 15 | 9 | 11 | 29490 | 41 | ||
63691 | 17683 | DPW Maintained 1 | Tristania conferta :: 61 | 1090 Pierce St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6002401.1721 | 2112213.0575 | 37.7798698996827 | -122.435296102784 | (37.7798698996827, -122.435296102784) | 15 | 5 | 11 | 29490 | 41 | |||
63696 | 200519 | DPW Maintained 1 | Tristania conferta :: 61 | 1400x La Salle Ave | 62 | Median : Cutout | Tree | DPW 1 | 1 | Width 0ft | 6016469.2023 | 2095054.3401 | 37.7335445478075 | -122.385432015834 | (37.7335445478075, -122.385432015834) | 10 | 3 | 8 | 58 | 1 | |||
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 | ||
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 | |||
64567 | 16871 | DPW Maintained 1 | Tristania conferta :: 61 | 254 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/07/1995 12:00:00 AM | 18 | 3X3 | 6005762.2091 | 2110361.0964 | 37.7749751613383 | -122.423537070496 | (37.7749751613383, -122.423537070496) | 7 | 9 | 11 | 28852 | 10 | ||
64593 | 10488 | DPW Maintained 1 | Tristania conferta :: 61 | 1679 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5998021.2087 | 2108536.3669 | 37.7695249491594 | -122.450183175684 | (37.7695249491594, -122.450183175684) | 15 | 5 | 11 | 29492 | 9 | |||
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 | ||
65091 | 22405 | DPW Maintained 1 | Tristania conferta :: 61 | 5800 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/03/1992 12:00:00 AM | 5 | 3X3 | 6013773.1583 | 2092062.8244 | 37.7251809229772 | -122.394543678104 | (37.7251809229772, -122.394543678104) | 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) );