Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▼ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 52388 | 52388 | 178914 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993788.47929 | 2086756.5816799998 | 37.7094799730978 | -122.463243292153 | (37.7094799730978, -122.463243292153) | ||||
| 66527 | 66527 | 178915 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993789.8911 | 2086758.89685 | 37.70948641134179 | -122.46323858062 | (37.7094864113418, -122.46323858062) | ||||
| 65590 | 65590 | 178916 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993790.44094 | 2086761.47706 | 37.7094935276652 | -122.46323686739599 | (37.7094935276652, -122.463236867396) | ||||
| 67795 | 67795 | 178907 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993774.9758 | 2086763.55645 | 37.7094983462303 | -122.46329046790501 | (37.7094983462303, -122.463290467905) | ||||
| 183985 | 183985 | 178917 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993792.21408 | 2086763.29106 | 37.7094986106303 | -122.463230870712 | (37.7094986106303, -122.463230870712) | ||||
| 48579 | 48579 | 178918 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993792.015380001 | 2086765.64003 | 37.709505048900496 | -122.46323172778 | (37.7095050489005, -122.46323172778) | ||||
| 76456 | 76456 | 178908 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993776.62184 | 2086766.22044 | 37.7095057557476 | -122.463284972138 | (37.7095057557476, -122.463284972138) | ||||
| 184051 | 184051 | 178910 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993781.83724 | 2086767.02745 | 37.7095082720684 | -122.463267005492 | (37.7095082720684, -122.463267005492) | ||||
| 182335 | 182335 | 178911 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993783.22919 | 2086769.82188 | 37.709516025103895 | -122.46326239735201 | (37.7095160251039, -122.463262397352) | ||||
| 175027 | 175027 | 51531 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 175 Rae Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2005 12:00:00 AM | 1 | Permit Number 47833 | 5997697.55511 | 2087175.4993200002 | 37.7108546506849 | -122.449763101302 | (37.7108546506849, -122.449763101302) | ||
| 39287 | 39287 | 31050 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 25 South Hill Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51560 | 6002835.195830001 | 2087448.13614 | 37.711895858785894 | -122.432025692555 | (37.7118958587859, -122.432025692555) | |
| 63534 | 63534 | 120891 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 201 Leland Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 3x3 | 6009886.0438 | 2087551.2204 | 37.71257612443421 | -122.407663136759 | (37.7125761244342, -122.407663136759) | |||
| 149958 | 149958 | 120890 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 201 Leland Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 3x3 | 6009870.8927 | 2087557.0134 | 37.71259118267999 | -122.40771591213999 | (37.71259118268, -122.40771591214) | |||
| 74957 | 74957 | 120889 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 201 Leland Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 3x3 | 6009853.959 | 2087561.9153 | 37.71260369432971 | -122.407774785999 | (37.7126036943297, -122.407774785999) | |||
| 61322 | 61322 | 120888 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 201 Leland Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 3x3 | 6009826.3305 | 2087573.9471 | 37.7126351844606 | -122.40787112709101 | (37.7126351844606, -122.407871127091) | |||
| 56141 | 56141 | 120887 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 201 Leland Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 3x3 | 6009811.6249 | 2087578.8489 | 37.7126478205015 | -122.407922299954 | (37.7126478205015, -122.407922299954) | |||
| 187851 | 187851 | 120886 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 201 Leland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 3x3 | 6009795.1369 | 2087583.7508 | 37.712660357001795 | -122.40797963340599 | (37.7126603570018, -122.407979633406) | |||
| 135125 | 135125 | 178874 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 190 Foote Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5998666.63351 | 2088343.6345099998 | 37.7141174818994 | -122.446497740299 | (37.7141174818994, -122.446497740299) | |||
| 68703 | 68703 | 178875 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 190 Foote Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5998646.9675199995 | 2088361.56482 | 37.7141655911394 | -122.446567002474 | (37.7141655911394, -122.446567002474) | |||
| 72387 | 72387 | 178871 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 276 Foote Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5998313.518130001 | 2088706.56781 | 37.7150938380738 | -122.44774434904801 | (37.7150938380738, -122.447744349048) | |||
| 24086 | 24086 | 178876 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 852 Paris St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6000760.9108 | 2088982.59449 | 37.7159913219087 | -122.439304903221 | (37.7159913219087, -122.439304903221) | |||
| 165537 | 165537 | 178872 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1029 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003905.75349 | 2089465.8631799999 | 37.717496734867396 | -122.428469272232 | (37.7174967348674, -122.428469272232) | |||
| 54951 | 54951 | 178873 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1029 Russia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003894.97731 | 2089471.2893700001 | 37.7175110241788 | -122.428506907095 | (37.7175110241788, -122.428506907095) | |||
| 32814 | 32814 | 214424 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 732 Shields St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5992045.199469999 | 2089870.8873400001 | 37.7179305201634 | -122.469494855606 | (37.7179305201634, -122.469494855606) | |||
| 152248 | 152248 | 178929 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 236 Niagara Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 5999086.8403199995 | 2089914.7209 | 37.7184553195406 | -122.445158233389 | (37.7184553195406, -122.445158233389) | ||||
| 53380 | 53380 | 214420 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 466 Victoria St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 6ft | 5993273.262130001 | 2090266.31835 | 37.7190871751261 | -122.465278724129 | (37.7190871751261, -122.465278724129) | |||
| 55665 | 55665 | 178881 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 631 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6002458.40291 | 2090087.03952 | 37.7191203367176 | -122.433516460014 | (37.7191203367176, -122.433516460014) | |||
| 72225 | 72225 | 103482 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 560 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6003141.00472 | 2090240.25972 | 37.719579750897104 | -122.431167899382 | (37.7195797508971, -122.431167899382) | |||
| 138003 | 138003 | 70633 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 514 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 1 | 3x3 | 6003062.45597 | 2090620.0521099998 | 37.720618125211 | -122.43146651207898 | (37.720618125211, -122.431466512079) | |
| 154431 | 154431 | 178903 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 10x Mansell St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 6011814.45609 | 2090752.0893599999 | 37.7214728265024 | -122.401222688486 | (37.7214728265024, -122.401222688486) | |||
| 27753 | 27753 | 178904 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 10x Mansell St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 6011792.88406 | 2090769.7339700002 | 37.7215200714836 | -122.401298496839 | (37.7215200714836, -122.401298496839) | |||
| 157893 | 157893 | 214416 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 539 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5994748.7087900005 | 2092127.64393 | 37.724282906628794 | -122.46031349786399 | (37.7242829066288, -122.460313497864) | |||
| 160226 | 160226 | 178928 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 86 Santa Ysabel Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 6000750.4572 | 2093270.2717099998 | 37.7277637154981 | -122.439648243684 | (37.7277637154981, -122.439648243684) | ||||
| 52291 | 52291 | 214402 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 75 Westgate Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993211.39069 | 2093578.01882 | 37.728176729173796 | -122.465733068822 | (37.7281767291738, -122.465733068822) | |||
| 161927 | 161927 | 214476 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 270 Judson Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 5998285.21453 | 2093571.32939 | 37.7284497264529 | -122.448192264458 | (37.7284497264529, -122.448192264458) | ||||
| 178158 | 178158 | 178942 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 46 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003694.49459 | 2093990.6350099999 | 37.729908798255295 | -122.429522006933 | (37.7299087982553, -122.429522006933) | |||
| 136547 | 136547 | 214401 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 306 San Benito Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992866.37257 | 2094814.0590599999 | 37.731550682422 | -122.467015624375 | (37.731550682422, -122.467015624375) | |||
| 77100 | 77100 | 214458 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 87 Joost Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001469.66795 | 2094911.1287900002 | 37.73231004206529 | -122.437279364672 | (37.7323100420653, -122.437279364672) | |||
| 62754 | 62754 | 214473 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 766 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5997009.81636 | 2095018.0676900002 | 37.732349130199296 | -122.452705728912 | (37.7323491301993, -122.452705728912) | |||
| 153877 | 153877 | 214465 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 538 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5998516.53897 | 2094996.08822 | 37.732375000089505 | -122.44749508032801 | (37.7323750000895, -122.447495080328) | |||
| 48024 | 48024 | 183421 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1214 Wawona St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5989156.9564 | 2096994.6461 | 37.7373232077722 | -122.47999917002701 | (37.7373232077722, -122.479999170027) | |||
| 130212 | 130212 | 92294 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2666 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52739 | 5989910.1386 | 2097230.9793 | 37.7380158497087 | -122.477412366526 | (37.7380158497087, -122.477412366526) |
| 159311 | 159311 | 183377 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2651 22nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5989551.7412 | 2097288.806 | 37.738153824368204 | -122.478655737727 | (37.7381538243682, -122.478655737727) | |||
| 68995 | 68995 | 214386 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2658 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991781.74675 | 2097342.53415 | 37.7384305734182 | -122.470949475734 | (37.7384305734182, -122.470949475734) | |||
| 165951 | 165951 | 183560 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1620 Vicente St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5987892.6486 | 2097633.8663 | 37.7390048005458 | -122.48441728268601 | (37.7390048005458, -122.484417282686) | |||
| 178587 | 178587 | 183559 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1616 Vicente St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5987905.5766 | 2097633.8663 | 37.7390055533414 | -122.484372584152 | (37.7390055533414, -122.484372584152) | |||
| 182993 | 182993 | 183558 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1610 Vicente St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5987922.2884 | 2097634.497 | 37.7390082581786 | -122.484314849379 | (37.7390082581786, -122.484314849379) | |||
| 48508 | 48508 | 183557 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1606 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5987960.4417 | 2097637.0195 | 37.7390174057998 | -122.48418311934999 | (37.7390174057998, -122.48418311935) | |||
| 183255 | 183255 | 83569 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2579 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2008 12:00:00 AM | 1 | 3x3 | Permit Number 50370 | 5987984.0904 | 2097769.4524 | 37.7393824087044 | -122.48411106317499 | (37.7393824087044, -122.484111063175) | |
| 159661 | 159661 | 47761 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2582 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2002 12:00:00 AM | 1 | Permit Number 45540 | 5989894.53015279 | 2097799.30899888 | 37.7395754307957 | -122.477507859345 | (37.7395754307957, -122.477507859345) | |
| 167537 | 167537 | 183513 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2538 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5986470.4078 | 2097964.8461 | 37.739830662789004 | -122.489359001455 | (37.739830662789, -122.489359001455) | |||
| 157734 | 157734 | 46392 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2474 44th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/2002 12:00:00 AM | 1 | Permit Number 44624 | 5982733.0582 | 2098295.9927 | 37.7405210225717 | -122.502305471655 | (37.7405210225717, -122.502305471655) | |
| 38035 | 38035 | 92473 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2408 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52855 | 5988531.9158 | 2098337.111 | 37.7409729307865 | -122.482258526052 | (37.7409729307865, -122.482258526052) |
| 154672 | 154672 | 182570 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2202 Ulloa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5989157.6649 | 2098357.6812 | 37.7410657893771 | -122.480096445466 | (37.7410657893771, -122.480096445466) | |||
| 50845 | 50845 | 214391 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 181 Granville Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5994381.282869999 | 2098640.67197 | 37.742144938946204 | -122.462055722089 | (37.7421449389462, -122.462055722089) | |||
| 43582 | 43582 | 214394 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 191 Granville Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 5994343.40984 | 2098666.78046 | 37.742214445742896 | -122.46218856725201 | (37.7422144457429, -122.462188567252) | |||
| 43246 | 43246 | 247776 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 228 30th St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6005091.07435 | 2098463.74529 | 37.7422699303121 | -122.425011997728 | (37.7422699303121, -122.425011997728) | |||
| 35621 | 35621 | 181328 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1749 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5987757.6067 | 2098927.9954 | 37.742550273655 | -122.484979108902 | (37.742550273655, -122.484979108902) | |||
| 24617 | 24617 | 181947 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1651 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5988027.6673 | 2098939.5018 | 37.7425975937033 | -122.484046173892 | (37.7425975937033, -122.484046173892) | |||
| 166830 | 166830 | 181326 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2020 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5986900.7227 | 2098966.9139 | 37.742607185371206 | -122.48794478148399 | (37.7426071853712, -122.487944781484) | |||
| 188674 | 188674 | 181914 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1830 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5987457.4265 | 2098985.8656 | 37.742691680738 | -122.48602127745 | (37.742691680738, -122.48602127745) | |||
| 152855 | 152855 | 214399 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 280 Granville Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 5993979.945780001 | 2098920.29255 | 37.7428895919817 | -122.46346369708799 | (37.7428895919817, -122.463463697088) | |||
| 161787 | 161787 | 182100 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2378 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5987982.8264 | 2099115.3119 | 37.743077711116 | -122.484214109335 | (37.743077711116, -122.484214109335) | |||
| 61360 | 61360 | 83419 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2379 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 5988867.9747 | 2099162.5294 | 37.7432588555713 | -122.48115699763201 | (37.7432588555713, -122.481156997632) | |||
| 44345 | 44345 | 181814 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2169 Santiago St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5986311.3611 | 2099566.4282 | 37.7442188936716 | -122.49002668010799 | (37.7442188936716, -122.490026680108) | |||
| 167611 | 167611 | 95528 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1032 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767319 | 5989620.9197 | 2099732.2391 | 37.7448668732681 | -122.478595193308 | (37.7448668732681, -122.478595193308) |
| 167008 | 167008 | 238002 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1471 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6003322.028609999 | 2099674.87097 | 37.7454953128593 | -122.43121524060801 | (37.7454953128593, -122.431215240608) | |||
| 74407 | 74407 | 95447 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2210 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767309 | 5985770.3096 | 2100149.6093 | 37.745788542103206 | -122.49194041962099 | (37.7457885421032, -122.491940419621) |
| 179082 | 179082 | 183831 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2246 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5989808.8015 | 2100066.0373 | 37.7457943024947 | -122.477969938421 | (37.7457943024947, -122.477969938421) | |||
| 46911 | 46911 | 95592 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2210 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767309 | 5985769.8829 | 2100165.3986 | 37.7458318703149 | -122.491943057318 | (37.7458318703149, -122.491943057318) |
| 35756 | 35756 | 218355 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 365 Castenada Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5993521.424240001 | 2100014.7209799998 | 37.7458681870785 | -122.465128597612 | (37.7458681870785, -122.465128597612) | |||
| 39971 | 39971 | 218354 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 365 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5993503.7358800005 | 2100017.05504 | 37.745873575808794 | -122.46518993049801 | (37.7458735758088, -122.465189930498) | |||
| 29283 | 29283 | 95438 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2186 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767300 | 5986698.9662 | 2100381.1584 | 37.746478551124504 | -122.48874631833598 | (37.7464785511245, -122.488746318336) |
| 164556 | 164556 | 92332 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2178 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52764 | 5986694.1348 | 2100449.0089 | 37.746664568430795 | -122.488768011117 | (37.7466645684308, -122.488768011117) |
| 67840 | 67840 | 183942 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1805 Quintara St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5987837.1544 | 2100978.5872 | 37.748185287488496 | -122.484854460213 | (37.7481852874885, -122.484854460213) | |||
| 68429 | 68429 | 185590 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2086 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5986989.5241 | 2101082.1958 | 37.748420363683294 | -122.487793111063 | (37.7484203636833, -122.487793111063) | |||
| 158937 | 158937 | 214443 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 720 Quintara St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5991170.54389 | 2101147.50148 | 37.7488426659675 | -122.473340138153 | (37.7488426659675, -122.473340138153) | |||
| 25806 | 25806 | 214442 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 720 Quintara St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5991187.94391 | 2101152.05769 | 37.7488561836758 | -122.47328030175801 | (37.7488561836758, -122.473280301758) | |||
| 56991 | 56991 | 214441 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 720 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5991205.26954 | 2101153.09908 | 37.748860046264205 | -122.473220466273 | (37.7488600462642, -122.473220466273) | |||
| 51252 | 51252 | 214403 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2140 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993695.41418 | 2101124.7709 | 37.7489261338491 | -122.464607559198 | (37.7489261338491, -122.464607559198) | |||
| 37902 | 37902 | 60819 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1607 Pacheco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/02/1983 12:00:00 AM | 1 | Permit Number 20497 | 5989955.2951 | 2101733.4508 | 37.7503810843418 | -122.477585243781 | (37.7503810843418, -122.477585243781) | |
| 48076 | 48076 | 44724 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1970 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 1 | Permit Number 43843 | 5989436.9907 | 2101937.2229 | 37.750910497817294 | -122.479392462675 | (37.7509104978173, -122.479392462675) | |
| 38600 | 38600 | 237996 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 741 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001915.60449 | 2101837.36295 | 37.7513532016953 | -122.436233155455 | (37.7513532016953, -122.436233155455) | |||
| 156078 | 156078 | 92366 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1915 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52779 | 5985969.6964 | 2102174.4618 | 37.7513598906592 | -122.49139998707199 | (37.7513598906592, -122.491399987072) |
| 30952 | 30952 | 182628 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1890 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5988800.9853 | 2102469.1319999998 | 37.7523340169161 | -122.48163075760901 | (37.7523340169161, -122.481630757609) | |||
| 130682 | 130682 | 44716 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1879 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 1 | Permit Number 43838 | 5989679.8369 | 2102593.1522 | 37.7527256083507 | -122.47860064969299 | (37.7527256083507, -122.478600649693) | |
| 36062 | 36062 | 96607 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1655 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2011 12:00:00 AM | 1 | 3x3 | Permit Number 768135 | 5988818.1686 | 2103045.0516 | 37.7539163374898 | -122.48161351303601 | (37.7539163374898, -122.481613513036) | |
| 178235 | 178235 | 51494 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1767 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2005 12:00:00 AM | 1 | Permit Number 47806 | 5984074.2238 | 2103158.268 | 37.7539502052222 | -122.498027293704 | (37.7539502052222, -122.498027293704) | ||
| 149853 | 149853 | 53802 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1758 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/1972 12:00:00 AM | 1 | Permit Number 9494 | 5983498.0607 | 2103182.1267 | 37.7539819174643 | -122.500021533616 | (37.7539819174643, -122.500021533616) | ||
| 59178 | 59178 | 182739 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1755 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5985933.2204 | 2103292.5347 | 37.7544276818477 | -122.491608417213 | (37.7544276818477, -122.491608417213) | |||
| 24750 | 24750 | 182725 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1734 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5987217.2069 | 2103447.5916 | 37.7549283802803 | -122.487179505586 | (37.7549283802803, -122.487179505586) | |||
| 63435 | 63435 | 214440 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1746 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5992520.380580001 | 2103558.15623 | 37.7555397706536 | -122.468847844656 | (37.7555397706536, -122.468847844656) | |||
| 172408 | 172408 | 95443 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1634 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767305 | 5985639.2643 | 2104071.5459 | 37.7565494487406 | -122.49268234984 | (37.7565494487406, -122.49268234984) |
| 188640 | 188640 | 184708 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1619 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5984043.3081 | 2104133.2508 | 37.7566254238897 | -122.498206207845 | (37.7566254238897, -122.498206207845) | |||
| 155472 | 155472 | 182206 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1659 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5989323.8869 | 2104045.9173 | 37.75669384099071 | -122.479937878141 | (37.7566938409907, -122.479937878141) | |||
| 40255 | 40255 | 51768 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3638 Lawton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52851 | 5982945.3427 | 2104265.0097 | 37.756922756494106 | -122.50201305526699 | (37.7569227564941, -122.502013055267) |
| 109056 | 109056 | 51769 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3638 Lawton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52851 | 5982925.7859 | 2104266.232 | 37.7569249636711 | -122.50208077934201 | (37.7569249636711, -122.502080779342) |
| 186101 | 186101 | 51766 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3638 Lawton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2005 12:00:00 AM | 1 | Permit Number 48032 | 5982963.9827 | 2104265.9264 | 37.7569263685127 | -122.50194866004801 | (37.7569263685127, -122.501948660048) | ||
| 167545 | 167545 | 51767 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3638 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2005 12:00:00 AM | 1 | Permit Number 48032 | 5982982.0116 | 2104266.5376 | 37.756929105781495 | -122.501886355597 | (37.7569291057815, -122.501886355597) | ||
| 61059 | 61059 | 182221 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2830 Lawton St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5985427.0921 | 2104352.0968 | 37.7573073554199 | -122.493436776332 | (37.7573073554199, -122.493436776332) |
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");