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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 189058 | 189058 | 200839 | Undocumented 2 | Tristania conferta :: 79 | 1499 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6012131.3311 | 2106987.3608 | 37.7660690877931 | -122.40126764344 | (37.7660690877931, -122.40126764344) | |||
| 188947 | 188947 | 140139 | Undocumented 2 | Tristania conferta :: 79 | 1744 FELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5999035.8387 | 2109765.9757 | 37.7729591530651 | -122.44676211071501 | (37.7729591530651, -122.446762110715) | |||
| 188839 | 188839 | 140039 | Undocumented 2 | Tristania conferta :: 79 | 555 GOUGH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6005821.2941 | 2111685.5479 | 37.7786151184258 | -122.423426859428 | (37.7786151184258, -122.423426859428) | |||
| 188805 | 188805 | 142089 | Undocumented 2 | Tristania conferta :: 79 | 1240 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6001887.8568 | 2110510.0284 | 37.775164645879606 | -122.436949929204 | (37.7751646458796, -122.436949929204) | |||
| 188790 | 188790 | 199674 | Undocumented 2 | Tristania conferta :: 79 | 1453 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6015501.9906 | 2093353.6888 | 37.7288213408036 | -122.388657298244 | (37.7288213408036, -122.388657298244) | |||
| 188583 | 188583 | 143113 | Undocumented 2 | Tristania conferta :: 79 | 2775 VAN NESS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6005458.8135 | 2119882.0495 | 37.8011001957164 | -122.425264228759 | (37.8011001957164, -122.425264228759) | |||
| 188566 | 188566 | 141403 | Undocumented 2 | Tristania conferta :: 79 | 637 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6004926.4763 | 2111150.5659 | 37.777095644253 | -122.426484277073 | (37.777095644253, -122.426484277073) | |||
| 188411 | 188411 | 199797 | Undocumented 2 | Tristania conferta :: 79 | 2655 Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6015107.7412 | 2091052.6667 | 37.7224813341695 | -122.389859594082 | (37.7224813341695, -122.389859594082) | |||
| 188299 | 188299 | 244978 | Undocumented 2 | Tristania conferta :: 79 | 768 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6002882.0692 | 2109605.9159 | 37.7727386350951 | -122.43344610618799 | (37.7727386350951, -122.433446106188) | |||
| 188298 | 188298 | 245889 | Undocumented 2 | Tristania conferta :: 79 | 208 Broderick St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6001301.3376 | 2109508.5838 | 37.7723815763595 | -122.438907043703 | (37.7723815763595, -122.438907043703) | |||
| 188054 | 188054 | 200154 | Undocumented 2 | Tristania conferta :: 79 | 3101 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6014306.6335 | 2089979.6268 | 37.7194905204176 | -122.392553840565 | (37.7194905204176, -122.392553840565) | |||
| 188026 | 188026 | 142069 | Undocumented 2 | Tristania conferta :: 79 | 1000 WEBSTER ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6003891.204 | 2112315.3287 | 37.780235215595106 | -122.43014872170099 | (37.7802352155951, -122.430148721701) | |||
| 187723 | 187723 | 141067 | Undocumented 2 | Tristania conferta :: 79 | 516 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5997555.0871 | 2112560.1333 | 37.780546483262796 | -122.452085820488 | (37.7805464832628, -122.452085820488) | |||
| 187473 | 187473 | 60579 | Permitted Site 1 | Tristania conferta :: 79 | 556 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/07/1983 12:00:00 AM | 13 | Permit Number 20193 | 6000143.5821 | 2110857.5211 | 37.7760194779825 | -122.443008707696 | (37.7760194779825, -122.443008707696) | |
| 187395 | 187395 | 248567 | Undocumented 2 | Tristania conferta :: 79 | 809 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5997620.5658 | 2107720.8482 | 37.7672628081675 | -122.451510146252 | (37.7672628081675, -122.451510146252) | |||
| 187341 | 187341 | 138720 | Undocumented 2 | Tristania conferta :: 79 | 2921 PINE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999959.1608 | 2114707.5789 | 37.7865802293131 | -122.44392335178699 | (37.7865802293131, -122.443923351787) | |||
| 187235 | 187235 | 143123 | Undocumented 2 | Tristania conferta :: 79 | 1999 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6002882.226 | 2119527.3787 | 37.799980462636796 | -122.4341549557 | (37.7999804626368, -122.4341549557) | |||
| 187133 | 187133 | 143427 | Undocumented 2 | Tristania conferta :: 79 | 855 SACRAMENTO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6010650.0101 | 2116903.247 | 37.793213033950295 | -122.407090272453 | (37.7932130339503, -122.407090272453) | |||
| 187040 | 187040 | 142268 | Undocumented 2 | Tristania conferta :: 79 | 528 FELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6004872.8761 | 2110588.727 | 37.7755499418264 | -122.426629679114 | (37.7755499418264, -122.426629679114) | |||
| 187004 | 187004 | 245021 | Undocumented 2 | Tristania conferta :: 79 | 291 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6001235.6925 | 2109653.6678 | 37.77277620562229 | -122.439144516103 | (37.7727762056223, -122.439144516103) | |||
| 186949 | 186949 | 138921 | Undocumented 2 | Tristania conferta :: 79 | 631 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6004505.2517 | 2110712.7569999998 | 37.775869707435795 | -122.427910221054 | (37.7758697074358, -122.427910221054) | |||
| 186887 | 186887 | 141089 | DPW Maintained 3 | Tristania conferta :: 79 | 100x JORDAN AVE | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 5996248.2713 | 2112978.5918 | 37.7816205163369 | -122.456636959709 | (37.7816205163369, -122.456636959709) | |||
| 186876 | 186876 | 47069 | Permitted Site 1 | Tristania conferta :: 79 | 606 Webster St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2002 12:00:00 AM | 5 | Permit Number 45052 | 6004039.0188 | 2110889.0487 | 37.7763273741764 | -122.429535615559 | (37.7763273741764, -122.429535615559) | ||
| 186800 | 186800 | 141815 | Undocumented 2 | Tristania conferta :: 79 | 1208 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6004606.1862 | 2112977.4993 | 37.7820938412857 | -122.427722461693 | (37.7820938412857, -122.427722461693) | |||
| 186678 | 186678 | 57326 | Permitted Site 1 | Tristania conferta :: 79 | 750 Presidio Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/31/1976 12:00:00 AM | 14 | Permit Number 16154 | 5999289.2953 | 2113999.1058 | 37.78459671384079 | -122.446189932846 | (37.7845967138408, -122.446189932846) | ||
| 186664 | 186664 | 199655 | Undocumented 2 | Tristania conferta :: 79 | 2798 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6014883.1348 | 2090822.9118 | 37.721838014236205 | -122.39061996667299 | (37.7218380142362, -122.390619966673) | |||
| 186172 | 186172 | 141883 | Undocumented 2 | Tristania conferta :: 79 | 1170 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6003827.7304 | 2112761.2344 | 37.7814559664057 | -122.430400129926 | (37.7814559664057, -122.430400129926) | |||
| 186027 | 186027 | 137775 | Undocumented 2 | Tristania conferta :: 79 | 1773 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6001023.8513 | 2111726.3554 | 37.778455226526496 | -122.44002594543801 | (37.7784552265265, -122.440025945438) | |||
| 185983 | 185983 | 137841 | Undocumented 2 | Tristania conferta :: 79 | 1800X Pine St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005085.0 | 2115443.0 | 37.7888905662133 | -122.42624156812799 | (37.7888905662133, -122.426241568128) | |||
| 185978 | 185978 | 138909 | Undocumented 2 | Tristania conferta :: 79 | 727 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6004219.3061 | 2110788.4288 | 37.776061302871 | -122.428904776437 | (37.776061302871, -122.428904776437) | |||
| 185914 | 185914 | 200660 | Undocumented 2 | Tristania conferta :: 79 | 1528 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6015206.7042 | 2095389.6827 | 37.7343954004192 | -122.38982028647301 | (37.7343954004192, -122.389820286473) | |||
| 185860 | 185860 | 138220 | Undocumented 2 | Tristania conferta :: 79 | 101 Anza St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5998691.3383 | 2112654.3837 | 37.78087029103521 | -122.448161793593 | (37.7808702910352, -122.448161793593) | |||
| 185733 | 185733 | 138245 | Undocumented 2 | Tristania conferta :: 79 | 750 PRESIDIO AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5999284.3395 | 2114037.2657 | 37.7847012079666 | -122.446209824081 | (37.7847012079666, -122.446209824081) | |||
| 185607 | 185607 | 244201 | Undocumented 2 | Tristania conferta :: 79 | 430 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6003695.9951 | 2109871.7153 | 37.7735145992495 | -122.430649617684 | (37.7735145992495, -122.430649617684) | |||
| 185606 | 185606 | 200664 | Undocumented 2 | Tristania conferta :: 79 | 1599 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6015245.1771 | 2095641.9548 | 37.73509022188 | -122.389704886034 | (37.73509022188, -122.389704886034) | |||
| 185318 | 185318 | 141976 | Undocumented 2 | Tristania conferta :: 79 | 632 FULTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6004632.3853 | 2111592.8247 | 37.7782933487801 | -122.427533145885 | (37.7782933487801, -122.427533145885) | |||
| 185112 | 185112 | 248420 | Undocumented 2 | Tristania conferta :: 79 | 125 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5998231.8263 | 2108050.4777 | 37.7682028717047 | -122.449419646794 | (37.7682028717047, -122.449419646794) | |||
| 185022 | 185022 | 245022 | Undocumented 2 | Tristania conferta :: 79 | 291 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6001243.6696 | 2109607.4669999997 | 37.7726498036991 | -122.43911361061599 | (37.7726498036991, -122.439113610616) | |||
| 184917 | 184917 | 73913 | Undocumented 2 | Tristania conferta :: 79 | 499 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/07/1995 12:00:00 AM | 8 | 6005876.1258 | 2111280.7378 | 37.7775067029674 | -122.42320839254299 | (37.7775067029674, -122.423208392543) | ||
| 184884 | 184884 | 142253 | Undocumented 2 | Tristania conferta :: 79 | 426 FELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6005407.8401 | 2110658.7444 | 37.7757724220835 | -122.424784089799 | (37.7757724220835, -122.424784089799) | |||
| 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) | |||
| 184635 | 184635 | 140041 | Undocumented 2 | Tristania conferta :: 79 | 900 SCOTT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6001999.2915 | 2111605.9788 | 37.7781801839393 | -122.436642916889 | (37.7781801839393, -122.436642916889) | |||
| 184619 | 184619 | 199796 | Undocumented 2 | Tristania conferta :: 79 | 2655 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6015085.8598 | 2091024.3496 | 37.7224023675174 | -122.389933256672 | (37.7224023675174, -122.389933256672) | |||
| 184556 | 184556 | 140550 | Undocumented 2 | Tristania conferta :: 79 | 1395 GOLDEN GATE AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6002973.9945 | 2112001.0188 | 37.779320207761295 | -122.433299302556 | (37.7793202077613, -122.433299302556) | |||
| 184369 | 184369 | 248527 | Undocumented 2 | Tristania conferta :: 79 | 65 Beulah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5997684.7656 | 2107798.3724 | 37.7674793460156 | -122.451293681226 | (37.7674793460156, -122.451293681226) | |||
| 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) | |||
| 183934 | 183934 | 139854 | Undocumented 2 | Tristania conferta :: 79 | 715 GOUGH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6005760.424 | 2112155.9925 | 37.779903408702204 | -122.423670890236 | (37.7799034087022, -122.423670890236) | |||
| 183794 | 183794 | 139974 | Undocumented 2 | Tristania conferta :: 79 | 1000 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6001954.9936 | 2111926.8615 | 37.77905872955721 | -122.436819135829 | (37.7790587295572, -122.436819135829) | |||
| 183708 | 183708 | 200930 | Undocumented 2 | Tristania conferta :: 79 | 4101 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6015555.39 | 2097392.3592 | 37.7399136731123 | -122.388754515291 | (37.7399136731123, -122.388754515291) | |||
| 183579 | 183579 | 140399 | Undocumented 2 | Tristania conferta :: 79 | 650 WILLOW ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6004395.7092 | 2113101.266 | 37.78242176565279 | -122.42845944123002 | (37.7824217656528, -122.42845944123) | |||
| 183512 | 183512 | 140502 | Undocumented 2 | Tristania conferta :: 79 | 951 Webster St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6003839.6233 | 2111973.5622 | 37.7792938881307 | -122.430302772663 | (37.7792938881307, -122.430302772663) | |||
| 183481 | 183481 | 140700 | Undocumented 2 | Tristania conferta :: 79 | 1974 FELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5997993.0611 | 2109621.9987 | 37.772504204998704 | -122.450358806984 | (37.7725042049987, -122.450358806984) | |||
| 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) | ||
| 183290 | 183290 | 199659 | Undocumented 2 | Tristania conferta :: 79 | 2799 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6014895.3627 | 2090769.4954 | 37.7216920217337 | -122.39057396691003 | (37.7216920217337, -122.39057396691) | |||
| 183089 | 183089 | 142795 | Undocumented 2 | Tristania conferta :: 79 | 535 Larkin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6007556.7713 | 2113214.153 | 37.78291009800979 | -122.41753152702101 | (37.7829100980098, -122.417531527021) | |||
| 183030 | 183030 | 200510 | Undocumented 2 | Tristania conferta :: 79 | 5913 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6013756.9175 | 2091787.9175 | 37.7244251810597 | -122.394580579707 | (37.7244251810597, -122.394580579707) | |||
| 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) | |||
| 182734 | 182734 | 143433 | Undocumented 2 | Tristania conferta :: 79 | 855 SACRAMENTO ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6010770.5411 | 2116920.4657 | 37.7932670566772 | -122.406674439368 | (37.7932670566772, -122.406674439368) | |||
| 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) | |||
| 182555 | 182555 | 141979 | Undocumented 2 | Tristania conferta :: 79 | 672 FULTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6004485.6235 | 2111573.5862 | 37.7782322224867 | -122.428039477975 | (37.7782322224867, -122.428039477975) | |||
| 182541 | 182541 | 246101 | Undocumented 2 | Tristania conferta :: 79 | 1764 Waller St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5997168.442000001 | 2108117.5543 | 37.7683261602514 | -122.45310260948 | (37.7683261602514, -122.45310260948) | |||
| 182384 | 182384 | 246258 | Undocumented 2 | Tristania conferta :: 79 | 258 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6002882.0144 | 2106736.0778 | 37.764858759447996 | -122.433241197137 | (37.764858759448, -122.433241197137) | |||
| 182242 | 182242 | 138883 | Undocumented 2 | Tristania conferta :: 79 | 520 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6004085.5412 | 2110582.6752 | 37.7754887818854 | -122.42935282905 | (37.7754887818854, -122.42935282905) | |||
| 182078 | 182078 | 200666 | Undocumented 2 | Tristania conferta :: 79 | 1595 Newcomb Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6015285.2988 | 2095613.9245 | 37.7350154810982 | -122.38956421273701 | (37.7350154810982, -122.389564212737) | |||
| 181815 | 181815 | 54243 | Permitted Site 1 | Tristania conferta :: 79 | 35 Kittredge Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/1972 12:00:00 AM | 26 | Permit Number 9984 | 5997958.8776 | 2111479.5979 | 37.777602735942295 | -122.45061099973499 | (37.7776027359423, -122.450610999735) | ||
| 181779 | 181779 | 141845 | Undocumented 2 | Tristania conferta :: 79 | 1281 EDDY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6004367.3732 | 2112894.0986 | 37.7818513319307 | -122.428542699812 | (37.7818513319307, -122.428542699812) | |||
| 181635 | 181635 | 38378 | Permitted Site 1 | Tristania conferta :: 79 | 2027 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/1998 12:00:00 AM | 11 | Permit Number 40437 | 6009441.5117 | 2120654.7585 | 37.8034460574359 | -122.411536943543 | (37.8034460574359, -122.411536943543) | ||
| 181551 | 181551 | 143133 | Undocumented 2 | Tristania conferta :: 79 | 2447 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6000680.1362 | 2119221.2843 | 37.7990147823393 | -122.441753021456 | (37.7990147823393, -122.441753021456) | |||
| 181462 | 181462 | 246407 | Undocumented 2 | Tristania conferta :: 79 | 163 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6003546.5096 | 2107398.1602 | 37.7667143510574 | -122.430990136276 | (37.7667143510574, -122.430990136276) | |||
| 181419 | 181419 | 140040 | Undocumented 2 | Tristania conferta :: 79 | 555 GOUGH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6005823.3929 | 2111668.7573 | 37.778569133987105 | -122.423418404891 | (37.7785691339871, -122.423418404891) | |||
| 181354 | 181354 | 72411 | Undocumented 2 | Tristania conferta :: 79 | 475 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/1996 12:00:00 AM | 10 | 6x6 | 6010101.0381 | 2120567.585 | 37.803243672381704 | -122.40924846000601 | (37.8032436723817, -122.409248460006) | |
| 181304 | 181304 | 141664 | Undocumented 2 | Tristania conferta :: 79 | 1 MASONIC AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5998850.0581 | 2112402.9363 | 37.7801889538337 | -122.44759460079399 | (37.7801889538337, -122.447594600794) | |||
| 181244 | 181244 | 246025 | Undocumented 2 | Tristania conferta :: 79 | 1649 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5998236.9744 | 2108568.3154 | 37.7696250165914 | -122.449439156157 | (37.7696250165914, -122.449439156157) | |||
| 181211 | 181211 | 139775 | Undocumented 2 | Tristania conferta :: 79 | 1285 Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6004779.4233 | 2113293.0082 | 37.7829699484469 | -122.427145619841 | (37.7829699484469, -122.427145619841) | |||
| 180918 | 180918 | 246307 | Undocumented 2 | Tristania conferta :: 79 | 1601 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6007039.6773 | 2109281.1913 | 37.7720820221483 | -122.41904141057199 | (37.7720820221483, -122.419041410572) | |||
| 180469 | 180469 | 138222 | Undocumented 2 | Tristania conferta :: 79 | 101 Anza St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5998723.4884 | 2112655.399 | 37.780874916637295 | -122.44805064424999 | (37.7808749166373, -122.44805064425) | |||
| 180440 | 180440 | 184353 | Undocumented 2 | Tristania conferta :: 79 | 1251 Sunset Blvd | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 0ft | 5984679.818 | 2106506.8001 | 37.763179828394996 | -122.49618007420099 | (37.763179828395, -122.496180074201) | |||
| 180265 | 180265 | 141851 | Undocumented 2 | Tristania conferta :: 79 | 1201 EDDY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6004614.8407 | 2112929.9908 | 37.7819638842768 | -122.427689135074 | (37.7819638842768, -122.427689135074) | |||
| 180174 | 180174 | 141853 | Undocumented 2 | Tristania conferta :: 79 | 1165 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6004693.5517 | 2112865.7626 | 37.781791981577705 | -122.42741225416 | (37.7817919815777, -122.42741225416) | |||
| 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) | |||
| 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) | |||
| 179771 | 179771 | 244948 | Undocumented 2 | Tristania conferta :: 79 | 281 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6005970.7006 | 2110659.3821 | 37.7758059476355 | -122.422837056089 | (37.7758059476355, -122.422837056089) | |||
| 179733 | 179733 | 200187 | Undocumented 2 | Tristania conferta :: 79 | 2999 Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6014602.6431 | 2090373.0881 | 37.720587322073 | -122.391558129174 | (37.720587322073, -122.391558129174) | |||
| 179690 | 179690 | 141445 | Undocumented 2 | Tristania conferta :: 79 | 15 Roselyn Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5998201.2916 | 2111619.0821 | 37.7779995957614 | -122.449782466229 | (37.7779995957614, -122.449782466229) | |||
| 179537 | 179537 | 246241 | Undocumented 2 | Tristania conferta :: 79 | 1395 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5999547.9215 | 2107815.4823 | 37.7676328306769 | -122.444850527256 | (37.7676328306769, -122.444850527256) | |||
| 179514 | 179514 | 248512 | Undocumented 2 | Tristania conferta :: 79 | 19 Beulah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 5997839.8141 | 2107820.4790000003 | 37.767548921712496 | -122.450758985918 | (37.7675489217125, -122.450758985918) | |||
| 179350 | 179350 | 34684 | Permitted Site 1 | Tristania conferta :: 79 | 1863 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 4 | Permit Number 38349 | 6003454.9512 | 2119604.4954 | 37.800224693559606 | -122.43217862062099 | (37.8002246935596, -122.432178620621) | |
| 179187 | 179187 | 58330 | Permitted Site 1 | Tristania conferta :: 79 | 61 Roselyn Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/1978 12:00:00 AM | 15 | Permit Number 17355 | 5998228.2265 | 2111432.4618 | 37.777488725806705 | -122.44967583774799 | (37.7774887258067, -122.449675837748) | ||
| 179157 | 179157 | 142015 | Undocumented 2 | Tristania conferta :: 79 | 729 LAGUNA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6004892.0126 | 2111380.2661 | 37.7777243964127 | -122.42661985860701 | (37.7777243964127, -122.426619858607) | |||
| 179134 | 179134 | 139615 | Undocumented 2 | Tristania conferta :: 79 | 1865 EDDY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6001550.4861 | 2112499.8743 | 37.780609079666704 | -122.438259549585 | (37.7806090796667, -122.438259549585) | |||
| 178968 | 178968 | 245198 | Undocumented 2 | Tristania conferta :: 79 | 121 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6001307.2965 | 2109181.3655 | 37.7714834556733 | -122.438862978172 | (37.7714834556733, -122.438862978172) | |||
| 178943 | 178943 | 139935 | Undocumented 2 | Tristania conferta :: 79 | 800 GOUGH ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6005714.5324 | 2112478.1713 | 37.7807854422322 | -122.423852565408 | (37.7807854422322, -122.423852565408) | |||
| 178701 | 178701 | 139813 | Undocumented 2 | Tristania conferta :: 79 | 1624 EDDY ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6002704.9363 | 2112706.5853 | 37.7812422487992 | -122.434280542357 | (37.7812422487992, -122.434280542357) | |||
| 178622 | 178622 | 142366 | Undocumented 2 | Tristania conferta :: 79 | 1135 ELLIS ST | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6005560.2454 | 2113404.4098 | 37.7833199541216 | -122.424452221294 | (37.7833199541216, -122.424452221294) | |||
| 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) | |||
| 178563 | 178563 | 142367 | Undocumented 2 | Tristania conferta :: 79 | 1071 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6005589.4935 | 2113384.4680000003 | 37.7832668504733 | -122.42434961552799 | (37.7832668504733, -122.424349615528) | |||
| 178377 | 178377 | 137789 | Undocumented 2 | Tristania conferta :: 79 | 1711 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6005260.1426 | 2115739.9282 | 37.7897157547789 | -122.42565674016399 | (37.7897157547789, -122.425656740164) | |||
| 178361 | 178361 | 248530 | Undocumented 2 | Tristania conferta :: 79 | 35 Beulah St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5997722.0136 | 2107803.8234 | 37.7674964457612 | -122.45116523916799 | (37.7674964457612, -122.451165239168) | |||
| 178296 | 178296 | 59515 | Permitted Site 1 | Tristania conferta :: 79 | 1641 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/1981 12:00:00 AM | 11 | Permit Number 18893 | 5999949.9862 | 2110546.3657 | 37.7751540846206 | -122.44365604668998 | (37.7751540846206, -122.44365604669) | ||
| 178293 | 178293 | 142081 | Undocumented 2 | Tristania conferta :: 79 | 1593 FULTON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6000187.5461 | 2110918.9503 | 37.776190653467104 | -122.44286103728999 | (37.7761906534671, -122.44286103729) |
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");