Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▲ | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 32382 | 32382 | 200015 | Undocumented 2 | Tristania conferta :: 79 | 1021 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6018293.9123 | 2092319.9509 | 37.7261372321338 | -122.37893357191099 | (37.7261372321338, -122.378933571911) | |||
| 63410 | 63410 | 200019 | Undocumented 2 | Tristania conferta :: 79 | 1012 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6018229.2689 | 2092102.4532 | 37.7255364609642 | -122.37914194332399 | (37.7255364609642, -122.379141943324) | |||
| 58102 | 58102 | 199983 | Undocumented 2 | Tristania conferta :: 79 | 1065 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6018148.6647 | 2092424.0259999998 | 37.7264149928709 | -122.379442916331 | (37.7264149928709, -122.379442916331) | |||
| 157504 | 157504 | 199987 | Undocumented 2 | Tristania conferta :: 79 | 1040 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6018098.5001 | 2092201.6353 | 37.7258015841871 | -122.379600891938 | (37.7258015841871, -122.379600891938) | |||
| 69255 | 69255 | 199988 | Undocumented 2 | Tristania conferta :: 79 | 1048 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6018073.2308 | 2092225.0095 | 37.7258643714622 | -122.37968987018299 | (37.7258643714622, -122.379689870183) | |||
| 183360 | 183360 | 81614 | Undocumented 2 | Tristania conferta :: 79 | 1450@ Shafter Hawes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/14/2004 12:00:00 AM | 13 | 6017097.2029 | 2092677.3305 | 37.7270524726432 | -122.38309543137501 | (37.7270524726432, -122.383095431375) | ||
| 39279 | 39279 | 102731 | Undocumented 2 | Tristania conferta :: 79 | 1450 Hawes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6017062.4575 | 2092631.8457 | 37.7269256602576 | -122.383212382288 | (37.7269256602576, -122.383212382288) | |||
| 182827 | 182827 | 199877 | Undocumented 2 | Tristania conferta :: 79 | 1501 Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6017008.6079 | 2093600.4201 | 37.7295821995791 | -122.383465938576 | (37.7295821995791, -122.383465938576) | |||
| 162679 | 162679 | 199876 | Undocumented 2 | Tristania conferta :: 79 | 1501 Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6016991.57 | 2093575.1379 | 37.7295118379571 | -122.38352308156601 | (37.7295118379571, -122.383523081566) | |||
| 13604 | 13604 | 28836 | Permitted Site 1 | Tristania conferta :: 79 | 1501 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2005 12:00:00 AM | 12 | 4x4 | 6016976.7304 | 2093554.8023 | 37.729455180200794 | -122.383572968876 | (37.7294551802008, -122.383572968876) | ||
| 14144 | 14144 | 28832 | Permitted Site 1 | Tristania conferta :: 79 | 1500 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2005 12:00:00 AM | 12 | 4x4 | 6016972.3335 | 2093632.2976 | 37.7296677240114 | -122.383593562534 | (37.7296677240114, -122.383593562534) | ||
| 15437 | 15437 | 28833 | Permitted Site 1 | Tristania conferta :: 79 | 1500 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2005 12:00:00 AM | 12 | 4x4 | 6016963.5397 | 2093616.3588 | 37.729623473146894 | -122.383622854715 | (37.7296234731469, -122.383622854715) | ||
| 14603 | 14603 | 28837 | DPW Maintained 3 | Tristania conferta :: 79 | 1527 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/12/2005 12:00:00 AM | 6 | 4x4 | 6016961.8909 | 2093534.4666 | 37.7293985221539 | -122.38362285575701 | (37.7293985221539, -122.383622855757) | ||
| 16422 | 16422 | 28834 | Permitted Site 1 | Tristania conferta :: 79 | 1500 Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2005 12:00:00 AM | 16 | 4x4 | 6016954.1963 | 2093605.3666 | 37.7295927742855 | -122.38365439115499 | (37.7295927742855, -122.383654391155) | ||
| 69324 | 69324 | 199879 | Undocumented 2 | Tristania conferta :: 79 | 1527 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6016949.7994 | 2093519.0775 | 37.7293555983699 | -122.383663586634 | (37.7293555983699, -122.383663586634) | |||
| 14785 | 14785 | 29469 | Permitted Site 1 | Tristania conferta :: 79 | 1609 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 8 | 3X3 | 6016821.7398 | 2093350.8961 | 37.7288867261126 | -122.38409459771098 | (37.7288867261126, -122.384094597711) | ||
| 14713 | 14713 | 29485 | Permitted Site 1 | Tristania conferta :: 79 | 1608 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 12 | 3x3 | 6016787.6638 | 2093383.8729 | 37.7289753898862 | -122.38421469762 | (37.7289753898862, -122.38421469762) | ||
| 13938 | 13938 | 29486 | Permitted Site 1 | Tristania conferta :: 79 | 1616 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 12 | 3x3 | 6016775.5724 | 2093362.9876 | 37.7289173744178 | -122.384255044958 | (37.7289173744178, -122.384255044958) | ||
| 29369 | 29369 | 199905 | Undocumented 2 | Tristania conferta :: 79 | 1298 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6016747.5421 | 2093255.8132 | 37.7286215447387 | -122.38434448732599 | (37.7286215447387, -122.384344487326) | |||
| 42346 | 42346 | 199883 | Undocumented 2 | Tristania conferta :: 79 | 1624 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6016743.6948 | 2093323.4155 | 37.7288069546046 | -122.384362494194 | (37.7288069546046, -122.384362494194) | |||
| 157972 | 157972 | 199884 | Undocumented 2 | Tristania conferta :: 79 | 1624 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6016731.0538 | 2093302.5302 | 37.728748908693106 | -122.38440474134701 | (37.7287489086931, -122.384404741347) | |||
| 184769 | 184769 | 199885 | Undocumented 2 | Tristania conferta :: 79 | 1624 Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6016716.7638 | 2093277.2481 | 37.728678698833605 | -122.384452383066 | (37.7286786988336, -122.384452383066) | |||
| 64786 | 64786 | 199889 | Undocumented 2 | Tristania conferta :: 79 | 1725 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6016642.7991 | 2093116.8237 | 37.7282341146901 | -122.384696915405 | (37.7282341146901, -122.384696915405) | |||
| 16769 | 16769 | 29493 | Permitted Site 1 | Tristania conferta :: 79 | 1700X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 12 | 3X3 | 6016630.1295 | 2093166.4001 | 37.728369541019894 | -122.384744167276 | (37.7283695410199, -122.384744167276) | ||
| 13996 | 13996 | 29494 | DPW Maintained 3 | Tristania conferta :: 79 | 1700X Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 12 | 3X3 | 6016622.9685 | 2093155.9340000001 | 37.7283404071211 | -122.384768194628 | (37.7283404071211, -122.384768194628) | ||
| 14449 | 14449 | 29495 | Permitted Site 1 | Tristania conferta :: 79 | 1700X Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 12 | 3X3 | 6016616.3583 | 2093144.917 | 37.7283097910179 | -122.384790279442 | (37.7283097910179, -122.384790279442) | ||
| 180080 | 180080 | 199911 | Undocumented 2 | Tristania conferta :: 79 | 1733 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6016596.5278 | 2093055.1286 | 37.7280621529643 | -122.384852582425 | (37.7280621529643, -122.384852582425) | |||
| 159236 | 159236 | 199910 | Undocumented 2 | Tristania conferta :: 79 | 1733 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6016580.0023 | 2093030.3404 | 37.7279931754204 | -122.384907985938 | (37.7279931754204, -122.384907985938) | |||
| 176088 | 176088 | 199891 | Undocumented 2 | Tristania conferta :: 79 | 1700 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6016576.6972 | 2093089.2812 | 37.72815483243671 | -122.384923516456 | (37.7281548324367, -122.384923516456) | |||
| 164112 | 164112 | 199892 | Undocumented 2 | Tristania conferta :: 79 | 1700 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6016564.5785 | 2093072.2049 | 37.728107273971204 | -122.38496422243401 | (37.7281072739712, -122.384964222434) | |||
| 159673 | 159673 | 199893 | Undocumented 2 | Tristania conferta :: 79 | 1700 Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6016554.6632 | 2093059.5354 | 37.7280719375741 | -122.38499761796301 | (37.7280719375741, -122.384997617963) | |||
| 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) | |||
| 3074 | 3074 | 199930 | Permitted Site 1 | Tristania conferta :: 79 | 1801 Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 02/28/2006 12:00:00 AM | 6 | Width 0ft | 6016497.9258 | 2092921.8231 | 37.727690668221506 | -122.385184171361 | (37.7276906682215, -122.385184171361) | ||
| 3105 | 3105 | 199929 | Permitted Site 1 | Tristania conferta :: 79 | 1801 Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 02/28/2006 12:00:00 AM | 6 | Width 0ft | 6016487.4596 | 2092903.0942 | 37.727638663365 | -122.385219049049 | (37.727638663365, -122.385219049049) | ||
| 182627 | 182627 | 200520 | DPW Maintained 3 | Tristania conferta :: 79 | 1400x La Salle Ave | 63 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 0ft | 6016476.5475 | 2095041.1188 | 37.7335086511389 | -122.38540570010599 | (37.7335086511389, -122.385405700106) | |||
| 3081 | 3081 | 199928 | Permitted Site 1 | Tristania conferta :: 79 | 1801 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 02/27/2008 12:00:00 AM | 4 | Width 0ft | 6016476.4427 | 2092884.9162 | 37.727588140695204 | -122.385255868852 | (37.7275881406952, -122.385255868852) | ||
| 58587 | 58587 | 200519 | DPW Maintained 3 | Tristania conferta :: 79 | 1400x La Salle Ave | 62 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 6016469.2023 | 2095054.3401 | 37.7335445478075 | -122.38543201583401 | (37.7335445478075, -122.385432015834) | |||
| 3082 | 3082 | 199927 | Permitted Site 1 | Tristania conferta :: 79 | 1801 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 02/28/2006 12:00:00 AM | 5 | Width 0ft | 6016464.324 | 2092869.4925 | 37.7275451198245 | -122.385296689415 | (37.7275451198245, -122.385296689415) | ||
| 16413 | 16413 | 29503 | Permitted Site 1 | Tristania conferta :: 79 | 1800X Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 12 | 3x3 | 6016452.7561 | 2092931.7384 | 37.727715394829296 | -122.38534101579599 | (37.7277153948293, -122.385341015796) | ||
| 16346 | 16346 | 29504 | Permitted Site 1 | Tristania conferta :: 79 | 1800X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 12 | 3x3 | 6016442.8409 | 2092919.0689 | 37.7276800583286 | -122.38537441062401 | (37.7276800583286, -122.385374410624) | ||
| 63527 | 63527 | 199953 | Undocumented 2 | Tristania conferta :: 79 | 1899 Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6016430.7222 | 2092829.8313 | 37.7274343589932 | -122.38541008953501 | (37.7274343589932, -122.385410089535) | |||
| 161971 | 161971 | 199952 | Undocumented 2 | Tristania conferta :: 79 | 1899 Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6016420.8069 | 2092814.4075 | 37.727391459700605 | -122.38544329269101 | (37.7273914597006, -122.385443292691) | |||
| 26798 | 26798 | 199951 | Undocumented 2 | Tristania conferta :: 79 | 1899 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6016408.6882 | 2092795.6787 | 37.7273393636102 | -122.38548388280701 | (37.7273393636102, -122.385483882807) | |||
| 149174 | 149174 | 199950 | Undocumented 2 | Tristania conferta :: 79 | 1899 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6016400.4255 | 2092782.4583 | 37.7273026058349 | -122.385511526281 | (37.7273026058349, -122.385511526281) | |||
| 32620 | 32620 | 199933 | Undocumented 2 | Tristania conferta :: 79 | 1898 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6016396.5695 | 2092856.2721 | 37.7275050706356 | -122.385529998516 | (37.7275050706356, -122.385529998516) | |||
| 171880 | 171880 | 199710 | Undocumented 2 | Tristania conferta :: 79 | 1925 Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6016332.671 | 2092691.0173 | 37.7270477778667 | -122.38573938498999 | (37.7270477778667, -122.38573938499) | |||
| 169048 | 169048 | 199709 | Undocumented 2 | Tristania conferta :: 79 | 1925 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6016317.7981 | 2092670.0851 | 37.7269894791605 | -122.385789342511 | (37.7269894791605, -122.385789342511) | |||
| 134758 | 134758 | 199701 | Undocumented 2 | Tristania conferta :: 79 | 1920 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6016301.5318 | 2092737.8037 | 37.7271745209486 | -122.385850293459 | (37.7271745209486, -122.385850293459) | |||
| 55488 | 55488 | 199708 | Undocumented 2 | Tristania conferta :: 79 | 1925 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6016296.8658 | 2092642.5426 | 37.7269126945323 | -122.385859786812 | (37.7269126945323, -122.385859786812) | |||
| 178611 | 178611 | 199702 | Undocumented 2 | Tristania conferta :: 79 | 1920 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6016277.3489 | 2092699.8804 | 37.7270690527648 | -122.385931251973 | (37.7270690527648, -122.385931251973) | |||
| 179935 | 179935 | 199720 | Undocumented 2 | Tristania conferta :: 79 | 1995 Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6016277.0353 | 2092618.8561 | 37.72684655865179 | -122.385926690704 | (37.7268465586518, -122.385926690704) | |||
| 57175 | 57175 | 199703 | Undocumented 2 | Tristania conferta :: 79 | 1920 Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6016265.2574 | 2092686.1401 | 37.7270306554464 | -122.385972095124 | (37.7270306554464, -122.385972095124) | |||
| 130500 | 130500 | 199704 | Undocumented 2 | Tristania conferta :: 79 | 1920 Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6016256.4636 | 2092675.6975 | 37.7270014954531 | -122.386001767813 | (37.7270014954531, -122.386001767813) | |||
| 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) | |||
| 168783 | 168783 | 199718 | Undocumented 2 | Tristania conferta :: 79 | 1999 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6016237.3741 | 2092566.5255 | 37.7267006741711 | -122.386060153377 | (37.7267006741711, -122.386060153377) | |||
| 50817 | 50817 | 82772 | Permitted Site 1 | Tristania conferta :: 79 | 1410 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52295 | 6016233.7032 | 2093926.9573 | 37.7304359474549 | -122.38616764377399 | (37.7304359474549, -122.386167643774) | |
| 34259 | 34259 | 199768 | Undocumented 2 | Tristania conferta :: 79 | 2029 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6016150.937999999 | 2092445.1351 | 37.7263625758948 | -122.386350503257 | (37.7263625758948, -122.386350503257) | |||
| 15670 | 15670 | 29518 | DPW Maintained 3 | Tristania conferta :: 79 | 2002X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6016118.5109 | 2092491.8522 | 37.7264890568376 | -122.38646585917401 | (37.7264890568376, -122.386465859174) | ||
| 184347 | 184347 | 199760 | Undocumented 2 | Tristania conferta :: 79 | 2004 Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6016108.6179 | 2092480.3103 | 37.726456817407204 | -122.38649925476001 | (37.7264568174072, -122.38649925476) | |||
| 13919 | 13919 | 29521 | DPW Maintained 3 | Tristania conferta :: 79 | 2006X Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 8 | 3X3 | 6016098.1753 | 2092465.4708 | 37.726415492982795 | -122.386534320443 | (37.7264154929828, -122.386534320443) | ||
| 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) | |||
| 44265 | 44265 | 199765 | Undocumented 2 | Tristania conferta :: 79 | 2010 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6016065.7481 | 2092407.7615 | 37.726255239445 | -122.386642398454 | (37.726255239445, -122.386642398454) | |||
| 169198 | 169198 | 199766 | Undocumented 2 | Tristania conferta :: 79 | 2012 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6016050.9086 | 2092395.1204 | 37.7262197079231 | -122.386692817183 | (37.7262197079231, -122.386692817183) | |||
| 163186 | 163186 | 199767 | Undocumented 2 | Tristania conferta :: 79 | 2014 Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6016040.466 | 2092381.3801 | 37.7261814016259 | -122.386727959266 | (37.7261814016259, -122.386727959266) | |||
| 49512 | 49512 | 200911 | Undocumented 2 | Tristania conferta :: 79 | 3801 03rd St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6015820.1566 | 2098275.9378 | 37.7423544699147 | -122.387900693237 | (37.7423544699147, -122.387900693237) | |||
| 171007 | 171007 | 200910 | Undocumented 2 | Tristania conferta :: 79 | 3801 03rd St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6015813.5433 | 2098253.2638 | 37.74229184539389 | -122.387921978414 | (37.7422918453939, -122.387921978414) | |||
| 46012 | 46012 | 200909 | Undocumented 2 | Tristania conferta :: 79 | 3801 03rd St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6015806.4577 | 2098231.0621 | 37.7422304915422 | -122.38794492958598 | (37.7422304915422, -122.387944929586) | |||
| 49146 | 49146 | 200908 | Undocumented 2 | Tristania conferta :: 79 | 3801 03rd St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6015799.3721 | 2098207.4433 | 37.7421652466195 | -122.387967781856 | (37.7421652466195, -122.387967781856) | |||
| 13531 | 13531 | 29526 | DPW Maintained 3 | Tristania conferta :: 79 | 2200X Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 4 | 2X3 | 6015798.6366 | 2092060.1318 | 37.725285925529 | -122.387541555629 | (37.725285925529, -122.387541555629) | ||
| 171170 | 171170 | 200907 | Undocumented 2 | Tristania conferta :: 79 | 3801 03rd St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6015794.1759 | 2098187.1312 | 37.742109185886505 | -122.387984331771 | (37.7421091858865, -122.387984331771) | |||
| 70495 | 70495 | 199819 | Undocumented 2 | Tristania conferta :: 79 | 2225 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6015792.5909 | 2091976.5907 | 37.7250562032851 | -122.387556629575 | (37.7250562032851, -122.387556629575) | |||
| 153049 | 153049 | 200906 | Undocumented 2 | Tristania conferta :: 79 | 3801 03rd St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6015788.035 | 2098168.2362 | 37.7420569638785 | -122.388004247029 | (37.7420569638785, -122.388004247029) | |||
| 172026 | 172026 | 200905 | Undocumented 2 | Tristania conferta :: 79 | 3801 03rd St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6015782.8389 | 2098148.8688 | 37.74200349709729 | -122.38802086245501 | (37.7420034970973, -122.388020862455) | |||
| 15652 | 15652 | 29527 | DPW Maintained 3 | Tristania conferta :: 79 | 2220 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 3 | 2X3 | 6015766.2095 | 2092015.0636 | 37.7251603810099 | -122.387650511034 | (37.7251603810099, -122.387650511034) | ||
| 14625 | 14625 | 22146 | DPW Maintained 3 | Tristania conferta :: 79 | 3800 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2008 12:00:00 AM | 12 | 3x3 | 6015760.6373 | 2098363.7997 | 37.742592423172 | -122.388112624911 | (37.742592423172, -122.388112624911) | ||
| 71623 | 71623 | 199816 | Undocumented 2 | Tristania conferta :: 79 | 2222 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6015734.8816 | 2091975.4915 | 37.72504998848329 | -122.387756049526 | (37.7250499884833, -122.387756049526) | |||
| 167448 | 167448 | 200913 | Undocumented 2 | Tristania conferta :: 79 | 3801 03rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6015728.5157 | 2097971.7279 | 37.7415140947501 | -122.388196336709 | (37.7415140947501, -122.388196336709) | |||
| 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) | |||
| 34740 | 34740 | 199817 | Undocumented 2 | Tristania conferta :: 79 | 2224 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6015723.8893 | 2091960.1023 | 37.7250071238567 | -122.38779297577899 | (37.7250071238567, -122.387792975779) | |||
| 73571 | 73571 | 199818 | Undocumented 2 | Tristania conferta :: 79 | 2226 Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6015709.0498 | 2091939.7667 | 37.7249504642567 | -122.387842856465 | (37.7249504642567, -122.387842856465) | |||
| 158900 | 158900 | 200918 | Undocumented 2 | Tristania conferta :: 79 | 3801 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6015708.4397 | 2097905.3591 | 37.7413307472539 | -122.388261122371 | (37.7413307472539, -122.388261122371) | |||
| 36884 | 36884 | 200917 | Undocumented 2 | Tristania conferta :: 79 | 3801 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6015704.1884 | 2097889.2984 | 37.741286412301505 | -122.38827470136299 | (37.7412864123015, -122.388274701363) | |||
| 16601 | 16601 | 22174 | Permitted Site 1 | Tristania conferta :: 79 | 3900 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1995 12:00:00 AM | 3 | 3X3 | 6015675.1373 | 2098078.9572 | 37.7418055667015 | -122.388388385005 | (37.7418055667015, -122.388388385005) | ||
| 14553 | 14553 | 29440 | Permitted Site 1 | Tristania conferta :: 79 | 2301X Ingalls St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 3 | 3X3 | 6015660.6839 | 2091799.6156 | 37.7245629575419 | -122.38800027789101 | (37.7245629575419, -122.388000277891) | ||
| 16656 | 16656 | 22177 | Permitted Site 1 | Tristania conferta :: 79 | 3950X 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6015646.3224 | 2097987.7887 | 37.741553639953 | -122.388481656276 | (37.741553639953, -122.388481656276) | |||
| 13702 | 13702 | 22191 | Permitted Site 1 | Tristania conferta :: 79 | 4011 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/2008 12:00:00 AM | 3 | 6015646.0862 | 2097696.0967 | 37.7407527004376 | -122.38846211797701 | (37.7407527004376, -122.388462117977) | |||
| 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) | ||
| 23312 | 23312 | 22190 | DPW Maintained 3 | Tristania conferta :: 79 | 4011 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/12/1993 12:00:00 AM | 6 | 0 | 6015638.5282 | 2097667.7542 | 37.7406744589074 | -122.38848627310101 | (37.7406744589074, -122.388486273101) | ||
| 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) | |||
| 15418 | 15418 | 94801 | Permitted Site 1 | Tristania conferta :: 79 | 3950X 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6015629.3168 | 2097929.6865 | 37.7413931608426 | -122.388536401689 | (37.7413931608426, -122.388536401689) | |||
| 14469 | 14469 | 95295 | DPW Maintained 3 | Tristania conferta :: 79 | 4049 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6015625.3016 | 2097623.8233 | 37.740553100681 | -122.388528940359 | (37.740553100681, -122.388528940359) | |||
| 14504 | 14504 | 29438 | DPW Maintained 3 | Tristania conferta :: 79 | 2305X Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6015624.4095 | 2091751.2497 | 37.72442814458989 | -122.388122301142 | (37.7244281445899, -122.388122301142) | ||
| 13783 | 13783 | 29532 | DPW Maintained 3 | Tristania conferta :: 79 | 2302X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6015618.3638 | 2091811.707 | 37.7245938134403 | -122.388147417672 | (37.7245938134403, -122.388147417672) | ||
| 15171 | 15171 | 22197 | DPW Maintained 3 | Tristania conferta :: 79 | 4049 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6015613.0199 | 2097583.199 | 37.740440874048204 | -122.388568571109 | (37.7404408740482, -122.388568571109) | |||
| 13454 | 13454 | 29437 | DPW Maintained 3 | Tristania conferta :: 79 | 2307X Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6015612.318 | 2091732.5629 | 37.72437616438229 | -122.388162796666 | (37.7243761643823, -122.388162796666) | ||
| 56152 | 56152 | 199821 | Undocumented 2 | Tristania conferta :: 79 | 2309 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6015591.9824 | 2091704.5326 | 37.7242980719622 | -122.388231139286 | (37.7242980719622, -122.388231139286) | |||
| 15436 | 15436 | 29533 | DPW Maintained 3 | Tristania conferta :: 79 | 2304X Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6015579.3413 | 2091755.0969999998 | 37.724436211393396 | -122.388278365495 | (37.7244362113934, -122.388278365495) | ||
| 39541 | 39541 | 200920 | DPW Maintained 3 | Tristania conferta :: 79 | 4018 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | Width 0ft | 6015570.2699 | 2097736.9572 | 37.7408606933275 | -122.38872711611201 | (37.7408606933275, -122.388727116112) | |||
| 163138 | 163138 | 200932 | Undocumented 2 | Tristania conferta :: 79 | 4101 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6015570.0337 | 2097446.6824 | 37.740063645101294 | -122.38870767425699 | (37.7400636451013, -122.388707674257) | |||
| 153593 | 153593 | 199820 | Undocumented 2 | Tristania conferta :: 79 | 2311 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6015569.4483 | 2091672.6551 | 37.724209294028896 | -122.388306813339 | (37.7242092940289, -122.388306813339) |
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");