Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qCaretaker, PlantDate, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2701 | 2701 | 141995 | DPW Maintained 3 | Tristania conferta :: 79 | 818 WEBSTER ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/21/1999 12:00:00 AM | 5 | Width 0ft | 6003983.7554 | 2111636.8614 | 37.778377554053 | -122.42978013780301 | (37.778377554053, -122.429780137803) | ||
| 2795 | 2795 | 6186 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005445.8524 | 2113436.2606 | 37.783400948036 | -122.42485024282301 | (37.783400948036, -122.424850242823) | |||
| 3047 | 3047 | 246310 | DPW Maintained 3 | Tristania conferta :: 79 | 1601 Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/06/2012 10:05:00 AM | 2 | Width 0ft | 6007075.5388 | 2109348.1328 | 37.7722678469563 | -122.41892211112301 | (37.7722678469563, -122.418922111123) | ||
| 4812 | 4812 | 24261 | DPW Maintained 3 | Tristania conferta :: 79 | 600X Willow St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/19/2004 12:00:00 AM | 5 | 3X3 | 6004538.0187 | 2113122.6754 | 37.7824886025731 | -122.427968638693 | (37.7824886025731, -122.427968638693) | ||
| 5315 | 5315 | 18239 | Permitted Site 1 | Tristania conferta :: 79 | 1790X Post St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2000 12:00:00 AM | 3 | 4X4 | 6003687.2504 | 2114237.8837 | 37.7855025167716 | -122.43099154386499 | (37.7855025167716, -122.430991543865) | ||
| 5607 | 5607 | 6200 | DPW Maintained 3 | Tristania conferta :: 79 | 1135 Ellis St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005257.1287 | 2113359.2082 | 37.783178719822295 | -122.42549766781099 | (37.7831787198223, -122.425497667811) | |||
| 6017 | 6017 | 29686 | Permitted Site 1 | Tristania conferta :: 79 | 1880 Lombard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003340.0203 | 2119674.0794 | 37.800409236193296 | -122.432581299288 | (37.8004092361933, -122.432581299288) | |||
| 6706 | 6706 | 21600 | Permitted Site 1 | Tristania conferta :: 79 | 1515 Sutter St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6005281.4713 | 2114753.9781 | 37.7870097872628 | -122.42551274764999 | (37.7870097872628, -122.42551274765) | |||
| 7414 | 7414 | 14484 | DPW Maintained 3 | Tristania conferta :: 79 | 281 Masonic Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 5998949.0465 | 2111993.9536 | 37.7790716497834 | -122.447222712917 | (37.7790716497834, -122.447222712917) | |||
| 8907 | 8907 | 17685 | DPW Maintained 3 | Tristania conferta :: 79 | 1090 Pierce St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002392.8724 | 2112252.5847 | 37.779977960097 | -122.43532764329201 | (37.779977960097, -122.435327643292) | |||
| 13552 | 13552 | 29439 | DPW Maintained 3 | Tristania conferta :: 79 | 2303X Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6015640.8979 | 2091772.6846 | 37.7244879141293 | -122.38806679762199 | (37.7244879141293, -122.388066797622) | ||
| 14365 | 14365 | 29425 | DPW Maintained 3 | Tristania conferta :: 79 | 2501X Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 6 | 3x3 | 6015328.4861 | 2091346.7788 | 37.7233011472419 | -122.389117048339 | (37.7233011472419, -122.389117048339) | ||
| 14809 | 14809 | 22396 | Permitted Site 1 | Tristania conferta :: 79 | 5700 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/1995 12:00:00 AM | 6 | 3X3 | 6013879.4285 | 2092330.5481 | 37.725921945734704 | -122.394195045111 | (37.7259219457347, -122.394195045111) | ||
| 15158 | 15158 | 29434 | DPW Maintained 3 | Tristania conferta :: 79 | 2401X Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 5 | 3X3 | 6015482.9432 | 2091559.1573 | 37.723892857778104 | -122.38859793246701 | (37.7238928577781, -122.388597932467) | ||
| 15366 | 15366 | 22406 | DPW Maintained 3 | Tristania conferta :: 79 | 5800 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/29/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53653 | 6013782.5564 | 2092078.9697 | 37.7252257771905 | -122.394512319608 | (37.7252257771905, -122.394512319608) | |
| 15503 | 15503 | 29385 | Permitted Site 1 | Tristania conferta :: 79 | 3199X Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 4 | 3x3 | 6014260.3439 | 2089918.7195 | 37.7193207101956 | -122.39270958943999 | (37.7193207101956, -122.39270958944) | ||
| 15886 | 15886 | 30095 | Permitted Site 1 | Tristania conferta :: 79 | 6190X 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6013424.226 | 2091142.2984 | 37.7226339394685 | -122.395685442076 | (37.7226339394685, -122.395685442076) | |||
| 17941 | 17941 | 495 | Permitted Site 1 | Tristania conferta :: 79 | 2749X 24th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2010 12:00:00 AM | 3 | 3X3 | 6010480.319 | 2102220.7863 | 37.752888894824295 | -122.406642256485 | (37.7528888948243, -122.406642256485) | ||
| 18047 | 18047 | 9657 | DPW Maintained 3 | Tristania conferta :: 79 | 95 Gough St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/07/1995 12:00:00 AM | 18 | 3X3 | 6006069.5259 | 2109884.9457 | 37.7736851076601 | -122.422440154098 | (37.7736851076601, -122.422440154098) | ||
| 18544 | 18544 | 15286 | DPW Maintained 3 | Tristania conferta :: 79 | 1600 Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/12/1995 12:00:00 AM | 6 | 3x3 | 6007046.1273 | 2109405.5176 | 37.7724237557967 | -122.41902791928499 | (37.7724237557967, -122.419027919285) | ||
| 27596 | 27596 | 139676 | Undocumented 2 | Tristania conferta :: 79 | 2130 O'Farrell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6000922.1046 | 2113153.0063 | 37.782366653551605 | -122.44048027276199 | (37.7823666535516, -122.440480272762) | |||
| 27756 | 27756 | 199895 | Undocumented 2 | Tristania conferta :: 79 | 1700 Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6016530.9767 | 2093031.4421 | 37.7279934886935 | -122.38507754718599 | (37.7279934886935, -122.385077547186) | |||
| 28829 | 28829 | 200962 | Undocumented 2 | Tristania conferta :: 79 | 5600 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6013974.3728 | 2092581.6444 | 37.726616682460204 | -122.393884395326 | (37.7266166824602, -122.393884395326) | |||
| 37899 | 37899 | 138525 | Undocumented 2 | Tristania conferta :: 79 | 1608 Scott St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6001648.301 | 2114083.6756 | 37.78496335768929 | -122.438034643925 | (37.7849633576893, -122.438034643925) | |||
| 39705 | 39705 | 137779 | Undocumented 2 | Tristania conferta :: 79 | 1773 Golden Gate Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6001099.2377 | 2111735.524 | 37.7784846924631 | -122.439765813586 | (37.7784846924631, -122.439765813586) | |||
| 41255 | 41255 | 139805 | Undocumented 2 | Tristania conferta :: 79 | 1101 GOUGH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6005648.2172 | 2112955.0668 | 37.7820911362793 | -122.42411590723101 | (37.7820911362793, -122.424115907231) | |||
| 41688 | 41688 | 143431 | Undocumented 2 | Tristania conferta :: 79 | 855 SACRAMENTO ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6010731.6396 | 2116914.7262 | 37.7932491208157 | -122.40680863713301 | (37.7932491208157, -122.406808637133) | |||
| 41717 | 41717 | 200922 | Undocumented 2 | Tristania conferta :: 79 | 4049 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6015633.332 | 2097648.3868 | 37.7406209920403 | -122.38850288821699 | (37.7406209920403, -122.388502888217) | |||
| 41736 | 41736 | 139931 | Undocumented 2 | Tristania conferta :: 79 | 800 GOUGH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6005701.5757 | 2112576.2725 | 37.7810540726267 | -122.423904366871 | (37.7810540726267, -122.423904366871) | |||
| 46505 | 46505 | 45601 | Permitted Site 1 | Tristania conferta :: 79 | 1100 Fillmore St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/2001 12:00:00 AM | 10 | Permit Number 44335 | 6003419.3416 | 2112114.1133 | 37.7796559917005 | -122.431766739067 | (37.7796559917005, -122.431766739067) | ||
| 49161 | 49161 | 199705 | Undocumented 2 | Tristania conferta :: 79 | 1920 Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6016247.6698 | 2092666.3541 | 37.7269753536387 | -122.38603151707 | (37.7269753536387, -122.38603151707) | |||
| 49649 | 49649 | 121011 | Undocumented 2 | Tristania conferta :: 79 | 199X Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 4x4 | 6015164.1782 | 2115507.7051 | 37.7896327822139 | -122.391373228803 | (37.7896327822139, -122.391373228803) | |||
| 51533 | 51533 | 200668 | Undocumented 2 | Tristania conferta :: 79 | 1591 Newcomb Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6015323.7716 | 2095585.3447 | 37.734939139911205 | -122.389429202238 | (37.7349391399112, -122.389429202238) | |||
| 59186 | 59186 | 95599 | Undocumented 2 | Tristania conferta :: 79 | 1625 Carroll Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6014002.7059 | 2092031.5945 | 37.72510793068879 | -122.39374796448999 | (37.7251079306888, -122.39374796449) | |||
| 61180 | 61180 | 199761 | Undocumented 2 | Tristania conferta :: 79 | 2008 Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6016088.8319 | 2092453.3793 | 37.7263817748652 | -122.386565777701 | (37.7263817748652, -122.386565777701) | |||
| 63524 | 63524 | 200517 | Undocumented 2 | Tristania conferta :: 79 | 5701 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6013955.7587 | 2092307.9135 | 37.725864038087 | -122.393929591022 | (37.725864038087, -122.393929591022) | |||
| 64299 | 64299 | 200663 | Undocumented 2 | Tristania conferta :: 79 | 1535 Oakdale Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6015121.5143 | 2095453.4378 | 37.7345657344021 | -122.390119270723 | (37.7345657344021, -122.390119270723) | |||
| 66464 | 66464 | 200893 | Undocumented 2 | Tristania conferta :: 79 | 825 Newhall St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6015466.1111 | 2097093.8178 | 37.7390889909368 | -122.389042368279 | (37.7390889909368, -122.389042368279) | |||
| 69788 | 69788 | 245428 | Undocumented 2 | Tristania conferta :: 79 | 2500 16th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6008979.9860000005 | 2106872.7578 | 37.7655780948672 | -122.412159456951 | (37.7655780948672, -122.412159456951) | |||
| 76987 | 76987 | 95308 | Permitted Site 1 | Tristania conferta :: 79 | 5411 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6014271.0268 | 2093133.3664 | 37.728148081857206 | -122.39289744809601 | (37.7281480818572, -122.392897448096) | |||
| 102667 | 102667 | 98999 | DPW Maintained 3 | Tristania conferta :: 79 | 2190X North Point St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 01/20/2015 12:00:00 AM | 3 | 3x3 | Permit Number 771149 | 6000277.5 | 2120626.8 | 37.8028510037355 | -122.443247276641 | (37.8028510037355, -122.443247276641) | |
| 123425 | 123425 | 200225 | Undocumented 2 | Tristania conferta :: 79 | 3098 Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6014353.5321 | 2090113.0139 | 37.7198593794464 | -122.392401052747 | (37.7198593794464, -122.392401052747) | |||
| 131386 | 131386 | 140649 | Undocumented 2 | Tristania conferta :: 79 | 109 Shrader St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5997299.8022 | 2110011.7822 | 37.7735347493893 | -122.452784984309 | (37.7735347493893, -122.452784984309) | |||
| 134953 | 134953 | 200990 | Undocumented 2 | Tristania conferta :: 79 | 75 Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6015409.9294 | 2115740.0891 | 37.7902844914695 | -122.390539192334 | (37.7902844914695, -122.390539192334) | |||
| 146658 | 146658 | 138201 | Undocumented 2 | Tristania conferta :: 79 | 100 MASONIC AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 5998933.3099 | 2112544.5659 | 37.7805825894916 | -122.447316792413 | (37.7805825894916, -122.447316792413) | |||
| 147363 | 147363 | 141356 | Undocumented 2 | Tristania conferta :: 79 | 501 SCOTT ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6002142.6655 | 2110223.8735 | 37.7743934152992 | -122.436048009263 | (37.7743934152992, -122.436048009263) | |||
| 153665 | 153665 | 140099 | Undocumented 2 | Tristania conferta :: 79 | 515 GOUGH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6005844.3812 | 2111525.5128 | 37.7781770040399 | -122.423335612643 | (37.7781770040399, -122.423335612643) | |||
| 155198 | 155198 | 200912 | Undocumented 2 | Tristania conferta :: 79 | 3801 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6015724.2643 | 2097951.4157 | 37.7414580860536 | -122.38820961947901 | (37.7414580860536, -122.388209619479) | |||
| 158654 | 158654 | 245992 | Undocumented 2 | Tristania conferta :: 79 | 1250 Waller St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5999690.8568 | 2108469.5931 | 37.7694370106113 | -122.444403147816 | (37.7694370106113, -122.444403147816) | |||
| 164606 | 164606 | 138235 | Undocumented 2 | Tristania conferta :: 79 | 230 Masonic Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5998964.7831 | 2112316.4696 | 37.779958094491604 | -122.447191491368 | (37.7799580944916, -122.447191491368) | |||
| 170871 | 170871 | 140351 | Undocumented 2 | Tristania conferta :: 79 | 1314 ELLIS ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004431.2052 | 2113294.3783 | 37.782954012602296 | -122.42835040863899 | (37.7829540126023, -122.428350408639) | |||
| 171512 | 171512 | 47581 | Permitted Site 1 | Tristania conferta :: 79 | 301 Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/2002 12:00:00 AM | 10 | Permit Number 45427 | 6014732.3141 | 2115093.3212 | 37.7884710015858 | -122.39283844369801 | (37.7884710015858, -122.392838443698) | ||
| 171968 | 171968 | 93015 | Permitted Site 1 | Tristania conferta :: 79 | 2395 Lombard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 01/08/2010 12:00:00 AM | 3 | 4x4 | Permit Number 53139; 3-year maintenance agreement through 12/29/12 | 6001036.8533 | 2119267.6007 | 37.7991622735558 | -122.440521987709 | (37.7991622735558, -122.440521987709) |
| 173133 | 173133 | 199799 | Undocumented 2 | Tristania conferta :: 79 | 2655 Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6015139.2762 | 2091096.4296 | 37.72260324722 | -122.389753639026 | (37.72260324722, -122.389753639026) | |||
| 175069 | 175069 | 138409 | Undocumented 2 | Tristania conferta :: 79 | 2445 PINE ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6002113.6961 | 2115006.6113 | 37.7875239591061 | -122.436490609497 | (37.7875239591061, -122.436490609497) | |||
| 175607 | 175607 | 141094 | Undocumented 2 | Tristania conferta :: 79 | 188 Jordan Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5996267.5613 | 2113016.8335 | 37.7817266254142 | -122.456572992218 | (37.7817266254142, -122.456572992218) | |||
| 177241 | 177241 | 138755 | Undocumented 2 | Tristania conferta :: 79 | 2343 Sutter St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6001410.063999999 | 2114215.486 | 37.7853117240421 | -122.43886831502701 | (37.7853117240421, -122.438868315027) | |||
| 178361 | 178361 | 248530 | Undocumented 2 | Tristania conferta :: 79 | 35 Beulah St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5997722.0136 | 2107803.8234 | 37.7674964457612 | -122.45116523916799 | (37.7674964457612, -122.451165239168) | |||
| 182541 | 182541 | 246101 | Undocumented 2 | Tristania conferta :: 79 | 1764 Waller St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5997168.442000001 | 2108117.5543 | 37.7683261602514 | -122.45310260948 | (37.7683261602514, -122.45310260948) | |||
| 183089 | 183089 | 142795 | Undocumented 2 | Tristania conferta :: 79 | 535 Larkin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6007556.7713 | 2113214.153 | 37.78291009800979 | -122.41753152702101 | (37.7829100980098, -122.417531527021) | |||
| 183512 | 183512 | 140502 | Undocumented 2 | Tristania conferta :: 79 | 951 Webster St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6003839.6233 | 2111973.5622 | 37.7792938881307 | -122.430302772663 | (37.7792938881307, -122.430302772663) | |||
| 183708 | 183708 | 200930 | Undocumented 2 | Tristania conferta :: 79 | 4101 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6015555.39 | 2097392.3592 | 37.7399136731123 | -122.388754515291 | (37.7399136731123, -122.388754515291) | |||
| 185983 | 185983 | 137841 | Undocumented 2 | Tristania conferta :: 79 | 1800X Pine St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005085.0 | 2115443.0 | 37.7888905662133 | -122.42624156812799 | (37.7888905662133, -122.426241568128) | |||
| 186876 | 186876 | 47069 | Permitted Site 1 | Tristania conferta :: 79 | 606 Webster St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2002 12:00:00 AM | 5 | Permit Number 45052 | 6004039.0188 | 2110889.0487 | 37.7763273741764 | -122.429535615559 | (37.7763273741764, -122.429535615559) | ||
| 188026 | 188026 | 142069 | Undocumented 2 | Tristania conferta :: 79 | 1000 WEBSTER ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6003891.204 | 2112315.3287 | 37.780235215595106 | -122.43014872170099 | (37.7802352155951, -122.430148721701) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");