Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, PlantDate, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker ▼ | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2734 | 2734 | 253182 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 5157 Diamond Heights Blvd | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6000788.0 | 2100195.0 | 37.7467795353698 | -122.44001478039101 | (37.7467795353698, -122.440014780391) | |||||
| 2736 | 2736 | 253183 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 5159 Diamond Heights Blvd | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6000808.0 | 2099903.0 | 37.745978911495 | -122.439924689335 | (37.745978911495, -122.439924689335) | |||||
| 3804 | 3804 | 253558 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1240 Wisconsin St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6012830.0 | 2101639.0 | 37.7514226163546 | -122.39847574638901 | (37.7514226163546, -122.398475746389) | |||||
| 4283 | 4283 | 253621 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 200x Montcalm St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6010036.0 | 2099760.0 | 37.7461072494139 | -122.40800527847799 | (37.7461072494139, -122.408005278478) | ||||
| 7555 | 7555 | 107448 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1111x Chestnut St | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 50 | 6006408.68895 | 2120404.8626200003 | 37.80258932431129 | -122.42201440535801 | (37.8025893243113, -122.422014405358) | ||||
| 8668 | 8668 | 107450 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1140x Chestnut St | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 60 | 6006380.05181 | 2120425.48408 | 37.802644330436394 | -122.42211497023399 | (37.8026443304364, -122.422114970234) | ||||
| 10103 | 10103 | 173844 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 2X Crestline Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5999319.0 | 2101169.0 | 37.7493701671822 | -122.445164434644 | (37.7493701671822, -122.445164434644) | |||||
| 23412 | 23412 | 194471 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 84 Whitney Young Cir | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6016756.75905 | 2095047.7627400002 | 37.733542392957794 | -122.38443738208001 | (37.7335423929578, -122.38443738208) | ||||
| 23763 | 23763 | 194461 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 2000 25th St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | 6012563.257130001 | 2101880.94422 | 37.7520720792617 | -122.399415164477 | (37.7520720792617, -122.399415164477) | ||||
| 23919 | 23919 | 194457 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 2001 25th St | 32 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | 6012708.71911 | 2101842.22219 | 37.7519738634013 | -122.398909414543 | (37.7519738634013, -122.398909414543) | ||||
| 24477 | 24477 | 201741 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 727 Jamestown Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 6015551.73985 | 2087509.47398 | 37.7127770280164 | -122.388077638997 | (37.7127770280164, -122.388077638997) | |||
| 24492 | 24492 | 184737 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1301 Sunset Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984694.2473 | 2106265.1087 | 37.76251705685429 | -122.49611233651699 | (37.7625170568543, -122.496112336517) | |||
| 24643 | 24643 | 184784 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1301 Sunset Blvd | 45 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984713.613 | 2105863.1758 | 37.7614145960538 | -122.496015705201 | (37.7614145960538, -122.496015705201) | |||
| 25773 | 25773 | 186433 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1601 Sunset Blvd | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 0ft | 5984738.4307 | 2104031.9087 | 37.7563879005336 | -122.495794783817 | (37.7563879005336, -122.495794783817) | |||
| 26646 | 26646 | 107449 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1130x CHESTNUT ST | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 60 | 6006351.9 | 2120450.9 | 37.802712528214705 | -122.42221419659701 | (37.8027125282147, -122.422214196597) | ||||
| 26883 | 26883 | 194468 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1901 Quint St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6012422.70585 | 2095229.76642 | 37.7338015236278 | -122.39943431646401 | (37.7338015236278, -122.399434316464) | |||
| 27015 | 27015 | 201772 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 724 Jamestown Ave | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 8ft | 6015630.59439 | 2087639.5462599997 | 37.7131385500726 | -122.38781416009199 | (37.7131385500726, -122.387814160092) | |||
| 27691 | 27691 | 201795 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 724 Jamestown Ave | 43 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 8ft | 6015420.28917 | 2088209.0342599999 | 37.7146906018698 | -122.388580780005 | (37.7146906018698, -122.388580780005) | |||
| 27943 | 27943 | 201789 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 724 Jamestown Ave | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 8ft | 6015483.8795300005 | 2088094.9602400002 | 37.7143809005356 | -122.388353026664 | (37.7143809005356, -122.388353026664) | |||
| 28201 | 28201 | 234514 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 998 York St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 7ft | 6009944.54234 | 2103430.26244 | 37.7561798559202 | -122.408580392894 | (37.7561798559202, -122.408580392894) | |||
| 29087 | 29087 | 194467 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1901 Quint St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 6012416.6749 | 2095223.9720599998 | 37.7337852773717 | -122.399454760738 | (37.7337852773717, -122.399454760738) | |||
| 29459 | 29459 | 187394 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 2100 Sunset Blvd | 47 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 0ft | 5985039.81 | 2100667.7899 | 37.7471685994587 | -122.494504537591 | (37.7471685994587, -122.494504537591) | |||
| 29585 | 29585 | 201739 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 727 Jamestown Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 8ft | 6015537.38953 | 2087630.70495 | 37.713109109879206 | -122.38813569381901 | (37.7131091098792, -122.388135693819) | |||
| 30720 | 30720 | 201784 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 724 Jamestown Ave | 32 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 8ft | 6015541.73553 | 2087974.1397799999 | 37.714052356604704 | -122.38814462500099 | (37.7140523566047, -122.388144625001) | |||
| 31124 | 31124 | 184781 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1301 Sunset Blvd | 42 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984718.1696 | 2105899.6288 | 37.761514952666396 | -122.496002635394 | (37.7615149526664, -122.496002635394) | |||
| 31179 | 31179 | 186593 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1501 Sunset Blvd | 64 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984773.0801 | 2104494.2844 | 37.7576594849516 | -122.495709060541 | (37.7576594849516, -122.495709060541) | |||
| 32079 | 32079 | 211081 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 90 Melrose Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 8ft | 5999513.42858 | 2095531.7988099998 | 37.73390285471879 | -122.44408709224899 | (37.7339028547188, -122.444087092249) | |||
| 32213 | 32213 | 234524 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 671 Church St | 22 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | Width 3ft | 6004318.84944 | 2105025.5422900002 | 37.7602434426069 | -122.4281496397 | (37.7602434426069, -122.4281496397) | |||
| 32941 | 32941 | 119052 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 539 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5982216.76848 | 2112075.96454 | 37.7783265569214 | -122.50511154623399 | (37.7783265569214, -122.505111546234) | |||
| 33579 | 33579 | 185295 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 2601 Sunset Blvd | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984962.8666 | 2097355.3585 | 37.7380690548117 | -122.49452644909701 | (37.7380690548117, -122.494526449097) | |||
| 33959 | 33959 | 201774 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 724 Jamestown Ave | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 8ft | 6015625.88693 | 2087662.37118 | 37.713200962139794 | -122.38783202245001 | (37.7132009621398, -122.38783202245) | |||
| 34118 | 34118 | 185363 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 2601 Sunset Blvd | 88 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 43 | Width 0ft | 5984980.3483 | 2096870.9998 | 37.7367401586853 | -122.49443031260901 | (37.7367401586853, -122.494430312609) | |||
| 34594 | 34594 | 211059 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 2088 15th Ave | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 16 | Width 6ft | 5991648.13538 | 2101268.0455099996 | 37.749201292209996 | -122.47169742662201 | (37.74920129221, -122.471697426622) | |||
| 35494 | 35494 | 201763 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 724 Jamestown Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 8ft | 6015661.0546 | 2087420.2073 | 37.7125379747236 | -122.38769358441601 | (37.7125379747236, -122.387693584416) | |||
| 35598 | 35598 | 187095 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 2600 Sunset Blvd | 31 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5985178.0339 | 2097175.5923 | 37.7375880557056 | -122.49376927619801 | (37.7375880557056, -122.493769276198) | |||
| 36339 | 36339 | 194446 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1501 25th St | 16 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 6014162.91853 | 2101954.38506 | 37.7523627617528 | -122.393888395238 | (37.7523627617528, -122.393888395238) | ||||
| 37534 | 37534 | 201742 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 727 Jamestown Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 8ft | 6015557.23057 | 2087482.7730299998 | 37.712704016543796 | -122.388056798998 | (37.7127040165438, -122.388056798998) | |||
| 37786 | 37786 | 201746 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 727 Jamestown Ave | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 8ft | 6015580.416230001 | 2087372.51377 | 37.7124025503214 | -122.387968972099 | (37.7124025503214, -122.387968972099) | |||
| 38312 | 38312 | 201756 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 724 Jamestown Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 8ft | 6015765.334969999 | 2087252.1296299999 | 37.7120822414633 | -122.38732143863899 | (37.7120822414633, -122.387321438639) | |||
| 38837 | 38837 | 201733 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 727 Jamestown Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 8ft | 6015510.4184 | 2087766.77172 | 37.7134812286504 | -122.388238406274 | (37.7134812286504, -122.388238406274) | |||
| 39509 | 39509 | 194455 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1501 22nd St | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6013406.26386 | 2103790.51305 | 37.757362292666 | -122.396633751156 | (37.757362292666, -122.396633751156) | ||||
| 39924 | 39924 | 247143 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 500 27th St | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 26 | 6003160.527980001 | 2100099.92491 | 37.746653258353604 | -122.43180402765499 | (37.7466532583536, -122.431804027655) | ||||
| 40120 | 40120 | 201738 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 727 Jamestown Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 6015533.66415 | 2087659.5142599999 | 37.7131880082953 | -122.38815057938601 | (37.7131880082953, -122.388150579386) | |||
| 40566 | 40566 | 141265 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 52 JORDAN AVE | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 0ft | 5996227.2891 | 2114192.1724 | 37.7849514808139 | -122.45679734575899 | (37.7849514808139, -122.456797345759) | |||
| 41624 | 41624 | 185204 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 2500 Sunset Blvd | 57 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 0ft | 5985139.3342 | 2097991.4603 | 37.739825946299895 | -122.49396318779199 | (37.7398259462999, -122.493963187792) | |||
| 41772 | 41772 | 194456 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1501 22nd St | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6013384.43791 | 2103815.09856 | 37.757428584386794 | -122.396710957944 | (37.7574285843868, -122.396710957944) | ||||
| 42302 | 42302 | 247896 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 351 Mayflower St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 29 | Width 5ft | 6010145.43386 | 2098385.46575 | 37.7423392041921 | -122.407529975731 | (37.7423392041921, -122.407529975731) | |||
| 42475 | 42475 | 186097 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1901 Sunset Blvd | 43 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 0ft | 5984866.2826 | 2101735.8043 | 37.7500909175156 | -122.495183318527 | (37.7500909175156, -122.495183318527) | |||
| 42770 | 42770 | 201783 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 724 Jamestown Ave | 31 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 8ft | 6015549.05195 | 2087952.54872 | 37.71399347708579 | -122.388117830599 | (37.7139934770858, -122.388117830599) | |||
| 43003 | 43003 | 186702 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1401 Sunset Blvd | 59 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 0ft | 5984718.4366 | 2105146.0279 | 37.759445790880704 | -122.49594611618099 | (37.7594457908807, -122.495946116181) | |||
| 43082 | 43082 | 201788 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 724 Jamestown Ave | 36 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 8ft | 6015494.63123 | 2088072.87111 | 37.7143208438162 | -122.388314323455 | (37.7143208438162, -122.388314323455) | |||
| 43614 | 43614 | 201769 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 724 Jamestown Ave | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 8ft | 6015636.77799 | 2087561.79601 | 37.712925405365894 | -122.387787365691 | (37.7129254053659, -122.387787365691) | |||
| 44453 | 44453 | 201779 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 724 Jamestown Ave | 27 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 8ft | 6015589.3271 | 2087835.5136400003 | 37.7136743526627 | -122.387970461377 | (37.7136743526627, -122.387970461377) | |||
| 46160 | 46160 | 178178 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 769 Cayuga Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 6001369.37887 | 2092541.7115 | 37.725798463024 | -122.43745647446 | (37.725798463024, -122.43745647446) | |||
| 46377 | 46377 | 132179 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1302 Columbus Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 33 | 6007259.6989400005 | 2121860.7667900003 | 37.806634826503604 | -122.419172811197 | (37.8066348265036, -122.419172811197) | ||||
| 47337 | 47337 | 132178 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 2449 Mason St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | 6008741.74811 | 2122071.6365799997 | 37.807297172691 | -122.41405880917101 | (37.807297172691, -122.414058809171) | ||||
| 47813 | 47813 | 194447 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 680 De Haro St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 6012074.2081699995 | 2105270.47212 | 37.761351707727 | -122.401344555627 | (37.761351707727, -122.401344555627) | ||||
| 48068 | 48068 | 186902 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 2700 Sunset Blvd | 51 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 0ft | 5985182.8419 | 2096662.3766 | 37.7361791837873 | -122.49371484567101 | (37.7361791837873, -122.493714845671) | |||
| 48087 | 48087 | 186595 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1501 Sunset Blvd | 66 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984740.8383 | 2104479.6291 | 37.757617357388504 | -122.49581948315 | (37.7576173573885, -122.49581948315) | |||
| 48500 | 48500 | 234512 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1300 San Jose Ave | 61 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 6ft | 6003219.80457 | 2095456.8072099998 | 37.7339076867834 | -122.431267680974 | (37.7339076867834, -122.431267680974) | |||
| 48590 | 48590 | 185705 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 2101 Sunset Blvd | 38 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984891.1634 | 2100474.9689 | 37.7466304646766 | -122.495004322509 | (37.7466304646766, -122.495004322509) | |||
| 48907 | 48907 | 194437 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1021 Minnesota St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 6015301.57899 | 2103740.56291 | 37.757330441350796 | -122.39007545771099 | (37.7573304413508, -122.390075457711) | |||
| 48957 | 48957 | 201749 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 491 Jamestown Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | Width 8ft | 6015821.034469999 | 2087045.57383 | 37.711518163305705 | -122.387114525336 | (37.7115181633057, -122.387114525336) | |||
| 49957 | 49957 | 121696 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1300x De Haro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6012218.0 | 2102254.0 | 37.7530771598286 | -122.400635326689 | (37.7530771598286, -122.400635326689) | ||||
| 50595 | 50595 | 211057 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 447 Lawton St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 3ft | 5992810.26786 | 2104540.37946 | 37.7582534434534 | -122.467916772063 | (37.7582534434534, -122.467916772063) | |||
| 50718 | 50718 | 234502 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 3502 24th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6006115.28896 | 2102029.42996 | 37.75211829094879 | -122.421723779538 | (37.7521182909488, -122.421723779538) | ||||
| 51290 | 51290 | 201775 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 724 Jamestown Ave | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 8ft | 6015614.36786 | 2087706.44647 | 37.713321346286605 | -122.38787491019501 | (37.7133213462866, -122.387874910195) | |||
| 51377 | 51377 | 186343 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1801 Sunset Blvd | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 0ft | 5984811.8118 | 2102790.6052 | 37.7529839215525 | -122.495449463877 | (37.7529839215525, -122.495449463877) | |||
| 52025 | 52025 | 201793 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 724 Jamestown Ave | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 8ft | 6015446.06267 | 2088163.05451 | 37.7145657786635 | -122.388488487967 | (37.7145657786635, -122.388488487967) | |||
| 52505 | 52505 | 201768 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 724 Jamestown Ave | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 8ft | 6015641.02933 | 2087537.69345 | 37.7128594598683 | -122.387770990859 | (37.7128594598683, -122.387770990859) | |||
| 52527 | 52527 | 201734 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 727 Jamestown Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 8ft | 6015517.44938 | 2087731.0337099999 | 37.71338348853 | -122.388211611887 | (37.71338348853, -122.388211611887) | |||
| 52628 | 52628 | 185362 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 2601 Sunset Blvd | 87 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984999.1909 | 2096870.1623 | 37.7367389618664 | -122.494365104774 | (37.7367389618664, -122.494365104774) | |||
| 52904 | 52904 | 186688 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1401 Sunset Blvd | 45 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984691.4289 | 2105282.7412 | 37.759819585598294 | -122.49604960675501 | (37.7598195855983, -122.496049606755) | |||
| 53163 | 53163 | 234510 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1101 San Jose Ave | 20 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6004874.945590001 | 2096454.6329400002 | 37.7367411519672 | -122.42561634482901 | (37.7367411519672, -122.425616344829) | ||||
| 53419 | 53419 | 186531 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1501 Sunset Blvd | 2 | unknown : Yard 19 | Tree 1 | Private 1 | 9 | Width 0ft | 5984751.3064 | 2104919.289 | 37.7588251541556 | -122.49581571217699 | (37.7588251541556, -122.495815712177) | |||
| 54562 | 54562 | 201750 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 491 Jamestown Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 34 | Width 8ft | 6015853.10494 | 2087012.76113 | 37.7114298417752 | -122.3870013933 | (37.7114298417752, -122.3870013933) | |||
| 56943 | 56943 | 186594 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1501 Sunset Blvd | 65 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 0ft | 5984719.4834 | 2104488.841 | 37.7576414000341 | -122.495894015518 | (37.7576414000341, -122.495894015518) | |||
| 56959 | 56959 | 186253 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1701 Sunset Blvd | 64 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984779.1353 | 2103090.988 | 37.753806776442396 | -122.495584617514 | (37.7538067764424, -122.495584617514) | |||
| 57218 | 57218 | 211082 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 843 Detroit St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 5ft | 5999417.62854 | 2095618.0089599998 | 37.7341341018996 | -122.444424494503 | (37.7341341018996, -122.444424494503) | |||
| 58202 | 58202 | 247072 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 2401 Castro St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 6002777.3490699995 | 2098440.5181299997 | 37.7420751857223 | -122.433010482565 | (37.7420751857223, -122.433010482565) | ||||
| 58515 | 58515 | 201761 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 724 Jamestown Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 8ft | 6015680.02756 | 2087378.6526400002 | 37.7124249245429 | -122.38762511002199 | (37.7124249245429, -122.387625110022) | |||
| 58801 | 58801 | 247910 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 399 Franconia St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 6009965.37797 | 2098759.5657599997 | 37.7433563212371 | -122.408178935533 | (37.7433563212371, -122.408178935533) | ||||
| 59541 | 59541 | 201777 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 724 Jamestown Ave | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 8ft | 6015601.56547 | 2087780.3718 | 37.713523621788895 | -122.387924315354 | (37.7135236217889, -122.387924315354) | |||
| 60219 | 60219 | 246698 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1 Bonview St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 6007671.81678 | 2099058.43431 | 37.7440482560225 | -122.41613066549401 | (37.7440482560225, -122.416130665494) | ||||
| 61413 | 61413 | 201732 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 727 Jamestown Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 6015480.18133 | 2087865.40702 | 37.713750386735 | -122.388349797223 | (37.713750386735, -122.388349797223) | |||
| 61525 | 61525 | 185176 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 2500 Sunset Blvd | 28 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 0ft | 5985156.5992 | 2097794.2406 | 37.739285444120604 | -122.493888963204 | (37.7392854441206, -122.493888963204) | |||
| 61731 | 61731 | 187396 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 2100 Sunset Blvd | 49 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 0ft | 5985054.0302 | 2100695.3416 | 37.74724508117 | -122.494457396667 | (37.74724508117, -122.494457396667) | |||
| 61933 | 61933 | 132181 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1302 Columbus Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | 6007227.55341 | 2121889.28804 | 37.8067113282286 | -122.41928608168699 | (37.8067113282286, -122.419286081687) | ||||
| 62069 | 62069 | 194453 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 2250 26th St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 6011877.75436 | 2101392.1938 | 37.750691845665 | -122.401751398122 | (37.750691845665, -122.401751398122) | ||||
| 62522 | 62522 | 201754 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 724 Jamestown Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 8ft | 6015794.331180001 | 2087216.37677 | 37.7119856767735 | -122.387218726159 | (37.7119856767735, -122.387218726159) | |||
| 62668 | 62668 | 194458 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 2001 25th St | 33 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | 6012757.94703 | 2101850.0059 | 37.751997978722294 | -122.39873972236799 | (37.7519979787223, -122.398739722368) | ||||
| 63101 | 63101 | 184993 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 2701 Sunset Blvd | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 29 | Width 0ft | 5985021.3833 | 2096558.6319 | 37.7358848813643 | -122.49426542142099 | (37.7358848813643, -122.494265421421) | |||
| 63165 | 63165 | 247144 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 500 27th St | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6003151.94767 | 2100099.93337 | 37.7466527951889 | -122.43183369806499 | (37.7466527951889, -122.431833698065) | ||||
| 64115 | 64115 | 186098 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1901 Sunset Blvd | 44 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 0ft | 5984859.9858 | 2101721.9514 | 37.750052512593705 | -122.495204071455 | (37.7500525125937, -122.495204071455) | |||
| 64746 | 64746 | 218299 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1 Ardenwood Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 8ft | 5991311.902419999 | 2096390.21304 | 37.7357885567818 | -122.472504543874 | (37.7357885567818, -122.472504543874) | |||
| 65021 | 65021 | 234509 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1101 San Jose Ave | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6004750.382069999 | 2096347.4513299998 | 37.7364398161369 | -122.42603938772699 | (37.7364398161369, -122.426039387727) | ||||
| 65116 | 65116 | 194454 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1301 Rhode Island St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6012013.85217 | 2102295.56099 | 37.753179889343 | -122.40134423455 | (37.753179889343, -122.40134423455) | |||
| 66554 | 66554 | 185075 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 2801 Sunset Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985040.8539 | 2096108.9226 | 37.7346512389504 | -122.494164969235 | (37.7346512389504, -122.494164969235) | |||
| 66730 | 66730 | 132173 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 91 Mayfair Dr | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 6ft | 5997717.35609 | 2114490.42899 | 37.7858558611085 | -122.45166373928998 | (37.7858558611085, -122.45166373929) | |||
| 67533 | 67533 | 234513 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 998 York St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 7ft | 6009942.57021 | 2103461.5506 | 37.7562656557487 | -122.408589420289 | (37.7562656557487, -122.408589420289) |
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");