trees
1,377 rows where qSpecies_id = 61 sorted by Longitude
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 71074 | 200015 | DPW Maintained 1 | Tristania conferta :: 61 | 1021 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6018293.9123 | 2092319.9509 | 37.7261372321338 | -122.378933571911 | (37.7261372321338, -122.378933571911) | 10 | 3 | 8 | 58 | 1 | |||
| 92220 | 200019 | DPW Maintained 1 | Tristania conferta :: 61 | 1012 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6018229.2689 | 2092102.4532 | 37.7255364609642 | -122.379141943324 | (37.7255364609642, -122.379141943324) | 10 | 3 | 8 | 58 | 1 | |||
| 91963 | 199983 | DPW Maintained 1 | Tristania conferta :: 61 | 1065 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6018148.6647 | 2092424.026 | 37.7264149928709 | -122.379442916331 | (37.7264149928709, -122.379442916331) | 10 | 3 | 8 | 58 | 1 | |||
| 34013 | 199987 | DPW Maintained 1 | Tristania conferta :: 61 | 1040 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6018098.5001 | 2092201.6353 | 37.7258015841871 | -122.379600891938 | (37.7258015841871, -122.379600891938) | 10 | 3 | 8 | 58 | 1 | |||
| 172100 | 199988 | DPW Maintained 1 | Tristania conferta :: 61 | 1048 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6018073.2308 | 2092225.0095 | 37.7258643714622 | -122.379689870183 | (37.7258643714622, -122.379689870183) | 10 | 3 | 8 | 58 | 1 | |||
| 1224 | 81614 | DPW Maintained 1 | Tristania conferta :: 61 | 1450@ Shafter Hawes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 6017097.2029 | 2092677.3305 | 37.7270524726432 | -122.383095431375 | (37.7270524726432, -122.383095431375) | 10 | 3 | 8 | 58 | 1 | |||
| 50211 | 102731 | DPW Maintained 1 | Tristania conferta :: 61 | 1450 Hawes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6017062.4575 | 2092631.8457 | 37.7269256602576 | -122.383212382288 | (37.7269256602576, -122.383212382288) | 10 | 3 | 8 | 58 | 1 | |||
| 53377 | 199877 | DPW Maintained 1 | Tristania conferta :: 61 | 1501 Ingalls St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6017008.6079 | 2093600.4201 | 37.7295821995791 | -122.383465938576 | (37.7295821995791, -122.383465938576) | 10 | 3 | 8 | 58 | 1 | |||
| 125656 | 199876 | DPW Maintained 1 | Tristania conferta :: 61 | 1501 Ingalls St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6016991.57 | 2093575.1379 | 37.7295118379571 | -122.383523081566 | (37.7295118379571, -122.383523081566) | 10 | 3 | 8 | 58 | 1 | |||
| 139517 | 28836 | DPW Maintained 1 | Tristania conferta :: 61 | 1501 Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/2005 12:00:00 AM | 12 | 4x4 | 6016976.7304 | 2093554.8023 | 37.7294551802008 | -122.383572968876 | (37.7294551802008, -122.383572968876) | 10 | 3 | 8 | 58 | 1 | ||
| 10938 | 28832 | DPW Maintained 1 | Tristania conferta :: 61 | 1500 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/2005 12:00:00 AM | 12 | 4x4 | 6016972.3335 | 2093632.2976 | 37.7296677240114 | -122.383593562534 | (37.7296677240114, -122.383593562534) | 10 | 3 | 8 | 58 | 1 | ||
| 179595 | 28833 | DPW Maintained 1 | Tristania conferta :: 61 | 1500 Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/2005 12:00:00 AM | 12 | 4x4 | 6016963.5397 | 2093616.3588 | 37.7296234731469 | -122.383622854715 | (37.7296234731469, -122.383622854715) | 10 | 3 | 8 | 58 | 1 | ||
| 70802 | 28837 | DPW Maintained 1 | Tristania conferta :: 61 | 1527 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/12/2005 12:00:00 AM | 6 | 4x4 | 6016961.8909 | 2093534.4666 | 37.7293985221539 | -122.383622855757 | (37.7293985221539, -122.383622855757) | 10 | 3 | 8 | 58 | 1 | ||
| 131339 | 28834 | DPW Maintained 1 | Tristania conferta :: 61 | 1500 Ingalls St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/2005 12:00:00 AM | 16 | 4x4 | 6016954.1963 | 2093605.3666 | 37.7295927742855 | -122.383654391155 | (37.7295927742855, -122.383654391155) | 10 | 3 | 8 | 58 | 1 | ||
| 62834 | 199879 | DPW Maintained 1 | Tristania conferta :: 61 | 1527 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6016949.7994 | 2093519.0775 | 37.7293555983699 | -122.383663586634 | (37.7293555983699, -122.383663586634) | 10 | 3 | 8 | 58 | 1 | |||
| 22349 | 29469 | DPW Maintained 1 | Tristania conferta :: 61 | 1609 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2006 12:00:00 AM | 8 | 3X3 | 6016821.7398 | 2093350.8961 | 37.7288867261126 | -122.384094597711 | (37.7288867261126, -122.384094597711) | 10 | 3 | 8 | 58 | 1 | ||
| 3757 | 29485 | DPW Maintained 1 | Tristania conferta :: 61 | 1608 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2006 12:00:00 AM | 12 | 3x3 | 6016787.6638 | 2093383.8729 | 37.7289753898862 | -122.38421469762 | (37.7289753898862, -122.38421469762) | 10 | 3 | 8 | 58 | 1 | ||
| 80125 | 29486 | DPW Maintained 1 | Tristania conferta :: 61 | 1616 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2006 12:00:00 AM | 12 | 3x3 | 6016775.5724 | 2093362.9876 | 37.7289173744178 | -122.384255044958 | (37.7289173744178, -122.384255044958) | 10 | 3 | 8 | 58 | 1 | ||
| 42714 | 199905 | DPW Maintained 1 | Tristania conferta :: 61 | 1298 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6016747.5421 | 2093255.8132 | 37.7286215447387 | -122.384344487326 | (37.7286215447387, -122.384344487326) | 10 | 3 | 8 | 58 | 1 | |||
| 154541 | 199883 | DPW Maintained 1 | Tristania conferta :: 61 | 1624 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6016743.6948 | 2093323.4155 | 37.7288069546046 | -122.384362494194 | (37.7288069546046, -122.384362494194) | 10 | 3 | 8 | 58 | 1 | |||
| 159556 | 199884 | DPW Maintained 1 | Tristania conferta :: 61 | 1624 Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6016731.0538 | 2093302.5302 | 37.7287489086931 | -122.384404741347 | (37.7287489086931, -122.384404741347) | 10 | 3 | 8 | 58 | 1 | |||
| 89234 | 199885 | DPW Maintained 1 | Tristania conferta :: 61 | 1624 Ingalls St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6016716.7638 | 2093277.2481 | 37.7286786988336 | -122.384452383066 | (37.7286786988336, -122.384452383066) | 10 | 3 | 8 | 58 | 1 | |||
| 96092 | 199889 | DPW Maintained 1 | Tristania conferta :: 61 | 1725 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6016642.7991 | 2093116.8237 | 37.7282341146901 | -122.384696915405 | (37.7282341146901, -122.384696915405) | 10 | 3 | 8 | 58 | 1 | |||
| 55162 | 29493 | DPW Maintained 1 | Tristania conferta :: 61 | 1700X Ingalls St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2006 12:00:00 AM | 12 | 3X3 | 6016630.1295 | 2093166.4001 | 37.7283695410199 | -122.384744167276 | (37.7283695410199, -122.384744167276) | 10 | 3 | 8 | 58 | 1 | ||
| 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 | ||
| 156608 | 29495 | DPW Maintained 1 | Tristania conferta :: 61 | 1700X Ingalls St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2006 12:00:00 AM | 12 | 3X3 | 6016616.3583 | 2093144.917 | 37.7283097910179 | -122.384790279442 | (37.7283097910179, -122.384790279442) | 10 | 3 | 8 | 58 | 1 | ||
| 81648 | 199911 | DPW Maintained 1 | Tristania conferta :: 61 | 1733 Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6016596.5278 | 2093055.1286 | 37.7280621529643 | -122.384852582425 | (37.7280621529643, -122.384852582425) | 10 | 3 | 8 | 58 | 1 | |||
| 45530 | 199910 | DPW Maintained 1 | Tristania conferta :: 61 | 1733 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6016580.0023 | 2093030.3404 | 37.7279931754204 | -122.384907985938 | (37.7279931754204, -122.384907985938) | 10 | 3 | 8 | 58 | 1 | |||
| 166320 | 199891 | DPW Maintained 1 | Tristania conferta :: 61 | 1700 Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6016576.6972 | 2093089.2812 | 37.7281548324367 | -122.384923516456 | (37.7281548324367, -122.384923516456) | 10 | 3 | 8 | 58 | 1 | |||
| 160104 | 199892 | DPW Maintained 1 | Tristania conferta :: 61 | 1700 Ingalls St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6016564.5785 | 2093072.2049 | 37.7281072739712 | -122.384964222434 | (37.7281072739712, -122.384964222434) | 10 | 3 | 8 | 58 | 1 | |||
| 180500 | 199893 | DPW Maintained 1 | Tristania conferta :: 61 | 1700 Ingalls St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6016554.6632 | 2093059.5354 | 37.7280719375741 | -122.384997617963 | (37.7280719375741, -122.384997617963) | 10 | 3 | 8 | 58 | 1 | |||
| 92800 | 199895 | DPW Maintained 1 | Tristania conferta :: 61 | 1700 Ingalls St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6016530.9767 | 2093031.4421 | 37.7279934886935 | -122.385077547186 | (37.7279934886935, -122.385077547186) | 10 | 3 | 8 | 58 | 1 | |||
| 154274 | 199930 | DPW Maintained 1 | Tristania conferta :: 61 | 1801 Ingalls St | 4 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 02/28/2006 12:00:00 AM | 6 | Width 0ft | 6016497.9258 | 2092921.8231 | 37.7276906682215 | -122.385184171361 | (37.7276906682215, -122.385184171361) | 10 | 3 | 8 | 58 | 1 | ||
| 191358 | 199929 | DPW Maintained 1 | Tristania conferta :: 61 | 1801 Ingalls St | 3 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 02/28/2006 12:00:00 AM | 6 | Width 0ft | 6016487.4596 | 2092903.0942 | 37.727638663365 | -122.385219049049 | (37.727638663365, -122.385219049049) | 10 | 3 | 8 | 58 | 1 | ||
| 45411 | 199928 | DPW Maintained 1 | Tristania conferta :: 61 | 1801 Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 02/27/2008 12:00:00 AM | 4 | Width 0ft | 6016476.4427 | 2092884.9162 | 37.7275881406952 | -122.385255868852 | (37.7275881406952, -122.385255868852) | 10 | 3 | 8 | 58 | 1 | ||
| 92591 | 199927 | DPW Maintained 1 | Tristania conferta :: 61 | 1801 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 02/28/2006 12:00:00 AM | 5 | Width 0ft | 6016464.324 | 2092869.4925 | 37.7275451198245 | -122.385296689415 | (37.7275451198245, -122.385296689415) | 10 | 3 | 8 | 58 | 1 | ||
| 110545 | 29503 | DPW Maintained 1 | Tristania conferta :: 61 | 1800X Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2006 12:00:00 AM | 12 | 3x3 | 6016452.7561 | 2092931.7384 | 37.7277153948293 | -122.385341015796 | (37.7277153948293, -122.385341015796) | 10 | 3 | 8 | 58 | 1 | ||
| 4210 | 29504 | DPW Maintained 1 | Tristania conferta :: 61 | 1800X Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2006 12:00:00 AM | 12 | 3x3 | 6016442.8409 | 2092919.0689 | 37.7276800583286 | -122.385374410624 | (37.7276800583286, -122.385374410624) | 10 | 3 | 8 | 58 | 1 | ||
| 174856 | 200520 | DPW Maintained 1 | Tristania conferta :: 61 | 1400x La Salle Ave | 63 | Median : Cutout | Tree | DPW 1 | 2 | Width 0ft | 6016476.5475 | 2095041.1188 | 37.7335086511389 | -122.385405700106 | (37.7335086511389, -122.385405700106) | 10 | 3 | 8 | 58 | 1 | |||
| 141903 | 199953 | DPW Maintained 1 | Tristania conferta :: 61 | 1899 Ingalls St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6016430.7222 | 2092829.8313 | 37.7274343589932 | -122.385410089535 | (37.7274343589932, -122.385410089535) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 60840 | 199952 | DPW Maintained 1 | Tristania conferta :: 61 | 1899 Ingalls St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6016420.8069 | 2092814.4075 | 37.7273914597006 | -122.385443292691 | (37.7273914597006, -122.385443292691) | 10 | 3 | 8 | 58 | 1 | |||
| 89543 | 199951 | DPW Maintained 1 | Tristania conferta :: 61 | 1899 Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6016408.6882 | 2092795.6787 | 37.7273393636102 | -122.385483882807 | (37.7273393636102, -122.385483882807) | 10 | 3 | 8 | 58 | 1 | |||
| 164384 | 199950 | DPW Maintained 1 | Tristania conferta :: 61 | 1899 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6016400.4255 | 2092782.4583 | 37.7273026058349 | -122.385511526281 | (37.7273026058349, -122.385511526281) | 10 | 3 | 8 | 58 | 1 | |||
| 138871 | 199933 | DPW Maintained 1 | Tristania conferta :: 61 | 1898 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6016396.5695 | 2092856.2721 | 37.7275050706356 | -122.385529998516 | (37.7275050706356, -122.385529998516) | 10 | 3 | 8 | 58 | 1 | |||
| 193937 | 199710 | DPW Maintained 1 | Tristania conferta :: 61 | 1925 Ingalls St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6016332.671 | 2092691.0173 | 37.7270477778667 | -122.38573938499 | (37.7270477778667, -122.38573938499) | 10 | 3 | 8 | 58 | 1 | |||
| 180381 | 199709 | DPW Maintained 1 | Tristania conferta :: 61 | 1925 Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6016317.7981 | 2092670.0851 | 37.7269894791605 | -122.385789342511 | (37.7269894791605, -122.385789342511) | 10 | 3 | 8 | 58 | 1 | |||
| 38745 | 199701 | DPW Maintained 1 | Tristania conferta :: 61 | 1920 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6016301.5318 | 2092737.8037 | 37.7271745209486 | -122.385850293459 | (37.7271745209486, -122.385850293459) | 10 | 3 | 8 | 58 | 1 | |||
| 97308 | 199708 | DPW Maintained 1 | Tristania conferta :: 61 | 1925 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6016296.8658 | 2092642.5426 | 37.7269126945323 | -122.385859786812 | (37.7269126945323, -122.385859786812) | 10 | 3 | 8 | 58 | 1 | |||
| 129126 | 199702 | DPW Maintained 1 | Tristania conferta :: 61 | 1920 Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6016277.3489 | 2092699.8804 | 37.7270690527648 | -122.385931251973 | (37.7270690527648, -122.385931251973) | 10 | 3 | 8 | 58 | 1 | |||
| 48162 | 199720 | DPW Maintained 1 | Tristania conferta :: 61 | 1999 Ingalls St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6016267 | 2092645 | 37.7269177892808 | -122.385963204426 | (37.7269177892808, -122.385963204426) | 10 | 3 | 8 | 58 | 1 | |||
| 91009 | 199703 | DPW Maintained 1 | Tristania conferta :: 61 | 1920 Ingalls St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6016265.2574 | 2092686.1401 | 37.7270306554464 | -122.385972095124 | (37.7270306554464, -122.385972095124) | 10 | 3 | 8 | 58 | 1 | |||
| 86769 | 199704 | DPW Maintained 1 | Tristania conferta :: 61 | 1920 Ingalls St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6016256.4636 | 2092675.6975 | 37.7270014954531 | -122.386001767813 | (37.7270014954531, -122.386001767813) | 10 | 3 | 8 | 58 | 1 | |||
| 176499 | 199705 | DPW Maintained 1 | Tristania conferta :: 61 | 1920 Ingalls St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6016247.6698 | 2092666.3541 | 37.7269753536387 | -122.38603151707 | (37.7269753536387, -122.38603151707) | 10 | 3 | 8 | 58 | 1 | |||
| 144749 | 199718 | DPW Maintained 1 | Tristania conferta :: 61 | 1999 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6016237.3741 | 2092566.5255 | 37.7267006741711 | -122.386060153377 | (37.7267006741711, -122.386060153377) | 10 | 3 | 8 | 58 | 1 | |||
| 50214 | 82772 | DPW Maintained 1 | Tristania conferta :: 61 | 1410 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52295 | 6016233.7032 | 2093926.9573 | 37.7304359474549 | -122.386167643774 | (37.7304359474549, -122.386167643774) | 10 | 3 | 8 | 58 | 1 | |
| 155595 | 199768 | DPW Maintained 1 | Tristania conferta :: 61 | 2029 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6016150.938 | 2092445.1351 | 37.7263625758948 | -122.386350503257 | (37.7263625758948, -122.386350503257) | 10 | 3 | 8 | 58 | 1 | |||
| 125242 | 29518 | DPW Maintained 1 | Tristania conferta :: 61 | 2002X Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6016118.5109 | 2092491.8522 | 37.7264890568376 | -122.386465859174 | (37.7264890568376, -122.386465859174) | 10 | 3 | 8 | 58 | 1 | ||
| 160255 | 199760 | DPW Maintained 1 | Tristania conferta :: 61 | 2000 Ingalls St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6016108.6179 | 2092480.3103 | 37.7264568174072 | -122.38649925476 | (37.7264568174072, -122.38649925476) | 10 | 3 | 8 | 58 | 1 | |||
| 141857 | 29521 | DPW Maintained 1 | Tristania conferta :: 61 | 2000X Ingalls St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2006 12:00:00 AM | 8 | 3X3 | 6016098.1753 | 2092465.4708 | 37.7264154929828 | -122.386534320443 | (37.7264154929828, -122.386534320443) | 10 | 3 | 8 | 58 | 1 | ||
| 66609 | 199761 | DPW Maintained 1 | Tristania conferta :: 61 | 2000X Ingalls St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6016088.8319 | 2092453.3793 | 37.7263817748652 | -122.386565777701 | (37.7263817748652, -122.386565777701) | 10 | 3 | 8 | 58 | 1 | |||
| 74984 | 199765 | DPW Maintained 1 | Tristania conferta :: 61 | 2050 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6016065.7481 | 2092407.7615 | 37.726255239445 | -122.386642398454 | (37.726255239445, -122.386642398454) | 10 | 3 | 8 | 58 | 1 | |||
| 155912 | 199766 | DPW Maintained 1 | Tristania conferta :: 61 | 2050 Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6016050.9086 | 2092395.1204 | 37.7262197079231 | -122.386692817183 | (37.7262197079231, -122.386692817183) | 10 | 3 | 8 | 58 | 1 | |||
| 58120 | 199767 | DPW Maintained 1 | Tristania conferta :: 61 | 2050 Ingalls St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6016040.466 | 2092381.3801 | 37.7261814016259 | -122.386727959266 | (37.7261814016259, -122.386727959266) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | ||
| 126613 | 199819 | DPW Maintained 1 | Tristania conferta :: 61 | 2225 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6015792.5909 | 2091976.5907 | 37.7250562032851 | -122.387556629575 | (37.7250562032851, -122.387556629575) | 10 | 3 | 8 | 58 | 1 | |||
| 144607 | 29527 | DPW Maintained 1 | Tristania conferta :: 61 | 2220 Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2006 12:00:00 AM | 3 | 2X3 | 6015766.2095 | 2092015.0636 | 37.7251603810099 | -122.387650511034 | (37.7251603810099, -122.387650511034) | 10 | 3 | 8 | 58 | 1 | ||
| 30494 | 199816 | DPW Maintained 1 | Tristania conferta :: 61 | 2240 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6015734.8816 | 2091975.4915 | 37.7250499884833 | -122.387756049526 | (37.7250499884833, -122.387756049526) | 10 | 3 | 8 | 58 | 1 | |||
| 184504 | 199817 | DPW Maintained 1 | Tristania conferta :: 61 | 2240 Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6015723.8893 | 2091960.1023 | 37.7250071238567 | -122.387792975779 | (37.7250071238567, -122.387792975779) | 10 | 3 | 8 | 58 | 1 | |||
| 18493 | 199818 | DPW Maintained 1 | Tristania conferta :: 61 | 2226 Ingalls St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6015709.0498 | 2091939.7667 | 37.7249504642567 | -122.387842856465 | (37.7249504642567, -122.387842856465) | 10 | 3 | 8 | 58 | 1 | |||
| 78319 | 200911 | DPW Maintained 1 | Tristania conferta :: 61 | 3801 03rd St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6015820.1566 | 2098275.9378 | 37.7423544699147 | -122.387900693237 | (37.7423544699147, -122.387900693237) | 10 | 3 | 8 | 58 | 1 | |||
| 44952 | 200910 | DPW Maintained 1 | Tristania conferta :: 61 | 3801 03rd St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6015813.5433 | 2098253.2638 | 37.7422918453939 | -122.387921978414 | (37.7422918453939, -122.387921978414) | 10 | 3 | 8 | 58 | 1 | |||
| 92466 | 200909 | DPW Maintained 1 | Tristania conferta :: 61 | 3801 03rd St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6015806.4577 | 2098231.0621 | 37.7422304915422 | -122.387944929586 | (37.7422304915422, -122.387944929586) | 10 | 3 | 8 | 58 | 1 | |||
| 173968 | 200908 | DPW Maintained 1 | Tristania conferta :: 61 | 3801 03rd St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6015799.3721 | 2098207.4433 | 37.7421652466195 | -122.387967781856 | (37.7421652466195, -122.387967781856) | 10 | 3 | 8 | 58 | 1 | |||
| 84547 | 200907 | DPW Maintained 1 | Tristania conferta :: 61 | 3801 03rd St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6015794.1759 | 2098187.1312 | 37.7421091858865 | -122.387984331771 | (37.7421091858865, -122.387984331771) | 10 | 3 | 8 | 58 | 1 | |||
| 183125 | 29440 | DPW Maintained 1 | Tristania conferta :: 61 | 2301X Ingalls St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2006 12:00:00 AM | 3 | 3X3 | 6015660.6839 | 2091799.6156 | 37.7245629575419 | -122.388000277891 | (37.7245629575419, -122.388000277891) | 10 | 3 | 8 | 58 | 1 | ||
| 165155 | 200906 | DPW Maintained 1 | Tristania conferta :: 61 | 3801 03rd St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6015788.035 | 2098168.2362 | 37.7420569638785 | -122.388004247029 | (37.7420569638785, -122.388004247029) | 10 | 3 | 8 | 58 | 1 | |||
| 89017 | 200905 | DPW Maintained 1 | Tristania conferta :: 61 | 3801 03rd St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6015782.8389 | 2098148.8688 | 37.7420034970973 | -122.388020862455 | (37.7420034970973, -122.388020862455) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | ||
| 67818 | 22146 | DPW Maintained 1 | Tristania conferta :: 61 | 3800 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2008 12:00:00 AM | 12 | 3x3 | 6015760.6373 | 2098363.7997 | 37.742592423172 | -122.388112624911 | (37.742592423172, -122.388112624911) | 10 | 3 | 8 | 58 | 1 | ||
| 65983 | 29438 | DPW Maintained 1 | Tristania conferta :: 61 | 2305X Ingalls St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6015624.4095 | 2091751.2497 | 37.7244281445899 | -122.388122301142 | (37.7244281445899, -122.388122301142) | 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 | ||
| 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 | ||
| 161261 | 200913 | DPW Maintained 1 | Tristania conferta :: 61 | 3801 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6015728.5157 | 2097971.7279 | 37.7415140947501 | -122.388196336709 | (37.7415140947501, -122.388196336709) | 10 | 3 | 8 | 58 | 1 | |||
| 127870 | 200912 | DPW Maintained 1 | Tristania conferta :: 61 | 3801 03rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6015724.2643 | 2097951.4157 | 37.7414580860536 | -122.388209619479 | (37.7414580860536, -122.388209619479) | 10 | 3 | 8 | 58 | 1 | |||
| 59965 | 199821 | DPW Maintained 1 | Tristania conferta :: 61 | 2309 Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6015591.9824 | 2091704.5326 | 37.7242980719622 | -122.388231139286 | (37.7242980719622, -122.388231139286) | 10 | 3 | 8 | 58 | 1 | |||
| 40506 | 200918 | DPW Maintained 1 | Tristania conferta :: 61 | 3801 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6015708.4397 | 2097905.3591 | 37.7413307472539 | -122.388261122371 | (37.7413307472539, -122.388261122371) | 10 | 3 | 8 | 58 | 1 | |||
| 60294 | 200917 | DPW Maintained 1 | Tristania conferta :: 61 | 3801 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6015704.1884 | 2097889.2984 | 37.7412864123015 | -122.388274701363 | (37.7412864123015, -122.388274701363) | 10 | 3 | 8 | 58 | 1 | |||
| 117955 | 29533 | DPW Maintained 1 | Tristania conferta :: 61 | 2304X Ingalls St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6015579.3413 | 2091755.097 | 37.7244362113934 | -122.388278365495 | (37.7244362113934, -122.388278365495) | 10 | 3 | 8 | 58 | 1 | ||
| 86014 | 199820 | DPW Maintained 1 | Tristania conferta :: 61 | 2311 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6015569.4483 | 2091672.6551 | 37.7242092940289 | -122.388306813339 | (37.7242092940289, -122.388306813339) | 10 | 3 | 8 | 58 | 1 | |||
| 138000 | 199822 | DPW Maintained 1 | Tristania conferta :: 61 | 2350 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6015555.1584 | 2091721.021 | 37.7243413054209 | -122.388359585978 | (37.7243413054209, -122.388359585978) | 10 | 3 | 8 | 58 | 1 | |||
| 107065 | 22174 | DPW Maintained 1 | Tristania conferta :: 61 | 3900 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1995 12:00:00 AM | 3 | 3X3 | 6015675.1373 | 2098078.9572 | 37.7418055667015 | -122.388388385005 | (37.7418055667015, -122.388388385005) | 10 | 3 | 8 | 58 | 1 | ||
| 73214 | 199823 | DPW Maintained 1 | Tristania conferta :: 61 | 2350 Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6015539.2196 | 2091696.8381 | 37.724274020732 | -122.388412997536 | (37.724274020732, -122.388412997536) | 10 | 3 | 8 | 58 | 1 | |||
| 133353 | 22191 | DPW Maintained 1 | Tristania conferta :: 61 | 4011 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 3 | 6015646.0862 | 2097696.0967 | 37.7407527004376 | -122.388462117977 | (37.7407527004376, -122.388462117977) | 10 | 3 | 8 | 58 | 1 | |||
| 75411 | 22177 | DPW Maintained 1 | Tristania conferta :: 61 | 3950X 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6015646.3224 | 2097987.7887 | 37.741553639953 | -122.388481656276 | (37.741553639953, -122.388481656276) | 10 | 3 | 8 | 58 | 1 | |||
| 154471 | 22190 | DPW Maintained 1 | Tristania conferta :: 61 | 4011 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/12/1993 12:00:00 AM | 6 | 0 | 6015638.5282 | 2097667.7542 | 37.7406744589074 | -122.388486273101 | (37.7406744589074, -122.388486273101) | 10 | 3 | 8 | 58 | 1 | ||
| 32386 | 200922 | DPW Maintained 1 | Tristania conferta :: 61 | 4049 03rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6015633.332 | 2097648.3868 | 37.7406209920403 | -122.388502888217 | (37.7406209920403, -122.388502888217) | 10 | 3 | 8 | 58 | 1 | |||
| 71977 | 95295 | DPW Maintained 1 | Tristania conferta :: 61 | 4049 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6015625.3016 | 2097623.8233 | 37.740553100681 | -122.388528940359 | (37.740553100681, -122.388528940359) | 10 | 3 | 8 | 58 | 1 | |||
| 91195 | 94801 | DPW Maintained 1 | Tristania conferta :: 61 | 3950X 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6015629.3168 | 2097929.6865 | 37.7413931608426 | -122.388536401689 | (37.7413931608426, -122.388536401689) | 10 | 3 | 8 | 58 | 1 | |||
| 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 |
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) );