trees
1,377 rows where qSpecies_id = 61 sorted by TreeID
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 151635 | 100969 | DPW Maintained 1 | Tristania conferta :: 61 | 418 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6007656.9693 | 2112859.914 | 37.7819430807706 | -122.417159773401 | (37.7819430807706, -122.417159773401) | 7 | 9 | 9 | 28852 | 36 | |||
| 150218 | 101329 | DPW Maintained 1 | Tristania conferta :: 61 | 2703 Turk Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 5997904.4066 | 2111642.2894 | 37.7780463265361 | -122.450811165883 | (37.7780463265361, -122.450811165883) | 15 | 6 | 2 | 54 | 16 | |||
| 76979 | 101650 | DPW Maintained 1 | Tristania conferta :: 61 | 3X Masonic Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5998828.7375 | 2112398.5369 | 37.7801756557318 | -122.447668041416 | (37.7801756557318, -122.447668041416) | 15 | 6 | 2 | 54 | 16 | |||
| 131796 | 10246 | DPW Maintained 1 | Tristania conferta :: 61 | 100 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6005589.149 | 2109643.5092 | 37.7729950707153 | -122.424084680793 | (37.7729950707153, -122.424084680793) | 7 | 9 | 11 | 28852 | 10 | |||
| 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 | |||
| 128917 | 10302 | DPW Maintained 1 | Tristania conferta :: 61 | 596 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/1997 12:00:00 AM | 20 | 3X3 | 6003330.7652 | 2109326.5077 | 37.7719968952641 | -122.431874063617 | (37.7719968952641, -122.431874063617) | 15 | 9 | 11 | 29492 | 10 | ||
| 166772 | 10305 | DPW Maintained 1 | Tristania conferta :: 61 | 614 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/03/1999 12:00:00 AM | 25 | 3x3 | 6003095.7029 | 2109294.636 | 37.7718960552644 | -122.432684884303 | (37.7718960552644, -122.432684884303) | 15 | 5 | 11 | 29492 | 9 | ||
| 160563 | 10310 | DPW Maintained 1 | Tristania conferta :: 61 | 630 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2004 12:00:00 AM | 8 | 6002998.1704 | 2109278.2038 | 37.7718454047065 | -122.433021081698 | (37.7718454047065, -122.433021081698) | 15 | 5 | 11 | 29492 | 9 | |||
| 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 | |||
| 124308 | 10344 | DPW Maintained 1 | Tristania conferta :: 61 | 946 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6001573.5571 | 2109081.4751 | 37.7712243264402 | -122.437934814539 | (37.7712243264402, -122.437934814539) | 15 | 5 | 11 | 29492 | 9 | |||
| 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 | ||
| 90602 | 10366 | DPW Maintained 1 | Tristania conferta :: 61 | 1166 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 3X4 | 6000501.5622 | 2108932.6998 | 37.7707548079908 | -122.441632199385 | (37.7707548079908, -122.441632199385) | 15 | 5 | 11 | 29492 | 9 | |||
| 80936 | 10388 | DPW Maintained 1 | Tristania conferta :: 61 | 1354 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/26/2007 12:00:00 AM | 3 | 3X3 | 5999661.5734 | 2108814.8136 | 37.7703832281799 | -122.444529252288 | (37.7703832281799, -122.444529252288) | 15 | 5 | 11 | 29492 | 9 | ||
| 128869 | 103963 | DPW Maintained 1 | Tristania conferta :: 61 | 2534 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2015 12:00:00 AM | 0 | Permit Number 773267 | 6000467 | 2114127 | 37.7850150648369 | -122.442124666784 | (37.7850150648369, -122.442124666784) | 15 | 6 | 1 | 29490 | 27 | ||
| 40297 | 10406 | DPW Maintained 1 | Tristania conferta :: 61 | 1386 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2007 12:00:00 AM | 3 | 3x3 | 5999529.6926 | 2108795.3635 | 37.7703222971334 | -122.444984028084 | (37.7703222971334, -122.444984028084) | 15 | 5 | 11 | 29492 | 9 | ||
| 185869 | 10407 | DPW Maintained 1 | Tristania conferta :: 61 | 1392 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/01/2009 12:00:00 AM | 8 | 3x3 | 5999510.2425 | 2108793.466 | 37.7703159769785 | -122.445051169277 | (37.7703159769785, -122.445051169277) | 15 | 5 | 11 | 29492 | 9 | ||
| 86662 | 10428 | DPW Maintained 1 | Tristania conferta :: 61 | 1427 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/26/2007 12:00:00 AM | 3 | 3X3 | 5999264.0192 | 2108708.6767 | 37.7700691107077 | -122.445896752918 | (37.7700691107077, -122.445896752918) | 15 | 5 | 11 | 29492 | 9 | ||
| 59775 | 10431 | DPW Maintained 1 | Tristania conferta :: 61 | 1430 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2004 12:00:00 AM | 8 | 3X3 | 5999221.0892 | 2108752.9533 | 37.770188231639 | -122.446048431812 | (37.770188231639, -122.446048431812) | 15 | 5 | 11 | 29492 | 9 | ||
| 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 | ||
| 91468 | 10433 | DPW Maintained 1 | Tristania conferta :: 61 | 1449 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/12/2001 12:00:00 AM | 3 | 3x3 | 5999155.0008 | 2108693.838 | 37.7700221418409 | -122.446272777074 | (37.7700221418409, -122.446272777074) | 15 | 5 | 11 | 29492 | 9 | ||
| 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 | |||
| 133686 | 10448 | DPW Maintained 1 | Tristania conferta :: 61 | 1525 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1996 12:00:00 AM | 20 | 2X3 | 5998831.2765 | 2108649.625 | 37.7698822506188 | -122.447389347046 | (37.7698822506188, -122.447389347046) | 15 | 5 | 11 | 29492 | 9 | ||
| 193071 | 10456 | DPW Maintained 1 | Tristania conferta :: 61 | 1556 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5998680.607 | 2108678.296 | 37.7699523629106 | -122.447912571831 | (37.7699523629106, -122.447912571831) | 15 | 5 | 11 | 29492 | 9 | |||
| 58783 | 10468 | DPW Maintained 1 | Tristania conferta :: 61 | 1600 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/04/1993 12:00:00 AM | 10 | 3x3 | 5998442.2021 | 2108643.6888 | 37.7698437104477 | -122.448734713286 | (37.7698437104477, -122.448734713286) | 15 | 5 | 11 | 29492 | 9 | ||
| 102263 | 10469 | DPW Maintained 1 | Tristania conferta :: 61 | 1608 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/06/2011 12:00:00 AM | 3 | 3x3 | 5998376.833 | 2108635.1438 | 37.7698165098188 | -122.448960206815 | (37.7698165098188, -122.448960206815) | 15 | 5 | 11 | 29492 | 9 | ||
| 169282 | 10471 | DPW Maintained 1 | Tristania conferta :: 61 | 1628 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/06/2011 12:00:00 AM | 1 | 3x3 | 5998338.8079 | 2108630.4441 | 37.7698014309157 | -122.44909139548 | (37.7698014309157, -122.44909139548) | 15 | 5 | 11 | 29492 | 9 | ||
| 178841 | 10480 | DPW Maintained 1 | Tristania conferta :: 61 | 1665 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/09/1992 12:00:00 AM | 1 | 3X3 | 5998086.3169 | 2108545.149 | 37.7695527882164 | -122.449958603017 | (37.7695527882164, -122.449958603017) | 15 | 5 | 11 | 29492 | 9 | ||
| 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 | |||
| 172868 | 10491 | DPW Maintained 1 | Tristania conferta :: 61 | 1694 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/19/2008 12:00:00 AM | 3 | 3X3 | 5998067.7185 | 2108593.9143 | 37.7696856210689 | -122.450026449099 | (37.7696856210689, -122.450026449099) | 15 | 5 | 11 | 29492 | 9 | ||
| 152365 | 10492 | DPW Maintained 1 | Tristania conferta :: 61 | 1699 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/09/1992 12:00:00 AM | 10 | 3X3 | 5997918.2468 | 2108523.3453 | 37.7694833025616 | -122.450538376308 | (37.7694833025616, -122.450538376308) | 15 | 5 | 11 | 29492 | 9 | ||
| 122744 | 10510 | DPW Maintained 1 | Tristania conferta :: 61 | 1793 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/09/1992 12:00:00 AM | 1 | 5997601.0333 | 2108476.5582 | 37.7693366759731 | -122.451632224006 | (37.7693366759731, -122.451632224006) | 15 | 5 | 11 | 29492 | 9 | |||
| 29646 | 10511 | DPW Maintained 1 | Tristania conferta :: 61 | 1800 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2007 12:00:00 AM | 6 | 3X3 | 5997484.5237 | 2108509.319 | 37.7694199557275 | -122.452037587086 | (37.7694199557275, -122.452037587086) | 15 | 5 | 11 | 29492 | 9 | ||
| 75392 | 10519 | DPW Maintained 1 | Tristania conferta :: 61 | 1840 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/1990 12:00:00 AM | 50 | 5997331.1413 | 2108490.0928 | 37.7693583785533 | -122.452566739633 | (37.7693583785533, -122.452566739633) | 15 | 5 | 11 | 29492 | 9 | |||
| 170787 | 106206 | DPW Maintained 1 | Tristania conferta :: 61 | 1600X Fillmore St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 5x5 | 6003113.3747 | 2114020.7176 | 37.784873699559 | -122.432961462333 | (37.784873699559, -122.432961462333) | 13 | 9 | 11 | 29490 | 13 | |||
| 70906 | 10640 | DPW Maintained 1 | Tristania conferta :: 61 | 879 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/26/1992 12:00:00 AM | 12 | 3X3 | 6003664.2022 | 2110709.9334 | 37.7758143385689 | -122.430819424449 | (37.7758143385689, -122.430819424449) | 7 | 9 | 11 | 29492 | 10 | ||
| 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 | |||
| 86991 | 10682 | DPW Maintained 1 | Tristania conferta :: 61 | 1145 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6002385.9834 | 2110534.2276 | 37.7752593905207 | -122.43522853143 | (37.7752593905207, -122.43522853143) | 15 | 5 | 11 | 29492 | 10 | |||
| 152677 | 10683 | DPW Maintained 1 | Tristania conferta :: 61 | 1155 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6002334.989 | 2110528.6392 | 37.775241150218 | -122.435404532604 | (37.775241150218, -122.435404532604) | 15 | 5 | 11 | 29492 | 10 | |||
| 144379 | 10685 | DPW Maintained 1 | Tristania conferta :: 61 | 1167 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002283.296 | 2110520.9551 | 37.7752171157043 | -122.435582800345 | (37.7752171157043, -122.435582800345) | 15 | 5 | 11 | 29492 | 10 | |||
| 111645 | 10686 | DPW Maintained 1 | Tristania conferta :: 61 | 1179 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002229.5074 | 2110511.8739 | 37.7751891257972 | -122.435768217131 | (37.7751891257972, -122.435768217131) | 15 | 5 | 11 | 29492 | 10 | |||
| 44515 | 10687 | DPW Maintained 1 | Tristania conferta :: 61 | 1185 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6002205.7566 | 2110510.4768 | 37.7751839405685 | -122.435850276383 | (37.7751839405685, -122.435850276383) | 15 | 5 | 11 | 29492 | 10 | |||
| 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 | |||
| 185203 | 10693 | DPW Maintained 1 | Tristania conferta :: 61 | 1250 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6001870.5552 | 2110507.5567 | 37.7751568758154 | -122.43700960221 | (37.7751568758154, -122.43700960221) | 15 | 5 | 11 | 29492 | 10 | |||
| 78595 | 10696 | DPW Maintained 1 | Tristania conferta :: 61 | 1257 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001848.8335 | 2110459.5307 | 37.7750237737687 | -122.43708130309 | (37.7750237737687, -122.43708130309) | 15 | 5 | 11 | 29492 | 10 | |||
| 134850 | 10697 | DPW Maintained 1 | Tristania conferta :: 61 | 1273 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3X3 | 6001825.1691 | 2110457.0657 | 37.7750156603511 | -122.437162986716 | (37.7750156603511, -122.437162986716) | 15 | 5 | 11 | 29492 | 10 | |||
| 70340 | 10699 | DPW Maintained 1 | Tristania conferta :: 61 | 1275 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6001777.3475 | 2110450.1636 | 37.7749939904382 | -122.43732791737 | (37.7749939904382, -122.43732791737) | 15 | 5 | 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 | |||
| 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 | |||
| 70707 | 107145 | DPW Maintained 1 | Tristania conferta :: 61 | 2466 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 5985834.5248 | 2098407.3335 | 37.7410084743792 | -122.491590149603 | (37.7410084743792, -122.491590149603) | 1 | 8 | 3 | 29491 | 35 | ||||
| 62984 | 107146 | DPW Maintained 1 | Tristania conferta :: 61 | 2466 34th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 5985834.1864 | 2098423.2393 | 37.7410521276716 | -122.491592490194 | (37.7410521276716, -122.491592490194) | 1 | 8 | 3 | 29491 | 35 | ||||
| 101869 | 107147 | DPW Maintained 1 | Tristania conferta :: 61 | 2466 34th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 5985833.5095 | 2098430.6846 | 37.7410725309134 | -122.491595378553 | (37.7410725309134, -122.491595378553) | 1 | 8 | 3 | 29491 | 35 | ||||
| 133803 | 108697 | DPW Maintained 1 | Tristania conferta :: 61 | 2414 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774621 | 6000824.14262 | 2119316.97174 | 37.7992857188841 | -122.441261581656 | (37.7992857188841, -122.441261581656) | 13 | 9 | 1 | 57 | 17 |
| 76664 | 109151 | Permitted Site 7 | Tristania conferta :: 61 | 727 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/29/2015 12:00:00 AM | 3 | 3x3 | Permit Number 769036 | 5986896.6 | 2110966.4 | 37.7755542438819 | -122.48884090533 | (37.7755542438819, -122.48884090533) | 11 | 6 | 2 | 55 | 26 |
| 104677 | 111746 | Permitted Site 7 | Tristania conferta :: 61 | 398X 03rd St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/22/2015 12:00:00 AM | 3 | 10x20 | Permit Number 775763 | 6013296.04718 | 2113048.21405 | 37.7827757318295 | -122.397664238011 | (37.7827757318295, -122.397664238011) | 6 | 2 | 9 | 28856 | 34 | |
| 172109 | 111747 | Permitted Site 7 | Tristania conferta :: 61 | 398X 03rd St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/22/2015 12:00:00 AM | 3 | 10x20 | Permit Number 775763 | 6013296.04718 | 2113048.21405 | 37.7827757318295 | -122.397664238011 | (37.7827757318295, -122.397664238011) | 6 | 2 | 9 | 28856 | 34 | |
| 36704 | 111994 | Permitted Site 7 | Tristania conferta :: 61 | 1244 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2015 12:00:00 AM | 3 | 3x3 | 5993400.7 | 2107017.1 | 37.7650879480266 | -122.466054789326 | (37.7650879480266, -122.466054789326) | 11 | 8 | 11 | 56 | 12 | ||
| 159152 | 112507 | DPW Maintained 1 | Tristania conferta :: 61 | 695 Willow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2x2 | 6004336.6662 | 2113071.6622 | 37.782337139661 | -122.428661593197 | (37.782337139661, -122.428661593197) | 7 | 9 | 11 | 29490 | 41 | |||
| 103530 | 113554 | Undocumented 4 | Tristania conferta :: 61 | 400X Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6007659.5152 | 2112834.4553 | 37.7818733205533 | -122.4171491612 | (37.7818733205533, -122.4171491612) | 7 | 9 | 9 | 28852 | 36 | |||
| 58128 | 114168 | DPW Maintained 1 | Tristania conferta :: 61 | 1x Shrader St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 5997246.1454 | 2110389.6791 | 37.7745692814468 | -122.452997873526 | (37.7745692814468, -122.452997873526) | 15 | 5 | 2 | 29492 | 16 | |||
| 170156 | 114594 | DPW Maintained 1 | Tristania conferta :: 61 | 2584 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2015 12:00:00 AM | Permit Number 775079 | 6000253.6 | 2114128.6 | 37.7850072942162 | -122.442863075731 | (37.7850072942162, -122.442863075731) | 15 | 6 | 1 | 29490 | 27 | |||
| 107579 | 114595 | DPW Maintained 1 | Tristania conferta :: 61 | 2584 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2015 12:00:00 AM | Permit Number 775079 | 6000253.6 | 2114128.6 | 37.7850072942162 | -122.442863075731 | (37.7850072942162, -122.442863075731) | 15 | 6 | 1 | 29490 | 27 | |||
| 54773 | 115011 | DPW Maintained 1 | Tristania conferta :: 61 | 1600 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6001663.1427 | 2114000.6718 | 37.7847362944928 | -122.437977348952 | (37.7847362944928, -122.437977348952) | 13 | 6 | 11 | 29490 | 13 | |||
| 43808 | 115203 | DPW Maintained 1 | Tristania conferta :: 61 | 2056 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/22/2018 12:00:00 AM | 3 | Permit Number 769837 | 6001029.7 | 2112838.5 | 37.7815092255851 | -122.440085481713 | (37.7815092255851, -122.440085481713) | 15 | 5 | 11 | 29490 | 41 | ||
| 95289 | 115299 | Permitted Site 7 | Tristania conferta :: 61 | 177 Lomita Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | Permit Number 775793 | 5991298.7 | 2104254.5 | 37.757381090716 | -122.473123533862 | (37.757381090716, -122.473123533862) | 1 | 8 | 4 | 56 | 12 | |||
| 97027 | 115300 | Permitted Site 7 | Tristania conferta :: 61 | 177 Lomita Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | Permit Number 775793 | 5991298.7 | 2104254.5 | 37.757381090716 | -122.473123533862 | (37.757381090716, -122.473123533862) | 1 | 8 | 4 | 56 | 12 | |||
| 58736 | 115369 | DPW Maintained 1 | Tristania conferta :: 61 | 720 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2016 12:00:00 AM | 3 | Permit Number 777460 | 5993541.3 | 2110551.9 | 37.7748016816289 | -122.465825344597 | (37.7748016816289, -122.465825344597) | 11 | 6 | 2 | 54 | 11 | ||
| 24778 | 115380 | Permitted Site 7 | Tristania conferta :: 61 | 1657X York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2016 12:00:00 AM | 3 | Permit Number 775521 | 6010720.61658 | 2099977.21326 | 37.7467419766429 | -122.405653246985 | (37.7467419766429, -122.405653246985) | 2 | 7 | 7 | 28859 | 2 | ||
| 148527 | 119142 | Permitted Site 7 | Tristania conferta :: 61 | 583 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781376 | 5981295.16505 | 2111765.56723 | 37.7774200299425 | -122.508276611938 | (37.7774200299425, -122.508276611938) | 11 | 6 | 2 | 55 | 26 |
| 83278 | 121007 | DPW Maintained 1 | Tristania conferta :: 61 | 199X Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x4 | 6015091.1726 | 2115438.8125 | 37.7894395668943 | -122.391621004116 | (37.7894395668943, -122.391621004116) | 6 | 2 | 9 | 28855 | 6 | |||
| 54256 | 121008 | DPW Maintained 1 | Tristania conferta :: 61 | 199X Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 4x4 | 6015113.794 | 2115458.3492 | 37.7894944658082 | -122.391544102374 | (37.7894944658082, -122.391544102374) | 6 | 2 | 9 | 28855 | 6 | |||
| 109061 | 121009 | DPW Maintained 1 | Tristania conferta :: 61 | 199X Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 4x4 | 6015134.359 | 2115477.8859 | 37.7895492505351 | -122.391474315503 | (37.7895492505351, -122.391474315503) | 6 | 2 | 9 | 28855 | 6 | |||
| 52692 | 121010 | DPW Maintained 1 | Tristania conferta :: 61 | 199X Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x4 | 6015151.8392 | 2115494.3379 | 37.7895953941333 | -122.391414985971 | (37.7895953941333, -122.391414985971) | 6 | 2 | 9 | 28855 | 6 | |||
| 36622 | 121011 | DPW Maintained 1 | Tristania conferta :: 61 | 199X Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 4x4 | 6015164.1782 | 2115507.7051 | 37.7896327822139 | -122.391373228803 | (37.7896327822139, -122.391373228803) | 6 | 2 | 9 | 28855 | 6 | |||
| 11372 | 121012 | DPW Maintained 1 | Tristania conferta :: 61 | 199X Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 4x4 | 6015178.5737 | 2115521.0723 | 37.7896702844128 | -122.391324356251 | (37.7896702844128, -122.391324356251) | 6 | 2 | 9 | 28855 | 6 | |||
| 169675 | 121013 | DPW Maintained 1 | Tristania conferta :: 61 | 199X Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 4x4 | 6015189.8844 | 2115534.4395 | 37.7897076153927 | -122.391286156841 | (37.7897076153927, -122.391286156841) | 6 | 2 | 9 | 28855 | 6 | |||
| 114675 | 12242 | DPW Maintained 1 | Tristania conferta :: 61 | 1130 Mendell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/04/1997 12:00:00 AM | 6 | 3X3 | 6015460.5377 | 2096047.2009 | 37.7362148852375 | -122.388988585219 | (37.7362148852375, -122.388988585219) | 10 | 3 | 8 | 58 | 1 | ||
| 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 | ||
| 181832 | 12267 | DPW Maintained 1 | Tristania conferta :: 61 | 649 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2005 12:00:00 AM | 3 | 3X3 | 6004918.0391 | 2111202.3941 | 37.7772374748382 | -122.426517155351 | (37.7772374748382, -122.426517155351) | 7 | 9 | 11 | 28852 | 10 | ||
| 33724 | 12273 | DPW Maintained 1 | Tristania conferta :: 61 | 721 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1991 12:00:00 AM | 12 | 3X3 | 6004895.7756 | 2111355.1796 | 37.7776557277721 | -122.426605054269 | (37.7776557277721, -122.426605054269) | 7 | 9 | 11 | 28852 | 10 | ||
| 127387 | 12280 | DPW Maintained 1 | Tristania conferta :: 61 | 741 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/1997 12:00:00 AM | 3 | 3X3 | 6004879.1558 | 2111501.6218 | 37.7780568825374 | -122.426672978752 | (37.7780568825374, -122.426672978752) | 7 | 9 | 11 | 28852 | 10 | ||
| 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 | |||
| 1715 | 122822 | DPW Maintained 1 | Tristania conferta :: 61 | 1736 Stockton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6010044.5984 | 2120081.0225 | 37.8019045299018 | -122.409409413578 | (37.8019045299018, -122.409409413578) | 3 | 1 | 10 | 308 | 23 | |||
| 66530 | 122823 | Permitted Site 7 | Tristania conferta :: 61 | 1736 Stockton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 4x4 | 6010043.2132 | 2120098.5684 | 37.8019526289989 | -122.409415446027 | (37.8019526289989, -122.409415446027) | 3 | 1 | 10 | 308 | 23 | ||
| 188487 | 122837 | DPW Maintained 1 | Tristania conferta :: 61 | 945 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 2x3 | 6001926.8941 | 2111799.4441 | 37.7787072764484 | -122.436907219039 | (37.7787072764484, -122.436907219039) | 15 | 5 | 11 | 29490 | 41 | |||
| 139281 | 122838 | DPW Maintained 1 | Tristania conferta :: 61 | 945 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 2x3 | 6001931.7611 | 2111776.6298 | 37.7786449107474 | -122.436888748547 | (37.7786449107474, -122.436888748547) | 15 | 5 | 11 | 29490 | 41 | |||
| 77373 | 122839 | DPW Maintained 1 | Tristania conferta :: 61 | 945 Scott St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 2x3 | 6001935.4114 | 2111748.3401 | 37.7785674418218 | -122.436874095034 | (37.7785674418218, -122.436874095034) | 15 | 5 | 11 | 29490 | 41 | |||
| 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 | ||
| 100998 | 12339 | DPW Maintained 1 | Tristania conferta :: 61 | 1199 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/22/1999 12:00:00 AM | 12 | 3X3 | 6004687.2548 | 2112907.9517 | 37.7819074662565 | -122.42743704494 | (37.7819074662565, -122.42743704494) | 7 | 9 | 11 | 29490 | 41 | ||
| 79434 | 12343 | DPW Maintained 1 | Tristania conferta :: 61 | 1200 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/16/1993 12:00:00 AM | 6 | 4X4 | 6004715.5822 | 2113048.0527 | 37.7822937509983 | -122.427349028504 | (37.7822937509983, -122.427349028504) | 7 | 9 | 11 | 28858 | 41 | ||
| 153348 | 12344 | DPW Maintained 1 | Tristania conferta :: 61 | 1200 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/16/1993 12:00:00 AM | 6 | 4X4 | 6004712.8065 | 2113066.0947 | 37.7823431328758 | -122.427359916847 | (37.7823431328758, -122.427359916847) | 7 | 9 | 11 | 28858 | 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 | ||||
| 159399 | 12350 | DPW Maintained 1 | Tristania conferta :: 61 | 1280 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/10/1997 12:00:00 AM | 3 | 4x4 | 6004697.5402 | 2113177.8166 | 37.7826490300917 | -122.427420692937 | (37.7826490300917, -122.427420692937) | 7 | 9 | 11 | 28858 | 41 | ||
| 175453 | 12359 | DPW Maintained 1 | Tristania conferta :: 61 | 1295X Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4X6 | 6004744.0331 | 2113287.4568 | 37.7829527043097 | -122.427267659807 | (37.7829527043097, -122.427267659807) | 7 | 9 | 11 | 28858 | 41 | |||
| 89751 | 12366 | DPW Maintained 1 | Tristania conferta :: 61 | 1314X Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/05/1990 12:00:00 AM | 6 | 3X3 | 6004530.405 | 2113308.3501 | 37.782997988422 | -122.428008214219 | (37.782997988422, -122.428008214219) | 7 | 9 | 11 | 29490 | 41 | ||
| 70061 | 12368 | DPW Maintained 1 | Tristania conferta :: 61 | 1325 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/02/1991 12:00:00 AM | 18 | 3X3 | 6004615.633 | 2113432.0006 | 37.7833423233744 | -122.42772217323 | (37.7833423233744, -122.42772217323) | 7 | 9 | 11 | 29490 | 41 | ||
| 163692 | 12987 | DPW Maintained 1 | Tristania conferta :: 61 | 318 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2006 12:00:00 AM | 3 | 3X3 | 6010766.7048 | 2120702.1725 | 37.8036504876245 | -122.406954379692 | (37.8036504876245, -122.406954379692) | 3 | 1 | 10 | 308 | 23 | ||
| 75752 | 13092 | DPW Maintained 1 | Tristania conferta :: 61 | 1447 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/18/2005 12:00:00 AM | 8 | 3x3 | 6005407.9937 | 2119875.0129 | 37.8010780038521 | -122.425439586315 | (37.8010780038521, -122.425439586315) | 13 | 9 | 1 | 57 | 17 | ||
| 191173 | 13094 | DPW Maintained 1 | Tristania conferta :: 61 | 1450 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/13/1995 12:00:00 AM | 12 | 3X3 | 6005349.3555 | 2119944.5969 | 37.801265750478 | -122.425647455227 | (37.801265750478, -122.425647455227) | 13 | 9 | 1 | 57 | 17 | ||
| 103234 | 13098 | DPW Maintained 1 | Tristania conferta :: 61 | 1488 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/1997 12:00:00 AM | 30 | 3X3 | 6005248.4978 | 2119934.433 | 37.8012321434749 | -122.425995743515 | (37.8012321434749, -122.425995743515) | 13 | 9 | 1 | 57 | 17 |
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) );